訂單生產(chǎn)進度控制表（全自動計算）

生產(chǎn)管理工具——生產(chǎn)計劃與控制管理,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

訂單生產(chǎn)進度控制表（全自動計算生產(chǎn)進展數(shù)據(jù)）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

您好！今天是,,,,,2016年1月19日,,,,,1、全自動計算每一份訂單計劃達成率、累計達成率、生產(chǎn)效率、每日累計差缺數(shù)量，讓您清晰掌控所有訂單的生產(chǎn)進展情況。,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,2、自動進行生產(chǎn)排程，根據(jù)訂單總量、日產(chǎn)能力、預計產(chǎn)能飽和率、所需準備日期，自動安排每日產(chǎn)量及日程，日期為自動顯示。（若遇節(jié)假日應考慮順延）日期以2016年為例。,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

序號,負責車間,責任人,接單日期,交貨期,訂單號,生產(chǎn)單號,產(chǎn)品名稱,規(guī)格型號,計量單位,"準備時間

(天)",訂單總量,標準工時（H）,"標準

日產(chǎn)能","生產(chǎn)計劃

及進展監(jiān)控",第1天,第2天,第3天,第4天,第5天,第6天,第7天,第8天,第9天,第10天,第11天,第12天,第13天,第14天,第15天,第16天,第17天,第18天,第19天,第20天,第21天,第22天,第23天,第24天,第25天,第26天,第27天,第28天,第29天,第30天,第31天

1,,,2016/2/4,,,,,,,3,6500,0.50,300,星期,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二

,,,,,,,,,,,,,,日期,2/7,2/8,2/9,2/10,2/11,2/12,2/13,2/14,2/15,2/16,2/17,2/18,2/19,2/20,2/21,2/22,2/23,2/24,2/25,2/26,2/27,2/28,2/29,3/1,3/2,3/3,3/4,3/5,3/6,3/7,3/8

,,,,,,,,,,,,,,預計產(chǎn)能飽合率,90%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%

,,,,,,,,,,,,,,計劃日產(chǎn)量,270,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,230,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際日產(chǎn)量,260,320,300,310,310,320,310,310,310,310,310,310,320,310,320,320,310,300,320,310,310,240,,,,,,,,,

,,,,,,,,,,,,,,計劃達成率,96.30%,106.67%,100.00%,103.33%,103.33%,106.67%,103.33%,103.33%,103.33%,103.33%,103.33%,103.33%,106.67%,103.33%,106.67%,106.67%,103.33%,100.00%,106.67%,103.33%,103.33%,104.35%,n/a,n/a,n/a,n/a,n/a,n/a,n/a,n/a,n/a

,,,,,,,,,,,,,,累計完成數(shù),260,580,880,1190,1500,1820,2130,2440,2750,3060,3370,3680,4000,4310,4630,4950,5260,5560,5880,6190,6500,6740,6740,6740,6740,6740,6740,6740,6740,6740,6740

,,,,,,,,,,,,,,訂單完成率,4.00%,8.92%,13.54%,18.31%,23.08%,28.00%,32.77%,37.54%,42.31%,47.08%,51.85%,56.62%,61.54%,66.31%,71.23%,76.15%,80.92%,85.54%,90.46%,95.23%,100.00%,103.69%,103.69%,103.69%,103.69%,103.69%,103.69%,103.69%,103.69%,103.69%,103.69%

,,,,,,,,,,,,,,差缺,6240,5920,5620,5310,5000,4680,4370,4060,3750,3440,3130,2820,2500,2190,1870,1550,1240,940,620,310,0,-240,-240,-240,-240,-240,-240,-240,-240,-240,-240

,,,,,,,,,,,,,,產(chǎn)出工時,130,160,150,155,155,160,155,155,155,155,155,155,160,155,160,160,155,150,160,155,155,120,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際出勤工時,145,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,生產(chǎn)效率,89.66%,#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!

2,,,2016/2/6,,,,,,,2,3000,0.20,200,星期,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三

,,,,,,,,,,,,,,日期,2/8,2/9,2/10,2/11,2/12,2/13,2/14,2/15,2/16,2/17,2/18,2/19,2/20,2/21,2/22,2/23,2/24,2/25,2/26,2/27,2/28,2/29,3/1,3/2,3/3,3/4,3/5,3/6,3/7,3/8,3/9

,,,,,,,,,,,,,,預計產(chǎn)能飽合率,90%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%

,,,,,,,,,,,,,,計劃日產(chǎn)量,180,200,200,200,200,200,200,200,200,200,200,200,200,200,200,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際日產(chǎn)量,160,190,210,210,210,210,210,210,210,210,210,210,210,210,210,30,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,計劃達成率,88.89%,95.00%,105.00%,105.00%,105.00%,105.00%,105.00%,105.00%,105.00%,105.00%,105.00%,105.00%,105.00%,105.00%,105.00%,150.00%,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

,,,,,,,,,,,,,,累計完成數(shù),160,350,560,770,980,1190,1400,1610,1820,2030,2240,2450,2660,2870,3080,3110,3110,3110,3110,3110,3110,3110,3110,3110,3110,3110,3110,3110,3110,3110,3110

,,,,,,,,,,,,,,訂單完成率,5.33%,11.67%,18.67%,25.67%,32.67%,39.67%,46.67%,53.67%,60.67%,67.67%,74.67%,81.67%,88.67%,95.67%,102.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%,103.67%

,,,,,,,,,,,,,,差缺,2840,2650,2440,2230,2020,1810,1600,1390,1180,970,760,550,340,130,-80,-110,-110,-110,-110,-110,-110,-110,-110,-110,-110,-110,-110,-110,-110,-110,-110

,,,,,,,,,,,,,,產(chǎn)出工時,32,38,42,42,42,42,42,42,42,42,42,42,42,42,42,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際出勤工時,36,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,生產(chǎn)效率,88.89%,#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!

3,,,2016/2/2,,,,,,,6,8000,0.10,500,星期,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三

,,,,,,,,,,,,,,日期,2/8,2/9,2/10,2/11,2/12,2/13,2/14,2/15,2/16,2/17,2/18,2/19,2/20,2/21,2/22,2/23,2/24,2/25,2/26,2/27,2/28,2/29,3/1,3/2,3/3,3/4,3/5,3/6,3/7,3/8,3/9

,,,,,,,,,,,,,,預計產(chǎn)能飽合率,90%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%

,,,,,,,,,,,,,,計劃日產(chǎn)量,450,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際日產(chǎn)量,360,480,520,520,520,510,510,510,510,510,510,510,510,510,510,490,20,,,,,,,,,,,,,,

,,,,,,,,,,,,,,計劃達成率,80.00%,96.00%,104.00%,104.00%,104.00%,102.00%,102.00%,102.00%,102.00%,102.00%,102.00%,102.00%,102.00%,102.00%,102.00%,98.00%,40.00%,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

,,,,,,,,,,,,,,累計完成數(shù),360,840,1360,1880,2400,2910,3420,3930,4440,4950,5460,5970,6480,6990,7500,7990,8010,8010,8010,8010,8010,8010,8010,8010,8010,8010,8010,8010,8010,8010,8010

,,,,,,,,,,,,,,訂單完成率,4.50%,10.50%,17.00%,23.50%,30.00%,36.38%,42.75%,49.13%,55.50%,61.88%,68.25%,74.63%,81.00%,87.38%,93.75%,99.88%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%,100.13%

,,,,,,,,,,,,,,差缺,7640,7160,6640,6120,5600,5090,4580,4070,3560,3050,2540,2030,1520,1010,500,10,-10,-10,-10,-10,-10,-10,-10,-10,-10,-10,-10,-10,-10,-10,-10

,,,,,,,,,,,,,,產(chǎn)出工時,36,48,52,52,52,51,51,51,51,51,51,51,51,51,51,49,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際出勤工時,39,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,生產(chǎn)效率,92.31%,#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!

4,,,2016/2/10,,,,,,,5,1000,0.80,180,星期,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三

,,,,,,,,,,,,,,日期,2/15,2/16,2/17,2/18,2/19,2/20,2/21,2/22,2/23,2/24,2/25,2/26,2/27,2/28,2/29,3/1,3/2,3/3,3/4,3/5,3/6,3/7,3/8,3/9,3/10,3/11,3/12,3/13,3/14,3/15,3/16

,,,,,,,,,,,,,,預計產(chǎn)能飽合率,90%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%

,,,,,,,,,,,,,,計劃日產(chǎn)量,162,180,180,180,180,118,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際日產(chǎn)量,120,170,185,185,185,160,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,計劃達成率,74.07%,94.44%,102.78%,102.78%,102.78%,135.59%,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,n/a,n/a,n/a,n/a,n/a,n/a,n/a,n/a

,,,,,,,,,,,,,,累計完成數(shù),120,290,475,660,845,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005

,,,,,,,,,,,,,,訂單完成率,12.00%,29.00%,47.50%,66.00%,84.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%,100.50%

,,,,,,,,,,,,,,差缺,880,710,525,340,155,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5,-5

,,,,,,,,,,,,,,產(chǎn)出工時,96,136,148,148,148,128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際出勤工時,120,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,生產(chǎn)效率,80.00%,#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!

5,,,2016/2/15,,,,,,,1,800,0.50,400,星期,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四,星期五,星期六,星期日,星期一,星期二,星期三,星期四

,,,,,,,,,,,,,,日期,2/16,2/17,2/18,2/19,2/20,2/21,2/22,2/23,2/24,2/25,2/26,2/27,2/28,2/29,3/1,3/2,3/3,3/4,3/5,3/6,3/7,3/8,3/9,3/10,3/11,3/12,3/13,3/14,3/15,3/16,3/17

,,,,,,,,,,,,,,預計產(chǎn)能飽合率,90%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%,100%

,,,,,,,,,,,,,,計劃日產(chǎn)量,360,400,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,實際日產(chǎn)量,260,480,80,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,計劃達成率,72.22%,120.00%,200.00%,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,n/a,n/a,n/a,n/a,n/a,n/a,n/a,n/a,n/a,n/a,n/a

,,,,,,,,,,,,,,累計完成數(shù),260,740,820,820,820,820,820,820,820,820,820,820,820,8