电子表格版生产排程计划表(更新版)

料号小时产能良率库存JL160-110095%JL160-25090%JL160-310090%JL160-45080%JL160-512090%NBC-12590%NBC-25095%NBC-315090%NBC-410090%NBC-55080%XL-17590%XL-210090%生产计划排程表（至柔版）日期1/261/271/281/291/301/312/12/22/3星期周三周四周五周六周日周一周二周三周四1WO00001JL160-11/28100095%60002150100215060.001/261/261/28计划2150215017002WO00002JL160-21/3090%4000107550107580.00计划3WO00003JL160-31/3050090%80002150100215080.00计划4WO00004JL160-41/3180%50010755050010.00计划5WO00005JL160-52/290%55892580120258046.58计划6WO00006NBC-12/690%4687537.525537.5187.48计划Line-1#总负荷(1为满负荷)110.7911WO00007NBC-215001/2995%1579110050110031.581/271/271/28(1500)计划11004792WO00008NBC-350001/2990%55563300150330037.041/261/29(5000)计划330018633933WO00009NBC-420001/3190%22232200100220022.231/291/30(2000)计划19382854WO00010NBC-55002/180%62511005062512.501/301/30(500)计划6255WO00011XL-18002/190%88916507588911.851/301/31(800)计划4993906WO00012XL-220002/290%22232200100220022.231/312/1(2000)计划1680543Line-2#总负荷(1为满负荷)405714057511110.247…排程说明：(可根据日排单量排产，不必等前一个任务全部完成才能开始下一个任务)-见体验区1.自动排程规则：第一个任务按计划排产量自动排完订单，后续任务先依剩余产能(或排单量)、再依排单量（或剩余订单量）自动排完订单2.可根据需要手工改动日计划排产量、实际开始日期，排程及开工/完工时间自动调整(排程红色为DELAY交期数量)3.比一般自动排程柔性更强：依排产量同一天可排产多个产品，并自动显示开工、完工时间开始日期结束日期生产工时实际开始日期日产能小时产能日计划排产量已完成数量差异订单号优先顺序料号订单数量交期库存数量良率需生产数量2/42/52/62/72/82/92/102/112/122/132/142/152/162/172/182/192/202/212/222/232/242/252/26周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六计划量为随机数量WO000011FG0000160001/27100095%52642200182252.641/261/28WO000022FG0000215002/190%1667110073333.341/261/30WO000033FG0000316002/150090%1223220081812.231/291/30WO000044FG0000420002/180%2500110050450.001/302/3WO000055FG000058002/190%889165073511.851/302/1WO000066FG000065002/690%55655051522.24#VALUE!2/2Line-1#总负荷WO000071FG0000715001/29#N/A#N/A22002170#N/A#N/A#N/AWO000082FG0000850001/29#N/A#N/A2200684#N/A#N/A#N/AWO000093FG0000920001/31#N/A#N/A2200839#N/A#N/A#N/AWO000104FG000105002/1#N/A#N/A1100534#N/A#N/A#N/AWO000115FG000118002/1#N/A#N/A1650552#N/A#N/A#N/AWO000126FG0001220002/2#N/A#N/A550543#N/A#N/A#N/ALine-2#总负荷库存数量良率需生产数量日产能按F9体验订单号优先顺序料号订单数量交期实际开始日期开始日期结束日期日计划排产量生产工时1/261/271/281/291/301/312/12/22/32/42/52/62/72/82/92/102/112/122/132/14周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一182218221620189189290733266734489504504504504484128735265328921411111110.850.44#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A2/152/162/172/182/192/202/212/222/232/242/252/26周二周三周四周五周六周日周一周二周三周四周五周六#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A