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$