Problem 11-21 (Algo) Prepare a master schedule given this information The forecast for each week of an eight-week schedule is 55 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 1 25 Use a production lot size of 80 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 5 G 7 8 55 43 55 25 55 55 Forecast Customer Orders Projected On Hand Inventory MPS ATP 55 2 55 0 55 0 55 0