Skip to Content
0
Former Member
Apr 07, 2007 at 11:48 AM

Key figure incorrect disaggregation

28 Views

Hi All,

Please help me in resolving the issue regarding incorrect key figure disaggregation in the planning book. The key figure value which is disaggregated is based on another keyfigure. The calculation type and disaggregation type set up in the planning area for these two key figures are

Calculation type Based on KF Time based disaggregation

KF1 S P

KF2 P KF1 P

I am providing an example as below.

You select one SKU (50058801807) in the planning book. These three characteristic value combinations exist for the SKU: CVC1, CVC2, and CVC3. You enter 100 pieces as the ‘actual impact of promotional events quantity (KF2)’ in the month of May (month five).

You save the data. The system first performs time-based disaggregation. In other words, it first disaggregates the 100 pieces of the SKU level into technical periods based on the number of workdays in each period. In this example, factory calendar has been defined in the planning area, so there are five workdays in each week. The month of May has 22 workdays (one day public holiday). No proportional factors exist.The calculation is as follows:

Level1: The system collects the rounding differences from all the periods.

Technical Number of DaysCalculation Result Brought Forward

Period in TP

5/1-5 5 100 * 5/22 = 22.727 23 -0.273

5/8-12 5 100 * 5/22= 22.727 23 -0.273

5/15-19 5 100 * 5/22 = 22.727 23 -0.273

5/22-26 5 100 * 5/22 = 22.727 23 -0.273

5/29-31 2 100 * 2/22 = 9.090 9 0.090

Total: 101 1

Level 2: Distribution of the difference -1

Technical Number of Days Calculation Result Brought Forward

Period in TP

5/1-5 5 -1 * 5/22 = -0.227 0 -0.227

5/8-12 5 -1 * 5/22 = -0.227 0 -0.454

5/15-19 5 -1 * 5/22 = -0.227 0 -0.681

5/22-26 5 -1 * 5/22 = -0.227 0 -0.908

5/29-31 2 -1 * 2/22 = -0.090 -1 0

Total: -1 0

The result:

Technical Result

Period

5/1-5 23

5/8-12 23

5/15-19 23

5/22-26 23

5/29-31 8

Total: 100

As an example, the 23 pieces, which are to be distributed in several technical periods (5/1-5, 5/8-12, 5/15-19, 5/22-26 and 5/29-31), are calculated below for the three characteristic value combinations:

CVC Calculation Result Remainder

CVC1 23 * 1/3 = 7.666 8 -0.334

CVC2 23 * 1/3 = 7.666 8 -0.334

CVC3 23 * 1/3 = 7.666 8 -0.334

Total: 24 -1.002

The remainder -1.002 is distributed to the three characteristic value combinations:

CVC Calculation Result Remainder

CVC1 -1.002 * 1/3 = -0.334 0 -0.334

CVC2 -1.002 * 1/3 = -0.334 0 -0.668

CVC3 -1.002 * 1/3 = -0.334 -1 0

Total: -1

The following table shows which of the seven characteristic combinations the system assigns how many pieces:

CVC Result

CVC1 8

CVC2 8

CVC3 7

Total: 23

Calculation for 8 pieces:

CVC Calculation Result Remainder

CVC1 8 * 1/3 = 2.666 3 -0.333

CVC2 8 * 1/3 = 2.666 3 -0.333

CVC3 8 * 1/3 = 2.666 3 -0.333

Total: 9 -0.999

The remainder 0.994 is distributed to the five characteristic value combinations:

CVC Calculation Result Remainder

CVC1 0.999 * 1/3 = -0.333 0 -0.333

CVC2 0.999 * 1/3 = -0.333 0 -0.666

CVC3 0.999 * 1/3 = -0.333 -1

Total: -1

The following table shows which of the seven characteristic combinations the system assigns how many pieces:

CVC Result

CVC1 3

CVC2 3

CVC3 2

Total: 8

This means that each characteristic combination is assigned the relevant proportion from the table for each technical period for which the system can distribute 8 pieces. In the period 5/29-31, eight pieces are distributed to the three characteristic combinations.

The results are displayed schematically in the following figure:

Technical periods in which data is saved:

5/1-5 5/8-12 5/15-19 5/22-26 5/29-31

23 23 23 23 8

Disaggregation in technical periods at SKU level:

For value 23

23

8 8 7

For value 8

8

3 3 2

Disaggregation in technical periods at detailed level:

Now according to the above calculation,

CVC 1 gets value – 35

CVC 2 gets value -35

CVC 3 gets value-30

The planning book values are:

CVC 1– 33.623

CVC 2 -50.276

CVC 3 -16.101

Please note: 3 decimal places set for the key figure in the planning area, but this calculation is based on one decimal place.

Even then the differences should not be this high.

Please provide me some examples on disaggregation of kf based on another kf with no proportional factors maintained.

Thank you in advance for your help and support.

Kind Regards,