Observed monthly sales of a popular brand tennis shoe at a medium-sized sports store at the town's

Question:

Observed monthly sales of a popular brand tennis shoe at a medium-sized sports store at the town's mall over the first eight months of the year are given in the following table.
Month Mar Apr May June July Aug 33 35 30 Jan Feb 30 28 36 40 Demand 38

a) Use a three-month moving average method to forecast the sales for the months April through September. Also compute the mean squared error (MSE) based on the sales and forecasts for months April through August.
b) If the forecast for January was 28, determine the forecast for sales for the months February through September using an exponential smoothing method with a = 0.60. Also compute the mean squared error (MSE) based on the sales and forecasts for months April through August.
c) Which method would you recommend based on MSE? Why?

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

Step by Step Answer:

Related Book For  book-img-for-question

Introduction To Probability And Statistics

ISBN: 9780495389538

13th Edition

Authors: William Mendenhall, Robert J. Beaver, Barbara M. Beaver

Question Posted: