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 are as follows Week Customer Orders 1 2 3 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 Forecast Customer Orders Projected On Hand Inventory MPS 60 55 2 60 40 3 60 25 60 12 5 60 0 60 0 7 60 0 60 0