單一品類生產(chǎn)配方成本核算表

單一品類生產(chǎn)配方成本核算表制表日期:2017年03月09日,,,,,,,,,,,,,,,,,,,,,

原輔材料,,,,,,,,,,,一、原輔料成本核算,,,,,,,,,,

,,,,,,,,,,,毛料,,,,凈料,,,產(chǎn)品定位原輔料成本核算,,,

序號,原輔材料--與配方,,,,,,品牌,規(guī)格標(biāo)準(zhǔn),購進(jìn)單價,單價轉(zhuǎn)換（元/kg）,,,,,凈料率,凈重量（kg）,金額(元),高位價(元),中位價(元),低位價(元),特殊價(元)

,1.)--,單位,標(biāo)準(zhǔn)配方,份量轉(zhuǎn)換(kg),配方百分比,總量百分比,,,,,單位,毛重量,單價(元),金額(元),,,,170.0%,145.0%,130.0%,200.00%

1,,斤,6.0,3.00,49.83%,12.36%,,,3.85,7.70,kg,3.000,7.70,23.10,100.00%,3.000,23.10,39.27,33.50,30.03,46.20

2,,斤,4.0,2.00,33.22%,8.24%,,1*260g/包,1.10,2.20,kg,2.000,2.20,4.40,100.00%,2.000,4.40,7.48,6.38,5.72,8.80

3,,斤,0.5,0.25,4.15%,1.03%,,,2.67,5.34,kg,0.250,5.34,1.34,100.00%,0.250,1.34,2.27,1.94,1.74,2.67

4,,斤,1.0,0.50,8.31%,2.06%,,,2.10,4.20,kg,0.500,4.20,2.10,100.00%,0.500,2.10,3.57,3.05,2.73,4.20

5,,小盒,2.0,0.090,1.50%,0.37%,,45g/合,6.00,0.27,kg,0.090,0.27,0.02,100.00%,0.090,0.02,0.04,0.04,0.03,0.05

6,,小盒,2.0,0.090,1.50%,0.37%,,,33.00,66.00,kg,0.090,66.00,5.94,100.00%,0.090,5.94,10.10,8.61,7.72,11.88

7,,小盒,2.0,0.090,1.50%,0.06%,,,27.00,54.00,kg,0.090,54.00,4.86,100.00%,0.090,4.86,8.26,7.05,6.32,9.72

8,小計,,,6.020,100.00%,24.79%,,,,,,,,,,6.020,,,,,

9,2.)--,,,,,,,,,,,,,,,,,,,,

10,,份,1.0,5.000,27.38%,20.59%,,5kg/罐,22.00,44.00,kg,5.000,44.00,220.00,100.00%,5.000,220.00,374.00,319.00,286.00,440.00

11,,份,1.0,5.000,27.38%,20.59%,,5kg/罐,24.00,48.00,kg,5.000,48.00,240.00,100.00%,5.000,240.00,408.00,348.00,312.00,480.00

12,,份,1.0,5.000,27.38%,20.59%,,5kg/罐,33.00,66.00,kg,5.000,66.00,330.00,100.00%,5.000,330.00,561.00,478.50,429.00,660.00

13,,份,0.5,2.500,13.69%,10.30%,,750ml/瓶,18.00,36.00,kg,2.500,36.00,90.00,100.00%,2.500,90.00,153.00,130.50,117.00,180.00

14,,少許,80g,0.080,0.44%,0.33%,,750ml/瓶,11.00,22.00,kg,0.080,22.00,1.76,100.00%,0.080,1.76,2.99,2.55,2.29,3.52

15,,適量,120g,0.120,0.66%,0.49%,,市售,23.00,46.00,kg,0.120,46.00,5.52,100.00%,0.120,5.52,9.38,8.00,7.18,11.04

16,,適量,60g,0.060,0.33%,0.25%,,市售,23.00,46.00,kg,0.060,46.00,2.76,100.00%,0.060,2.76,4.69,4.00,3.59,5.52

17,,適量,150g,0.150,0.82%,0.62%,,市售,8.80,17.60,kg,0.150,17.60,2.64,100.00%,0.150,2.64,4.49,3.83,3.43,5.28

18,,適量,150g,0.150,0.82%,0.62%,,市售,12.00,24.00,kg,0.150,24.00,3.60,100.00%,0.150,3.60,6.12,5.22,4.68,7.20

19,,適量,200g,0.200,1.10%,0.82%,,市售,9.90,19.80,kg,0.200,19.80,3.96,100.00%,0.200,3.96,6.73,5.74,5.15,7.92

20,小計,,,18.260,100.00%,75.21%,,,,,,,,,,18.260,,,,,

21,配方累計,,,24.280,,100.00%,,,,,,,,,,,,,,,

22,0.)--,,,,,,,,,,,,,,,,,,,,

23,,斤,5.0,2.500,32.24%,10.30%,,,7.00,14.00,kg,2.500,14.00,35.00,100.00%,2.500,35.00,59.50,50.75,45.50,17.50

24,,斤,5.0,2.500,32.24%,10.30%,,,1.90,3.80,kg,2.500,3.80,9.50,100.00%,2.500,9.50,16.15,13.78,12.35,4.75

25,,斤,4~4.5,2.250,29.01%,9.27%,,,17.00,34.00,kg,2.250,34.00,76.50,100.00%,2.250,76.50,130.05,110.93,99.45,38.25

26,,斤,0.5,0.250,3.22%,1.03%,,,22.00,44.00,kg,0.250,44.00,11.00,100.00%,0.250,11.00,18.70,15.95,8.46,5.50

27,,個,2~3,0.240,3.09%,0.99%,,市售,16.00,32.00,kg,0.240,32.00,7.68,100.00%,0.240,7.68,13.06,11.14,5.91,3.84

28,,少許,15g,0.015,0.19%,0.06%,,,12.00,24.00,kg,0.015,24.00,0.36,100.00%,0.015,0.36,0.61,0.52,0.28,0.18

29,