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 Initial Inventory = 60 1 2 3 4 5 6 7 8 Forecast 30 30 30 30 40 40 40 40 Customer orders (committed) 31 20 10 4 2 Projected on-hand inventory MPS ATP