help please!!!!

4 7 2 45 15 31 50 100 55 48 5 60 25 6 65 72 70 8 75 67 9 80 10 22 1. (*) Complete the following master schedule record: On-hand inventory at end of week 1: 65 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 2. (**) Consider the master schedule record shown in problem 1. Suppose marketing books an order for an additional 10 units in week 4. Recalculate the projected ending inventory and available-to-promise numbers. How low does the projected ending inventory get? What actions might the company take as a result? 3. - 150 200 150 73