For the restaurant sales data in problem 39, use the Exponential Smoothing Excel template in MindTap to

Question:

For the restaurant sales data in problem 39, use the Exponential Smoothing Excel template in MindTap to find the best exponential smoothing model by evaluating the MSE for a from 0.1 to 0.9, in increments of 0.1. How does this model compare with the best moving average model.

Data from in problem 39

A restaurant wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown below and can be found in the Excel worksheet C9 Excel P39 Data in MindTap. Use Excel and the Moving Average template to answer the following questions.