生产计划表

生产计划管理表序号接单日期产品名称颜色2014-3-25材料准备时间订单量本计划表按每周5天工作制自动排标准日产能生产计划及执及行情况日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量第1天9-790%81012012-9-251200090071588.27%7155.96%112859-380%96022012-8-30210000120045046.88%4504.50%9550n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%034567891011实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%121314151617计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a181920预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺日 期预计产能饱合率计划日产量实际日产量计划达成率累计完成数订单完成率差 缺80%0n/a000n/a80%0n/a000n/a100%0n/a000自动排定；同时法定假日将自动扣除；

第2天9-10100%900901100.11%161613.47%103849-4100%1200第3天9-11100%900910101.11%252621.05%94749-5100%1200第4天9-12100%900950105.56%347628.97%85249-6100%1200第5天9-13100%900第6天9-14100%900第7天9-17100%900第8天9-18100%900第9天9-19100%900第10天9-20100%90030033.33%377631.47%82249-7100%12000.00%377631.47%82249-10100%12000.00%377631.47%82249-11100%12000.00%377631.47%82249-12100%12000.00%377631.47%82249-13100%6400.00%377631.47%82249-14100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%4504.50%9550n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%00.00%4504.50%9550n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%00.00%4504.50%9550n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%00.00%4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a000n/a0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a90%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a80%0n/a000n/a80%0n/a000n/a80%0n/a00090%0n/a000n/a90%0n/a000n/a90%0n/a00090%0n/a000n/a90%0n/a000n/a90%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000第11天9-21100%900第12天9-24100%900第13天9-25100%900第14天9-26100%390第15天9-27100%0n/a377631.47%82249-21100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第16天9-28100%0n/a377631.47%82249-24100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第17天10-8100%0n/a377631.47%82249-25100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第18天10-9100%0n/a377631.47%82249-26100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第19天10-10100%0n/a377631.47%82249-27100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%377631.47%82249-17100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%377631.47%82249-18100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%377631.47%82249-19100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%00.00%377631.47%82249-20100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000第20天10-11100%0n/a377631.47%82249-28100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第21天10-12100%0n/a377631.47%822410-8100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第22天10-15100%0n/a377631.47%822410-9100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第23天10-16100%0n/a377631.47%822410-10100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第24天10-17100%0n/a377631.47%822410-11100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第25天10-18100%0n/a377631.47%822410-12100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第26天10-19100%0n/a377631.47%822410-15100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第27天10-22100%0n/a377631.47%822410-16100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第28天10-24100%0n/a377631.47%822410-17100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000第29天10-25100%0n/a377631.47%822410-18100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第30天10-26100%0n/a377631.47%822410-19100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0第31天10-29100%0n/a377631.47%822410-22100%0n/a4504.50%9550n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0全年节假日日期1-221-231-241-256-237-18-19-3010-110-210-310-410-510-2310-3112-2412-25节日名称除夕春节春节春节端午节建党日建军节中秋节国庆节国庆节国庆节国庆节国庆节重阳节万圣节平安夜圣诞节n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000100%0n/a000n/a100%0n/a000n/a100%0n/a000