试产成本核算用表格.xls

《试产成本核算用表格.xls》由会员分享，可在线阅读，更多相关《试产成本核算用表格.xls（10页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、客户项目产品图号品名单机用量材材料料模穴数材质材料单价 产品单重11#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A1#N/A水口重量 水口比率 损耗率 色粉比率 水口回收材料用量g转厂费用比例抽粒费率材料成本0%3.20%2.50%00.000.00%0.00#N/A0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50

2、%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/

3、0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV

4、/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!0%3.20%2.50%#DIV/0!#DIV/0!0.00%0.00#DIV/0!材材料料注注塑塑使用机台T加工单价 模温机数量设备成本汇总单台机投入人力单位人力成本每小时成本成型周期s注塑加工成本25045145235.5080.50300.67#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A

5、#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A#N/A1#N/A#N/A#N/A#N/A后后处处理理喷喷油油注塑不良率

6、注塑总成本油漆型号油漆价格(RMB/KG)开油水型号开油水价格(RMB/KG)油漆用量(g)开油水比例5.00%#N/A0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!

7、0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00喷油材料成本时产 投入人员喷油人工成本喷油总成本喷油不良率喷油后总成本丝印时产丝印投入人员0.000.000.00#N/A0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DI

8、V/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!后后处处理理喷喷油油丝印人工成本丝印总成本丝印不良率丝印后总成本组装时产组装投入人员组装人工成本组装不良率0.000.00#N/A0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.0

9、00.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0!0.000.000.00#DIV/0

10、!0.00包材成本比例包材成本运输成本比例运输成本管理经营成本比例组装后部品总成本#N/A3.09%#N/A0.70%#N/A15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.

11、09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#

12、DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%#DIV/0!3.09%#DIV/0!0.70%#DIV/0!15.75%管理经营成本总成本利润建议报价价格输输出出资资料料零件图号零件名称材料出模数#N/A#N/A8%#N/A0001#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0

13、000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0

14、000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000#DIV/0!#DIV/0!#DIV/0!0000单机用量 材料单价 制品单重 注塑机吨位 注塑周期 材料成本费注塑加工费喷油费丝印费组装费1#N/A025030#N/A0.670.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000

15、.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/

16、A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.001#N/A000#DIV/0!#N/A0.000.000.00输输出出资资料料包装费运费管理费用 总成本利润率建议报价价格#N/A#N/A#N/A#N/A8%#N/A#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DI

17、V/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!