Question

In Excel, create a forecast for periods 6-13 using the following method:

Exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53);

With exponential smoothing, the forecast for period 13 will be:

Period	Data
1	45
2	52
3	48
4	59
5	55
6	55
7	64
8	58
9	73
10	66
11	69
12	74

Thank you :)

Answer 1

for exponential smoothing:

next period forecast =previous period actual*alpha+(1-alpha)*previous period forecast

Period	Data	forecast
1	45
2	52
3	48
4	59
5	55	53.0000
6	55	53.4600
7	64	53.8142
8	58	56.1569
9	73	56.5808
10	66	60.3572
11	69	61.6551
12	74	63.3444
13		65.7952

from above forecast for period 13 will be =65.7952