Problem 11-21 (Static) 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 1 2 3 4 Customer Order 52 35 20 12 Click here for the Excel Data File Use a production lot size of 75 units and no beginning inventory (Leave no cells blank - be certain to enter "o" wherever required.) 3 June ences July 50 52 50 35 50 50 20 50 12 50 0 Forecast Customer Orders Projected on-hand inventory MPS ATP 50 0 50 0