生产计划表注:需生产量=(订单量-库存量)/成品率,自动计算序号订单号品名规格型号订单量交货日期库存量成品率需生产量日产能日计划
生产量开始日期结束日期1K0010001A_1品名***80002020/11/27200092%6522160012002020/11/182020/11/232K0010002A_2品名***20002020/11/30095%21055004502020/11/192020/11/243K0010003A_3品名***8002020/12/0320090%6673003002020/11/282020/11/304K0010004A_4品名***10002020/12/1030095%7374003002020/11/292020/12/15K0010005A_5品名***20002020/12/13090%22226004002020/11/302020/12/5-------------------