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

1、料号小时产能良率库存FG0000110095%FG000025090%FG0000310090%FG000045080%FG0000512090%FG000062590%FG000075095%FG0000815090%FG0000910090%FG000105080%FG000117590%FG0001210090%生产计划排程表（至柔版）优先顺序订单号料号订单数量交期库存数量良率需生产数量日产能日计划排产量生产工时实际开始日期开始日期结束日期1/261/271/281/291/301/312/12/22/32/42/52/62/72/82/9三四五六日一二三四五六日一二三1WO00001F

2、G0000160001/28100095%52642200220052.641/261/261/28220022008642WO00002FG0000215001/3090%16671100110033.341/281/296689993WO00003FG0000316001/3050090%12232200122312.231/291/3020210214WO00004FG0000420001/3180%25001100110050.001/302/159011008115WO00005FG000058002/290%88926408897.412/12/26951946WO00006FG0

3、000610002/690%111255055044.482/22/451055052Line-1#Line-1#总总负负荷荷(1为满负荷)1111111110.0951WO00007FG0000715001/2995%15791100110031.581/271/271/2811004792WO00008FG0000850001/2990%55563300330037.041/261/29330018633933WO00009FG0000920001/3190%22232200220022.231/291/3019382854WO00010FG000105002/180%6251100625

4、12.501/301/306255WO00011FG000118002/190%889165088911.851/301/314993906WO00012FG0001220002/290%22232200220022.231/312/11680543Line-2#Line-2#总总负负荷荷(1为满负荷)1111110.25排排程程说说明明：(可根据日排单量排产，不必等前一个任务全部完成才能开始下一个任务)-见体验区1.自动排程规则：第一个任务按计划排产量自动排完订单，后续任务先依剩余产能(或排单量)、再依排单量（或剩余订单量）自动排完订单2.可根据需要手工改动日计划排产量、实际开始日期，排程及

5、开工/完工时间自动调整(排程红色为DELAY交期数量)3.比一般自动排程柔性更强：依排产量同一天可排产多个产品，并自动显示开工、完工时间2/10 2/11 2/12 2/13 2/14 2/15 2/16 2/17 2/18 2/19 2/20 2/21 2/22 2/23 2/24 2/25 2/26四五六日一二三四五六日一二三四五六按按F9F9体体验验计划量为随机数量订单号优先顺序料号订单数量交期库存数量良率需生产数量日产能日计划排产量生产工时实际开始日期开始日期结束日期1/26三WO000011FG0000160001/27100095%5264220064652.641/262/364

6、6WO000022FG0000215002/190%1667110059833.341/261/28598WO000033FG0000316002/150090%12232200112012.231/261/28358WO000044FG0000420002/180%25001100107150.001/282/1WO000055FG000058002/190%889165052111.852/12/2WO000066FG000065002/690%55655052622.242/12/3Line-1#Line-1#总总负负荷荷1WO000071FG0000715001/2995%157922

7、00141115.791/261/271411WO000082FG0000850001/2990%5556220071155.561/262/2711WO000093FG0000920001/3190%2223220066722.231/261/3078WO000104FG000105002/180%625110090412.501/271/28WO000115FG000118002/190%889165069211.851/281/30WO000126FG0001220002/290%222355051488.921/302/4Line-2#Line-2#总总负负荷荷11/27 1/28 1

8、/29 1/30 1/312/12/22/32/42/52/62/72/82/9 2/10 2/11 2/12 2/13 2/14 2/15四五六日一二三四五六日一二三四五六日一二64664664664664664664696598471358507537777777771175213681572661341111111 0.291687117117117117117115796676676671443272981706171033023723724055142571111111 0.93 0.472/16 2/17 2/18 2/19 2/20 2/21 2/22 2/23 2/24 2/25 2/26三四五六日一二三四五六