Problem 2. (14%) Given the information in the table, update on-hand inventory, schedule MPS, and calculate available-to-promise (ATP) quantities. The order policy is to produce in lots of 300. Show all your calculations to receive full or partial credits. Week Quantity on hand: 100 1 4 5 6 7 8 ? Forecast 100 100 100 100 120 120 120 120 Customer orders (booked) 40 190 220 70 60 110 40 0 Projected on-hand Inventory MPS quantity Available-to-promise (ATP) Assume that prospective new customer orders arrive in the following sequence, independent of one another. Order Quantity Week Due Which of the orders should be accepted? 1 70 6 2 60 1 a. all of the orders b. orders 1, 2, and 3 only C. orders 1 and 2 only d. orders 1, 2, and 4 only e. none of the above 80 3 4 50 7 Problem 2. (14%) Given the information in the table, update on-hand inventory, schedule MPS, and calculate available-to-promise (ATP) quantities. The order policy is to produce in lots of 300. Show all your calculations to receive full or partial credits. Week Quantity on hand: 100 1 4 5 6 7 8 ? Forecast 100 100 100 100 120 120 120 120 Customer orders (booked) 40 190 220 70 60 110 40 0 Projected on-hand Inventory MPS quantity Available-to-promise (ATP) Assume that prospective new customer orders arrive in the following sequence, independent of one another. Order Quantity Week Due Which of the orders should be accepted? 1 70 6 2 60 1 a. all of the orders b. orders 1, 2, and 3 only C. orders 1 and 2 only d. orders 1, 2, and 4 only e. none of the above 80 3 4 50 7