Flexible planning for low volume sales data

[Former Member]

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.

[Caetano]

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

[Caetano]

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

[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