Explore BrainMass

# Forecasting: Moving Averages, Exponential Smoothing

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

A. Use 5 period moving average (MA n=5) to compute the forecasts of sales for months 6 to 20 and a 7 period moving average (MA n=7) to compute forecasts for months 8 to 20.
b. Use an exponential smoothing approach with a smoothing constant alpha =0.2 to forecast sales for month 2 to 20. Change alpha to 0.1. Does this make the forecast better or worse? (calculate the MSD and compare their MSD Explain. Assume that the forecast for month 2 is 22 (same as first month's sales)
c. Find alpha that minimizes the MSD. (using solver)

Data:
Month Sales
1 22
2 21
3 24
4 30
5 25
6 25
7 33
8 40
9 36
10 39
11 50
12 55
13 44
14 48
15 55
16 47
17 61
18 58
19 55
20 60

Please see the attached file for full problem description including data chart.

Â© BrainMass Inc. brainmass.com November 24, 2021, 11:21 am ad1c9bdddf
https://brainmass.com/statistics/central-tendency/forecasting-moving-averages-exponential-smoothing-24924

#### Solution Summary

Forecasts using moving average, exponential smoothing and finds alpha that minimizes the MSD.

\$2.49