财务指标预算分析表

1、20132013年年销销售售收收入入预预算算表表公司名称华云信息有限公司预算年度2013年制表时间销销售售收收入入预预算算月月份份1 12 23 34 45 56 67 7销销售售总总收收入入单位：元542505425053832.553832.5511255112549762.0649762.06 44986.2844986.28 42577.142577.1 51183.3951183.39销销量量A 产品单位：件100125130135130136155B 产品单位：件15012010086684868定定价价策策略略价价格格变变动动A 产品-3%-3%B 产品 -2%-2%1%1%1%

2、1%单单价价定价A 产品单位：元250.00242.5242.5242.5242.5242.5242.5242.5B 产品 单位：元200.00200196196197.96197.96199.9396199.9396销销售售收收入入A 产品单位：元24250.030312.531525.032737.531525.032980.037587.5B 产品 单位：元30000.023520.019600.017024.613461.39597.113595.9销销售售收收入入合合计计54250.053832.551125.049762.144986.342577.151183.4收收入入结结构构

3、当月销售/年销售收入（）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年年销销售售收收入入预预算算表表制表时间价价格格变变动动20132013年年材材料料预预算算表表公司名称华云信息有限公司预算年度2013年制表时间材材料料预预算算月月份份1 12 23 34 45 56 6合计物料标准成本14250.014250.023028.02

5、3028.023366.823366.824640.324640.324035.124035.123520.023520.0标准物料成本14250.00 23028.0023366.7524640.2624035.1323520.05销售收入比例26%43%46%50%53%55%物料成本差异（人工输入）0-8341388.58000占合计物料标准成本比例0%-4%6%0%0%0%共计物料成本14250.00 22194.0024755.3324640.2624035.1323520.05占销售收入比例26%41%48%50%53%55%物物料料成成本本变变动动国内物料成本1 1% %3 3%

6、 %- -1 1% %单单位位物物料料成成本本A产品75.0075.7575.7578.0278.0277.2477.24B产品45.0045.4545.4546.8146.8146.3546.35共共计计物物料料成成本本A产品7500.017574.018821.820614.320851.821295.5B产品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年年材材料料预预算算表表制表时间20132013年年三三项项费费用用预预算算表表公司名称华云信息有限公司预算年度2013制表时间2012/11/1月月份份:12345678管管理理费费用用6,5946,5956595659565956595659565

9、95营营业业费费用用2853.52816281628162816281628162816财财务务费费用用218.49218.49218.49217.49217.49217.49268.98280.98三三项项费费用用合合计计: :9665.999629.499629.499628.499628.499628.499679.989691.98管管理理费费用用: :工资1456614666146761566715720157201572015720职工福利基金8080808080808080工会经费00000000职工教育经费524524524524524524524524社会保险基金850850

10、850850850850850850保险费200200200200200200200200业务招待费2,5002,5002,5002,5002,5002,5002,5002,500差旅费1,5001,5001,5001,5001,5001,5001,5001,500办公费300300300300300300300300通讯费小车费税金租赁费资产占用费修理费低值易耗品摊销8080808080808080折旧费7575757575757575排污费董事会会费研究与开发费存货盘盈盘亏提取坏帐准备2021212121212121提取存货跌价准备88888888无形资产摊销中介机构费检验费会务费报损费咨

11、询费诉讼费残联基金208208208208208208208208内部培训费208208208208208208208208招聘费00000000上交管理费00000000收取管理费4141414141414141其他00000000三三项项费费用用趋趋势势图图1234567891011129590.00 9610.00 9630.00 9650.00 9670.00 9690.00 9710.00 68%29%3%三三项项费费用用结结构构图图管理费用营业费用财务费用管管理理费费用用合合计计6,5946,5956,5956,5956,5956,5956,5956,595营营业业费费用用: :通

12、讯费180180180180180180180180运输费360360360360360360360360会务费500500500500500500500500租赁费00000000折旧费87.5050505050505050存货毁损8585858585858585产品检验费4141414141414141运费640640640640640640640640返利00000000广告费800800800800800800800800促销费160160160160160160160160中介机构费00000000内部培训费00000000招聘费00000000其他00000000合合计计营营业业费

13、费用用2,8542,8162,8162,8162,8162,8162,8162,816财财务务费费用用: :金融手续费8080808080808080汇兑损益00000000贴现利息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)财财务务费费用用合合计计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年年三三项项费费用用预预算算表表2012/11/168%29%3%三三项项费费用用结结构构图图管理费用营业费用财务费用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年年人人工工预预算算表表材材料料预预算算月月份份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年年人人工工预预算算表表2013年年制制造造费费用用预预算算表表月月份份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空调暖气00000000维修费00000000机物料消耗00000000清洗费00000000折旧214251251301334449505505低耗摊销88888888场所租赁费00000000制版费44444444运费00000000质检费00000000内部培训费00000000招聘费2121212121212121会务费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年年制制造造费费用用预预算算表表20132013年年预预算算损损益益表表公司名称华云信息有限公司预算年度预算损益表20122012年年1 12 23 34 45 5收入A产品100,00024,25030,31331,52532,73831,525B产品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%主主营营业业务务利利润润35,98732,27423,04119,99417,30812,885%销售收入21%59%43%39%35%29%管理费用25,4026,5946,59

24、56,5956,5956,595营业费用2,4322,8542,8162,8162,8162,816财务费用2,723218218218217217营营业业利利润润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年年预预算算损损益益表表预算年度20132013年年预预算算资资产产负负债债表表资产负债表预算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)应应收收帐帐款款款款48,00048,00050,22050,22052,73157,75358,71259,962

28、存存货货50,00050,00049,91853,73556,54157,77564,89177,820其其他他流流动动资资产产500500670670703770783799流流动动资资产产合合计计261,780261,780110,877111,743115,616113,859107,601114,944固固定定资资产产96,00096,00096,00096,00096,100104,380115,380129,600资资产产折折旧旧(12,000)(12,000)(12,386)(12,773)(13,159)(13,595)(14,064)(14,687)固固定定资资产产净净值值8

29、4,00084,00083,61483,22782,94190,785101,316114,913资资产产合合计计345,780345,780194,491194,970198,557204,644208,917229,857应应付付帐帐款款89,00089,00041,32241,32244,25548,47049,02950,072应应交交税税金金13,00013,0002,1672,1562,2072,7092,8222,906应应付付工工资资97,00097,0003,5353,5353,5353,5353,6933,693其其他他流流动动负负债债5005006706707037707

30、83799流流动动负负债债合合计计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负负债债合合计计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所所有有者者权权益益134,000134,000134,517135,008135,576136,879140,311141,828负负债债和和所所有有者者权权益益合合计计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