You are responsible to do the demand forecasting in your company for product A and your manager asked you to do the following based on the table below:

$1-$ Compute the demand forecasting for period $11$ using three$-$period moving average

Compute the demand forecasting for period $11$ using three$-$period weighted moving average with weights $0\mathrm{.}5,0\mathrm{.}3$ and $0\mathrm{.}2($higher weight is the most recent$).$ You can use excel for this task. $(10$ points$)$

Period

Demand

$1$

$95$

$2$

$105$

$3$

$102$

$4$

$120$

$5$

$115$

$6$

$130$

$7$

$138$

$8$

$130$

$9$

$133$

$10$

$140$