For the foilowing data, calculate the projected available balance and the planned MPS receipts. The lot size is $100.$ The demand time fence is $2$ weeks. $(4$ Marks$)$

$\backslash$table$[[$Week$,1,2,3,4],[$Forecast$,40,60,45,60],[$Customer Orders,$70,40,65,30],[$Projected available balance,$80,,,],[$MPS$,,,,]]$