Skip to Content

Statistical Forecasting with IBP for S&OP - Time bucket problem


for our S&OP process in IBP for S&OP, we want to execute our Demand Planning Process based on monthly time buckets, and our Supply Planning Process based on weekly time buckets. Consequently, we implemented a Time Profile with the lowest Time Profile level being "Week" in our Planning Area.

If I now use Statistical Forecasting methods within our described system settings, all calculations take place on the lowest Time Profile level - the weekly one. In addition to that, the statistical forecasting profiles use the weekly planning level as input. So, for example, when I want to use historic data of a full year, I have to select 52 periods (weeks) as Historical Periods.

As I would much prefer to base my Statistical Forecasting on an aggregated monthly time bucket and use only 12 historic periods (months) as data input - is there any possibility to switch the relevant Time Profile level for the Demand Planning Process to a monthly bucket?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Sep 02, 2015 at 08:01 PM

    Hi Holger,

    You ca run Statistical Forecast at Monthly Level,though the Actuals Qty input is at Weekly level or the planning area is at weekly level. For this you define an input Calculated KF MTHACTUALS@MTHPRODCUST = SUM(ACTUALS@WKPRODCUST).

    This KF will be an input to Stat Fcst and the output can be KF at Monthly Level eg STATFCST@MTHPRODCUST.

    If you want to bring this monthy output forecast to a weekly level, you can add additional calculations.

    Hope this helps.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.