Consider the quarterly sales data for Kilbourne Health Club shown below. These data are available in a

Question:

Consider the quarterly sales data for Kilbourne Health Club shown below.image text in transcribed

These data are available in a simpler format in the Excel worksheet C9 Excel P41 in MindTap.

a. Use the Moving Average Excel template to develop a four-period moving average model and compute MAD, MAPE, and MSE for your forecasts.

b. Use the Exponential Smoothing Excel template to find a good value of a for a single exponential smoothing model and compare your results to part (a) using only MSE.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: