IBP - Use current value for calculation in future periods

[victorhugo_leao]

Hi experts!

I need a requirement to calculate forecast based on actuals sales average.

So, I have this actslsavg in current period.

How to use it (fixed) for the future period's calculations?

Example:

Thanks a lot,

Best regards!

Victor Hugo

[piyush_parekh · Accepted solution]

Hi,

Assuming your key figures are defined at PERPRODLOCCUST, create a planning level without any time-dimension - PRODLOCCUST.

Aggregate Actuals Sales as follows:

Actuals Sales @PRODLOCCUST = AVG (Actuals Sales @PERPRODLOCCUST)

You can also define time range if you want to restrict sales average to certain number of periods.

Forecast @PERPRODLOCCUST = Actuals Sales @PRODLOCCUST * Forecast Factor @PERPRODLOCCUST

Hope this helps!!

Regards,

Piyush

[former_member804657]

Hi Victor,

As others suggest you can run the forecast operator using a simple moving average. Or another method that I did is to use the CAGGR average function and multiply it with the forecast factor, be sure to set the scheduled operator to clear values of that key figure at every end of the cycle.

[rahulmohnot]

Victor,

Please keep in consideration few things:

1. Do you want to execute the forecast operator after actual sales history load ? if "Yes", use "simple average" algorithm as it gives flexibility to choose horizon for averaging past history. The calculation will not.

2.In case, you want to proceed with calculation only then please ensure to reset the ActSalesAvg KF before every cycle otherwise while calculating the time independent KF as proposed by Piyush, must have condition for current period only. This will ensure that while moving from period based KF to period independent KF the quantity is correct.

Hope this helps.

Warm Regards,

Rahul

[piyush_parekh]

Hi,

Define calculation -

Actual Sales Avg @PRODLOCCUST = Actuals Sales @PRODLOCCUST

Actuals Sales Avg @PERPRODLOCCUST = Actuals Sales Avg @PRODLOCCUST (Additional Input : Forecast Factor @PERPRODLOCCUST)

Assumption is planning objects would be available at PERPRODLOCCUST.

Or

You can explore forecast model with Actuals Sales as Input and Actuals Sales Avg as output key figures. Use Simple average algorithm.

Regards,

Piyush

[victorhugo_leao]

Thank you, Piyush!

I think this will help!!

Considering the example, what is the best way to copy the ActualSalesAvg to the future periods (lets consider 3 periods in the future)?

In case we need to see the value across future periods...

Thanks a lot!