on 02-01-2013 11:31 AM
Hi Experts,
Does any one help How Upper Tolerance Limit and Lower Tolerance Limit calculates for Corrected History KF?
The sap formula is
Upper Tolerance Limit = Ex-post Fcst + sigma*MAD
Lower Tolerence Limit = Ex-post Fcst + sigma* MAD
In the above formula i know Expost Fcst value and sigma value But do not know how MAD calculates?
Can any one help how MAD calculates?
Advance Thanks,
Hi Sumanth,
MAD is the ratio of sum of absolute values of differences between actual and forecast values and number of periods considered.
i.e. MAD = SUM( e(i) ) / n
where e(i) = | Actual value(i) - Forecast value(i) |
and n = number of periods.
http://en.wikipedia.org/wiki/Mean_absolute_error
Thanks,
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This 260 = Past 156 weeks + future 104 weeks?
Is that above formula correct?
i am not getting the desired result in the system the way you mentioned. please help me in the below screen.
or
Give me some guide in the below screen which is for week week12 and week13.
Week 12 and 13 have corrected forecast. How the system is determining Upper and lover limit for week12 and week13.
the sigma factor for this is 0.60
Sumanth,
The system is not showing right result for MAD.
Quite a statement. A better statement might be that the system does not meet your expectations; the system is most likely calculating exactly what it is programmed to calculate.
Read SAP's documentation of what logic THEY use in their various forecast algorithms (including their formula for MAD).
http://help.sap.com/saphelp_scm700_ehp02/helpdata/EN/ac/216b8c337b11d398290000e8a49608/frameset.htm
If your system is not consistent with the SAP documentation, then search OSS notes; or raise a message with SAP. There is noone here who can modify your system.
I have personally never found it profitable to try and analyze or duplicate SAP's forecasting algorithms. Much effort can be spent, but in the end, all you have is still just a forecast, which will inevitably be WRONG when compared to the actual.
Best Regards,
DB49
Sumanth,
Pay attention to your selection on which forecast was run. MAD or any other measure of forecast error is meaninggful only at the selection level at which forecast is run. Rest is disaggregation and aggregation.
If you try to measure it at some other level in your excel sheets, it will never match. So make a distinction between WHAT you are actually forecasting and WHAT you are reporting the error for.
Hope this general gyan helps
Thanks
BORAT
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.