Question: show work with with all steps including atp calculations Problem 2) ABC Company needs to schedule operations for the next six weeks. Create a Master

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 =35 units. Forecasted Demand =20 units every period. Desired Safety Stock Level =25 units. MPS Quantity Lot-Sizing Rule: Fixed Order Quantity =80 units per lot. Customer Orders: 24 units in Week 1, 22 units in Week 2, 21 units in Week 3, 19 units in Week 4, 12 units in Week 5, and 11 units in Week 6. MPS Quantity Planned for Week 1: 80 units. 12 points ATP Calculations: ATP ( Week 1)=35+8011=104 ATP ( Week 2)= ATP ( Week 3)= ATP ( Week 4) = ATP ( Week 5) = ATP ( Week 6) =
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
