A B E F H K item:A Order Policy: 50 units Lead Time: 2 week Week 1 2 3 4 5 6 7 8 9 10 20 10 0 20 30 10 20 40 5 30 0 20 0 40 0 8 2 0 Quantity on Hand : 10 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start Available-to-promise (ATP) inver 50 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 coun 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