i need help finding the ATP for each week pleaseeee this is my third question ive wasted on the same problem bc the answers chegg gives are always wrong :(

0.0 Consider the master schedule record shown below. Suppose marketing books an order for an additional 25 units in week 4. Calculate the projected ending inventory and available-to-promise numbers, E Click the icon to view the master schedule record. Calculate the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 75 Week 2 3 4 5 6 7 8 9 Forecasted demand 60 60 70 45 85 50 90 85 Booked orders 55 55 67 90 33 83 24 95 Projected ending inventory 265 205 135 305 220 137 257 162 Master production schedule 250 260 210 Available to promise 148 0 0 129 0 166 0 O alcula * More Info alcula 5 6 9 On-hand inventory at end of week 1: 75 Week 2 3 Forecasted demand 60 60 Booked orders 55 55 Projected ending inventory Master production schedule 250 Available to promise 4 70 42 45 90 85 33 7 50 83 8 90 24 85 95 260 210 91 Print Done