Consider the following partially completed master schedule record:

Complete the projected on-hand inventory calculations and the available-to-promise calculations!

Please show your step-by-step calculation using EXCEL, thank you.

On-hand inventory at the end of week 1 Week 2 Forecasted demand 280 Booked orders 270 Projected ending inventory Master production schedule 400 Available to promise 200 3 240 270 4 250 280 5 290 310 160 6 320 310 7 450 220 8 250 190 9 240 120 700 800 400 90