Prepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2,16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Use the MPS rule of ordering production when projected on-hand inventory would be negative without production. Suppose that there are currently 64 pumps in inventory and a production lot size of 70 pumps is used. (Leave no cells blank-be certain to enter "O" wherever required.) Jul 6 June 30 25 30 16 Forecast Customer orders (committed) Projected on-hand inventory MPS ATP 30 30 40 40 40 40