Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 75 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows: Week 1 2 3 4 Customer Orders 48 42 23 12 Use a production lot size of 100 units and no beginning inventory (In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "O" wherever required.) Juno July 2 3 4 5 6 7 B Forecast 75 75 75 75 75 75 75 Customer Orders 48 42 23 12 0 0 0 Projected On-Hand Inventory MPS ATP