1 2 item:A 3 4 6- Quantity on Hand: 7 12 8 Forecast 9 Customer orders (booked) 10 Projected on-hand inventory 11 MPS quantity 12 MPS start 13 Available-to-promise (ATP) inventory 14 1 20 30 55 2 10 20 3 40 5 4108 Week 5 0 0 6 0 2 7 30 0 Order Policy: 55 units Lead Time: 2 weeks 8 20 0 9 40 0 10 20 15 1) Complete the above MPS table and ATP quantities. Include the formulas within each cell in the above table. Just entering the final numbers won't be counted. (25 points) 16 17 18 2) A customer requests a new order for 30 units of item A in week 1. 19 When is the earliest date the entire order could be shipped? (5 points) 20 21

1) Complete the above MPS table and ATP quantities. Include the formulas within each cell in the above table. Just entering the final numbers won't be counted. ( 25 points) 2) A customer requests a new order for 30 units of item A in week 1. When is the earliest date the entire order could be shipped? (5 points)