Hello! Help please with forecasting and excel formulas

Forecasting

Background:

Your company has done well for four straight years staring in $2017.$

ABC Mfg$.,$ launched a new sophisticated data collection device using unique, patented, semiconductors chips, supplied from China. As sales grew, ABC added the necessary manpower To keep pace with demand. The data is summarized below.

$\backslash$table$[[$ABC Mfg$],[,\backslash$table$[[$Sales $($D$)],[($Millions$)]],\backslash$table$[[$Fcst $($F$)],[($Millions$)]],$Manpower,Fcst $($F$)],[2017,$$$25,$$$30,50,45],[2018,$$$35,$$$30,60,55],[2019,$$$48,$$$40,70,70],[2020,$$$60,$$$50,90,85],[2021,,$A$,,$B$]]$

You need to create an Excel spreadsheet to calculate the various answers for this.

Questions:

a$.$ Given the data given above, develop a forecast for variable A and B using a simple $2$ year moving average $($SMA$)($Please round to a one decimal place$)$

A $=\_\_\_\_\_$ B $=\_\_\_\_\_$

b$.$ Using the spreadsheet you created for a$)$ above, develop a $3$ year weighted moving average $($SWMA$)$ applying the following weighs $(\mathrm{.}2,\mathrm{.}3,$ and $\mathrm{.}4)$

$($Please round to one decimal place$)$

A $=\_\_\_\_\_$ B $=\_\_\_\_\_\_$

$3.$ Using exponential smoothing $($ExS$)$ with an alpha value of $0\mathrm{.}2.$ What is the sales forecast value for $2021($A$)\_\_\_\_\_?($Please round to a whole number$)$

$4.$ Using the same method, but using an alpha value of $0\mathrm{.}6,$ forecast the anticipated manpower. What is the forecasted value of $2021($B$)\_\_\_\_?$

$($Please round to a whole number$)$

$5.$ Using the Mean Absolute Percent Error $($MAPE$),$ what appears to be the best forecast method? $($Please round to one decimal place$)$

MAPE:SMA MAPE:WSMA MAPE $($Exp$.$ Smoothing$)$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

What does the above data tell you?

$6.$ On your spreadsheet, calculate the $\%$ change in a$)$ sales and b$)$ manpower for all years $2017-2020.$ Do not answer this question here $$ use your spreadsheet.

$7.$ Summarize what your graph depicts? $($What does it $$tell you$).$

Input your answer in this space.

$8.$ Comparing the data, is the plant more or less efficient in $2020$ Vs $2017?$

Explain Your Reasoning: Input your answer in this space.