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 $=50$ units. Forecasted Demand $=25$ units every period. Desired Safety Stock Level $=15$ units. MPS Quantity Lot$-$Sizing Rule: Fixed Order Quantity $=110$ units per lot. Customer Orders: $38$ units in Week $1,35$ units in Week $2,32$ units in Week $3,28$ units in Week $4,15$ units in Week $5,$ and $10$ units in Week $6.$ MPS Quantity Planned for Week $1$: $110$ units. $12$ points

$\backslash$table$[[,\backslash$table$[[$Week$],[1]],\backslash$table$[[$Week$],[2]],\backslash$table$[[$Week$],[3]],\backslash$table$[[$Week$],[4]],\backslash$table$[[$Week$],[5]],\backslash$table$[[$Week$],[6]]],[$Beginning Inventory,$50,,,,,],[$Forecasted Demand,$25,25,25,25,25,25],[\backslash$table$[[$Customer Orders$],[($confirmed$)]],38,35,32,28,15,10],[\backslash$table$[[$Initial Projected On$-],[$Hand Inventory$]],12,,,,,],[\backslash$table$[[$MPS Quantity$]],110,,,,,],[\backslash$table$[[$Revised Projected$],[$On$-$Hand Inventory$]],,,,,,],[\backslash$table$[[$Available$-$to$-],[$Promise $($ATP$)],[$Inventory$]],,,,,,]]$

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 $=50$ units. Forecasted Demand $=25$ units every period. Desired Safety Stock Level $=15$ units. MPS Quantity Lot$-$Sizing Rule: Fixed Order Quantity $=110$ units per lot. Customer Orders: $38$ units in Week $1,35$ units in Week $2,32$ units in Week $3,28$ units in Week $4,15$ units in Week $5,$ and $10$ units in Week $6.$ MPS Quantity Planned for Week $1$: $110$ units.