3
$\begingroup$

I have 5000 SKUs which all of them are highly positive autocorrelated, to get the item level forecast for all5000 SKUs (disaggregate forecast) which approach can provide more accurate forecasts, BU or TD, SES is forecasting method? and why?

BU approach: we do the forecast for all 500 SKUs directly TD approach: first we sum up the demand for all SKUs, then we do the forecast for aggregate demand, finally according to the weight of each SKU, we will obtain the disaggregate forecast for each SKU!(f(i,t)=pi*Ft)

Thank you in advance!

Improve this question
$\endgroup$

2 Answers 2

Reset to default
1
$\begingroup$

This paper gives a framework for reconciling hierarchical forecasts. It also points out a flaw in top-down decomposition.

Improve this answer
$\endgroup$
1
$\begingroup$

This can probably not be answered based entirely on theory. It will depend on your time series, the length of history, even your error measure.

I would recommend that you fit both the bottom-up and the top-down procedure to your data with a holdout sample (say, the last three observations), forecast into the holdout sample and see which approach works best.

That said, grouping 5000 items in a top-down approach looks dubious to me. The fastest moving items will completely dominate the slower ones. Perhaps you could introduce a more fine-grained hierarchy?

SES (Single Exponential Smoothing) is certainly a good first candidate. You could also look at the other Exponential Smoothing methods. See, e.g., this free online textbook on forecasting.

Improve this answer
$\endgroup$
9
  • $\begingroup$ Thank you, Actually I've done the forecasts and the Buttom-Up always works better, do you think it's because of the high positive autocorrelation? $\endgroup$
    – Roji
    Commented Nov 20, 2012 at 17:06
  • $\begingroup$ I used MSE as an error measure $\endgroup$
    – Roji
    Commented Nov 20, 2012 at 17:07
  • $\begingroup$ the time series data are stationary and follows ARMA(1,1) process $\endgroup$
    – Roji
    Commented Nov 20, 2012 at 17:09
  • $\begingroup$ That bottom-up works better may be because a top-down forecast with 5000 series is dominated by fast movers. MSE: do you average that over the 5000 series to determine which method works better for the entire sample? If so, the MSE will be determined by large errors (i.e., by series with high means). How much do your series differ on average? $\endgroup$
    – Stephan Kolassa
    Commented Nov 20, 2012 at 20:17
  • $\begingroup$ I didn't average errors, I calculate MSE for each SKU and for both approach , I'm trying to find a intutive explanation why BU works better for high positive autocorrelated data, this is my idea: When autocorrelation is highly positive, successive values of dt are positively correlated and so the process will tend to be smoother than the random series, With data are not so noisy, the signal can be detected at the bottom level, and so the bottom-up approach may do so well. Do you think that's make sense? $\endgroup$
    – Roji
    Commented Nov 21, 2012 at 10:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.