Refer to the data in the file that accompanies this book named ProductionHours.xlsx containing monthly data on the average number of hours worked each week by production workers in the United States over 94 consecutive months.

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 a, b, and g.

a. What are the optimal values of a, b, and g?
b. Prepare a line graph comparing the predictions from this method against the original data.
c. What are the forecasts for the next four months using this technique?