Please include work and formulas please. Thanks in advance :)

3.18. a. Given the following master schedule, fill in the projected available and available to promise rows: On hand: 35 Lot size: 200 Planning time fence: 10 Demand time fence: 2 Period 1 2 3 4 5 6 7 8 9 10 11 12 30 40 40 50 40 40 30 40 40 50 40 40 31 35 29 21 17 14 33 11 5 2 0 1 Forecast Customer Orders Projected Available Available to Promise MPS 200 200 b. A customer wants an order of 100 in period 4. What can you tell him? c. The customer from part (b) cancels his request, but then says he wants 120 in period 5. What do you tell him now? d. Sales has requested that you add an 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? 3.18. a. Given the following master schedule, fill in the projected available and available to promise rows: On hand: 35 Lot size: 200 Planning time fence: 10 Demand time fence: 2 Period 1 2 3 4 5 6 7 8 9 10 11 12 30 40 40 50 40 40 30 40 40 50 40 40 31 35 29 21 17 14 33 11 5 2 0 1 Forecast Customer Orders Projected Available Available to Promise MPS 200 200 b. A customer wants an order of 100 in period 4. What can you tell him? c. The customer from part (b) cancels his request, but then says he wants 120 in period 5. What do you tell him now? d. Sales has requested that you add an 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