1. Moving Averages.  Use the below actual sales to calculate a three-year average which will be used as the forecast for next periods.

2. Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40.

3. Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel.

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