车间订单排产计划表-公式计算总下单数量21000总计划排产数量6586总剩余排产数量14414200600900120030001200280680118116832186218621781472117468018020订单号订单数量交货日期计划排产数量开始日期计划天数日期6/256/266/276/286/296/307/17/27/37/47/57/67/77/87/97/107/117/12星期周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二MO2214758002022/6/252002022/6/254计划200 200 200 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 MO2214765002022/6/264002022/6/262计划0 400 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 MO2214776002022/6/276002022/6/271计划0 0 600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 MO22147820002022/6/2810002022/6/282计划0 0 0 1000 1000 0 0 0 0 0 0 0 0 0 0 0 0 0 MO22147930002022/6/2920002022/6/292计划0 0 0 0 2000 1000 0 0 0 0 0 0 0 0 0 0 0 0 MO2214803002022/6/302002022/6/302计划0 0 0 0 0 200 100 0 0 0 0 0 0 0 0 0 0 0 MO22148120002022/7/11802022/7/112计划0 0 0 0 0 0 180 180 180 180 180 180 180 180 180 180 180 20 MO22148245002022/7/25002022/7/29计划0 0 0 0 0 0 0 500 500 500 500 500 500 500 500 500 0 0 MO22148335002022/7/35012022/7/37计划0 0 0 0 0 0 0 0 501 501 501 501 501 501 494 0 0 0 MO22148420002022/7/45022022/7/44计划0 0 0 0 0 0 0 0 0 502 502 502 494 0 0 0 0 0 MO22148518002022/7/55032022/7/54计划0 0 0 0 0 0 0 0 0 0 503 503 503 291 0 0 0 0