|
|
|
|
|
|
|
|
|
|
Time
Series Forecasting Exercise |
|
Simple
Exponential Smoothing |
|
|
|
|
|
|
Simple |
|
alpha= |
0.3 |
|
|
|
Exponential |
|
|
Percent |
Squared |
|
Period |
Sales |
Smoothing |
Error |
Abs. Error |
Error |
Error |
|
1 |
99 |
N/A |
|
|
|
|
|
2 |
88 |
99.0 |
-11.0 |
11.0 |
12.50% |
121.0 |
|
3 |
50 |
95.7 |
-45.7 |
45.7 |
91.40% |
2088.5 |
|
4 |
58 |
82.0 |
-24.0 |
24.0 |
41.36% |
575.5 |
|
5 |
62 |
74.8 |
-12.8 |
12.8 |
20.63% |
163.7 |
|
6 |
60 |
71.0 |
-11.0 |
11.0 |
18.26% |
120.0 |
|
7 |
55 |
67.7 |
-12.7 |
12.7 |
23.03% |
160.5 |
|
8 |
62 |
63.9 |
-1.9 |
1.9 |
3.01% |
3.5 |
|
9 |
71 |
63.3 |
7.7 |
7.7 |
10.83% |
59.2 |
|
10 |
65 |
65.6 |
-0.6 |
0.6 |
0.95% |
0.4 |
|
|
|
-12.43 |
14.14 |
24.66% |
365.80 |
|
|
|
BIAS |
MAD |
MAPE |
MSE |
|
|
|
|
|
|
|
|
|
Standard Error (Square Root of
MSE) = |
|
19.1 |
|
|
|
|
|
|
|
|
Simple
Exponential Smoothing |
|
Forecast t = (alpha x actual t-1) + ((1- alpha) x forecast
t-1) |
|
|
Example: |
|
Please
use the simple exponential smoothing to forecast the sales for Period 11. |
|
Forecast Period 11 = (alpha x actual Period 10) + ((1- alpha) x
forecast Period 10) |
|
Forecast Period 11 = (0.3 x 65) + ((1-
0.3) x 65.6) |
|
Forecast Period 11 = 65.42 |
|
|
Note: |
|
By using
Simple Exponential Smoothing, the forecast for Period 1 = NA |
|
By using
Simple Exponential Smoothing, the forecast for Period 2 = Actual Period 1 |
|
By using
Simple Exponential Smoothing, the forecast for Period 3 = (alpha x actual Period 2) + ((1- alpha) x
forecast Period 2) |
|
|
|
|
|
|
|
|
|
|