Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of , , and y. a. What are the optimal values of ,...

Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of
,
, and y.

a. What are the optimal values of
,
, and y?

b. Prepare a line graph comparing the predictions from this method against the original data.

c. What are the forecasts for the next four quarters using this technique?