注塑车间生产计划安排表

注塑车间生产计划安排表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,更新时间：,2015/1/2114:06,,,,,,,计划周期:,2014年,,月,,日,到,,月,,日,,,,,,,,,,,,Rev,00

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

序号,"产品型号规格

(零部件名称)","计划

总产量","一模

出数",机台号,,人数,单位,原料品种规格型号,,,单件重量,,添加回料比例,预计损耗比例,材料领用与回收(KG),,,,计划生产情况,,,,,实际完成情况(套）,,,,,,,,

,,,,,客户,,,产品颜色,材料名称,,"产品

(g)","水口

(g)",,,新料用量,水口用量,回收水口,总用料量,"周期

(S)","班产量

(套)","班期

","开始

日期","完成

日期","完成

数量","未完成

数量",12/16,12/17,12/18,12/19,12/20,12/21,12/22

1,M20S左侧围上护板,1000,1,16#1400T,北汽,0,套,米色,PP-B-2,,1617,59,0%,0%,1676,0,59,1676,75,524.4,1.9,12/16,12/18,911,89,211,700,,,,,

2,M20左前门护板,2000,1,19#1400T,北汽,0,套,深灰,PP-C-2,,1900,59,0%,0%,3918,0,118,3918,70,561.8571429,3.6,,,1800,200,100,200,1500,,,,

3,SUVB柱下护板L/R,2000,2,2#1000T,逸海,0,套,黑色,PPX60A-1,,843,32,0%,0%,1750,0,64,1750,55,1430.181818,1.4,,,0,2000,,,,,,,

4,周转箱B箱,2000,1,14#800T,永流,0,套,灰色,PP,,831,3,0%,0%,1668,0,6,1668,79,497.8481013,4.0,,,0,2000,,,,,,,

5,SUVC柱上护板L,1000,1,15#780T,逸海,0,套,深灰,PPX60A-1,,896,94,0%,0%,990,0,94,990,75,524.4,1.9,12/18,12/19,0,1000,,,,,,,

6,H箱,1000,1,2#1000T,永流,0,套,灰色,PP,,1503,6,0%,0%,1509,0,6,1509,80,491.625,2.0,,,0,1000,,,,,,,

7,M20S后门拉手盒L/R,2000,2,19#136T,北汽,0,套,黑色,PP,,96,5,0%,0%,202,0,10,202,45,1748,1.1,,,0,2000,,,,,,,

8,M20S前门三角板本体L/R,2000,2,20#150T,北汽,0,套,黑色,PP,,68,19,0%,0%,174,0,38,174,52,1512.692308,1.3,,,0,2000,,,,,,,

9,油壶下壳体,2000,1,19#136T,永流,0,套,白色,PP,,50,5,0%,0%,110,0,10,110,57,690,2.9,,,0,2000,,,,,,,

10,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

11,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

12,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

13,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

14,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

15,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

16,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

17,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

18,,2000,#N/A,#N/A,#N/A,#N/A,套,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,2000,,,,,,,

19,,,#N/A,#N/A,#N/A,#N/A,,#N/A,#N/A,,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,0,0,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

计划所需原料明细,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

序号,材料种类,"需用新料

重量(KG)",,,,,,"已发新料

重量(KG)","新料

损耗率%","需用水口

重量(KG)","已发水口

重量(KG)",,"水口

损耗率%",,"需回收水口

重量(KG)",,"已回收水口

重量(KG)",,"水口

回收率%",,,,,,,,,,,,,

1,,9835,,,,,,9835,0.00%,0,,,#DIV/0!,,288,,,,0.00%,,,,,,,,,,,,,

2,,#N/A,,,,,,,#N/A,#N/A,,,#N/A,,#N/A,,,,#N/A,,,,,,,,,,,,,

3,,#N/A,,,,,,,#N/A,#N/A,,,#N/A,,#N/A,,,,#N/A,,,,,,,,,,,,,

4,,#N/A,,,,,,