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 1 2 3 Customer Orders 36 28 4 Use a production lot size of 85 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 5 6 7 Forecast 80 60 60 BO 80 60 60 60 Customer Orders 36 28 4 1 0 Projected On-Hand Inventory MPS ATP 0 0 0