given the following master schedule, fill in the projected available ans available to promise rows:

a. Given the following master schedule, fill in the Projected Available and Avail- able to Promise rows: On-hand: 35 Planning Time Fence: 10 Lot Size: 200 Demand Time Fence: 2 Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 30 40 40 50 40 40 30 40 40 50 40 40 Customer orders 31 35 29 21 17 14 33 11 5 2 0 Projected avail. Avail. to promise MPS 200 200 b. A customer wants an order of 100 in period 4. What can you tell them? c. The customer from part (b) cancels their request, but then says they want 120 in period 5. What do you tell them now? d. Sales has requested that you add a MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why? e. What action (if any) should be taken in period 11? Why is it okay to take the action