APO DP - Manage forecast for multiple items sharing same total forecast

[Former Member]

Hello, I need your support to manage in APO DP the forecast calculation for different items sharing

the same total forecast.

Example for a 3 month period

                     M1     M2     M3

SKU 1  FC = 20     30      100          Promo code

SKU 2  FC = 30     50          0          Promo code

SKU 3  FC = 50     20          0          Regular code

Requirements is to:

1. Assign a predefined % split for the FC within the 3 SKUs in each month

(in M0 i'll then have the possibility to set already the 3 month split x SKU)

2. Having the system automatically taking into account the real sales in the

months to propose an adjusted FC % mix

Anybody having experience with an APO implementation for this topic?

Thank you very much for your support,

Gabriele

[peter_casper]

Hi Gabriele,

the solution is pretty straight forward.

1a) Run a statistical forecast method on the aggregated article group level, i.e. one level higher than SKU.

1b) Ensure that the forecast key figure gets disaggregated according to another key figure which contains your desired % split

2) Create a macro which calculates / proposes a new future split based on the historical sales data split.

regards, Peter

[Former Member]

Hi Peter, thank you for the reply.

I've another more challenging question where I hope you can help as well.

In this case I've 2 promotional items and 1 regular code where:

For M1,2 the forecast is totally promotional

For M3 the forecast is on the regular item (as at M0 time we suppose in M1,2 the promotion stock will be completely sold and we can then sold the regular item in M3)

Forecast example for a 3 month period

                     M1     M2     M3

SKU 1  FC = 70     30           0          Promo code          total initial stock 100

SKU 2  FC = 30     70           0          Promo code          total initial stock 100

SKU 3  FC =   0       0        100         Regular code        total initial stock 0

The requirement is to dynamically update the forecast for M3 in the regular code based on the stock

consumption on the promotional codes.

For example if on M1,2 I'd sell less than the stock of 100 the "100" FC on the regular item for M3 would

be reduced accordingly.

Thanks in advance for the support,

[peter_casper]

Hi GM,

the principle would be exactly the same. Your forecast KF will get timely disagreggated based on another KF which you fill according to the logic described above.

Additionally you can create a macro to fine tune your numbers in case you need any deduction on SKU level based on absolute figures or any other special logic.

regards Peter