Question $15(10$ points$)$

Given below is the demand for product A$.$ The product has a lot size of $90$ and has an on$-$hand inventory of $55$ units. There is a $5$ week demand time fence and a $12$ week planning time fence. The following table gives the original forecasts and actual customer orders for the next $12$ weeks.

a$.$ Based on the demand data provided develop a realistic MPS$.(3$ marks$)$

b$.$ Calculate the PAB for the next $12$ periods

c$.$ Calculate the ATP

$(4$ marks$)$

$(3$ Marks$)$

$\backslash$table$[[$Week$,1,2,3,4,5,6,7,8,9,10,11,12],[$Forecast$,60,60,60,50,50,50,50,50,50,50,50,50],[\backslash$table$[[$Customer$],[$Orders$]],62,60,48,45,38,38,26,14,10,8,0,0],[$PAB$(55),,,,,,,,,,,,],[$MPS$,,,,,,,,,,,,],[$ATP$,,,,,,,,,,,,],[$Ending$,,,,,,,,,,,,]]$