订单生产进度控制表（全自动计算）

生产管理工具——生产计划与控制管理,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

订单生产进度控制表（全自动计算生产进展数据）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

您好！今天是,,,,,2016年1月19日,,,,,1、全自动计算每一份订单计划达成率、累计达成率、生产效率、每日累计差缺数量，让您清晰掌控所有订单的生产进展情况。,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,2、自动进行生产排程，根据订单总量、日产能力、预计产能饱和率、所需准备日期，自动安排每日产量及日程，日期为自动显示。（若遇节假日应考虑顺延）日期以2016年为例。,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

序号,负责车间,责任人,接单日期,交货期,订单号,生产单号,产品名称,规格型号,计量单位,"准备时间

(天)",订单总量,标准工时（H）,"标准

日产能","生产计划

及进展监控",第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

,,,,,,,,,,,,,,预计产能饱合率,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%

,,,,,,,,,,,,,,计划日产量,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

,,,,,,,,,,,,,,实际日产量,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

,,,,,,,,,,,,,,累计完成数,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

,,,,,,,,,,,,,,产出工时,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,生产效率,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

,,,,,,,,,,,,,,预计产能饱合率,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%

,,,,,,,,,,,,,,计划日产量,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

,,,,,,,,,,,,,,实际日产量,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

,,,,,,,,,,,,,,累计完成数,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

,,,,,,,,,,,,,,产出工时,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,生产效率,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

,,,,,,,,,,,,,,预计产能饱合率,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%

,,,,,,,,,,,,,,计划日产量,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

,,,,,,,,,,,,,,实际日产量,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

,,,,,,,,,,,,,,累计完成数,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

,,,,,,,,,,,,,,产出工时,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,生产效率,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

,,,,,,,,,,,,,,预计产能饱合率,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%

,,,,,,,,,,,,,,计划日产量,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

,,,,,,,,,,,,,,实际日产量,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

,,,,,,,,,,,,,,累计完成数,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

,,,,,,,,,,,,,,产出工时,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,生产效率,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

,,,,,,,,,,,,,,预计产能饱合率,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%

,,,,,,,,,,,,,,计划日产量,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

,,,,,,,,,,,,,,实际日产量,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

,,,,,,,,,,,,,,累计完成数,260,740,820,820,820,820,820,820,820,820,820,820,820,8