Question

A restaurant wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown below and can be found on the worksheet C11P6 in the OM5 Data & Calculations Workbook.
a. Plot the data and provide insights about the time series.
b. What is the forecast for week 16, using a two-period moving average?
c. What is the forecast for week 16, using a three-period moving average?
d. Compute MSE for the two- and three-period moving average models and compare your results.
e. Find the best number of periods for the moving average model based on MSE.


$1.99
Sales3
Views198
Comments0
  • CreatedSeptember 17, 2015
  • Files Included
Post your question
5000