Please provide Excel calculations/work.

18. The following table is a partial master schedule: 5 8 Forecast 240 240 225 225 200 200 210 210 Customer Orders 190 196 24099 145 78 92 50 MPS Lot Sin: 400 unts Prejected and Inventory 300 Available to Promise | 1. Complete the master schedule records. Show all calculations. 2. Suppose a customer cancels an order of 60 units in Week 3. What effect will it have on the projected on-hand inventory and the available- to-promise record for that week? 3. Complete the projected on-hand inventory and available-to-promise records of the master schedule shown in the following table: 12345678 110 60 110 60 110 60 110 60 80 60 120 85 55 30 130 40 110 60 110 60 110 60 110 60 Forecast Customer Orders MPS Projected On Hand Inventory - 40 Available-to- Promise