产品成本分析表

版次/version:报价单号/QuotationNo:客户名称/Customer:项目状态/Projectstate:项目名称/ProjectName:注意:所有物料均为未税价项目经理/PM:报价单位/Quotdept.:日期/Date：项目进度：试产前，试产，量产20K，量产50K，量产100K工艺成型涂装加工外购件组装外发加工NCVMtotal报价单总价成本费用5.624.412.170.110.150.54#DIV/0!#DIV/0!实际报价利润率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!成型成本分析明细表NO部品名称CAV模数原料名称产品啤重(g)产品净重(g)水口重量(g)材料单价(RMB/KG)水口料净值（RMB/kg)材料费/pcs机台(T)机台费用(RMB/H)成型时间（S）制造费用/pcs二次加工或嵌入外购费用注塑损耗率%损耗费用包装费用/pcs注射费用合计1A壳1PC透明+PC白色15.409.406.004850.70910045360.4500.4010%0.161.722B壳1PC白色9.206.203.004850.42710045260.3258%0.060.813C壳1PC白色8.805.803.004850.40710045280.3500.4008%0.091.254D壳1PC白色9.806.603.204850.45410045280.3500.2008%0.081.085电池盖1PC白色6.804.302.504850.31410045220.2755%0.030.626A装饰片4PC原料1.560.061.324850.0175035200.0493%0.000.077防撞垫8TPU1.660.021.501800.0045035180.0223%0.000.038转轴缓冲垫4TPU1.100.021.02180.0055035180.0443%0.000.0590.00#DIV/0!#DIV/0!6%#DIV/0!#DIV/0!5.622011.12.28合计塑胶产品生产成本分析明细表喷涂成本分析明细表序号部品名称PRIMER用量(g)单价/KG稀释剂用量(g)单价/KG硬化剂用量(g)单价/KG底漆用量(g)单价/KG稀释剂用量(g)单价/KG硬化剂用量（g）单价/KG面漆用量（g）单价/KG稀释剂用量（g）单价/KG硬化剂用量（g）单价/KG材料费TOTAL1B壳1.5079.003.0019.002.1083.003.0019.000.41C壳1.5079.003.0019.002.2083.003.0019.000.422D壳1.8077.003.2025.642.5083.003.4019.000.493电池盖2.00115.003.5036.002.8083.003.8019.000.66序号部品名称喷涂工艺制造费用/pcs损耗率%损耗费用/pcs治具模费用分摊数治具成型单价使用次数治具费用(元/次)包装费用/pcs合计1B壳二涂0.3010%0.24150001500000.170030.09000.051.09C壳二涂0.3010%0.15150001500000.170030.09000.051.012D壳二涂0.3010%0.16150001500000.100030.06670.051.073电池盖二涂0.308%0.18150001500000.070030.05670.051.244.41合计加工成本分析明细表序号部品名称工艺材料单价(RMB/KG)用量（g/pcs)开油水单价(RMB/KG)用量（g/pcs)固化漆单价(RMB/KG)用量（g/pcs)材料成本（元/pcs)加工次数加工单价(pcs)制造费用(pcs)损耗率%损耗费用合计1A壳丝印21000.2200.052000.020.42530.150.455%0.181.062电池盖丝印21000.3200.062000.020.635210.150.402%0.081.12合计2.17外购件和组装成本分析明细表配件名称摄像头装饰件背胶喇叭方程网摄像头泡棉合计(含税)合计(不含税)用量(/pcs)111损耗率Scrap0.5%0.5%0.5%单价0.030.050.05材料费用0.030.050.050.000.000.000.000.000.000.000.000.000.000.130.11装配费用0.050.050.050.15外发加工和组装成本分析明细表配件名称A壳装饰件合计用量(/pcs)1外加工损耗率5.0%外加工单价0.5材料费用0.000.540.000.000.54装配费用0特殊工艺水电镀NCVMIMLEMINCVM成本分析明细表序号部品名称底涂UV(g)单价/KG中涂UV(g)单价/KG面涂UV(g)单价/KG黄色色精(g)单价/KG棕褐色色精(g)单价/KG黑色色精(g)单价/KG小筐钨丝根/PC单价/根膜材g/pcS12单价/KG材料费TOTAL10.0020.00序号部品名称数量颜色喷涂工艺制造费用/pcs损耗率%损耗费用/pcs治具模费用分摊数治具成型单价使用次数治具费用(元/次)包装费用/pcs合计10.00#DIV/0!#DIV/0!2合计#DIV/0!注意:以上所有用量和材料费为单个产品说明:1.黄色部分不要动,里面设有函数,批注里有函数说明.2.白色和蓝色部分均需填写,而蓝色部分要认真填写,否则影响最终结果.3.所有用量和单价精确到0.01,最小用量是0.01g.4.喷涂的制造费用根据一套治具装1pcs产品为标准,一套治具装2pcs费用=标准费用/2,以此类推.5.治具的成型费用根据一套治具装1pcs产品为标准,一套治具装2pcs费用=标准费用/2,以此类推6.加工成本的损耗栏里要确认上一工序是成型还是成型+喷涂,损耗的成本函数要做相应变更.7.外发加工单价和原料,油漆,油墨,溶化,等材料单价注意填不含税单价.外购配件填未含税价.8.NCVM成本分析表只用于本公司生产成本分析,外发生产填在外发加工成本一栏.10.成本计算只算消耗物料,可多次重复使用物料不算成本(如钢板,热熔治具),11.固定收费标准请参考如下.a.注塑机50T---30元/Hb.注塑机100T---45元/Hc.注塑机160T---80元/Hc.注塑机200T---100元/Hd.注塑机双色160T---120元/He.喷涂线---0.30元/一涂,以此类推f.印刷---0.10/次g.导电漆/导电胶---0.25元/次h.组装普通泡棉背胶---0.05-0.1/pcsi.热熔超声---0.15-0.25/pcsj.喷涂治具大(如前壳治具)---0.1元/片k.喷涂治具中(如电池盖治具,前壳治具片)---0.07元/片l.喷涂治具小(如小治具片/小塞子)---0.04元/片机台吨位元/小时50T30100T45120T65150T80180T951挂4元/个1挂8元/个1涂0.301涂0.152涂0.602涂0.303涂0.903涂0.604涂1.204涂0.901PCS元/个1PCS元/个1涂0.101涂0.102涂0.202涂0.203涂0.303涂0.304涂0.404涂0.40成型机台工费率涂装制造费用印刷制造费用移印工艺丝印工艺版次/version:报价单号/QuotationNo:客户名称/Customer:项目状态/Projectstate:项目名称/ProjectName:注意:所有物料均为未税价项目经理/PM:报价单位/Quotdept.:日期/Date：项目进度：试产前，试产，量产20K，量产50K，量产100K工艺成型涂装加工外购件组装外发加工NCVMtotal报价单总价成本费用8.676.552.170.110.150.54#DIV/0!#DIV/0!实际报价利润率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!成型成本分析明细表NO部品名称CAV模数原料名称产品啤重(g)产品净重(g)水口重量(g)材料单价(RMB/KG)水口料净值（RMB/kg)材料费/pcs机台(T)机台费用(RMB/H)成型时间（S）制造费用/pcs二次加工或嵌入外购费用注塑损耗率%损耗费用包装费用/pcs注射费用合计1A壳1PC透明+PC白色15.409.406.004850.70910045360.4500.4010%0.161.722B壳1PC白色9.206.203.004850.42710045260.3258%0.060.813C壳1PC白色8.805.803.004850.40710045280.3500.4008%0.091.254D壳1PC白色9.806.603.204850.45410045280.3500.2008%0.081.085电池盖1PC白色15.007.807.2011551.72510045300.3758%0.172.276A装饰片1PC原料11.003.008.0011551.2255035200.1943%0.041.467防撞垫8TPU1.660.021.501800.0045035180.0223%0.000.038转轴缓冲垫4TPU1.100.021.02180.0055035180.0443%0.000.0590.00#DIV/0!#DIV/0!6%#DIV/0!#DIV/0!8.67塑胶产品生产成本分析明细表2011.12.28合计喷涂成本分析明细表序号部品名称PRIMER用量(g)单价/KG稀释剂用量(g)单价/KG硬化剂用量(g)单价/KG底漆用量(g)单价/KG稀释剂用量(g)单价/KG硬化剂用量（g）单价/KG面漆用量（g）单价/KG稀释剂用量（g）单价/KG硬化剂用量（g）单价/KG材料费TOTAL1B壳1.5079.003.0019.002.1083.003.0019.000.41C壳1.5079.003.0019.002.2083.003.0019.000.422D壳1.8077.003.2025.642.5083.003.4019.000.493电池盖2.00150.003.5036.002.80150.003.8025.000.94序号部品名称喷涂工艺制造费用/pcs损耗率%损耗费用/pcs治具模费用分摊数治具成型单价使用次数治具费用(元/次)包装费用/pcs合计1B壳二涂0.3010%0.24150001500000.170030.09000.051.09C壳二涂0.3010%0.15150001500000.170030.09000.051.012D壳二涂0.3010%0.16150001500000.100030.06670.051.073电池盖二涂2.008%0.34150001500000.070030.05670.053.386.55合计加工成本分析明细表序号部品名称工艺材料单价(RMB/KG)用量（g/pcs)开油水单价(RMB/KG)用量（g/pcs)固化漆单价(RMB/KG)用量（g/pcs)材料成本（元/pcs)加工次数加工单价(pcs)制造费用(pcs)损耗率%损耗费用合计1A壳丝印21000.2200.052000.020.42530.150.455%0.181.062电池盖丝印21000.3200.062000.020.635210.150.402%0.081.12合计2.17外购件和组装成本分析明细表配件名称摄像头装饰件背胶喇叭方程网摄像头泡棉合计(含税)合计(不含税)用量(/pcs)111损耗率Scrap0.5%0.5%0.5%单价0.030.050.05材料费用0.030.050.050.000.000.000.000.000.000.000.000.000.000.130.11装配费用0.050.050.050.15外发加工和组装成本分析明细表配件名