Calculate Available to Promise (enter responses as whole numbers)

On-hand inventory at end of week 1: 40 Wook 2 3 4 5 6 7 B 9 Forecasted demand 30 70 60 50 70 75 85 60 Booked orders 45 62 19 17 13 96 70 52 Projected ending inventory 295 225 165 285 215 119 324 264 Master production schedule 300 170 290 Available to promise 168