For following datia, calcutate the projected avalable balance and the planned MPS receipts. The lot size is $100.$

The demand time ferise is $2$ weeks

$\backslash$table$[[$Week$,1,2,3,4,],[$Forecast$,40,60,45,60,],[$Costomer Orders,$70,40,65,30,],[$Projected asculble balance,$80,,,,],[$Mps$,,,,,]]$