To answer the following questions, use data provided in sheet 'Headphone Sales'

$0\mathrm{.}5$ point Obtain the seasonal indexes for Jan to Dec based on Years $2019-2022$ in yellow cells below. DO NOT INCLUDE $2023$ DATA

$1$ point Obtain the Seasonally Adjusted Actual for Jan $\text{'}22$ to Dec $\text{'}22$ in light blue cells below.

$1$ point Using only $2022$ data and Exponential Smoothing with Trend $)=0\mathrm{.}6,=(0\mathrm{.}4,$ forecast Sales for Jan to Dec $\text{'}22$ in orange cells below.

$0\mathrm{.}5$ point Obtain MSE for $2022$ in pink cell below.

$1$ point Using Excel's Solver, obtain the optimal parameters $($ and $)$ that minimize MSE for $2022.$ GENERATE SOLVER'S ANSWER REPORT

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Annual

Seasonall

Seasonal Index

y Adj

Actual $2022$

Forecast

$2022$

MSE

enter MSE for $2022$ here