Skip to Content
avatar image
Former Member

Flexible planning for low volume sales data

Hello Gurus,

I am trying to implementing flexible planning with key figure " billed quantity" and on month basis. I have copied SIS data into our info structure and version is also copied to 000. While forecasting, I am getting basic value as zero error as data volume is very low and initial values are zero. I have taken last 36 months of historical data to plan for next 3 months.

Is there any other way to do forecast with low volume data in info structure?

capture.jpg

Thanks in advance.

capture.jpg (37.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 03, 2017 at 01:40 PM

    Hello

    Depending on the forecast model you are using, system requires that you have a long history for your key figure. For example, if you are using a seasonal model, you need to have several seasons, in order to have the correct forecast calculation.

    One option is to consider zero values in the start of the time axis, using BAdI HISTORICAL_VALUES, but then the forecast values may be too low.

    Another option is to choose a simpler forecast model, such as a constant model.

    Regards,

    Caetano

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Caetano,

      I checked with all models and getting forecast values between 0 and 1.

      Now, Should I create any Z program for planning or is there any scope with std forecasting?

      thanks

  • May 03, 2017 at 06:07 PM

    Hello

    The forecast results will be proportionally calculated to the key figure values. I mean, you will not get a high forecast if the key figure has low values.

    Maybe you can add a macro in flexible planning, multiplying the billed quantity and then using this value as the forecast value.

    Regards,

    Caetano

    Add comment
    10|10000 characters needed characters exceeded