Q4 (a) Given the information below, complete the calculations for the available-to- promise and the projected-on-hand, and answer the following questions. Master Schedule Item Product Line 800 Lead On-Hand Time 3 12 Forecast Customer Orders Master Schedule Available-To- Promise Projected-On-Hand 1 15 15 8 2 15 12 12 3 15 10 12 Week 4 5 15 20 8 5 15 18 6 20 2 22 7 20 0 28 8 20 0 30 (b) What actions are required by the master scheduler if order entry promises a new customer 8 units of product 800 to be shipped in week two? (c) What actions are required by the master scheduler if manufacturing said 8 of the 12 units due in Wk 3 were rejected in manufacturing and will not be available until Wk 5