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 ATP Calculations: 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 ATP Calculations