年度生产成本分析表2.xlsx

1、年年度度生生产产成成本本分分析析表表格格单位名称：统计人员：审查人员：项项目目1 1月月2 2月月3 3月月4 4月月5 5月月6 6月月7 7月月8 8月月9 9月月期初数6550.50183376.5860938.0056464.76100277.1765715.1762484.9754934.7858540.70直接材料605600.60631745.57653730.28684560.76634560.00556210.00524560.76 680000.50 554560.76直接人工49126.4054972.6252066.0652994.1352994.0049880.504

2、8994.1352800.5042994.13制造费用104086.5098573.2389370.4285804.9277804.0070600.8068804.9285804.9255804.92其他12.58270.00360.00452.6080.0078.5090.000.000.00合合计计758826.08785561.42795526.76823812.41765438.00676769.80642449.81 818605.92 653359.81本期转出582000.00908000.00800000.00780000.00800000.00680000.00650000.

3、00 815000.00 600000.00转出数量780001000009400095000100000840008000010000076000单位成本7.469.088.518.218.008.108.138.157.89期期末末数数183376.5860938.0056464.76100277.1765715.1762484.9754934.7858540.70111900.51直接材料比重79.81%80.42%82.18%83.10%82.90%82.19%81.65%83.07%84.88%直接人工比重6.47%7.00%6.54%6.43%6.92%7.37%7.63%6.45

4、%6.58%制造费用比重13.72%12.55%11.23%10.42%10.16%10.43%10.71%10.48%8.54%其他0.00%0.03%0.05%0.05%0.01%0.01%0.01%0.00%0.00%合合计计100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%日期：2019/1/10单位：元1010月月1111月月1212月月合合计计结结构构排排序序111900.51 146304.71 169818.73674560.00 504565.00 684560.50 7389214.7382.45%

5、153994.0042994.1052990.50606801.076.77%385804.9055804.9285800.50964064.9510.76%245.30150.0088.961627.940.02%4814404.20 603514.02 823440.46 8961708.69100.00%780000.00 580000.00 800000.00 8775000.009400070000960001067000.008.308.298.338.22146304.71 169818.73 193259.1982.83%83.60%83.13%82.45%平均数：746809.066.63%7.12%6.44%6.77%标准差：76895.4710.54%9.25%10.42%10.76%0.01%0.02%0.01%0.02%100.00%100.00%100.00%100.00%年年度度生生产产成成本本分分析析表表格格审查人员：