Modeling Questions
Hi all,
Can you please help me with the following model? I want to create a model to calculate my budget for the next year. Here's the list of components:
List:
- Product: Family => Subfamily => KSU
- Distribution Network: Global => Distribution Network Local
- Brand: Brand X and Y
Input:
- Sales history in quantity and revenue (CA) per month
- Price for one unit
- Forecast per year in quantity
Time:
- Anaplan calendar year/month
Version:
- Actual
- Forecast
Module:
- Module 1: Calculation of Forecast per month using the sales history data and applying a seasonality coefficient to adjust the data. The seasonality is not calculated per article but based on a key: Subfamily/Distribution Local/Brand. This means I need the sales data per this key. Please note that Subfamily, Distribution Network Local, and Brand have different hierarchical levels.
I am using the following formula to calculate the forecast in quantity: Forecast of the year * seasonality coefficient of every month.
I am stuck and don't know how to create the seasonality key (Subfamily/Distribution Local/Brand), is there a possible way to concatenate the lists to have a ligne item as Subfamily/Distribution Local/Brand using Anaplan ?
Thanks in advance.
Answers
-
Hi Neyla,
if understood correctly, you have one list for Product: Family => Subfamily => KSU
To use subfamily as aggregation level it's better to split Product in 3 lists hierarchy:
P1 Family > P2 Subfamily > P3 KSU
See details here
Best,
Konstantin
0