Homework: Aggregate Planning X Question 1 - Homework: Aggreg + ps://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghmiddleware%252Fmh k: Aggregate Planning and Master Scheduling As... i Saved 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 required.) July June 1 2 3 4 5 LO 6 7 8 30 30 30 Forecast 30 30 40 40 40 40 Customer orders (committed) 33 25 16 11 8 3 Projected on-hand inventory MPS ATP M