Skip to Content

Basic Value Calculation in seasonal model

Oct 25, 2016 at 11:33 AM


avatar image

Hello Guys,

I'm trying to figure out the calculations in SAP APO forecasting models precisely Seasonal Model (Strategy 30 ). For this model the initialization values is 1 season ( in my case it's 12 months). Total history horizon is of 3 years (01.2013 - 12.2015 ) and forecast horizon is 3 months (01.2016 - 02.2016). No Ex-Post method is chosen.Alpha = 0.1 Gamma = 0.7

As per SAP, for seasonal model :

Basic value = Mean of the historical values of the first historical season

Trend value = 0

Seasonal index for a period = Historical value for that period divided by the basic value

Mean absolute deviation (MAD) = 0

In my case Basic value is generated from 01.2014 and for that particular bucket value calculated by system is 788.33 ( which is not the average of sales of past season i.e. from 01.2013 till 12.2013, as per the logic mentioned by SAP (the average is 716.67) and SI = 0.14 (which is again irrationally calculated).

There are few formulas mentioned in under this link¤t_toc=/en/5c/3ec95360267614e10000000a174cb4/plain.htm&node_id=16

but that is again not helping.

I have attached a text file, just Copy and paste it into excel (it should get aligned )


1. How does system calculates the Basic Values ? For first bucket just after season 1,as well as subsequent buckets.

2. Which values are calculated first by the system Basic or SI ? It seems to me has to be Basic, but still would like to clarify my doubt



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers