Requirements:

Moving Averages. Use the below actual sales to calculate a one-year average which will be used as the forecast for next periods (chapter 14, text). Choose a moving average period that best supports this calculation.

Exponential Smoothing. Use the same data to forecast sales for the next periods with =.40 (chapter 14, text).

Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text).

Month Actual Sales

1 3050

2 2980

3 3670

4 2910

5 3340

6 4060

7 4750

8 5510

9 5280

10 5504

11 5810

12 6100