Skip to Content

This document reviews the impact of the parameters of the Second-Order Exponential Smoothing. The explanation follows a graphical approach without going into the heavy mathematics behind them.

This Forecasting model introduces a new statistical concept: Trend (Beta). It also uses the parameter Alpha, which was already introduced in the previous document:

APO DP – Forecast Model Parameters: First-Order Exponential Smoothing

1. Model Selection: Sales pattern

If you want to select a model manually, then you must analyze the historical data to determine whether a distinct pattern exists according to which you can manually select a model for the system.

Trend pattern:

If your historical data represents a suspected trend behavior, you can then select the second-order exponential smoothing (Holt Model).

Suppose that you have the following sales pattern, the constant forecast is clearly not appropriate here:

a = 0.3

APODP04.jpg

We need to incorporate the significant trend Pattern, for this we use Beta.

Simple exponential smoothing does not do well when there is a trend in the data. In such situations, it could be useful to apply a second-order exponential smoothing Model (Holt Model). The basic idea behind double exponential smoothing (Holt Model) is to introduce a term to take into account the possibility of a series exhibiting some form of trend.

2. Forecast Model Parameters: Second-Order Exponential Smoothing – Holt Model

The 2nd order exponential smoothing model without the seasonal pattern is also called Holt Model. In the opposite, models with Seasonal patterns and no tred are called Winters.

Model Parameters:

APODP02.jpg

Alpha factor:

The system uses the alpha factor for smoothing the basic value. If you do not specify an alpha factor, the system will automatically use the alpha factor 0.3.

Beta factor:

The system uses the beta factor for smoothing the trend.

In the following forecasting graphs you will see the impact of Beta (with a constant alpha = 0.3):

b = 0.1 / a = 0.3  -> (MAPE = 16.39)

APODP03-B01.jpg

b = 0.2 / a = 0.3  -> (MAPE = 15.45)

APODP03-B02.jpg

b = 0.3 / a = 0.3  -> (MAPE = 15.37)

APODP03-B03.jpg

b = 0.4 / a = 0.3  -> (MAPE = 15.86)

APODP03-B04.jpg

b = 0.5 / a = 0.3  -> (MAPE = 16.48) 

APODP03-B05.jpg

b = 0.6 / a = 0.3  -> (MAPE = 17.03)

APODP03-B06.jpg

b = 0.7 / a = 0.3  -> (MAPE = 17.51)

APODP03-B07.jpg

b = 0.8 / a = 0.3  -> (MAPE = 17.91)

APODP03-B08.jpg

b = 0.9 / a = 0.3  -> (MAPE = 18.31)

APODP03-B09.jpg

The choice of Beta is very important: the following table contains the monthly forecasting quantity of the different b beta factors for alpha = 0.3:

APODP03.jpg

Note that the forecast got with beta 0.1 is 2 times bigger than the forecast got with beta 0.9.

Conclusion: 0.3 is a good compromise

  • b (beta) close to 0: use a longer horizon to forecast the trend.
  • b (beta) close to 1: will probably use only the last few values to estimate the trend.
To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Suresh S

    Hi Mariano,

    Very nice article with good screenshots.

    Small suggestions:

    1. One of the most known second-order exponential smoothing methods, is sometimes referred to as “Holt’s Winters”. –> I guess it is not Holt’s Winters. Holt’s Winters is usually Seasonal-Trend model. This is purely Trend Model (Holt Model).

    2. Forecast error could have been better input to understand the best forecast parameter combination (Best Alpha and Beta) out of all ­čÖé

    Thanks,

    Suresh Sellaiah

    (0) 
    1. Mariano Cabalen Post author

      Thanks Suresh,

      You are absolutely right. I already modified the title and change that comment by this one:

      “The 2nd order exponential smoothing model without the seasonal pattern is also called Hold Model. In the opposite, models with Seasonal patterns and no tred are called Winters.”

      I made a couple of this articles and I will make new ones in the following days.. I will add the Forecast error to the new models.. it is good idea. In fact I will probably add the forecast error in this one.

      Thanks a lot.

      Kind Regards,

      Mariano

      (0) 
      1. SRS KANNAN

        DearMariano. This is good. I am using SPP . is there any documents you have for those forecasting models used in APO SPP. Thanks. Kannan SRS

        (0) 
  2. Qureshi white

    Mariano Cabalen,

    I have question regarding SAP SOP and SAP DP. I have product group and it has 20 material, I wanted to plan like One sheet with Production plan and other sheet is build rate.

    In Prod Plan I have 20 product families, each Rows describe Order line sold quantity, Total quantity, Carryover ship quantity, Ship quantity, Backlog quantity, buildable backlog quantity, weeks of backlog, Target, build, firm build, build hours and product family units day.

    I have seen in Standard SOP in sap I can create SOP in standard way but If tried to used in product group and material underneath, it is not coming. I have problem if you can take a look

     

    (0) 

Leave a Reply