Problem 11-21 Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are follows: Week Customer Order 1 52 2 35 3 20 4 12 Use a production lot size of 75 units and no beginning inventory. (Leave no cells blank - be certain to enter "0" wherever required.) June July 1 2 3 4 5 6 7 8 Forecast 50 50 50 50 50 50 50 50 Customer Orders 52 35 20 12 0 0 0 0 Projected on-hand inventory MPS ATP