Can you provide the Excel format along with the formulas for the following? Data Analytics and Demand Forecasting

Task $1$:

Answer the following Exercise questions. You may use the Excel examples provided in the lesson or use R$.$ If you used Excel, please upload the work file$($s$)$ to show work. If you used R$,$ please upload the R history file or R script that you used.

$[25$ points each$]$

Quarterly demand for flowers at a wholesaler is as shown. Forecast demand for year $5$ using simple exponential smoothing with $\backslash$alpha $=0\mathrm{.}1$ as well as Holt$$s model with $\backslash$alpha $=0\mathrm{.}1$ and $\backslash$beta $=0\mathrm{.}1.$ Which of the two methods do you prefer? Why?

Year Quarter Sales

$1$ I $98$

II $106$

III $109$

IV $133$

$2$ I $130$

II $116$

III $133$

IV $116$

$3$ I $138$

II $130$

III $147$

IV $141$

$4$ I $144$

II $142$

III $165$

IV $173$

Weekly demand figures at Hot Pizza Oven are as follows:

Period $123456789101112$

Demand $10811611812496119961021121029291$

Estimate demand for the next $4$ weeks using a $4-$week moving average method.

Estimate demand for the next $4$ weeks using a simple exponential smoothing with $\backslash$alpha $=0\mathrm{.}1.$

Estimate demand for the next $4$ weeks using a simple exponential smoothing with $\backslash$alpha $=0\mathrm{.}9.$

For each of the above $3$ methods, calculate MAD, MAPE, MSE values $($using the forecasts for periods $5-12).$

Which forecasting method do you prefer? Why?

Monthly demand at Fred$$s Electronics for mobile phones are as follows:

Month $123456789101112$

Demand $100011131271144515581648172418501864207621672191$

Estimate demand for the next two months using a simple exponential smoothing with $\backslash$alpha $=0\mathrm{.}3.($You may use the level at period $0$ to be L$0=1659($average demand over $12$ months$)).$

Estimate demand for the next two months using a Holt$$s model with $\backslash$alpha $=0\mathrm{.}05$ and $\backslash$beta $=0\mathrm{.}01.($You may use the level at period $0$ to be L$0=948$ and the trend in period $0$ to be T$0=109($obtained through regression model$)).$

Estimate demand for the next two months using a Holt$$s model with $\backslash$alpha $=0\mathrm{.}5$ and $\backslash$beta $=0\mathrm{.}1.($You may use the level at period $0$ to be L$0=948$ and the trend in period $0$ to be T$0=109($obtained through regression model$)).$

Estimate demand for the next two months using a Holt$$s model with $\backslash$alpha $=0\mathrm{.}5$ and $\backslash$beta $=0\mathrm{.}5.($You may use the level at period $0$ to be L$0=948$ and the trend in period $0$ to be T$0=109($obtained through regression model$)).$

Evaluate the MAD, MAPE, and MSE for each model.

Which method do you prefer? Why?