SOLVE THIS IN EXCEL An organization bases its yearly sales projections on official data regarding the industry's overall demand. Below are the company's overall sales and demand statistics during the previous ten years. $\backslash$begin$\{$tabular$\}\{|$c$|$c$|\}\backslash$hline Demand total & $\backslash$begin$\{$tabular$\}\{$c$\}$ Sales $\backslash \backslash ($thousands$)\backslash$end$\{$tabular$\}\backslash \backslash \backslash$hline $300$ & $30\backslash \backslash \backslash$hline $400$ & $16\backslash \backslash \backslash$hline $700$ & $46\backslash \backslash \backslash$hline $977$ & $16\backslash \backslash \backslash$hline $2000$ & $50\backslash \backslash \backslash$hline $680$ & $60\backslash \backslash \backslash$hline $560$ & $200\backslash \backslash \backslash$hline $\backslash$end$\{$tabular$\}$

i$)$ A $2-$year moving average.

ii$)$ A $6-$year weighted moving average using $0\mathrm{.}1,0\mathrm{.}2,$ and $0\mathrm{.}3,$ with the highest weights to the most recent months.

iii$)$ Exponential smoothing with$\backslash$alpha $=0\mathrm{.}3$

and a forecast for year $5.$

c$)$ With the data provided, what method would allow you to prepare the sales forecast for year $8?$