Using the Master Production Schedule grid below, calculate the Projected Available Balance for each Quarter and determine what quarter(s) require a Master Production Schedule receipt. + Beginning Inventory = 30 units Production Quantity/Lost Size = 80 units Forecast Projected Available Balance Master Production Schedule Forecast Actual Customer Orders Projected Available Balance Available to Promise Master Production Schedule 6. Available to Promise Calculations a. Utilizing the grid below, calculate the Projected Available Balance for each period and the Available to Promise using the Discrete Method. Beginning inventory = 45 units Production Quantity/Lot Size = 50 units Quarter 1 20 Forecast Actual Customer Orders Projected Available Balance Available to Promise Master Production Schedule 1 20 13 2 20 8 1 20 13 Quarter 2 70 2 20 8 3 20 20 4 30 3 20 20 Quarter 3 70 b. Utilizing the grid below, calculate the Projected Available Balance for each period and the Available to Promise using the Cumulative Method. Beginning inventory = 45 units Production Quantity/Lot Size = 50 units 4 30 5 30 6 30 5 30 Quarter 4 20 6 30 7 30 8 30 7 30 8 30