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 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.) June July 2 3 5 6 7 8 Forecast 50 50 50 Customer Orders 52 35 20 12 183 50 50 50 50 50 0 0 0 0 Projected on-hand inventory MPS ATP