Purchase Solution

Forecasting sales and mean square error

Not what you're looking for?

Ask Custom Question

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

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 25, determine the forecast for sales for the months February through September using an exponential smoothing method with alpha = 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?

Purchase this Solution

Solution Summary

This solution compares two forecasting methods for forecasting the sales of tennis shoes: 3-month moving average and exponential smoothing. Then the mean squared errors (MSE) are calculated and a better forecasting method is chosen.

Solution Preview

Dear Student:

In this exercise you are looking for two different methods of forecasting and then choosing the better option. No individual forecasting method is better than another; it depends upon the actual situation, which one gives a more reliable result.

All the calculations are in the ...

Purchase this Solution

Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.


This tests some key elements of major motivation theories.

Introduction to Finance

This quiz test introductory finance topics.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.