订单完成情况统计表

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

订单完成情况统计表（日跟踪记录）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

您好！今天是,,,,2016年1月19日,,,,,说明：本表格主要用于跟踪记录每日订单完成情况并进行统计分析，分析数据包括当日完成率、累计完成率、合格率、预计尚需生产天数、生产效率等。其中关键数据信息皆为自动函数生成，颜色标注部分无需填入数字。（本表格会自动提示每份订单距离交货的日期，以及剩余任务尚需生产的天数。）,,,,,,,,,,,,,,,,,,,,

序号,负责车间/生产线,责任人,员工人数,当日工作时间（H）,挡产时间,订单号,生产单号,接单日期,交货期,今天距离交货日期天数,产品名称,规格型号,计量单位,订单总量,"标准

日产能",标准工时（H）,计划日产量,期初已完成数量,当日实际产量（合格数）,不合格数,累计完成数,当日达成率,累计达成率,差缺数,预计尚需天数,当日合格率,产能饱和率,当日生产效率,备注

1,,,10,9,1,,,2015/10/4,2015/10/26,-85,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

2,,,9,8,1,,,2015/10/5,2015/10/28,-83,,,,3500,360,0.20,350,2000,300,20,2300,85.71%,65.71%,1200,3,93.75%,88.89%,84.51%,

3,,,10,9,1,,,2015/10/6,2015/11/5,-75,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

4,,,7,9,1,,,2015/10/7,2015/11/6,-74,,,,2500,112,0.50,112,300,100,5,400,89.29%,16.00%,2100,19,95.24%,93.75%,80.65%,

5,,,10,9,1,,,2015/10/8,2015/11/7,-73,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

6,,,10,9,1,,,2015/10/9,2015/11/8,-72,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

7,,,10,9,1,,,2015/10/10,2015/11/9,-71,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

8,,,10,9,1,,,2015/10/11,2015/11/10,-70,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

9,,,10,9,1,,,2015/10/12,2015/11/4,-76,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

10,,,10,9,1,,,2015/10/13,2015/11/12,-68,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

11,,,10,9,1,,,2015/10/14,2015/11/13,-67,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

12,,,10,9,1,,,2015/10/15,2015/11/14,-66,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

13,,,10,9,1,,,2015/10/16,2015/11/7,-73,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

14,,,10,9,1,,,2015/10/17,2015/11/16,-64,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

15,,,10,9,1,,,2015/10/18,2015/11/17,-63,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

16,,,10,9,1,,,2015/10/19,2015/11/18,-62,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

17,,,10,9,1,,,2015/10/20,2015/11/5,-75,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

18,,,10,9,1,,,2015/10/21,2015/11/20,-60,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

19,,,10,9,1,,,2015/10/22,2015/11/2,-78,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,78.65%,

20,,,10,9,1,,,2015/10/23,2015/11/4,-76,,,,6500,400,0.20,400,4000,350,20,4350,87.50%,66.92%,2150,5,94.59%,92.50%,7