财务指标预算分析表.xlsx

20132013年年销销售售收收入入预预算算表表公司名称华云信息有限公司预算年度2013年制表时间销销售售收收入入预预算算月月份份1 12 23 34 45 56 67 7销销售售总总收收入入单位：元54250542505383353833511255112549762.149762.1 44986.344986.3 42577.142577.1 51183.451183.4销销量量A 产品单位：件100125130135130136155B 产品单位：件15012010086684868定定价价策策略略价价格格变变动动A 产品-3%-3%B 产品-2%-2%1%1%1%1%单单价价定价A 产品单位：元250.00242.5242.5242.5242.5242.5242.5242.5B 产品单位：元200.00200196196197.96197.96199.9396 199.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收收入入结结构构当月销售/年销售收入（）8.2%8.1%7.7%7.5%6.8%6.4%7.7%2012/11/18 89 9101011111212合合计计6852068520654276542764880648806133461334 54301.754301.7 662177.76662177.76200180170160134175588981081009811325%5%3%3%254.625254.625 254.625254.625254.625199.9396199.94199.94205.938 205.937850925.045832.5 43286.340740.034119.8435821.017594.719594.1 21593.520593.820181.9226356.868519.765426.6 64879.761333.854301.7662177.810.3%9.9%9.8%9.3%8.2%100.0%100.0%20132013年年销销售售收收入入预预算算表表价价格格变变动动20132013年年材材料料预预算算表表公司名称华云信息有限公司预算年度2013年制表时间材材料料预预算算月月份份1 12 23 34 45 56 6合计物料标准成本14250.014250.0 23028.023028.023366.823366.824640.324640.324035.124035.123520.023520.0标准物料成本#23028.00 23366.75 24640.26 24035.13 23520.05销售收入比例26%43%46%50%53%55%物料成本差异（人工输入）0-8341388.58000占合计物料标准成本比例0%-4%6%0%0%0%共计物料成本#22194.00 24755.33 24640.26 24035.13 23520.05占销售收入比例26%41%48%50%53%55%物物料料成成本本变变动动国内物料成本1%1%3%3%-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.833721.837666.337666.338129.638129.637759.037759.037666.337666.3346814.5346814.529031.40 33721.7537666.3238129.5837758.9737666.32346814.5357%49%58%59%62%69%52%1321.540-1023.52000852.65%0%-3%0%0%0%0%30352.94 33721.7536642.8038129.5837758.9737666.32347667.1359%49%56%59%62%69%53%-2%-2%2%2%75.7077.2177.2177.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,595659565956595659565956595营营业业费费用用2853.52816281628162816281628162816财财务务费费用用218.49218.49218.49217.49217.49217.49268.98280.98三三项项费费用用合合计计:9665.999629.499629.499628.499628.499628.499679.989691.98管管理理费费用用:工资1456614666146761566715720157201572015720职工福利基金8080808080808080工会经费00000000职工教育经费524524524524524524524524社会保险基金850850850850850850850850保险费200200200200200200200200业务招待费2,5002,5002,5002,5002,5002,5002,5002,500差旅费1,5001,5001,5001,5001,5001,5001,5001,500办公费300300300300300300300300通讯费小车费税金租赁费资产占用费修理费低值易耗品摊销8080808080808080折旧费7575757575757575排污费董事会会费研究与开发费存货盘盈盘亏提取坏帐准备2021212121212121提取存货跌价准备88888888无形资产摊销中介机构费检验费会务费报损费咨询费诉讼费残联基金208208208208208208208208内部培训费208208208208208208208208招聘费00000000三三项项费费用用趋趋势势图图1234567891011129590.00 9610.00 9630.00 9650.00 9670.00 9690.00 9710.00 68%29%3%三三项项费费用用结结构构图图管理费用营业费用财务费用上交管理费00000000收取管理费4141414141414141其他00000000管管理理费费用用合合计计6,5946,5956,5956,5956,5956,5956,5956,595营营业业费费用用:通讯费180180180180180180180180运输费360360360360360360360360会务费500500500500500500500500租赁费00000000折旧费87.5050505050505050存货毁损8585858585858585产品检验费4141414141414141运费640640640640640640640640返利00000000广告费800800800800800800800800促销费160160160160160160160160中介机构费00000000内部培训费00000000招聘费00000000其他00000000合合计计营营业业费费用用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,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,6000 00 00 00 00 00 080808080960960757575759009000 00 00 00 021212121251251888896960 00 00 00 00 00 00 02082082082082,4962,4962082082082082,4962,49600000 020132013年年三三项项费费用用预预算算表表68%29%3%三三项项费费用用结结构构图图管理费用营业费用财务费用00000 04141414149249200000 06,5956,5956,5956,59579,13979,1390 00 01801801801802,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.98882882115115105931,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.031258.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.055557.422013年年人人工工预预算算表表2033年年制制造造费费用用预预算算表表月月份份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,0002,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合合计计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 021212121250250888810010000000 0777785854,5454,5454,5454,54553,0592033年年制制造造费费用用预预算算表表20332033年年预预算算损损益益表表公司名称华云信息有限公司预算年度预算损益表20332033年年1 12 23 34 45 56 6收入A产品100,00024,25030,31331,52532,73831,52532,980B产品75,00030,00023,52019,60017,02513,4619,597收收入入合合计计175,00054,25053,83351,12549,76244,98642,577销售成本直接材料107,22114,25023,02823,36724,64024,03523,520直接人工9,8733,5353,5353,5353,5353,6933,693制造费用21,9274,1914,2284,2284,2784,3744,489销销售售成成本本合合计计139,02121,97630,79231,13132,45432,10131,701材料/销售收入（%）61%26%43%46%50%53%55%人工/销售收入（%）6%7%7%7%7%8%9%毛利（%）21%59%43%39%35%29%26%主主营营业业务务利利润润35,98732,27423,04119,99417,30812,88510,876%销售收入21%59%43%39%35%29%26%管理费用25,4026,5946,5956,5956,5956,5956,595营业费用2,4322,8542,8162,8162,8162,8162,816财务费用2,723218218218217217217营营业业利利润润5,43022,60813,41110,3657,6803,2561,247所得税-6,7824,0233,1092,304977374净净利利润润5,43015,8259,3887,2555,3762,280873%销售收入3%29%17%14%11%5%2%制表时间7 78 89 910101111121220332033年年37,58850,92545,83343,28640,74034,120435,82113,59617,59519,59421,59320,59420,182226,35751,18368,52065,42764,88061,33454,302662,17829,03133,72237,66638,13037,75937,666346,8153,6933,6933,6933,6933,6933,69343,6824,5454,5454,5454,5454,5454,54553,05937,26941,95945,90446,36745,99745,904443,55557%49%58%59%62%69%52%7%5%6%6%6%7%7%27%39%30%29%25%15%33%13,91526,56019,52318,51215,3378,397218,62327%39%30%29%25%15%33%6,5956,5956,5956,5956,5956,59579,1392,8162,8162,8162,8162,8162,81633,8302692812832832722602,9564,23516,8689,8298,8185,654-1,274102,6981,2705,0612,9492,6451,696-31,1922,96411,8086,8806,1733,958-72,7806%17%11%10%6%0%11%20332033年年预预算算损损益益表表20332033年年预预算算资资产产负负债债表表资产负债表预算20332033年年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存存货货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)固固定定资资产产净净值值84,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其其他他流流动动负负债债500500670670703770783799流流动动负负债债合合计计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,60688,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月20332033年年9,99011,98313,80813,80814,27714,277282,090282,090(35,429)(36,529)(31,271)(27,827)(27,613)(24,789)(244,158)(244,158)74,92889,870103,564103,564107,075107,075963,673963,67391,00197,82398,78598,78598,78598,785994,643994,6439991,1981,3811,3811,4281,42812,70912,709141,489164,345186,266189,711193,951196,7742,008,9572,008,957129,600129,600129,700129,700129,700129,7001,511,4601,511,460(15,366)(16,046)(16,726)(17,406)(18,086)(18,765)(195,058)(195,058)114,234113,554112,974112,294111,614110,9351,316,4021,316,402255,723277,899299,241302,005305,565307,7093,325,3583,325,35862,26074,11884,93384,93384,93384,933839,581839,5814,5086,2147,7937,7938,8968,90072,07072,0703,6933,6933,6933,6933,6933,693140,682140,6829991,1981,3811,3811,4281,42812,70912,70971,45985,22397,79997,79998,94998,9531,065,0421,065,04216,56016,56016,56016,56016,5608,280157,320157,32022,00024,00024,00018,00010,00010,000146,000146,00038,56040,56040,56034,56026,56018,280303,320303,320110,019125,783138,359132,359125,509117,2331,368,3621,368,362132,000132,000132,000132,000132,000132,0001,706,0001,706,00013,70320,11728,88137,64648,05658,475250,997250,997145,703152,117160,881169,646180,056190,4751,956,9971,956,997255,723277,899299,241302,005305,565307,7093,325,3583,325,35820332033年年预预算算资资产产负负债债表表主要财务指标分析表编制单位：2033年度项项目目名名称称行行次次本本年年预预算算数数一一、效效益益指指标标：1（一）净资产收益率（%）26.96%（二）主营业务收入增长率（%）3278.39%（三）主营业务利润率（%）433.02%（四）利润增长率（%）51240.34%（五）总资产报酬率（%）64.13%（六）资本收益率（%）74.27%（七）利息保障倍数836.17527073（八）成本费用利润率（%）916.41%（九）成本费用占营业收入比率（%）1066.98%（十）人工成本占主营业收入比率（%）1166.98%（十一）人工成本利润率（%）12166.6%项项目目名名称称行行次次本本年年预预算算数数二二、资资产产运运行行状状况况指指标标：13（一）资产增长率（%）148.616977314（二）速动比率1595.24%（三）流动比率16188.63%（四）资产负债率（%）1741.15%（五）现金流动负债比率（%）1832.03%（六）所有者权益比率（%）1958.85%（七）产权比率（%）2069.9%主要财务指标分析表 2033年度