0% found this document useful (0 votes)
10 views19 pages

Selecting the Smoothing Constant in Forecasting

Exponential smoothing is a widely used forecasting technique that uses a simple formula to smooth historical data and produce forecasts. It weights recent observations higher than older ones. Though not highly accurate, it is popular due to its ease of use, minimal data storage needs, and cost effectiveness for large numbers of items. The document provides the basic exponential smoothing formula and demonstrates its use to forecast sales of automotive parts and alcohol using monthly sales data from 1999-2007. Forecasts for August 2007 are produced based on the fitted exponential smoothing models.

Uploaded by

Mandeep Singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views19 pages

Selecting the Smoothing Constant in Forecasting

Exponential smoothing is a widely used forecasting technique that uses a simple formula to smooth historical data and produce forecasts. It weights recent observations higher than older ones. Though not highly accurate, it is popular due to its ease of use, minimal data storage needs, and cost effectiveness for large numbers of items. The document provides the basic exponential smoothing formula and demonstrates its use to forecast sales of automotive parts and alcohol using monthly sales data from 1999-2007. Forecasts for August 2007 are produced based on the fitted exponential smoothing models.

Uploaded by

Mandeep Singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd

Exponential smoothing

This is a widely used


forecasting technique in
retailing, even though it
has not proven to be
especially accurate.

Why is exponential smoothing so


popular?

It's easythe exotic term notwithstanding.


Data storage requirements are minimal (even
though this is not the problem it once was due to
plunging memory prices).
It is very cost effective when forecasts must be
made for a large number of items--hence it has
extensive use in retailing.

The basic algorithm


Lt Xt (1 ) Lt

(1)

Where:
Lt is the forecast for the current period;
Xt is the most recent observation of the time series
variablesuch as, for example, sales last month of
part #000897
Lt-1 is the most recent forecast; and
is the smoothing constant, where 0 < < 1

Equation (1)
can be
written as
follows:

New Forecast = (New Data) + (1 - )Most Recent Forecast

Exponential smoothing is weighted moving


average process

To demonstrate, let

Lt 1 Xt 1 (1 ) Lt 2
Substitute (2) into (1):

Lt Xt (1 )[Xt 1 (1 ) Lt 2]

Xt (1 ) Xt 1 (1 ) 2 Lt 2

But notice that:

Lt 2 Xt 2 (1 ) Lt 3

(4)

Substitute (4) into (3) to obtain:

Lt Xt (1 ) Xt 1 (1 ) 2 Lt 2 (1 ) 3 Lt 3
If we continue to substitute recursively, we
get:

Lt Xt (1 ) Xt 1 (1 ) 2 Xt 2 (1 ) 3 Xt 3

Notice that

, (1 ), (1 ) 2 , (1 ) 3 , (1 ) 4 ,
are the weights attached to past values of X.
Since < 1, the weights attached to earlier
or more remote observations of X are
diminishing.

You dont have to go


through this recursive
process each time you
do a forecast. The
process is summarized
in the most recent
forecast.

Selecting the smoothing constant ()


The range of possible values is zero and one.

Sales of part #56

If you select a value of close to 1, that means you are attaching a


large weight to the most recent observation. This is not indicated if your
series is very erratic (swings widely from period to period). For
example, suppose you were forecasting the demand for part #56 in
month t.
If you attached
too much weight
to the
observation for t1, you will have a
large forecast
error for month t.
t-2

t-1

Month

We will now forecast


sales of liquor and
floor covering using
this technique. We
have monthly data
for each variable
beginning in
January 1999 and
running through July
of 2007.

Exponential Smoothing Demonstration


Millions of Dollars

5000
4000
3000

7000
6500

2000

6000
1000

5500
5000
4500
4000
99

00

01

02
03
04
Year/Month
Parts, Accessories, Tires

05

06

07

Beer, Wine, Liquor

Beer, Wine,
Liquor

Mean
Standard
Error
Median
Mode
Standard
Deviation
Sample
Variance
Kurtosis
Skewness
Range
Minimum
Maximum

Parts, Accessories,
Tires

2653.3592
2
Mean
49.798155 Standard Error
2567
Median
2232
Mode
505.39607
6
Standard Deviation
255425.19
3
Sample Variance
1.8835971
7
Kurtosis
1.1977726
9
Skewness
2770
Range
1818
Minimum
4588
Maximum

5568.1068
54.524706
6
5546
5613
553.36533
5
306213.19
4
-0.2735442
0.2359922
3
2411
4503
6914

s
Amplitude
X

Beer, Wine, Liquor =


0.1904
Parts, Tires, etc. = 0.099

The ratio of the


standard deviation to
the mean gives us a
nice measure of the
amplitude or volatility
of a series month-tomonth (or day-to-day,
quarter-to-quarter, as
the case may be).

Selecting the
smoothing constant
Pricey time series forecasting software,
such as EViews, use an algorithm to
select the value of the smoothing
constant that minimizes mean square
error for in-sample forecasts.
If you lack this software, you can use a
trial and error process.

Beer, Wine, and Liquor Sales, Smoothed (Alpha = 0.1280)

5000
4500
4000
3500
3000
2500
2000
1500
99

00

MSE $405.35

01

02
03
04
Year/Month
Actual

05

Smoothed

06

07

Sales of Auto Parts, Accessories, and Tires, Smoothed (Alpha = 0.69)


millions of dollars
7000
6500
6000
5500
5000
4500
4000
99

00

MSE $347.56

01

02
03
04
Year/Month
Actual

05

Smoothed

06

07

Auto Parts, Accessories, and Tires


(Alpha = .69)
Year
2006
2006
2006
2006
2006
2006
2007
2007
2007
2007
2007
2007
2007

Month
7
8
9
10
11
12
1
2
3
4
5
6
7

Actual
6493
6914
6245
6419
6072
5900
5628
5526
6608
6144
6702
6619
6538

Smoothed
6642.08
6539.21
6797.82
6416.37
6418.19
6179.32
5986.59
5739.16
5592.08
6293.06
6190.21
6543.34
6595.55

Beer, Wine, and Liquor (Alpha = .1280)


Year
2006
2006
2006
2006
2006
2006
2007
2007
2007
2007
2007
2007
2007

Month Actual Smoothed


7
3322
2994.10
8
3228
3036.07
9
3212
3060.64
10
3120
3080.01
11
3359
3085.13
12
4588
3120.19
1
2710
3308.08
2
2748
3231.52
3
3176
3169.63
4
3037
3170.44
5
3459
3153.36
6
3578
3192.48
7
3547
3241.83

Forecasts for August, 2007


Remember our basic algorithm
Lt Xt (1 ) Lt

Hence to parts, accessories, and tire sales (PAT)


for August, 2007:

PAT AUG 07 [(.69)(6,538)] [(1 .69)(6,595.55)] $6,555.84


To forecast beer, wine, and liquor sales
(BWL):

BWLAUG 07 [(.1280)(3,547)] [(1 .1280)(3,241.83)] $3,280.89

Common questions

Powered by AI

The choice of smoothing constant (α) dictates how much weight is given to the most recent observation; a value close to 1 emphasizes recent data, which could lead to large forecast errors if the data series is erratic. Conversely, a smaller α value results in a more stable forecast that is less sensitive to short-term fluctuations .

Using a high smoothing constant on a volatile series places excessive weight on recent observations, likely leading to significant forecast errors and reactive forecasts that align poorly with actual trends. The risk of instability is substantial, resulting in unreliable decision-making based on the forecasts .

In exponential smoothing, historical sales data are recursively aggregated using a smoothing constant (α) to produce forecasts. The method combines past observations with existing forecasts, progressively diminishing the weight of older data, thus focusing on recent sales trends to predict future sales .

Erratic data negatively impacts forecasting accuracy because exponential smoothing depends on the weight (α) assigned to recent observations. If the data exhibits substantial fluctuations, assigning too much weight could increase forecast errors; thus, a lower α is often used to stabilize these effects .

Trial and error for selecting the smoothing constant allows customization and adjustment based on performance metrics like mean square error. However, it is time-consuming and may not converge to an optimal α, especially without statistical software, limiting its efficiency in practice .

The amplitude of a time series, a measure of its volatility, can guide the selection of the smoothing constant. A higher amplitude suggests more volatility, recommending a lower α to minimize the sensitivity to erratic changes. Conversely, a lower amplitude indicates stability, allowing for a higher α .

Amplitude, calculated as the ratio of standard deviation to mean, indicates the volatility of a time series. For more volatile series with high amplitude, a smaller smoothing constant (α) is preferred to prevent overreacting to large fluctuations. Conversely, stable series with low amplitude may use a higher α .

Exponential smoothing is often preferred due to its simplicity, ease of application, and low computational expense, making it practical for handling numerous forecasts in retail. Its cost-effectiveness is particularly beneficial in large-scale operations, where more complex methods would entail significant resources and expertise .

Exponential smoothing is popular because it is straightforward to implement, requires minimal data storage, and is cost-efficient for forecasting a large number of items, which makes it particularly useful in retail environments .

The recursive nature of exponential smoothing allows new forecasts to be generated using only the latest forecast and observation, making the methodology efficient by reducing computational and storage needs. This process, which applies diminishing weights to past observations, updates the forecast continuously .

You might also like