Prepare an MPS table like Figure 12-11 using the following information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are: WeekCustomer Orders152235320412 Use a production lot size of 75 units and no beginning inventory. Complete the following table, using the above information. (Do not leave any empty spaces; input a "0" wherever it is required.) June July 1234 5678 Forecast50505050 50505050 Committed Projected on hand (min = 0) 0 Produce (lot size = 75) Available-to-promise Prepare an MPS table like Figure 12-11 using the following information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are: WeekCustomer Orders152235320412 Use a production lot size of 75 units and no beginning inventory. Complete the following table, using the above information. (Do not leave any empty spaces; input a "0" wherever it is required.) June July 1234 5678 Forecast50505050 50505050 Committed Projected on hand (min = 0) 0 Produce (lot size = 75) Available-to-promise