Q1)

Q2)

Q3)

Q4)

Please provide your answer with a formula.

For the following questions, complete the following master schedule record: On-hand inventory at end of week 1: 100 Week 2 3 4 5 6 7 8 9 Forecasted demand 250 250 300 300 350 350 250 250 Booked orders 265 255 270 245 260 235 180 100 Projected ending inventory Master production schedule 500 600 700 500 Available to promise What is the ending inventory for week 2? 500 355 340 335 What is the available to promise for week 2? 20 75 80 What is the available to promise for week 6? 205 220 85 80 What is the projected ending inventory for week 6? 430 330 380 80