成本核算(函数自动核算-完整版)

,2014年9月生产成本核算表,,,,21133,20473,,482357.5,555896.7165,14377.58863,3818.828906,988.2739139,575081.408,102322.7435,429461.66,#DIV/0!,63035.93,#DIV/0!,#DIV/0!,421684.8434,443839.2486,#DIV/0!,63811.36137,929335.4534,13133,0,#DIV/0!,13133,432.58,236534.6166,0,#DIV/0!,212.8425421,#DIV/0!,7840,8000,0.06,#DIV/0!,,,

本厂生产,482358,,,,21133,20473,,482357.5,555896.7165,14377.59,3818.83,988.2739139,575081.408,102322.7435,"429,462",-,"63,036",,#DIV/0!,421684.8434,443839.2486,#DIV/0!,63811.36137,929335.4534,13133,0,#DIV/0!,13133,432.58,236534.6166,0,#DIV/0!,212.8425421,#DIV/0!,7840,8000,0.06,,,,

外协加工,0,,,,,,,"511,682",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

加工类型,产品编号,类别,产品名称,型号规格,投产数量,约当产量,定额工费（单件）,定额工费成本,上期在产品,,,,,本期投料,,,,单价,全部生产费用合计,本期完工产品,,,,,,,,,,期末在产品,,,,,,,,,,,

,,,,,,,,,直接材料,直接人工,加工费,制造费用,合计,直接材料,直接人工,加工费,制造费用,,,直接材料,直接人工,加工费,制造费用,合计,完工产量,本月不良品数,良率,小计,单价,直接材料,直接人工,加工费,制造费用,合计,约当在产,在产品,完工率,单价,售价,毛利率,

1,2,3,4,5,6,7,8,9,10＝结转上期,11＝结转上期,12＝结转上期,13＝结转上期,14＝结转上期,15＝材料领用表,16＝详见公式,17＝详见公式,18＝详见公式,19,20,21＝10+15-31,22＝11+16-32,23＝12+17-33,24＝13+18-34,25,26,27,28,29,30,31＝（10+15）/7*36,32,33,34,35,36,,,37,,,检索

本厂生产,女双层冲锋衣FT14081,服装,女双层冲锋衣,FT14081,5000,4500,29.00,130500,"319,362","14,378",-,775,334515.12,-,"116,189.23",-,"17,054.13",93.55,"467,758.48","319,362.10","130,566.82",0.00,"17,829.56","467,758.48","5,000",,100.00%,"5,000",93.55,-,-,-,-,-,,,,0.00,102.50,9%,OK

外协加工,男双层冲锋衣FT14081,服装,男双层冲锋衣,FT14081,5000,4900,30.00,0,"143,830",-,"2,879",160,146868.60,-,-,#DIV/0!,-,#DIV/0!,#DIV/0!,0.00,0.00,#DIV/0!,0.00,,0,,#DIV/0!,0,0.00,"143,829.65",-,#DIV/0!,160.43,#DIV/0!,"4,900",5000,2.00%,#DIV/0!,109.40,#DIV/0!,OK

外协加工,背包BT14081,箱包,背包,BT14081,2500,2450,10.40,0,"82,307",-,499,28,82833.33,-,-,#DIV/0!,-,#DIV/0!,#DIV/0!,0.00,0.00,#DIV/0!,0.00,,0,,#DIV/0!,0,0.00,"82,306.58",-,#DIV/0!,27.81,#DIV/0!,"2,450",2500,2.00%,#DIV/0!,54.00,#DIV/0!,OK

外协加工,背包BT14082,箱包,背包,BT14082,500,490,46.00,0,"10,398",-,441,25,10864.36,-,-,#DIV/0!,-,#DIV/0!,#DIV/0!,0.00,0.00,#DIV/0!,0.00,,0,,#DIV/0!,0,0.00,"10,398.39",-,#DIV/0!,24.60,#DIV/0!,490,500,2.00%,#DIV/0!,84.50,#DIV/0!,OK

本厂生产,夹克上衣FT14091,服装,夹克上衣,FT14091,300.0,300.0,20.20,6060,,,,,0.00,"5,345.46","5,395.45",-,791.94,38.44,"11,532.85","5,345.46","5,395.45",0.00,791.94,"11,532.85",300,,100.00%,300,38.44,-,-,-,-,-,,,,0.00,47.23,19%,OK

本厂生产,灰色手提包BT14091,箱包,灰色手提包,BT14091,88.0,88.0,20.00,1760,,,,,0.00,910.93,"1,567.00",-,230.00,30.77,"2,707.93",910.93,"1,567.00",0.00,230.00,"2,707.93",88,,100.00%,88,30.77,-,-,-,-,-,,,,0.00,44.87,31%,OK

本厂生产,灰色手提包BT14092,箱包,灰色手提包,BT14092,275.0,275.0,12.50,3437.5,,,,,0.00,"2,404.41","3,060.54",-,449.22,21.51,"5,914.17","2,404.41","3,060.54",0.00,449.22,"5,914.17",275,,100.00%,275,21.51,-,-,-,-,-,,,,0.00,27.78,23%,OK

本厂生产,灰色手提包BT14093,箱包,灰色手提包,BT14093,550.0,550.0,12.00,6600,,,,,0.00,"6,388.68","5,876.24",-,862.51,23.87,"13,127.42","6,388.68","5,876.24",0.00,862.51,"13,127.42",550,,100.00%,550,23.87,-,-,-,-,-,,,,0.00,30.99,23%,OK

本厂生产,训练席BT14091,箱包,训练席,BT14091,420.0,420.0,95.00,39900,,,,,0.00,"18,727.19","35,524.52",-,"5,214.25",141.59,"59,465.96","18,727.19","35,524.52",0.00,"5,214.25","59,465.96",420,,100.00%,420,141.59,-,-,-,-,-,,,,0.00,192.31,26%,OK

本厂生产,眼罩BT14091,箱包,眼罩,BT14091,2000.0,2000.0,0.80,1600,,,,,0.00,"1,565.75","1,424.54",-,209.09,1.60,"3,199.39","1,565.75","1,424.54",0.00,209.09,"3,199.39","2,000",,100.00%,"2,000",1.60,-,-,-,-,-,,,,0.00,2.01,20%,OK

本厂生产,上衣FT14081,服装,上衣,FT14081,4500,4500,65.00,292500,,,,,0.00,"