This question was **closed** Jan 19, 2017 at 05:31 PM by Georgia Vanin for the following reason: Other

This question has been deleted.

This question has been undeleted.

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

!

forecast-calculation.png
(247.1 kB)

data-in-tabular-form.txt
(4.7 kB)

0
Comments

## Add comment