收藏 分享(赏)

08-【通用】入库产品成本核算单(模板) (2).xlsx

上传人:a****2 文档编号:3106343 上传时间:2024-01-19 格式:XLSX 页数:93 大小:173.78KB
下载 相关 举报
08-【通用】入库产品成本核算单(模板) (2).xlsx_第1页
第1页 / 共93页
08-【通用】入库产品成本核算单(模板) (2).xlsx_第2页
第2页 / 共93页
08-【通用】入库产品成本核算单(模板) (2).xlsx_第3页
第3页 / 共93页
08-【通用】入库产品成本核算单(模板) (2).xlsx_第4页
第4页 / 共93页
08-【通用】入库产品成本核算单(模板) (2).xlsx_第5页
第5页 / 共93页
08-【通用】入库产品成本核算单(模板) (2).xlsx_第6页
第6页 / 共93页
亲,该文档总共93页,到这儿已超出免费预览范围,如果喜欢就下载吧!
资源描述

1、成本计算单时间:生产订单号:产品名称:型号:订单批次数量:成本项目零部件(小时)组装(小时)总成本单位成本制造成本构成比例全成本结构比占售价结构比备注准备定额工时小时数生产定额工时小时数直接材料仓库实际发料领用数,未含增值税委外加工费直接人工各工序生产一线人员工资分配制造费用含辅杂工、仓管及车间管理人员工资制制造造成成本本小小计计-#DIV/0!#DIV/0!#DIV/0!管理费用含全部管理、技术质检及行政后勤人员工资销售费用含销售部门人员工资全全成成本本合合计计-#DIV/0!#DIV/0!不不含含税税售售价价#DIV/0!销售毛利率#DIV/0!销售利润率#DIV/0!不含增值税的其他综合

2、税负平均2.49%-增税已扣除,不再重复计算销售净利率#DIV/0!1-8月费率核算表费用项目工时(小时)人工(元)制造费用(元)管理费用(元)1月2月3月4月5月6月7月8月合计费率(元/H)#DIV/0!#DIV/0!#DIV/0!成本核算说明:1.工时是按照1-8月工资表计件直接人工工时统计,2.费用按账面金额统计,唯一扣减的为管理费用中研究开发材料费用。费率采用的1-8月平均费用,按定额工时进行分配,准备工时除真空成品外,均采用50件为批量计算单件产品所包括的准备工时3.专修产品虽有办理入库,但系统中领料为统一领料,只能在假若全部领用用完且平均分配到每一产品中;4.在制品待下月入库时核

3、算成本,本月未核算在制品成本。销售费用(元)合计(元)#DIV/0!#DIV/0!2.费用按账面金额统计,唯一扣减的为管理费用中研究开发材料费用。费率采用的1-8月平均费用,按定额工时进行分配,准备工时除真空成品外,均采用50件为批量计算单件产品所包括的准备工时3.专修产品虽有办理入库,但系统中领料为统一领料,只能在假若全部领用用完且平均分配到每一产品中;生产订单号码行号类型物料编码物料名称物料规格生产订单数量入库数量00000006421标准0201001005400000006420000000642 汇汇总总0201001005400000006931标准0201016004000000

4、006930000000693 汇汇总总0201016004000000007071标准0201016009600000007071标准0201016009600000007070000000707 汇汇总总0201016009600000007151标准0201001002300000007150000000715 汇汇总总0201001002300000007341标准0201001012500000007340000000734 汇汇总总0201001012500000008061标准0201001006100000008060000000806 汇汇总总0201001006100000

5、008081标准0201001008400000008080000000808 汇汇总总0201001008400000008091标准0201001008400000008090000000809 汇汇总总0201001008400000008121标准0201017001600000008120000000812 汇汇总总0201017001600000008391标准0201001004300000008391标准0201001004300000008390000000839 汇汇总总0201001004300000008471标准0201001011800000008470000000

6、847 汇汇总总0201001011800000008501标准0201027001900000008500000000850 汇汇总总0201027001900000008511标准0201027001900000008510000000851 汇汇总总0201027001900000008521标准0201027001900000008520000000852 汇汇总总0201027001900000008611标准0201027001900000008610000000861 汇汇总总0201027001900000008621标准0201027001900000008620000000

7、862 汇汇总总0201027001900000008831标准0201016004000000008830000000883 汇汇总总0201016004000000008841标准0201001009200000008840000000884 汇汇总总0201001009200000008891标准0201001007100000008890000000889 汇汇总总0201001007100000008941标准0201025003300000008940000000894 汇汇总总0201025003300000008961标准0201025000600000008960000000

8、896 汇汇总总0201025000600000009011标准0201025001400000009010000000901 汇汇总总0201025001400000009021标准0201025004000000009020000000902 汇汇总总0201025004000000009051标准0201025001900000009050000000905 汇汇总总0201025001900000009061标准0201025003700000009060000000906 汇汇总总0201025003700000009081标准0201025002400000009080000000

9、908 汇汇总总0201025002400000009101标准0201025002700000009100000000910 汇汇总总0201025002700000009111标准0201016022800000009111标准0201016022800000009110000000911 汇汇总总0201016022800000009171标准0201001008500000009170000000917 汇汇总总0201001008500000009181标准0201001005100000009180000000918 汇汇总总0201001005100000009191标准0201

10、001006800000009190000000919 汇汇总总0201001006800000009231标准0201001011600000009230000000923 汇汇总总0201001011600000009241标准0201001011800000009240000000924 汇汇总总0201001011800000009331标准0201016010200000009330000000933 汇汇总总0201016010200000009421标准0201016003600000009420000000942 汇汇总总0201016003600000009481标准0201

11、027001900000009480000000948 汇汇总总0201027001900000009491标准0201001002900000009491标准0201001002900000009491标准0201001002900000009491标准0201001002900000009491标准0201001002900000009490000000949 汇汇总总0201001002900000009651标准0201016016500000009651标准0201016016500000009651标准0201016016500000009651标准0201016016500000

12、009650000000965 汇汇总总0201016016500000009661标准0201016015500000009661标准0201016015500000009660000000966 汇汇总总0201016015500000009721标准0201016027000000009721标准0201016027000000009721标准0201016027000000009720000000972 汇汇总总0201016027000000009732标准0201016014700000009732标准0201016014700000009730000000973 汇汇总总0201

13、016014700000009771标准0201001000400000009770000000977 汇汇总总0201001000400000009901标准0201001003100000009900000000990 汇汇总总0201001003100000009911标准0201001003200000009910000000991 汇汇总总0201001003200000010201标准0201019000300000010201标准0201019000300000010201标准0201019000300000010201标准0201019000300000010201标准0201

14、019000300000010201标准0201019000300000010200000001020 汇汇总总0201019000300000010241标准0201016025900000010241标准0201016025900000010240000001024 汇汇总总0201016025900000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251

15、标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010250000001025 汇汇总总020101630200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准020

16、1016027200000010261标准0201016027200000010260000001026 汇汇总总0201016027200000010371标准0201001009700000010370000001037 汇汇总总0201001009700000010381标准0201001009800000010380000001038 汇汇总总0201001009800000010401标准0201001006600000010400000001040 汇汇总总0201001006600000010421标准0201001007700000010420000001042 汇汇总总020

17、1001007700000010471标准0201016003100000010470000001047 汇汇总总0201016003100000010481标准0201016004000000010480000001048 汇汇总总0201016004000000010501标准0201016007000000010500000001050 汇汇总总0201016007000000010511标准0201016007100000010510000001051 汇汇总总0201016007100000010521标准0201016009400000010520000001052 汇汇总总020

18、1016009400000010731标准0201016011300000010730000001073 汇汇总总0201016011300000010781标准0201001013000000010780000001078 汇汇总总0201001013000000010811标准0201001005200000010811标准0201001005200000010811标准0201001005200000010811标准0201001005200000010811标准0201001005200000010810000001081 汇汇总总0201001005200000010821标准020

19、1001012100000010821标准0201001012100000010820000001082 汇汇总总0201001012100000010831标准0201001002900000010831标准0201001002900000010831标准0201001002900000010831标准0201001002900000010831标准0201001002900000010830000001083 汇汇总总0201001002900000010971标准0201001009500000010971标准0201001009500000010970000001097 汇汇总总020

20、1001009500000011041标准0201016001900000011041标准0201016001900000011041标准0201016001900000011041标准0201016001900000011041标准0201016001900000011041标准0201016001900000011040000001104 汇汇总总0201016001900000011051标准0201001008200000011051标准0201001008200000011050000001105 汇汇总总0201001008200000011061标准020100200070000

21、0011060000001106 汇汇总总0201002000700000011181标准0201016022500000011181标准0201016022500000011180000001118 汇汇总总0201016022500000011191标准0202011006300000011190000001119 汇汇总总0202011006300000011201标准0201016006400000011201标准0201016006400000011200000001120 汇汇总总0201016006400000011231标准0201016005100000011231标准020

22、1016005100000011230000001123 汇汇总总0201016005100000011281标准0201001000700000011280000001128 汇汇总总0201001000700000011341标准0201001009700000011340000001134 汇汇总总0201001009700000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准020

23、1016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011440000001144 汇汇总总0201016000500000011691标准0201019002600000011690000001169 汇汇总总0201019002600000011791标准0201016017200000011791标准020101601720000

24、0011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011790000001179 汇汇总总0201016017200000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准020101602730000

25、0011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011800000001180 汇汇总总0201016027300000011891标准0201016025900000011891标准0201016025900000011890000001189 汇汇总总0201016025900000011921标准020103600500000011921标准020103600500000011921标准02010

26、3600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011920000001192 汇汇总总020103600500000012021标准02010160055000000

27、12021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准02010

28、16005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012020000001202 汇汇总总0201016005500000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准02010

29、16028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012120000001212 汇汇总总0201016028800000012181标准02010010098000000121800000012

30、18 汇汇总总0201001009800000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准02010

31、27004100000012401标准0201027004100000012401标准0201027004100000012400000001240 汇汇总总0201027004100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准02010

32、27000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011710000001171 汇汇总总0201027000100000011721标准0201027003600000011720000001172 汇汇总总0201027003600000011771标准0201027003300000011770000001177 汇汇总总0201027003300000011781标准02010270010000000117800000011

33、78 汇汇总总0201027001000000011841标准0201025002000000011841标准0201025002000000011840000001184 汇汇总总0201025002000000011851标准0201025003600000011851标准0201025003600000011850000001185 汇汇总总0201025003600000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准02010

34、25002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011870000001187 汇汇总总0201025002200000012051标准0201025002600000012050000001205 汇汇总总0201025002600000011911标准0201019004400000011910000001191 汇汇总总02010

35、19004400000011951标准0201029101200000011951标准0201029101200000011951标准0201029101200000011950000001195 汇汇总总0201029101200000011961标准0201029101100000011961标准0201029101100000011960000001196 汇汇总总0201029101100000011971标准0201029101400000011971标准0201029101400000011971标准0201029101400000011970000001197 汇汇总总02010

36、29101400000012351标准0201029101100000012350000001235 汇汇总总0201029101100000012361标准0201029101200000012361标准0201029101200000012360000001236 汇汇总总0201029101200000012371标准0201029101400000012371标准0201029101400000012370000001237 汇汇总总02010291014子件物料编码子件物料名称子件物料规格子件计量单位标准用量实际用量材料单价0303030002件50.0050.0046.150302

37、00101006KG336.40340.4062.1002010160097件182.00182.0014.8102010160098件182.00182.008.90030200107025KG300.00300.0065.38030119009011KG137.03137.0324.360304050009件24.0024.001,205.130303010005件50.0050.0097.190303010005件50.0050.0097.19030200108002KG178.00178.0063.1602010010044个299.00299.003.6002010010045个29

38、9.00299.004.45030119003002KG28.4828.4822.650307001件2,000.002,000.000.300307001件2,000.002,000.000.300307001件2,000.002,000.000.300307001件2,000.002,000.000.300307001件2,000.002,000.000.30030200101006KG336.40338.3162.10030102001001KG729.12729.125.07030100109016KG7.057.054.87030100109006KG72.1872.184.4403

39、0100109006KG167.05167.054.44030203509003KG10.1010.1040.17030200108002KG96.1298.7063.16030119002001KG29.7531.5024.36030102001016KG134.55134.555.070303030007件42.0042.0026.03030119001022KG101.20101.2022.2202010160229件300.00300.000.6802010160230件300.00300.000.95030103001005KG130.69135.005.26030200101010

40、KG20.0021.8064.83030100103009KG205.30205.305.81030119003004KG40.8945.5022.65030119003002KG47.4746.0022.65030102001018KG39.5641.414.790304020007件50.0050.00577.780307001件1,900.001,900.000.3002010010030个50.0050.00145.3002010010031个50.0050.00423.0802010010032个50.0050.00423.080305036KG4.004.0082.05030503

41、7KG191.50191.5023.9302010160166件122.0095.000.4302010160167件122.00120.000.1302010160168件122.00122.001.1102010160169件122.00115.000.7502010160156件130.00130.001.1302010160157件130.00130.000.4002010160144件86.0086.0010.4202010160145件86.0086.003.2502010160146件86.0086.0014.0202010160149件118.00118.007.2302010

42、160150件118.00118.002.63030200108006KG127.20129.6064.530304020020件50.0050.00426.000304020021件50.0050.00426.000305036KG4.004.0082.05件80.0080.0036.79件80.0080.0040.620305037KG488.00256.0023.930305098件80.0080.0046.150501001032个160.00160.000.2202010160040件140.00140.00224.6302010160041件140.00140.0010.26020

43、10160127件10.0010.003.3202010160130件5.005.001.8202010160142件5.005.002.5602010160147件5.005.00#DIV/0!02010160180件5.005.00225.9702010160322件5.005.00277.410501003119个15.0015.000.170501003122个15.0015.000.230501006006个10.0010.000.020503006069件5.005.001.4502010160130件5.005.001.8202010160142件5.005.002.560201

44、0160147件5.005.00#DIV/0!02010160273个5.005.00574.0302010160277个5.005.00237.340501003119个15.0015.000.170501003122个15.0015.000.230501006006个10.0010.000.020503006069件5.005.001.45030102001001KG349.58379.585.07030201001002KG28.2728.2744.020401080KG40.0040.0034.190306039件2,000.002,000.000.230306023件150.0015

45、0.001.83030200101006KG336.40336.4062.10030100109016KG13.3712.374.87030100109016KG22.6723.674.87030100101006KG64.8064.304.70030119001004KG4.404.4022.65030119001002KG47.0948.0320.9402010010053个47.0047.00128.2102010010054个47.0047.00423.0802010010055个47.0047.00423.080305036KG4.004.0082.050305037KG245.81

46、245.8123.9302010010122个200.00200.0020.1502010010123个200.00200.000.1302010010030个46.0051.00145.3002010010031个46.0046.00423.0802010010032个46.0046.00423.080305036KG3.683.7882.050305037KG176.18195.1823.9302010010097个50.0050.0046.2002010010098个50.0050.0025.7702010160020件40.0040.001.5202010160021件40.0040.

47、000.0602010160022件40.0040.001.790402019个40.0040.006.320501006017个40.0040.000.090501007008个40.0040.000.0602010010084个5.005.0097.1902010010085个20.0020.002.290401080KG30.0030.0034.1902010160226件192.00200.001.2202010160227件192.00200.002.71030100109015KG0.600.604.9602010160065件200.00200.005.6002010160066

48、件200.00200.0044.2902010160052件150.00150.001.6302010160053件300.00300.000.050305054KG5.156.4737.65030102001001KG349.58349.505.0702010160006件5.005.00294.8702010160007件15.0015.000.5602010160008件5.005.007.1502010160009件5.005.0088.4602010160011件10.0010.007.6102010160012件10.0010.0025.7402010160013件5.005.00

49、7.6402010160019件5.005.009.850501003028件10.0010.000.410501004003件10.0010.000.070501006004个10.0010.000.010501006018个20.0020.000.01030119001017KG19.0019.8322.2202010160173件14.0014.00484.6202010160174件14.0014.0044.6302010160175件14.0014.003.4502010160176件14.0014.0022.7002010160177件14.0014.0015.2002010160

50、178件14.0014.002.1802010160179件14.0014.000.430501007029个14.0014.000.040503006067件14.0014.000.9002010160174件22.0022.0044.6302010160175件22.0022.003.4502010160176件22.0022.0022.7002010160177件22.0022.0015.2002010160178件22.0022.002.1802010160179件22.0022.000.4302010160274个22.0022.00484.620501007029个22.0022.

展开阅读全文
相关资源
猜你喜欢
相关搜索

当前位置:首页 > 实用范文 > 工作计划

copyright@ 2008-2023 wnwk.com网站版权所有

经营许可证编号:浙ICP备2024059924号-2