Basic Value Calculation in seasonal model

[pravinkumar_yadav]

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 help.sap under this link http://help.sap.com/saphelp_scm70/helpdata/en/66/a2ca53f1a1214be10000000a174cb4/content.htm?frameset...

but that is again not helping.

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

Questions:

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

data-in-tabular-form.txt

!