生产成本结构分析图.xlsx

1、年年度度生生产产成成本本分分析析表表格格单位名称：华云信息有限公司统计人员：于晓梅项项目目1 1月月2 2月月3 3月月4 4月月5 5月月6 6月月7 7月月8 8月月期初数6550.50183376.5860938.0056464.76100277.1765715.1762484.9754934.78直接材料605600.60631745.57653730.28684560.76634560.00556210.00524560.76 680000.50直接人工49126.4054972.6252066.0652994.1352994.0049880.5048994.1352800.50制造

2、费用104086.5098573.2389370.4285804.9277804.0070600.8068804.9285804.92其他12.58270.00360.00452.6080.0078.5090.000.00合合计计758826.08785561.42795526.76823812.41765438.00676769.80642449.81 818605.92本期转出582000.00908000.00800000.00780000.00800000.00680000.00650000.00 815000.00转出数量7800010000094000950001000008400

3、080000100000单位成本7.469.088.518.218.008.108.138.15期期末末数数183376.5860938.0056464.76100277.1765715.1762484.9754934.7858540.70直接材料比重79.81%80.42%82.18%83.10%82.90%82.19%81.65%83.07%直接人工比重6.47%7.00%6.54%6.43%6.92%7.37%7.63%6.45%制造费用比重13.72%12.55%11.23%10.42%10.16%10.43%10.71%10.48%其他0.00%0.03%0.05%0.05%0.01

4、%0.01%0.01%0.00%合合计计100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%审查人员：张岚日期：2012/1/10单位：元9 9月月1010月月1111月月1212月月合合计计结结构构排排序序58540.70111900.51 146304.71 169818.73554560.76 674560.00 504565.00 684560.50 7389214.7382.45%142994.1353994.0042994.1052990.50606801.076.77%355804.9285804.9055804.928

5、5800.50964064.9510.76%20.0045.30150.0088.961627.940.02%4653359.81 814404.20 603514.02 823440.46 8961708.69100.00%600000.00 780000.00 580000.00 800000.00 8775000.00760009400070000960001067000.007.898.308.298.338.22111900.51 146304.71 169818.73 193259.1984.88%82.83%83.60%83.13%82.45%平均数：746809.066.58%6.63%7.12%6.44%6.77%标准差：76895.478.54%10.54%9.25%10.42%10.76%0.00%0.01%0.02%0.01%0.02%100.00%100.00%100.00%100.00%100.00%年年度度生生产产成成本本分分析析表表格格82.45%6.77%10.76%0.02%年年度度总总成成本本结结构构分分析析图图直接材料直接人工制造费用其他82.45%6.77%10.76%0.02%年年度度总总成成本本结结构构分分析析图图直接材料直接人工制造费用其他