訂單完成情況統(tǒng)計表

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

訂單完成情況統(tǒng)計表（日跟蹤記錄）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

您好！今天是,,,,2016年1月19日,,,,,說明：本表格主要用于跟蹤記錄每日訂單完成情況并進行統(tǒng)計分析，分析數(shù)據(jù)包括當日完成率、累計完成率、合格率、預計尚需生產(chǎn)天數(shù)、生產(chǎn)效率等。其中關(guān)鍵數(shù)據(jù)信息皆為自動函數(shù)生成，顏色標注部分無需填入數(shù)字。（本表格會自動提示每份訂單距離交貨的日期，以及剩余任務(wù)尚需生產(chǎn)的天數(shù)。）,,,,,,,,,,,,,,,,,,,,

序號,負責車間/生產(chǎn)線,責任人,員工人數(shù),當日工作時間（H）,擋產(chǎn)時間,訂單號,生產(chǎn)單號,接單日期,交貨期,今天距離交貨日期天數(shù),產(chǎn)品名稱,規(guī)格型號,計量單位,訂單總量,"標準

日產(chǎn)能",標準工時（H）,計劃日產(chǎn)量,期初已完成數(shù)量,當日實際產(chǎn)量（合格數(shù)）,不合格數(shù),累計完成數(shù),當日達成率,累計達成率,差缺數(shù),預計尚需天數(shù),當日合格率,產(chǎn)能飽和率,當日生產(chǎn)效率,備注

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