生产计划管理表(wps).xls

生生产产计计划划管管理理表表2012 9 32012 9 3 本本计计划划表表按按每每周周5 5天天工工作作制制自自动动排排定定 同同时时法法定定假假日日将将自自动动扣扣除除 序号接单日期产品名称颜色材料 准备时间 天 订单量 标准 日产能 生产计划 及执及行情况 第1天第2天 12012 9 2512000900 日 期9 79 10 预计产能饱合率90 100 计划日产量810900 实际日产量715715901901 计划达成率88 27 88 27 100 11 100 11 累计完成数7151616 订单完成率5 96 13 47 差 缺1128510384 22012 8 302100001200 日 期9 39 4 预计产能饱合率80 100 计划日产量9601200 实际日产量450450 计划达成率46 88 46 88 0 00 0 00 累计完成数450450 订单完成率4 50 4 50 差 缺95509550 3 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 4 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 5 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 6 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 7 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 8 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 9 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 10 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 11 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 12 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 6 累计完成数00 订单完成率00 差 缺00 13 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 14 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 15 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 16 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 17 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 18 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 12 累计完成数00 订单完成率00 差 缺00 19 日 期n an a 预计产能饱合率80 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 20 日 期n an a 预计产能饱合率100 80 计划日产量00 实际日产量 计划达成率n an an an a 累计完成数00 订单完成率00 差 缺00 18 第3天第4天第5天第6天第7天第8天第9天第10天第11天第12天 9 119 129 139 149 179 189 199 209 219 24 100 100 100 100 100 100 100 100 100 100 900900900900900900900900900900 910910950950300300 101 11 101 11 105 56 105 56 33 33 33 33 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 2526347637763776377637763776377637763776 21 05 28 97 31 47 31 47 31 47 31 47 31 47 31 47 31 47 31 47 9474852482248224822482248224822482248224 9 59 69 79 109 119 129 139 149 179 18 100 100 100 100 100 100 100 100 100 100 120012001200120012001200640000 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 n an an an an an a 450450450450450450450450450450 4 50 4 50 4 50 4 50 4 50 4 50 4 50 4 50 4 50 4 50 9550955095509550955095509550955095509550 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 本本计计划划表表按按每每周周5 5天天工工作作制制自自动动排排定定 同同时时法法定定假假日日将将自自动动扣扣除除 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 90 90 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 第13天第14天第15天第16天第17天第18天第19天第20天第21天第22天 9 259 269 279 2810 810 910 1010 1110 1210 15 100 100 100 100 100 100 100 100 100 100 90039000000000 0 00 0 00 0 00 0 00 n an an an an an an an an an an an an an an an a 3776377637763776377637763776377637763776 31 47 31 47 31 47 31 47 31 47 31 47 31 47 31 47 31 47 31 47 8224822482248224822482248224822482248224 9 199 209 219 249 259 269 279 2810 810 9 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 450450450450450450450450450450 4 50 4 50 4 50 4 50 4 50 4 50 4 50 4 50 4 50 4 50 9550955095509550955095509550955095509550 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 本本计计划划表表按按每每周周5 5天天工工作作制制自自动动排排定定 同同时时法法定定假假日日将将自自动动扣扣除除 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 n an an an an an an an an an a 100 100 100 100 100 100 100 100 100 100 0000000000 n an an an an an an an an an an an an an an an an an an an a 0000000000 0000000000 0000000000 第23天第24天第25天第26天第27天第28天第29天第30天第31天全年节假日 10 1610 1710 1810 1910 2210 2410 2510 2610 29日期 100 100 100 100 100 100 100 100 100 1 22 0000000001 23 1 24 n an an an an an an an an an an an an an an an an an a1 25 3776377637763776377637763776377637766 23 31 47 31 47 31 47 31 47 31 47 31 47 31 47 31 47 31 47 7 1 8224822482248224822482248224822482248 1 10 1010 1110 1210 1510 1610 1710 1810 1910 229 30 100 100 100 100 100 100 100 100 100 10 1 00000000010 2 10 3 n an an an an an an an an an an an an an an an an an a10 4 45045045045045045045045045010 5 4 50 4 50 4 50 4 50 4 50 4 50 4 50 4 50 4 50 10 23 95509550955095509550955095509550955010 31 n an an an an an an an an a12 24 100 100 100 100 100 100 100 100 100 12 25 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an an a 100 100 100 100 100 100 100 100 100 000000000 n an an an an an an an an an an an an an an an an an a 000000000 000000000 000000000 n an an an an an an an