《公司生产成本核算表.xls》由会员分享,可在线阅读,更多相关《公司生产成本核算表.xls(10页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、产品型号原材料编码原材料名称 数量单价金额A001CAILIAO001材料0011.002.202.20A001CAILIAO002材料0022.002.304.60A001CAILIAO003材料0033.002.407.20A002CAILIAO004材料0044.002.5010.00A002CAILIAO005材料0055.002.6013.00A002CAILIAO006材料0066.002.7016.20A003CAILIAO007材料0077.002.8019.60A003CAILIAO008材料0088.002.9023.20A004CAILIAO009材料0099.003.0
2、027.00A004CAILIAO010材料01010.003.1031.00A005CAILIAO011材料01111.003.2035.20A005CAILIAO012材料01212.003.3039.60A006CAILIAO003材料0032.002.404.80A006CAILIAO004材料0042.002.505.00A007CAILIAO005材料0052.002.605.20A007CAILIAO006材料0063.002.708.10A007CAILIAO007材料0074.002.8011.20产品型号 本月完工数量直接材料计件直接人工制造费用合计A00120028004
3、002,328465.65774165,994A00220078404006,5191303.84167616,063A0034001712080014,2362847.16447735,003A00450029000100024,1144822.88375258,937A00560044880120037,3197463.82837290,863A00640039208003,260651.92083828,632A00760014700120012,2242444.70314330,569合计29001202605800100,000.0020000246060自定义名称:生产成本分配表产
4、品型号定额材料金额A00114A00239.2A00342.8A00458A00574.8A0069.8A00724.5材料编码材料名称单价CAILIAO001材料0012.20CAILIAO002材料0022.30CAILIAO003材料0032.40CAILIAO004材料0042.50CAILIAO005材料0052.60CAILIAO006材料0062.70CAILIAO007材料0072.80CAILIAO008材料0082.90CAILIAO009材料0093.00CAILIAO010材料0103.10CAILIAO011材料0113.20CAILIAO012材料0123.30CA
5、ILIAO013材料0133.40产品型号 工序工序合计A001112A002112A003112A004112A005112A006112A007112产品型号期初余额本期增加本期减少数量单价金额数量单价金额数量单价A001127.96973 27.9697320024002.129203A002278.31525 156.630520024002.755597A003385.50747 256.522440028002.621644A0064115.8746 463.498440028003.127471A0055149.4383 747.1914600212003.218498A0066
6、19.57881 117.472940028002.259785A007748.94703 342.6292600212002.541399期末余额金额数量单价金额02012.129203 427.969702022.755597 556.630504032.621644 1056.52204043.127471 1263.49806053.218498 1947.19104062.259785 917.472906072.541399 1542.629本期减少产品型号期初余额本期增加本期减少数量单价金额数量单价金额数量单价A00120127.96973 5621.91630027.96973
7、 8390.9240027.96973A00220278.31525 15819.6878.31525040078.31525A00340385.50747 34459.5185.50747040085.50747A006404115.8746 46813.34115.87460400115.8746A005605149.4383 90410.16149.43830400149.4383A00640419.57881 7909.8419.57881040019.57881A00760748.94703 29710.8548.94703040048.94703期末余额金额数量单价金额11187.8910127.96973 2824.94331326.1-19878.31525 -15506.434202.99385.50747 256.522446349.844115.8746 463.498459775.31205149.4383 30634.857831.525419.57881 78.3152519578.8120748.94703 10132.04本期减少