i need help finding the projected ending inventory and available to promise for each week

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. Click the icon to view the master schedule record. 4 Calculate the master production schedule (onter your responses as whole numbers). On-hand inventory at end of week 1: 75 Week 2 3 5 6 Forecasted demand 60 60 70 45 85 Booked orders 55 55 67 90 33 Projected ending inventory 240 180 80 295 210 Master production schedule 250 260 7 50 83 8 90 9 85 95 160 24 280 210 205 er the master schedule record shown below. Suppose marketing books an order for an additional 25 units in week 4. * More Info e Info 6 8 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 5 45 90 85 33 7 50 83 90 24 85 95 260 210 91 Print Done