Solve please Task $4$: A small Tennessee company makes fused magnesia and silica. To prepare input for the planning software, the company first uses a spreadsheet to determine the capacity requirements for the main equipment $($the fusion furnaces$)$ and the production schedule for main products. Product$\backslash$#$3050$ had the following forecasted sales and outstanding orders $($all in thousand pounds$)$:

The initial inventory is $80,000$ pounds and $60,000$ pounds are desired as the minimum safety stock at the end of each week.$|$

Considering the holding and setup costs with EPQ, the company has found that the optimum production quantity is around $80,000$ units in each run. Use this production quantity to determine the production schedule $($MPS$)$ and Available to Promise inventory for the next $7$ weeks.

$2\mathrm{.}5$ Marks$]$