Prepare a master production schedule for industrial pumps in the manner of the following table. Use the MPS rule to “schedule production when the projected on-hand inventory would be less than 10 without production.” Suppose that a production lot size of 70 pumps is used. (Leave no cells blank – be certain to enter “0” wherever required.)


June July
  64          1            2            3          4          5          6          7            8
  Forecast 30 30 30 30 40 40 40 40
  Customer orders (committed) 33 20 10 4 2
  Projected on-hand inventory [removed] [removed] [removed] [removed] [removed] [removed] [removed] [removed]
  MPS [removed] [removed] [removed] [removed] [removed] [removed] [removed] [removed]
  ATP [removed] [removed] [removed] [removed] [removed] [removed] [removed] [removed]

Thanks for installing the Bottom of every post plugin by Corey Salzano. Contact me if you need custom WordPress plugins or website design.