Please provide a step by step calculation with excel. and please give interpretation of the number. Thank you

b. Consider the following partially completed master schedule record: 23 25 On-hand inventory at end of April: 40 Month Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 19 200 205 May 20 21 200 200 203 201 22 225 195 June 24 225 200 190 182 225 193 26 200 178 600 0 0 675 0 0 0 600 240 . . Complete the projected on-hand inventory calculations and the available-to-promise calculations! Suppose that a customer calls and cancel 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