$1.$ Generate as many valid forecasts as you can for a five$-$period moving average, a na$$ve $1-$period moving average, and a weighted

average forecast with weights $0\mathrm{.}6,0\mathrm{.}3$ and $0\mathrm{.}1$ for the most recent data, the next most recent data, and so forth, respectively.

$2.$ Calculate MAPE for each forecast. You will have a MAPE at the individual month level and the overall average for each methodology. $($Use common data periods only.$)$ Insert columns as necessary.

$3.$ Recommend a forecast and explain why that is your choice.

$4.$ Use Excel for all calculations.

$5.$ All calculations should be highlighted in yellow