Question $1$

Based on the scenario and the given formulas, answer the following questions $($provide your answers in the relevant cells in Table $1)$:

What is the inventory before production for Week $2$ of March and Week $2$ of April?

In which weeks should production take place? Allocate the correct production amount in the relevant cells in Table $1.$ For weeks in which no production takes place, allocate a zero.

What is available to promise $($ATP$)$ for Weeks $1$ and $3$ of March and Week $1$ of April?

Table $1$: Master production schedule for M$5$U$2$ assignment.

$\backslash$table$[[$Starting inventory: $103,$March,April$],[$Week$,1,2,3,4,1,2,3,4,,],[$Forecast$,100,101,103,103,105,110,110,100,,],[$Confirmed orders,$108,105,100,102,105,105,108,105,,],[\backslash$table$[[$Inventory before$],[$production$]],-5,-63,-16,29,,-41,4,,,],[$Production schedule,$150,150,,0,,150,0,,,],[$Ending inventory,$145,40,87,134,29,69,109,4,,],[$Available to promise,,$-,,30,,74,6,-,,]]$