excel自动生产排程至柔版表格文件下载.xls

excel自动生产排程至柔版表格文件下载.xls

《excel自动生产排程至柔版表格文件下载.xls》由会员分享，可在线阅读，更多相关《excel自动生产排程至柔版表格文件下载.xls（15页珍藏版）》请在冰点文库上搜索。

料号小时产能良率库存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三四五六日一二三四五六日一二三1WO00001FG0000160001/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/26951946WO00006FG0000610002/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%625110062512.501/301/306255WO00011FG000118002/190%889165088911.851/301/314993906WO00012FG0001220002/290%22232200220022.231/312/11680543Line-2#Line-2#总总负负荷荷（1为满负荷）1111110.25排排程程说说明明：

@#@（可根据日排单量排产，不必等前一个任务全部完成才能开始下一个任务）-见体验区1.自动排程规则：

@#@第一个任务按计划排产量自动排完订单，后续任务先依剩余产能（或排单量）、再依排单量（或剩余订单量）自动排完订单2.可根据需要手工改动日计划排产量、实际开始日期，排程及开工/完工时间自动调整（排程红色为DELAY交期数量）3.比一般自动排程柔性更强：

@#@依排产量同一天可排产多个产品，并自动显示开工、完工时间2/102/112/122/132/142/152/162/172/182/192/202/212/222/232/242/252/26四五六日一二三四五六日一二三四五六按按F9F9体体验验计划量为随机数量订单号优先顺序料号订单数量交期库存数量良率需生产数量日产能日计划排产量生产工时实际开始日期开始日期结束日期1/26三WO000011FG0000160001/27100095%5264220064652.641/262/3646WO000022FG0000215002/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%15792200141115.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/271/281/291/301/312/12/22/32/42/52/62/72/82/92/102/112/122/132/142/15四五六日一二三四五六日一二三四五六日一二646646646646646646646965984713585075377777777711752136815726613411111110.2916871171171171171171157966766766714432729817061710330237237240551425711111110.930.472/162/172/182/192/202/212/222/232/242/252/26三四五六日一二三四五六