生产计划自动排配模板.xls

生生产产计计划划排排程程表表(2017-8-31)首首次次任任务务开开始始日日期期：8/8每每日日计计划划工工时时:1111111111111111111111Line-11111111111111111111111Line-21111111111111111111111Line-31111111111111111111111Line优先顺序订单号料号数量交期库存数量良率小时产能日产能需生产数量生产工时日计划排产量可投放日期开始日期结束日期排产8/88/98/108/118/128/138/148/158/168/178/188/19一二三四五六日一二三四五11WO001 FG00160008/1595%1002200631663.1622008/88/13100%1100110011001100110081612WO002 FG00215008/1599%501100151630.3211008/138/17100%14255055027413WO003 FG00316008/1550099%1002200111211.1211128/178/18100%55256014WO004 FG00420008/2090%501100222344.4611008/188/2286%27055015WO005 FG0058008/2099%12026408096.7480921WO006 FG00650008/1590%1002200555655.5622008/88/13100%110011001100110011005622WO007 FG00720008/1590%1002200222322.2322008/138/16100%104411007923WO008 FG00810008/1590%1002200111211.1211128/168/17100%10219124WO009 FG00910018/2090%200440011135.5711138/178/17100%111325WO010 FG01040008/2090%801760444555.5617608/178/2287%36288088031WO011 FG01120008/1590%901980222324.7019808/88/10100%99099024332WO012 FG01215008/1590%1002200166716.6716678/108/11100%83083733WO013 FG01340008/1590%1002200444544.4522008/118/16100%26311001100110088234WO014 FG01455008/2090%1002200611261.1222008/168/2294%2181100110011003531903190327333003300315827502750349228102530负负荷荷率率 Line-1Line-1100%100%100%100%100%100%100%100%100%100%100%负负荷荷率率 Line-2Line-2100%100%100%100%100%100%100%100%100%100%100%负负荷荷率率 Line-3Line-3100%100%100%100%100%100%100%100%100%100%100%总总负负荷荷率率100%100%100%100%100%100%100%100%100%100%100%11111111111111118/208/218/22六日一5505508808801100110025302530100%100%100%100%100%100%100%100%