Rolling Forecast - Offset for Forecast consumption

[Former Member]

Hi Guys,

I wanted to set up / configure a rolling forecast consumption concept. For example :

                                   February      March                                    April

Forecast                       200                 20                                        50

Shipped Qty                  50                  100                                       50

Rolling Forecast                       150(200-50 From FEB)                 70 (170-100)              

New Forecast                                   170(150+20)                              120

And So on.

So as shown above its clear that 200-50 is done and the result of the difference between forecast and shipped Qty is made available in the next Month Period ID as rolling Forecast(150). Then the result of this can be Added to current month forecast to calculate the New forecast for the month. Now the Rolling Forecast for the month of March would be 70 and this should reflect in April as a carry forward.. then the logic continues...

Looking forward to customization and calculation logic ( at all levels) help.

Thanks

Br

Arjun Kumar Rao

[Irmi_Kuntze · Accepted solution]

Hi

as I see it, you need to roll over unconsumed shippments / unconfirmed orders from one month to the other

Best would be to model it first in Excel including proper formula that hold calculation for every potential combination you have

If your rolling-over would only for one month in the initial month, you could probably solve it with Attribute Transformation (compare Model config guide).

If you could somehow solve formulas with some kind of cumulation, there may be a workaround as well

If you find a way to model the excel formulas with e.g. have the shipments completely moved by one months and afterwards without taking result of one calculation from one month as input for the calculation in the next month, than post the excel here and we can check if we find another workaround

But if it shall roll over over several month as in a projected-stock-scenario, than I see only LCode as potential solution. For that you would need to make up a very good use case that explains verbally the requirement you want to achieve more detailed and an excel that holds all your formula, including definition of what is INPUT kf's and what shall be the OUTPUT. Than open an OSS message and request the code to be implemented into your system as it is now mandatory that SAP is going through the exercise together with you

[Former Member · Accepted solution]

Hi Irmhild,

We have taken your work around and tried to do the same. Thanks again.

Br

Arjun

[Former Member · Accepted solution]

Hi IRMI,

We are getting error in copying the Net Shipped/Forecast value from past month to current and future months. Can you please suggest if you see any issues in the attached calculation logic.

Forecast Roll Over Logic.txt.zip

[Former Member]

Hi,

Just Adding a Slight Correction to the above :

                                       March                      April                      May            June

Forecast                            20                          50                         100             100

Shipped Qty                     100                                      

Rolling Forecast                                  -80                -30

New Forecast                                                          70           100

Similarly:

                                       March                      April                      May            June

Forecast                           120                          50                         100             100

Shipped Qty                     100                                      

Rolling Forecast                                  20               

New Forecast                                    70                  100          100

Previously Suggested method was not working out, Would appreciate if alternative solution can be suggested?

Best Regards

Arjun