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 were 64 pumps in Inventory at the beginning of week 1. A production lot size of 70 pumps is used. (Leave no cells blank - be certain to enter "0" wherever requlred.) June 2 3 7 30 33 30 25 30 16 40 30 11 40 40 8 40 3 Forecast Customer orders (committed) Projected on hand inventory MPS ATP