The following table is a partial master schedule:

1. Complete the master schedule records. Show all calculations.

2. Suppose a customer cancels an order of 60 units in week 3, what effect would 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-topromise records of the master schedule shown in the following table:

Transcribed Image Text:

1 4 6. Week Forecast 210 240 225 225 200 200 210 240 Customer Orders MPS 78 190 196 240 99 145 92 50 Lot Size: 400 units Projected On-Hand Inventory = 300 Availahle-tn-Promise Week 4 6. 110 60 110 60 110 60 110 60 Forecast Customer Orders MPS 80 60 120 85 55 110 30 130 110 40 110 60 110 60 60 60 Projected On-Hand Inventory = 40