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

成本计算单时间：生产订单号：产品名称：型号：订单批次数量：成本项目零部件（小时）组装（小时）总成本单位成本制造成本构成比例全成本结构比占售价结构比备注准备定额工时小时数生产定额工时小时数直接材料仓库实际发料领用数，未含增值税委外加工费直接人工各工序生产一线人员工资分配制造费用含辅杂工、仓管及车间管理人员工资制制造造成成本本小小计计-#DIV/0!#DIV/0!#DIV/0!管理费用含全部管理、技术质检及行政后勤人员工资销售费用含销售部门人员工资全全成成本本合合计计-#DIV/0!#DIV/0!不不含含税税售售价价#DIV/0!销售毛利率#DIV/0!销售利润率#DIV/0!不含增值税的其他综合税负平均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.在制品待下月入库时核算成本，本月未核算在制品成本。销售费用（元）合计（元）#DIV/0!#DIV/0!2.费用按账面金额统计，唯一扣减的为管理费用中研究开发材料费用。费率采用的1-8月平均费用，按定额工时进行分配，准备工时除真空成品外，均采用50件为批量计算单件产品所包括的准备工时3.专修产品虽有办理入库，但系统中领料为统一领料，只能在假若全部领用用完且平均分配到每一产品中；生产订单号码行号类型物料编码物料名称物料规格生产订单数量入库数量00000006421标准0201001005400000006420000000642 汇汇总总0201001005400000006931标准0201016004000000006930000000693 汇汇总总0201016004000000007071标准0201016009600000007071标准0201016009600000007070000000707 汇汇总总0201016009600000007151标准0201001002300000007150000000715 汇汇总总0201001002300000007341标准0201001012500000007340000000734 汇汇总总0201001012500000008061标准0201001006100000008060000000806 汇汇总总0201001006100000008081标准0201001008400000008080000000808 汇汇总总0201001008400000008091标准0201001008400000008090000000809 汇汇总总0201001008400000008121标准0201017001600000008120000000812 汇汇总总0201017001600000008391标准0201001004300000008391标准0201001004300000008390000000839 汇汇总总0201001004300000008471标准0201001011800000008470000000847 汇汇总总0201001011800000008501标准0201027001900000008500000000850 汇汇总总0201027001900000008511标准0201027001900000008510000000851 汇汇总总0201027001900000008521标准0201027001900000008520000000852 汇汇总总0201027001900000008611标准0201027001900000008610000000861 汇汇总总0201027001900000008621标准0201027001900000008620000000862 汇汇总总0201027001900000008831标准0201016004000000008830000000883 汇汇总总0201016004000000008841标准0201001009200000008840000000884 汇汇总总0201001009200000008891标准0201001007100000008890000000889 汇汇总总0201001007100000008941标准0201025003300000008940000000894 汇汇总总0201025003300000008961标准0201025000600000008960000000896 汇汇总总0201025000600000009011标准0201025001400000009010000000901 汇汇总总0201025001400000009021标准0201025004000000009020000000902 汇汇总总0201025004000000009051标准0201025001900000009050000000905 汇汇总总0201025001900000009061标准0201025003700000009060000000906 汇汇总总0201025003700000009081标准0201025002400000009080000000908 汇汇总总0201025002400000009101标准0201025002700000009100000000910 汇汇总总0201025002700000009111标准0201016022800000009111标准0201016022800000009110000000911 汇汇总总0201016022800000009171标准0201001008500000009170000000917 汇汇总总0201001008500000009181标准0201001005100000009180000000918 汇汇总总0201001005100000009191标准0201001006800000009190000000919 汇汇总总0201001006800000009231标准0201001011600000009230000000923 汇汇总总0201001011600000009241标准0201001011800000009240000000924 汇汇总总0201001011800000009331标准0201016010200000009330000000933 汇汇总总0201016010200000009421标准0201016003600000009420000000942 汇汇总总0201016003600000009481标准0201027001900000009480000000948 汇汇总总0201027001900000009491标准0201001002900000009491标准0201001002900000009491标准0201001002900000009491标准0201001002900000009491标准0201001002900000009490000000949 汇汇总总0201001002900000009651标准0201016016500000009651标准0201016016500000009651标准0201016016500000009651标准0201016016500000009650000000965 汇汇总总0201016016500000009661标准0201016015500000009661标准0201016015500000009660000000966 汇汇总总0201016015500000009721标准0201016027000000009721标准0201016027000000009721标准0201016027000000009720000000972 汇汇总总0201016027000000009732标准0201016014700000009732标准0201016014700000009730000000973 汇汇总总0201016014700000009771标准0201001000400000009770000000977 汇汇总总0201001000400000009901标准0201001003100000009900000000990 汇汇总总0201001003100000009911标准0201001003200000009910000000991 汇汇总总0201001003200000010201标准0201019000300000010201标准0201019000300000010201标准0201019000300000010201标准0201019000300000010201标准0201019000300000010201标准0201019000300000010200000001020 汇汇总总0201019000300000010241标准0201016025900000010241标准0201016025900000010240000001024 汇汇总总0201016025900000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010251标准020101630200000010250000001025 汇汇总总020101630200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010261标准0201016027200000010260000001026 汇汇总总0201016027200000010371标准0201001009700000010370000001037 汇汇总总0201001009700000010381标准0201001009800000010380000001038 汇汇总总0201001009800000010401标准0201001006600000010400000001040 汇汇总总0201001006600000010421标准0201001007700000010420000001042 汇汇总总0201001007700000010471标准0201016003100000010470000001047 汇汇总总0201016003100000010481标准0201016004000000010480000001048 汇汇总总0201016004000000010501标准0201016007000000010500000001050 汇汇总总0201016007000000010511标准0201016007100000010510000001051 汇汇总总0201016007100000010521标准0201016009400000010520000001052 汇汇总总0201016009400000010731标准0201016011300000010730000001073 汇汇总总0201016011300000010781标准0201001013000000010780000001078 汇汇总总0201001013000000010811标准0201001005200000010811标准0201001005200000010811标准0201001005200000010811标准0201001005200000010811标准0201001005200000010810000001081 汇汇总总0201001005200000010821标准0201001012100000010821标准0201001012100000010820000001082 汇汇总总0201001012100000010831标准0201001002900000010831标准0201001002900000010831标准0201001002900000010831标准0201001002900000010831标准0201001002900000010830000001083 汇汇总总0201001002900000010971标准0201001009500000010971标准0201001009500000010970000001097 汇汇总总0201001009500000011041标准0201016001900000011041标准0201016001900000011041标准0201016001900000011041标准0201016001900000011041标准0201016001900000011041标准0201016001900000011040000001104 汇汇总总0201016001900000011051标准0201001008200000011051标准0201001008200000011050000001105 汇汇总总0201001008200000011061标准0201002000700000011060000001106 汇汇总总0201002000700000011181标准0201016022500000011181标准0201016022500000011180000001118 汇汇总总0201016022500000011191标准0202011006300000011190000001119 汇汇总总0202011006300000011201标准0201016006400000011201标准0201016006400000011200000001120 汇汇总总0201016006400000011231标准0201016005100000011231标准0201016005100000011230000001123 汇汇总总0201016005100000011281标准0201001000700000011280000001128 汇汇总总0201001000700000011341标准0201001009700000011340000001134 汇汇总总0201001009700000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011441标准0201016000500000011440000001144 汇汇总总0201016000500000011691标准0201019002600000011690000001169 汇汇总总0201019002600000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011791标准0201016017200000011790000001179 汇汇总总0201016017200000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011801标准0201016027300000011800000001180 汇汇总总0201016027300000011891标准0201016025900000011891标准0201016025900000011890000001189 汇汇总总0201016025900000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011921标准020103600500000011920000001192 汇汇总总020103600500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012021标准0201016005500000012020000001202 汇汇总总0201016005500000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012121标准0201016028800000012120000001212 汇汇总总0201016028800000012181标准0201001009800000012180000001218 汇汇总总0201001009800000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012401标准0201027004100000012400000001240 汇汇总总0201027004100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011711标准0201027000100000011710000001171 汇汇总总0201027000100000011721标准0201027003600000011720000001172 汇汇总总0201027003600000011771标准0201027003300000011770000001177 汇汇总总0201027003300000011781标准0201027001000000011780000001178 汇汇总总0201027001000000011841标准0201025002000000011841标准0201025002000000011840000001184 汇汇总总0201025002000000011851标准0201025003600000011851标准0201025003600000011850000001185 汇汇总总0201025003600000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011871标准0201025002200000011870000001187 汇汇总总0201025002200000012051标准0201025002600000012050000001205 汇汇总总0201025002600000011911标准0201019004400000011910000001191 汇汇总总0201019004400000011951标准0201029101200000011951标准0201029101200000011951标准0201029101200000011950000001195 汇汇总总0201029101200000011961标准0201029101100000011961标准0201029101100000011960000001196 汇汇总总0201029101100000011971标准0201029101400000011971标准0201029101400000011971标准0201029101400000011970000001197 汇汇总总0201029101400000012351标准0201029101100000012350000001235 汇汇总总0201029101100000012361标准0201029101200000012361标准0201029101200000012360000001236 汇汇总总0201029101200000012371标准0201029101400000012371标准0201029101400000012370000001237 汇汇总总02010291014子件物料编码子件物料名称子件物料规格子件计量单位标准用量实际用量材料单价0303030002件50.0050.0046.15030200101006KG336.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个299.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.44030100109006KG167.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.26030200101010KG20.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.050305037KG191.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.2302010160150件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.2602010160127件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.5602010160147件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.00150.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.81245.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.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件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.007.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.2002010160178件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.