Seasonal forecast calculation details

[Former Member]

Hi,

I'm using transaction MM02 to calculate seasonal forecast ("S" model", with no optimization marked);

I entered 18 months consumption and get a correct forecast for the next 18 months.

Thanks to the formula described in HELP.SAP,  I tried to reproduce the calculations in excel, but unsuccessfully. The main question is : what is "V(t)", actually.

Can someone send me the correct formula for G(t), and tell me what "V(t)" is ?

Monthly consumptions, calculated forecast and used parameters are in the attached file.

Thanks a lot in advance,

Sandrine

[former_member196530]

Hi ,

Please refer the below on the abbreviation which you are looking for -

Forecast Formulas - Forecasting (LO-PR) - SAP Library

To do it in excel please refer this

Forecast and Trend in Excel - Easy Excel Tutorial

Regards

JH

[Former Member]

Hi Jiaul,

Thanks for your reply and the trend excel tool.

As explained to Brahmakar, I don't catch what "Actual demand for current period" is, if not the consumption. I think this is my main point, as I already got formula from help.sap.

As requested to Brahmakar, please could you send me an example of consumptions and corresponding forecast calculation for seasonal+trend model (X) ?

Thanks a lot for your support.

Kind regards,

Sandrine

[rupesh_brahmankar3]

Hello,

V(t)= Actual demand for current period(T)

Please refer these abbreviation,

Consumption value in Period i:                      c(i)

Number of consumption values used for forecasting:  p

Number of periods in one seasonal cycle:            x

Initial value of Trend value:                      T(0)

Initial value of Basic value:                      B(0)

Initial values of Seasonal indices:                 S(0,j)

Please refer ,

Trend/Seasonal Models w. 1st Order Exp. Smoothing - Forecasting - SAP Library

Best Regards,

R.Brahmakar

[Former Member]

Hi Brahmankar,

Thanks for your reply. Actually, I still don't understand what "V(t)" is, as I don't catch what "Actual demand for current period" is. What's the difference with c(i), that is consumption ?

I don't see c(i) in any formula.

Please can you give me an example of consumptions and calculated forecast ? (for seasonal and seasonal+trend models) ?

Thanks a lot

Sandrine