1) Complete the above MPS table and ATP quantities. You should include all the formulas within the above table. Just entering the final numbers won't be counted.

2) If in week 1 a customer requests a new order for 30 units of item A, when is the earliest date the entire order could be shipped?

Quantity on Hand: A 1 2 3 4 i L i i E L L E Forecast 20 10 40 10 0 0 30 20 40 20 Customer orders (booked) 30 20 5 8 O 2 0 0 0 0 Projected on-hand inventory MP5 quantity 50 MP5 start Available-to-promise (ATP) invei 14 15 16 1) Complete the above MPS table and ATP quantities. You should include all the formulas within the above table. Just entering the final numbers won't be counted. (25 points) 17 2) If in week 1 a cust- mer requests a new order for 30 units of item A, when is the earliest date the entire order could be shipped? (5 points) 20