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 23 23 Correct 48 48 Correct 73 73 Correct 23 23 Correct 48 48 Correct 73 73 Correct 23 23 Correct 48 48 Correct MPS 75 75 Correct 75 75 Correct 75 75 Correct 0 0 Correct 75 75 Correct 75 75 Correct 0 0 Correct 75