xx公司材料成本核算.xls

产品型号原材料编码原材料名称 数量单价金额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.0027.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产品型号 本月完工数量直接材料计件直接人工制造费用合计A00120028004002,328465.6577425,994A00220078404006,5191303.8416816,063A0034001712080014,2362847.1644835,003A00450029000100024,1144822.8837558,937A00560044880120037,3197463.8283790,863A00640039208003,260651.9208388,632A00760014700120012,2242444.7031430,569合计29001202605800100,000.0020000246060自定义名称：生产成本分配表产品型号定额材料金额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.30CAILIAO013 材料0133.40产品型号 工序工序合计A001112A002112A003112A004112A005112A006112A007112产品型号期初余额本期增加本期减少数量单价金额数量单价金额数量单价A001127.96973 27.9697320024002.129203A002278.31525 156.630520024002.755597A003385.50747 256.522440028002.621644A0064115.8746 463.498440028003.127471A0055149.4383 747.1914600212003.218498A006619.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 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