Skip to Content
0

Basic Value Calculation in seasonal model

Oct 25, 2016 at 11:33 AM

216

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

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

!

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

0 Answers