please show work

5. Consider the following partially completed master schedule record: On-hand inventory at end of April: 40 Month "May Week 19 20 21 22 23 Forecasted demand 200 200 200 225 225 Booked orders 205 203 201 195 193 Projected ending inventory Master production schedule 600 0 0 675 Available to promise June 24 25 225 200 190 26 200 178 182 0 0 0 600 240 a. (*) Complete the projected on-hand inventory calculations and the available-to-promise calculations b. (**) Suppose that a customer calls and cancels an order for 50 units in week 25. Which of the following statements are true? The ATP for week 25 will increase by 50 units. The projected ending inventory for week 25 will increase by 50 units. The ATP for weeks 19 and 22 will be unaffected