$1-$ Using the data in following table,

$\backslash$table$[[$MoNTH$,$SALES$],[$January$,908],[$February$,1235],[$March$,804],[$April$,1019],[$May$,1151],[$June$,1383],[$July$,894],[$August$,1255],[$September$,1087],[$October$,1382],[$November$,957],[$December$,1254]]$

a$)$ Compute a $3-$month moving forecast of Sales from April through December and for the next month, January. Compute the MAD for the forecast.

b$)$ Compute a $6-$month moving forecast of Sales from July through December and for the next month, January. Compute the MAD for the forecast.

c$)$ Compute a weighted $3-$month moving forecast of Sales from April through December and for the next month, January, using weights of $0\mathrm{.}50($most recent data$),0\mathrm{.}30,$ and $0\mathrm{.}20($most distant data$).$ Compute the MAD for the forecast.

D$)$ Compare the forecasts you computed by using moving forecast model from part $a,b,$ and $c.$ Which forecasting model does a better job?

$2-$ Using the data from problem $1,$

A$)$ Compute an exponentially smoothed forecast with alpha$=0\mathrm{.}80$ through December and create a forecast for the next month, January. Use initial forecast of $908$ for January. Find MAD.

B$)$ Compute an exponentially smoothed forecast with alpha$=0\mathrm{.}60$ through December and create a forecast for the next month, January. Use initial forecast of $908$ for January. Find MAD.

C$)$ Compare the forecasts you computed by using an exponential smoothing model from part a and $b.$ Which forecasting model does a better job?

Show how to do this in google sheets preferably or excel and and a screenshot of the completed sheet.