ANSWER ALL PLEASE

Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on hand inventory would be negative without it Customer orders (committed) aro as follows: Week 1 2 3 Customer Orders 55 40 25 12 Use a production lot size of 90 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 "0" wherever required.) June July 2 3 4 0 7 60 55 60 40 60 25 60 12 60 0 60 0 60 0 00 0 Forecast Customer Orders Projected On Hand Inventory MPS ATP