Given the following Master Schedule Data:

Calculate the Projected Ending Inventory for week $18$:

Ending Inventory

$E{I}_t=E{I}_{t-1}+MP{S}_t-$max$(F_t,O{B}_t)$

where:

$E{I}_t=$ ending inventory in time period $t$

$MP{S}_t=$ master production schedule quantity available in time period $t$

$F_t=$ forecasted demand for time period $t$

$O{B}_t=$ orders booked for time period $t$

$\backslash$table$[[$Week$,16,17,18],[$Forecasted Demand,,$50,70],[$Booked Orders,,$60,40],[\backslash$table$[[$Master Production Schedule$],[($Planned Production$)]],,80,80],[$Projected Ending Inventory,$10,,]]$