QUESTION $1$: Use the time series data in the Excel template file EXCEL PICTURE file to test three forecast techniques: $3-$period moving average, $2-$period weighted moving average, and exponential smoothing. Calculate their MFE, MAD, and MAPE. Make sure to have all the cells configured with formulas. PLEASE SHOW ME WHAT FORMULA TO PUT IN EACH CELL AND ALSO SHOW ME THE RESULTS YOU GOT FROM YOUR END.

QUESTION $2$: Which forecast technique is best for this time series data?

a$.2-$period weighted moving average with weights $0\mathrm{.}4$ and $0\mathrm{.}6$ to $2-$period before and $1-$period before demands respectively.

b$.3-$period moving averagE

c$.$ Exponential smoothing with $=0\mathrm{.}3$

d$.$ Exponential smoothing with $=0\mathrm{.}7$

QUESTION $3$: Which forecast technique seems under$-$forecasted demand?

a$.2-$period weighted moving average with weights $0\mathrm{.}4$ and $0\mathrm{.}6$ to $2-$period before and $1-$period before demands respectively

b$.3-$period moving average

c$.$ Exponential smoothing with$=0\mathrm{.}3$

d$.$ Exponential smoothing with$=0\mathrm{.}7$

QUESTION $4$: Test exponential smoothing forecasts for $=0\mathrm{.}1,0\mathrm{.}2,...,0\mathrm{.}9.$ According to MAPE, the generating the most accurate forecasts is $----$ type your answer... and the corresponding MAPE is $-----$ Type your answer...$\%($keep $3$ digits after decimal point$).$