1 2 1) Table below is for a product with 150 unit lot size. The current on-hand inventory is 110 units. The product has a 2-week lead-time and a 12-week planning time fence. 3 The forecast and demand for the product are shown in the table below: 4 5 Forecast 80 80 80 70 70 70 70 70 70 70 70 6 Demand 65 61 51 17 7 70 83 78 49 34 11 7 0 0 8 9 10 11 12 13 P1a) Given this information, develop a realistic master schedule, complete with ATP logic. 14 15 16 P1b) Then explain how you would respond to each of the following customer order requests. Show what the master schedule would look like if the order was 17 accepted 18 (Assume these are independent requests, and do not have cumulative effects.) 19 . 20 units in Week 3 20 . 40 units in Week 5 21 120 units in Week 7 22 - B E F G J K L M N 1 11 40 12 40 0 2 Period 3 Forecast 30 40 40 50 40 40 30 40 40 50 Customer 31 35 29 4 Orders 21 17 14 33 11 5 2 Projected 5 Avail. Avail. To 6 Promise 7 MPS 200 200 8 9 2. (a) Given the above Master Schedule, fill in the Projected Available and Available to Promise rows: 10 11 On Hand: 35 Lot Size: 200 12 Demand Time Fence: 2 Planning Time Fence: 10 13 14 15 b) A customer wants an order of 100 in period 4. What can you tell them? 16 c) The customer from part (b) cancels their request, but then says they want 120 in period 5. What do you tell them now? 17