Single Exponential Smoothing calculator

SolutionHelp

1. Single Exponential Smoothing calculator

year	1	2	3	4	5	6	7	8	9	10
Sales	30	25	35	25	20	30	35	40	30	45

2. Single Exponential Smoothing calculator

year	1	2	3	4	5	6
Sales	650	700	810	800	900	700

3. Single Exponential Smoothing calculator

year	1	2	3	4	5	6	7	8	9	10
Sales	20	21	23	22	25	24	27	26	28	30

Example

1) Single Exponential Smoothing
year 1 2 3 4 5 6 7 8 9 10
Sales 30 25 35 25 20 30 35 40 30 45
Calculate Single Exponential Smoothing

Solution:

(1) year	(2) Sales	(3) Exponential Smoothing (α=0.3) $(alpha=0.3)$
1	30	30
2	25	0.3⋅30+0.7⋅30=30 $0.330+0.730=30$
3	35	0.3⋅25+0.7⋅30=28.5 $0.325+0.730=28.5$
4	25	0.3⋅35+0.7⋅28.5=30.45 $0.335+0.728.5=30.45$
5	20	0.3⋅25+0.7⋅30.45=28.815 $0.325+0.730.45=28.815$
6	30	0.3⋅20+0.7⋅28.815=26.1705 $0.320+0.728.815=26.1705$
7	35	0.3⋅30+0.7⋅26.1705=27.3193 $0.330+0.726.1705=27.3193$
8	40	0.3⋅35+0.7⋅27.3193=29.6235 $0.335+0.727.3193=29.6235$
9	30	0.3⋅40+0.7⋅29.6235=32.7365 $0.340+0.729.6235=32.7365$
10	45	0.3⋅30+0.7⋅32.7365=31.9155 $0.330+0.732.7365=31.9155$
11		0.3⋅45+0.7⋅31.9155=35.8409 $0.345+0.731.9155=35.8409$