《成本核算.xls》由会员分享，可在线阅读，更多相关《成本核算.xls（10页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、产品型号原材料编码原材料名称 数量单价金额 A001CAILIAO001材料0011.002.202.20 A001CAILIAO002材料0022.002.304.60 A001CAILIAO003材料0033.002.407.20 A002CAILIAO004材料0044.002.5010.00 A002CAILIAO005材料0055.002.6013.00 A002CAILIAO006材料0066.002.7016.20 A003CAILIAO007材料0077.002.8019.60 A003CAILIAO008材料0088.002.9023.20 A004CAILIAO009材料0
2、099.003.0027.00 A004CAILIAO010材料01010.003.1031.00 A005CAILIAO011材料01111.003.2035.20 A005CAILIAO012材料01212.003.3039.60 A006CAILIAO003材料0032.002.404.80 A006CAILIAO004材料0042.002.505.00 A007CAILIAO005材料0052.002.605.20 A007CAILIAO006材料0063.002.708.10 A007CAILIAO007材料0074.002.8011.20 产品型号 本月完工数量直接材料计件直接人工
3、制造费用合计 A00120028004002,328465.65774165,994 A00220078404006,5191303.84167616,063 A0034001712080014,2362847.16447735,003 A00450029000100024,1144822.88375258,937 A00560044880120037,3197463.82837290,863 A00640039208003,260651.92083828,632 A00760014700120012,2242444.70314330,569 合计29001202605800 100,000.
4、00 20000246060 自定义名称：生产成本分配表 产品型号定额材料金额 A00114 A00239.2 A00342.8 A00458 A00574.8 A0069.8 A00724.5 材料编码材料名称单价 CAILIAO001材料0012.20 CAILIAO002材料0022.30 CAILIAO003材料0032.40 CAILIAO004材料0042.50 CAILIAO005材料0052.60 CAILIAO006材料0062.70 CAILIAO007材料0072.80 CAILIAO008材料0082.90 CAILIAO009材料0093.00 CAILIAO010材
5、料0103.10 CAILIAO011材料0113.20 CAILIAO012材料0123.30 CAILIAO013材料0133.40 产品型号 工序工序合计 A001112 A002112 A003112 A004112 A005112 A006112 A007112 产品型号 期初余额本期增加本期减少 数量单价金额数量单价金额数量单价 A001127.96973 27.9697320024002.129203 A002278.31525 156.630520024002.755597 A003385.50747 256.522440028002.621644 A0064115.8746
6、463.498440028003.127471 A0055149.4383 747.1914600212003.218498 A006619.57881 117.472940028002.259785 A007748.94703 342.6292600212002.541399 期末余额 金额数量单价金额 02012.129203 427.9697 02022.755597 556.6305 04032.621644 1056.522 04043.127471 1263.498 06053.218498 1947.191 04062.259785 917.4729 06072.541399 1
7、542.629 本期减少 产品型号 期初余额本期增加本期减少 数量单价金额数量单价金额数量单价 A00120127.96973 5621.91630027.96973 8390.9240027.96973 A00220278.31525 15819.6878.31525040078.31525 A00340385.50747 34459.5185.50747040085.50747 A006404115.8746 46813.34115.87460400115.8746 A005605149.4383 90410.16149.43830400149.4383 A00640419.57881 7909.8419.57881040019.57881 A00760748.94703 29710.8548.94703040048.94703 期末余额 金额数量单价金额 11187.8910127.96973 2824.943 31326.1-19878.31525 -15506.4 34202.99385.50747 256.5224 46349.844115.8746 463.4984 59775.31205149.4383 30634.85 7831.525419.57881 78.31525 19578.8120748.94703 10132.04 本期减少