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

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

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

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

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

日產(chǎn)能",標(biāo)準(zhǔn)工時(shí)（H）,計(jì)劃日產(chǎn)量,期初已完成數(shù)量,當(dāng)日實(shí)際產(chǎn)量（合格數(shù)）,不合格數(shù),累計(jì)完成數(shù),當(dāng)日達(dá)成率,累計(jì)達(dá)成率,差缺數(shù),預(yù)計(jì)尚需天數(shù),當(dāng)日合格率,產(chǎn)能飽和率,當(dāng)日生產(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