A restaurant wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown

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.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

OM operations management

ISBN: 978-1285451374

5th edition

Authors: David Alan Collier, James R. Evans

Question Posted: