Question

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

Answer 1

SOLUTION:-

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

Formula:

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

Formula:

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

THANK YOU , if any queries please leave your valuable comment on comment box....