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: Customer Orders 40 Week 1 2 55 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 "O" wherever required.) June 1 2 4 5 6 7 Forecast 60 60 60 60 60 60 60 60 Customer Orders 55 40 25 12 0 0 0 Projected On-Hand Inventory 13 26 39 52 65 5 18 31 MPS 73 731 73 73 0 73 73 ATP 30 70 90 85 85 0 85 coa