注塑車間生產(chǎn)計劃安排表

注塑車間生產(chǎn)計劃安排表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,更新時間：,2015/1/2114:06,,,,,,,計劃周期:,2014年,,月,,日,到,,月,,日,,,,,,,,,,,,Rev,00

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

序號,"產(chǎn)品型號規(guī)格

(零部件名稱)","計劃

總產(chǎn)量","一模

出數(shù)",機臺號,,人數(shù),單位,原料品種規(guī)格型號,,,單件重量,,添加回料比例,預(yù)計損耗比例,材料領(lǐng)用與回收(KG),,,,計劃生產(chǎn)情況,,,,,實際完成情況(套）,,,,,,,,

,,,,,客戶,,,產(chǎn)品顏色,材料名稱,,"產(chǎn)品

(g)","水口

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

(S)","班產(chǎn)量

(套)","班期

","開始

日期","完成

日期","完成

數(shù)量","未完成

數(shù)量",12/16,12/17,12/18,12/19,12/20,12/21,12/22

1,M20S左側(cè)圍上護板,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,周轉(zhuǎn)箱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)",,,,,,"已發(fā)新料

重量(KG)","新料

損耗率%","需用水口

重量(KG)","已發(fā)水口

重量(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,,,,,,