Skip to Content
0

Flexible planning for low volume sales data

May 03, 2017 at 12:53 PM

41

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Caetano Almeida
May 03, 2017 at 01:40 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Caetano Almeida
May 03, 2017 at 06:07 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded