Problem 2) ABC Company needs to schedule operations for the next six weeks. Create a Master Schedule, including Available-to-Promise (ATP) Inventory, for each period in the scheduling horizon using the information below. Note: You do not need to show calculations for Projected On-Hand Inventory; however, you do need to show calculations for ATP below the table.

Beginning On-Hand Inventory = 40 units. Forecasted Demand = 30 units every period. Desired Safety Stock Level = 20 units. MPS Quantity Lot-Sizing Rule: Fixed Order Quantity = 120 units per lot. Customer Orders: 48 units in Week 1, 45 units in Week 2, 42 units in Week 3, 38 units in Week 4, 25 units in Week 5, and 20 units in Week 6. MPS Quantity Planned for Week 1: 120 units. 12 points

	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6
Beginning Inventory	40
Forecasted Demand	30	30	30	30	30	30
Customer Orders (confirmed)	48	45	42	38	25	20
Initial Projected On-Hand Inventory
MPS Quantity	120
Revised Projected On-Hand Inventory
Available-to-Promise (ATP) Inventory