die first $3$ questions attempted i

Question $15(10$ points$)$

Listen

Given below is the demand for product A$.$ The product has a lot size of $60$ and has an on$-$hand inventory of $35$ units. There is a $4$ 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$,40,40,40,35,35,35,35,35,35,35,35,35],[\backslash$table$[[$Customer$],[$Orders$]],41,39,32,30,25,25,17,9,6,5,0,],[PAB(35),,,,,,,,,,,,],[$MPS$,,,,,,,,,,,,],[$ATP$,,,,,,,,,,,,],[$Ending$,,,,,,,,,,,,]]$