.............................................................................
.............................................................................
Elsevier US
Job
code KIBChapter: Ch11-H7983 6-12-2006 9:22 p.m.
Page:373
Trimsize:7.25 in in
Fonts used Sabon & Frutiger
Margins:Top:36 pt
Gutter:66 pt
Font Size pt
Text Width PC
Depth:43 Lines
International
Operations Management373
or
Ft+1
=
Ft+
Yt−
Ft(11.3)
where
Ft+1
is the forecast value of the
dependent variable for periodt+ 1
Ftis the forecast value of the dependent variable for period
t Ytis the actual value of the dependent variable for period
t; and
is the value of the smoothing constant.
As it can be seen from the above equations, exponential smoothing is an average forecasting approach that requires only three pieces of data the forecast for
the most recent time period Ft, the actual value for that time period
Yt and the value of the smoothing constant. The smoothing constant is a weighting factor (its value lies between 0 and 1) that reflects the weight given to the most recent data values (the larger the value given to
the more strongly the model reacts to most recent data).
The value of the smoothing constant also determines the degree of smoothing and how responsive the model is to fluctuations in the data. As it can be seen from Equation (11.3), exponential smoothing is simply the old forecast
Ft adjusted by
times
the error Yt−
Ft in the old forecast.
That means that when the value of
is close to 0, the new forecast will be very similar to the old. On the other hand, when the value of
is
close to, the new forecast will include a substantial adjustment for any error that occurred in the preceding forecast.
Application of Equation (11.3) with
a smoothing constant value of= 0
3 will produce the following forecasts:
F2
= 130 + 0
3
130 − 130
= 130
F3
= 130 + 0
3
70 − 130
= 112
F4
= 112 + 0
3
140 − 112
= 120
4
F5
= 120
4 + 0
3
150 − 120
4
= 129
28
F6
= 129
28 + 0
3
90 − 129
28
= 117
5
F7
= 117
5 + 0
3
180 − 117
50
= 136
25
Note that as the forecast value for week 1 did not exist, we took it to be the same as the actual value for that period (i.e., we assumed a perfect forecast).
An exponential smoothing model with a different value of
will obviously produce different forecasts. For example, a smoothing constant value of
= 0
8 will produce the following forecasts:
F2
= 130 + 0
8
130 − 130
= 130
F3
= 130 + 0
8
70 − 130
= 82
.............................................................................
.............................................................................
Elsevier US
Job code KIB
Chapter: Ch11-H7983 6-12-2006 9:22 p.m.
Page:374
Trimsize:7.25 in in
Fonts used Sabon & Frutiger
Margins:Top:36 pt
Gutter:66 pt
Font Size pt
Text Width PC
Depth:43 Lines
374
International
BusinessF4
= 82 + 0
8
140 − 82
= 128
4
F5
= 128
4 + 0
8
150 − 128
4
= 145
68
F6
= 145
68 + 0
8
90 − 145
68
= 101
14
F7
= 101
14 + 0
8
180 − 101
14
= 164
23
As it can be seen from the above example, the operations manager can tryout a number of different forecasting models on some historical data,
in order to see how each of these models would have worked had it been used in the past. The accuracy of these forecasting models can be measured by a number of simple tests. A popular test for measuring forecast accuracy is the mean absolute percentage error (MAPE) test, which is based on the following equation:
MAPE
=
et/Ytn× where
Ytis the actual value of the dependent variable for period
t etis
the forecast error for period t (i.e.,
et=
Yt−
Ft); and
n is the number of forecast errors.
Yt= The MAPE values for the forecasts produced by the two exponential smoothing models can be produced as follows:
Model 1
= 0
3
tYtFtetet/Yt1 130 130
00
–
–
2 70 130
00
−60
00 0
86 3
140 112
00 28
00 0
20 4
150 120
40 29
60 0
20 5
90 129
28
−39
28 0
44 6
180 117
50 62
50 0
35 7
130 136
25
–
–
MAPE
=
et/Ytn× 100 =
2
05 5
× 100 = 41%
.............................................................................
.............................................................................
Elsevier US
Job code KIB
Chapter: Ch11-H7983 6-12-2006 9:22 p.m.
Page:375
Trimsize:7.25 in in
Fonts used Sabon & Frutiger
Margins:Top:36 pt
Gutter:66 pt
Font Size pt
Text Width PC
Depth:43 Lines
International Operations Management
375
Model 2
= 0
8
:
tYtFtetet/Yt1 130 130
00
–
–
2 70 130
00
−60
00 0
86 3
140 82
00 58
00 0
41 4
150 128
40 21
60 0
14 5
90 145
68
−55
68 0
62 6
180 101
14 78
86 0
44 7
164
23
–
–
MAPE
=
et/Ytn× 100 =
2
47 5
× 100 = 49
4%
The first exponential smoothing model has therefore produced more accurate forecasts than the second, as it has a lower average forecast error. Based on this and on the assumption that the future will not be dramatically different from the past, the operations manager of the company could use an exponential smoothing forecasting model with a low value of
in order to predict the number of component parts that will be required in the future.
Different forecasting models would obviously produce different forecasts.
For a good discussion of the
various forecasting methods, both statistical and judgmental, refer to Hanke et al.
20
Share with your friends: