8 1.) Complete the following questions related to the Master Planning of Resources. 1.1. Given the following master schedule, fill in the projected available and available to promise rows: On Hand: 35 Planning time fence: 10 Demand time fence: 2 Lot Size: 200 Period 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 1 Projected Avail. Avail. To Promise IMPS 200 200 1.2. A customer wants an order of 100 in period 4. Is this possible? 1.3. The customer from part (b) cancels his request, but then says he wants 120 in period 5. What do you tell him now? 1.4. 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?