1、20132013年年銷銷售售收收入入預(yù)預(yù)算算表表公司名稱華云信息有限公司預(yù)算年度2013年制表時間銷銷售售收收入入預(yù)預(yù)算算月月份份1 12 23 34 45 56 67 7銷銷售售總總收收入入單位：元542505425053832.553832.5511255112549762.0649762.06 44986.2844986.28 42577.142577.1 51183.3951183.39銷銷量量A 產(chǎn)品單位：件100125130135130136155B 產(chǎn)品單位：件15012010086684868定定價價策策略略價價格格變變動動A 產(chǎn)品-3%-3%B 產(chǎn)品 -2%-2%1%1%1%

2、1%單單價價定價A 產(chǎn)品單位：元250.00242.5242.5242.5242.5242.5242.5242.5B 產(chǎn)品 單位：元200.00200196196197.96197.96199.9396199.9396銷銷售售收收入入A 產(chǎn)品單位：元24250.030312.531525.032737.531525.032980.037587.5B 產(chǎn)品 單位：元30000.023520.019600.017024.613461.39597.113595.9銷銷售售收收入入合合計計54250.053832.551125.049762.144986.342577.151183.4收收入入結(jié)結(jié)構(gòu)構(gòu)

3、當(dāng)月銷售/年銷售收入（）8.2%8.1%7.7%7.5%6.8%6.4%7.7%2012/11/18 89 9101011111212合合計計68519.768519.7 65426.665426.6 64879.764879.7 61333.861333.8 54301.6554301.65 662177.758662177.758200180170160134175588981081009811325%5%3%3%254.625254.625254.625254.625254.625199.9396 199.9396 199.9396 205.9378 205.9377950925.045

4、832.543286.340740.034119.8435821.017594.719594.121593.520593.820181.9226356.868519.765426.664879.761333.854301.7662177.810.3%9.9%9.8%9.3%8.2%1 10 00 0. .0 0% %20132013年年銷銷售售收收入入預(yù)預(yù)算算表表制表時間價價格格變變動動20132013年年材材料料預(yù)預(yù)算算表表公司名稱華云信息有限公司預(yù)算年度2013年制表時間材材料料預(yù)預(yù)算算月月份份1 12 23 34 45 56 6合計物料標(biāo)準(zhǔn)成本14250.014250.023028.02

5、3028.023366.823366.824640.324640.324035.124035.123520.023520.0標(biāo)準(zhǔn)物料成本14250.00 23028.0023366.7524640.2624035.1323520.05銷售收入比例26%43%46%50%53%55%物料成本差異（人工輸入）0-8341388.58000占合計物料標(biāo)準(zhǔn)成本比例0%-4%6%0%0%0%共計物料成本14250.00 22194.0024755.3324640.2624035.1323520.05占銷售收入比例26%41%48%50%53%55%物物料料成成本本變變動動國內(nèi)物料成本1 1% %3 3%

6、 %- -1 1% %單單位位物物料料成成本本A產(chǎn)品75.0075.7575.7578.0278.0277.2477.24B產(chǎn)品45.0045.4545.4546.8146.8146.3546.35共共計計物物料料成成本本A產(chǎn)品7500.017574.018821.820614.320851.821295.5B產(chǎn)品6750.05454.04545.04026.03183.32224.6合計14250.023028.023366.824640.324035.123520.02012/11/17 78 89 9101011111212全全年年合合計計29031.429031.433721.8337

7、21.837666.337666.338129.638129.637759.037759.037666.337666.3346814.5346814.529031.4033721.7537666.3238129.5837758.9737666.32346814.5357%49%58%59%62%69%52%1321.540-1023.52000852.65%0%-3%0%0%0%0%30352.9433721.7536642.8038129.5837758.9737666.32347667.1359%49%56%59%62%69%53%- -2 2% %2 2% %75.7077.2177.2

8、177.2177.2177.2145.4246.3346.3346.3346.3346.3325879.929724.933126.333126.333126.333126.33151.53996.84540.05003.34632.74540.029031.433721.837666.338129.637759.037666.320132013年年材材料料預(yù)預(yù)算算表表制表時間20132013年年三三項項費費用用預(yù)預(yù)算算表表公司名稱華云信息有限公司預(yù)算年度2013制表時間2012/11/1月月份份:12345678管管理理費費用用6,5946,5956595659565956595659565

9、95營營業(yè)業(yè)費費用用2853.52816281628162816281628162816財財務(wù)務(wù)費費用用218.49218.49218.49217.49217.49217.49268.98280.98三三項項費費用用合合計計: :9665.999629.499629.499628.499628.499628.499679.989691.98管管理理費費用用: :工資1456614666146761566715720157201572015720職工福利基金8080808080808080工會經(jīng)費00000000職工教育經(jīng)費524524524524524524524524社會保險基金850850

10、850850850850850850保險費200200200200200200200200業(yè)務(wù)招待費2,5002,5002,5002,5002,5002,5002,5002,500差旅費1,5001,5001,5001,5001,5001,5001,5001,500辦公費300300300300300300300300通訊費小車費稅金租賃費資產(chǎn)占用費修理費低值易耗品攤銷8080808080808080折舊費7575757575757575排污費董事會會費研究與開發(fā)費存貨盤盈盤虧提取壞帳準(zhǔn)備2021212121212121提取存貨跌價準(zhǔn)備88888888無形資產(chǎn)攤銷中介機構(gòu)費檢驗費會務(wù)費報損費咨

11、詢費訴訟費殘聯(lián)基金208208208208208208208208內(nèi)部培訓(xùn)費208208208208208208208208招聘費00000000上交管理費00000000收取管理費4141414141414141其他00000000三三項項費費用用趨趨勢勢圖圖1234567891011129590.00 9610.00 9630.00 9650.00 9670.00 9690.00 9710.00 68%29%3%三三項項費費用用結(jié)結(jié)構(gòu)構(gòu)圖圖管理費用營業(yè)費用財務(wù)費用管管理理費費用用合合計計6,5946,5956,5956,5956,5956,5956,5956,595營營業(yè)業(yè)費費用用: :通

12、訊費180180180180180180180180運輸費360360360360360360360360會務(wù)費500500500500500500500500租賃費00000000折舊費87.5050505050505050存貨毀損8585858585858585產(chǎn)品檢驗費4141414141414141運費640640640640640640640640返利00000000廣告費800800800800800800800800促銷費160160160160160160160160中介機構(gòu)費00000000內(nèi)部培訓(xùn)費00000000招聘費00000000其他00000000合合計計營營業(yè)業(yè)費

13、費用用2,8542,8162,8162,8162,8162,8162,8162,816財財務(wù)務(wù)費費用用: :金融手續(xù)費8080808080808080匯兌損益00000000貼現(xiàn)利息00000000折扣與折讓00000000利息支出 - USD48.9948.9948.9948.9948.9948.9997.9897.98利息支出- RMB94.5094.5094.5094.5094.5094.5098112利息收入(5)(5)(5)(6)(6)(6)(7)(9)財財務(wù)務(wù)費費用用合合計計2182182182172172172692819101112合合計計659565956595659579,

14、139281628162816281633829.5282.98282.98271.98259.982955.829693.989693.989682.989670.98115924.3215720167251672516725188,350188,3508080808096096000000 05245245245246,2886,28885085085085010,20010,2002002002002002,4002,4002,5002,5002,5002,50030,00030,0001,5001,5001,5001,50018,00018,0003003003003003,6003,

15、6000 00 00 00 00 00 080808080960960757575759009000 00 00 00 021212121251251888896960 00 00 00 00 00 00 02082082082082,4962,4962082082082082,4962,49600000 000000 04141414149249200000 020132013年年三三項項費費用用預(yù)預(yù)算算表表2012/11/168%29%3%三三項項費費用用結(jié)結(jié)構(gòu)構(gòu)圖圖管理費用營業(yè)費用財務(wù)費用6,5956,5956,5956,59579,13979,1390 00 0180180180180

16、2,1602,1603603603603604,3204,3205005005005006,0006,00000000 050505050638638858585851,0201,020414141414924926406406406407,6807,68000000 08008008008009,6009,6001601601601601,9201,92000000 000000 000000 000000 02,8162,8162,8162,81633,83033,8300 00 08080808096096000000 000000 000000 097.9897.9897.9897.9

17、8882882115115105931,2051,205(10)(10)(11)(11)(91)(91)2832832722602,9562,9562013年年人人工工預(yù)預(yù)算算表表材材料料預(yù)預(yù)算算月月份份1 12 23 34 45 56 67 7人工成本合計3535.403535.403535.403535.403535.403535.403535.403535.403692.503692.503692.503692.503692.503692.50直接人工1850.121850.121850.121850.121850.121850.121850.12間接人工1258.031258.0312

18、58.031258.031361.331361.331361.33管理人員427.25427.25427.25427.25481.05481.05481.058 89 9101011111212全全年年合合計計3692.503692.503692.503692.503692.503692.503692.503692.503692.503692.5043681.631850.121850.121850.121850.121850.1222201.441361.331361.331361.331361.331361.3315922.77481.05481.05481.05481.05481.055

19、557.422013年年人人工工預(yù)預(yù)算算表表2013年年制制造造費費用用預(yù)預(yù)算算表表月月份份1 12 23 34 45 56 67 78 8制制造造費費用用4,1914,1914,2284,2284,2284,2284,2784,2784,3744,3744,4894,4894,5454,5454,5454,545工資663663663663726726726726職工福利基金88888888保險費00000000社會保險基金417417417417417417417417差旅費833833833833833833833833通訊費44444444辦公費2,0002,0002,0002,000

20、2,0002,0002,0002,000水33333333電22222222汽00000000空調(diào)暖氣00000000維修費00000000機物料消耗00000000清洗費00000000折舊214251251301334449505505低耗攤銷88888888場所租賃費00000000制版費44444444運費00000000質(zhì)檢費00000000內(nèi)部培訓(xùn)費00000000招聘費2121212121212121會務(wù)費88888888其他100000000其他277777777合計4,1914,2284,2284,2784,3744,4894,5454,5459 9101011111212合

21、合計計4,5454,5454,5454,5454,5454,5454,5454,54553,05953,0597267267267268,4598,459888810010000000 04174174174175,0005,00083383383383310,00010,000444445452,0002,0002,0002,00024,00024,000333330302222202000000 000000 000000 000000 000000 05055055055054,8304,8308888909000000 04444505000000 000000 000000 0212

22、12121250250888810010000000 0777785854,5454,5454,5454,54553,0592013年年制制造造費費用用預(yù)預(yù)算算表表20132013年年預(yù)預(yù)算算損損益益表表公司名稱華云信息有限公司預(yù)算年度預(yù)算損益表20122012年年1 12 23 34 45 5收入A產(chǎn)品100,00024,25030,31331,52532,73831,525B產(chǎn)品75,00030,00023,52019,60017,02513,461收收入入合合計計175,00054,25053,83351,12549,76244,986銷售成本直接材料107,22114,25023,02

23、823,36724,64024,035直接人工9,8733,5353,5353,5353,5353,693制造費用21,9274,1914,2284,2284,2784,374銷銷售售成成本本合合計計139,02121,97630,79231,13132,45432,101材料/銷售收入（%）61%26%43%46%50%53%人工/銷售收入（%）6%7%7%7%7%8%毛利（%）21%59%43%39%35%29%主主營營業(yè)業(yè)務(wù)務(wù)利利潤潤35,98732,27423,04119,99417,30812,885%銷售收入21%59%43%39%35%29%管理費用25,4026,5946,59

24、56,5956,5956,595營業(yè)費用2,4322,8542,8162,8162,8162,816財務(wù)費用2,723218218218217217營營業(yè)業(yè)利利潤潤5,43022,60813,41110,3657,6803,256所得稅-6,7824,0233,1092,304977凈凈利利潤潤5,43015,8259,3887,2555,3762,280%銷售收入3%29%17%14%11%5%2013制表時間2012/11/16 67 78 89 910101111121220132013年年32,98037,58850,92545,83343,28640,74034,120435,821

25、9,59713,59617,59519,59421,59320,59420,182226,35742,57751,18368,52065,42764,88061,33454,302662,17823,52029,03133,72237,66638,13037,75937,666346,8153,6933,6933,6933,6933,6933,6933,69343,6824,4894,5454,5454,5454,5454,5454,54553,05931,70137,26941,95945,90446,36745,99745,904443,55555%57%49%58%59%62%69%52

26、%9%7%5%6%6%6%7%7%26%27%39%30%29%25%15%33%10,87613,91526,56019,52318,51215,3378,397218,62326%27%39%30%29%25%15%33%6,5956,5956,5956,5956,5956,5956,59579,1392,8162,8162,8162,8162,8162,8162,81633,8302172692812832832722602,9561,2474,23516,8689,8298,8185,654-1,274102,6983741,2705,0612,9492,6451,696-31,192

27、8732,96411,8086,8806,1733,958-72,7802%6%17%11%10%6%0%11%20132013年年預(yù)預(yù)算算損損益益表表預(yù)算年度20132013年年預(yù)預(yù)算算資資產(chǎn)產(chǎn)負(fù)負(fù)債債表表資產(chǎn)負(fù)債表預(yù)算20122012年年1月2月3月4月5月6月貨貨幣幣資資金金160,000160,0006,6966,6967,0317,7007,8287,995盈盈余余資資金金3,2803,2803,373423(1,390)(10,139)(24,614)(31,631)應(yīng)應(yīng)收收帳帳款款款款48,00048,00050,22050,22052,73157,75358,71259,962

28、存存貨貨50,00050,00049,91853,73556,54157,77564,89177,820其其他他流流動動資資產(chǎn)產(chǎn)500500670670703770783799流流動動資資產(chǎn)產(chǎn)合合計計261,780261,780110,877111,743115,616113,859107,601114,944固固定定資資產(chǎn)產(chǎn)96,00096,00096,00096,00096,100104,380115,380129,600資資產(chǎn)產(chǎn)折折舊舊(12,000)(12,000)(12,386)(12,773)(13,159)(13,595)(14,064)(14,687)固固定定資資產(chǎn)產(chǎn)凈凈值值8

29、4,00084,00083,61483,22782,94190,785101,316114,913資資產(chǎn)產(chǎn)合合計計345,780345,780194,491194,970198,557204,644208,917229,857應(yīng)應(yīng)付付帳帳款款89,00089,00041,32241,32244,25548,47049,02950,072應(yīng)應(yīng)交交稅稅金金13,00013,0002,1672,1562,2072,7092,8222,906應(yīng)應(yīng)付付工工資資97,00097,0003,5353,5353,5353,5353,6933,693其其他他流流動動負(fù)負(fù)債債5005006706707037707

30、83799流流動動負(fù)負(fù)債債合合計計199,500199,50047,69347,68250,70155,48556,32657,470銀銀行行借借款款 - - USDUSD8,2808,2808,2808,2808,2808,2808,28016,560銀銀行行借借款款 - - RMBRMB4,0004,0004,0004,0004,0004,0004,00014,000 銀銀行行借借款款合合計計12,28012,28012,28012,28012,28012,28012,28030,560負(fù)負(fù)債債合合計計211,780211,78059,97359,96262,98167,76568,606

31、88,030實實收收資資本本130,000130,000130,000130,000130,000130,000132,000132,000盈盈余余公公積積4,0004,0004,5175,0085,5766,8798,3119,828所所有有者者權(quán)權(quán)益益134,000134,000134,517135,008135,576136,879140,311141,828負(fù)負(fù)債債和和所所有有者者權(quán)權(quán)益益合合計計345,780345,780194,491194,970198,557204,644208,917229,85717月8月9月10月11月12月20132013年年9,99011,98313,

32、80813,80814,27714,2772 28 82 2, ,0 09 90 0(35,429)(36,529)(31,271)(27,827)(27,613)(24,789)( (2 24 44 4, ,1 15 58 8) )74,92889,870103,564103,564107,075107,0759 96 63 3, ,6 67 73 391,00197,82398,78598,78598,78598,7859 99 94 4, ,6 64 43 39991,1981,3811,3811,4281,4281 12 2, ,7 70 09 9141,489164,345186,2

33、66189,711193,951196,7742 2, ,0 00 08 8, ,9 95 57 7129,600129,600129,700129,700129,700129,7001 1, ,5 51 11 1, ,4 46 60 0(15,366)(16,046)(16,726)(17,406)(18,086)(18,765)( (1 19 95 5, ,0 05 58 8) )114,234113,554112,974112,294111,614110,9351 1, ,3 31 16 6, ,4 40 02 2255,723277,899299,241302,005305,565307,7093 3, ,3 32 25 5, ,3 35 58 862,26074,11884,93384,93384,93384,9338 83 39 9, ,5 58 81 14,5086,2147,7937,7938,8968,9007 72 2, ,0 07 70 03,6933,6933,6933,6933,6933,6931 14 40 0, ,6 68