生产计划自动排程、物料自动分析

名称,交货期,订单量,日投入,车间能力,可生产日期,完成数量,,7/1,7/2,7/3,7/4,7/5,7/6,7/7,7/8,7/9,7/10,7/11,7/12,7/13,7/14,7/15,7/16,7/17,7/18,7/19,7/20,7/21,7/22,7/23,7/24,7/25,7/26,7/27,7/28,7/29,7/30,7/31,8/1

产品3,7/9,8000,1400,3500,7/3,8000,,1400,1400,1400,1400,1400,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

产品2,7/8,17000,4000,10000,7/3,17000,,4000,4000,4000,4000,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

产品5,7/10,8800,1600,4000,7/4,8800,,800,800,800,800,1600,1600,1600,800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

产品4,7/13,10000,2800,7000,7/9,10000,,0,0,0,0,700,2200,2800,2800,1500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

产品1,7/15,500,3000,7500,7/14,500,,0,0,0,0,0,0,500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

负荷,,,,,12月30日,,,100%,100%,100%,100%,100%,100%,87%,60%,21%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%,0%

,,,,,,bom,,物料1,物料2,物料3,物料4,物料5,物料6,物料7,物料8,物料9,物料10,,,,,,,,,,,,,,,,,,,,,,

,,,,,,产品1,,6,7,9,9,7,6,9,9,3,7,,,,,,,,,,,,,,,,,,,,,,

名称,日投入,车间能力,,,,产品2,,5,7,8,5,4,3,6,4,8,4,,,,,,,,,,,,,,,,,,,,,,

产品3,1400,3500,,,,产品3,,3,6,7,4,1,8,7,8,1,1,,,,,,,,,,,,,,,,,,,,,,

产品2,4000,10000,,,,产品4,,5,5,6,2,9,4,1,3,3,5,,,,,,,,,,,,,,,,,,,,,,

产品5,1600,4000,,,,产品5,,5,1,3,9,10,7,7,7,7,3,,,,,,,,,,,,,,,,,,,,,,

产品4,2800,7000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

产品1,3000,7500,,,,bom修,,物料1,物料2,物料3,物料4,物料5,物料6,物料7,物料8,物料9,物料10,,,,,,,,,,,,,,,,,,,,,,

,,,,,,产品3,,3,6,7,4,1,8,7,8,1,1,,,,,,,,,,,,,,,,,,,,,,

,,,,,,产品2,,5,7,8,5,4,3,6,4,8,4,,,,,,,,,,,,,,,,,,,,,,

,,,,,,产品5,,5,1,3,9,10,7,7,7,7,3,,,,,,,,,,,,,,,,,,,,,,

,,,,,,产品4,,5,5,6,2,9,4,1,3,3,5,,,,,,,,,,,,,,,,,,,,,,

,,,,,,产品1,,6,7,9,9,7,6,9,9,3,7,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,物料使用,合计,7/1,7/2,7/3,7/4,7/5,7/6,7/7,7/8,7/9,7/10,7/11,7/12,7/13,7/14,7/15,7/16,7/17,7/18,7/19,7/20,7/21,7/22,7/23,7/24,7/25,7/26,7/27,7/28,7/29,7/30,7/31,8/1

,,,,,,物料1,206000,28200,28200,28200,28200,20700,22000,25000,18000,7500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料2,229300,37200,37200,37200,37200,20500,18600,19100,14800,7500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料3,282900,44200,44200,44200,44200,26800,25000,26100,19200,9000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料4,220700,32800,32800,32800,32800,26400,22800,24500,12800,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料5,257500,25400,25400,25400,25400,27700,36800,44700,33200,13500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料6,219600,28800,28800,28800,28800,28200,28000,25400,16800,6000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料7,234100,39400,39400,39400,39400,27700,20400,18500,8400,1500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料8,228100,32800,32800,32800,32800,28500,25800,24100,14000,4500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料9,237100,39000,39000,39000,39000,22700,18800,21100,14000,4500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,物料10,155900,19800,19800,19800,19800,13700,16800,22300,16400,7500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,安全库存,物料,库存,7/1,7/2,7/3,7/4,7/5,7/6,7/7,7/8,7/9,7/10,7/11,7/12,7/13,7/14,7/15,7/16,7/17,7/18,7/19,7/20,7/21,7/22,7/23,7/24,7/25,7/26,7/27,7/28,7/29,7/30,7/31,8/1

,,,,,120000,物料1,250000,221800,193600,165400,137200,116500,94500,69500,51500,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000,44000

,,,,,120000,物料2,250000,212800,175600,138400,101200,80700,62100,43000,28200,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700,20700

,,,,,120000,物料3,250000,205800,161600,117400,73200,46400,21400,-4700,-23900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900,-32900

,,,,,120000,物料4,250000,217200,184400,151600,118800,92400,69600,45100,32300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300,29300

,,,,,120000,物料5,250000,224600,199200,173800,148400,120700,83900,39200,6000,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500,-7500

,,,,,80000,物料6,250000,221200,192400,163600,134800,106600,78600,53200,36400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400,30400

,,,,,120000,物料7,250000,210600,171200,131800,92400,64700,44300,25800,17400,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900,15900

,,,,,120000,物料8,250000,217200,184400,151600,118800,90300,64500,40400,26400,21900,21900,21900,21900,21900,21900,21900,219