How dissagregation is calculated and where is it defined?

[former_member687629]

Hi experts,

I would like to ask you about how total demand quantity is proportionally distributed as well as related useful link.

<Example>

Let’s assume a demand planner plans 200 quantity should be distributed in a month. This month, for instance, has 4 weeks with working day which range from Monday to Friday. Supposing all the quantity to be produced is divided by the numbers of working days in the month, which is twenty, each day is to produce 10 quantity products (disaggregation).

Then, each calendar week has 5 working days, so each week needs to produce 50 products. When it comes to making a production plan as well as transport plan in such case, how is the disaggregation ruled is like? In IBP, proportional distribution is done automatically or is there any rules or setting to define that? (Plus, even though in the case here demand is equally distributed by the numbers of working days in a month, I am seeking the possibility to change the coefficient. Like, Monday and Tuesday produce or transport more than other working days)

[gaurav_guglani87 · Accepted solution]

Hi,

By default, Month to week split will be based on 'WEEKWEIGHT' attribute of associated time profile which you provide in 'Period Weight' field in 'Key Figure configuration

Similar, Week to day split will be based on 'DAYWEIGHT' attribute of the time profile if that is provided in 'Period weight' Field.

If the field is left blank while creating Key Figures, you will have equal distribution when split from an aggregated level.

For building a solution wherein you want custom split based on user values, you can perform following steps

1. Build a key figure ' user Split' at Day Level in which user can enter proportions.

2. Write a calculation at Week and Day level which takes Month and Week level input respectively and multiply it by user split proportions.

Thanks

Gaurav