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_i=$ forecasted demand for time period $t$

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

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