Forecast method: exponential smoothing

LN calculates the demand forecast according to the Exponential Smoothing forecast method as follows:

The relevant parameters for this forecast method are:

  • Automatic Update of Forecast Parameters
  • Smoothing Factor for Demand
  • Smoothing Factor for Trend
  • Smoothing Factor for Season
  • Smoothing Factor for Forecast Error
  • Tracking Signal for Demand Forecast
  • Critical Tracking Signal

You can maintain these parameters in the Plan Items - Forecast Settings (cpdsp1110m000) session.

If the Automatic Update of Forecast Parameters check box is selected, LN first recomputes the smoothing factors for the exponential smoothing method. Using an iterative process, with step sizes of 0.2 and subsequently 0.05, LN produces an optimum combination of smoothing factors for the demand, the season, and the trend. This combination gives the smallest mean absolute deviation (MAD).

Next, LN calculates a demand forecast starting from the first period with demand history to the last forecast period via the exponential smoothing method.

The various variables for the demand forecast are computed as follows:

Average demand

Without seasonal influence:

AV(t) = FD(t) + a (AD(t) - FD(t))

With a constant seasonal influence:

AV(t) = (FD(t) + a (AD(t) - FD(t))) - SF(t)

With a progressive seasonal influence:

AV(t) = (FD(t) + a (AD(t) - FD(t))) / SF(t)

Where:

AV(t)season-adjusted average demand for period t
FD(t)demand forecast for period t
AD(t)actual demand for period t (*)
SF(t)seasonal factor for period t
aSmoothing Factor for Demand field

 

(*) For the current period and later periods, the forecast demand is taken as the actual demand.

Trend factor

With a linear trend influence:

TF(t) = TF(t-1) + b ((AV(t)-AV(t-1)) - TF(t-1))

With a progressive trend influence:

TF(t) = TF(t-1) + b (1.0 + ((AV(t)-AV(t-1))/AV(t)) - TF(t-1))

Where:

TF(t)trend factor for period t
AV(t)season-adjusted average demand for period t
bSmoothing Factor for Trend field

 

Seasonal factor

With a constant seasonal influence:

SF(t+L) = SF(t) + g ((AD(t) - AV(t)) - SF(t))

With a progressive seasonal influence:

SF(t+L) = SF(t) + g ((AD(t) / AV(t)) - SF(t))

Where:

SF(t)seasonal factor for period t
AD(t)actual demand for period t (*)
AV(t)season-adjusted average demand for period t
Lseason length in periods
gSmoothing Factor for Season field

 

(*) For the current period and later periods, the forecast demand is taken as the actual demand.

Demand forecast

Without trend influence:

FD(t+1) =	 AV(t)

With a linear trend influence:

FD(t+1) = FD(t+1) + TF(t)

With a progressive trend influence:

FD(t+1) = FD(t+1) * TF(t)

With a constant seasonal influence:

FD(t+1) = FD(t+1) + SF(t+1)

With a progressive seasonal influence:

FD(t+1) = FD(t+1) * SF(t+1)

Where:

AV(t)season-adjusted average demand for period t
TF(t)trend factor for period t
SF(t+1)seasonal factor for period t+1
FD(t+1)demand forecast for period t+1

 

Mean forecast error
[...]

Where:

AD(t)actual demand for period t
FD(t)demand forecast for period t
AE(t)mean absolute deviation (MAD) for period t
SE(t)mean forecast error (SER) for period t
abs(FD(t)-AD(t))absolute value of (FD(t)-AD(t))
eSmoothing Factor for Forecast Error field

 

The tracking signal is calculated as follows:

 TS(t) = abs(SE(t)/AE(t)) 

Where:

TS(t)tracking signal
SE(t)mean forecast error (SER) for period t
AE(t)mean absolute deviation (MAD) for period t
abs(SE(t)/AE(t))absolute value of (SE(t)/AE(t))

 

Note

If the forecast demand (FD) is always greater than the actual demand (AD), the value of (SE(t)/AE(t)) is 1. If the forecast demand (FD) is always less than the actual demand, the value of (SE(t)/AE(t)) is -1. The tracking signal is a number between 0 and 1. The tracking signal indicates whether the forecast demand is systematically above or below the actual demand.

If the Tracking Signal for Demand Forecast check box is selected, the smoothing factor for the demand is dependent on the forecast error.

If the tracking signal is greater than the value of the Critical Tracking Signal field, LN makes the smoothing factor for the demand equal to the tracking signal.