Examples
No value exists for consolidation member
In this example, no value exists for the consolidation members Digital Phones and Total Year 2009 or the leaf members. A 12,000,000 value is specified at the consolidated level.
| Total Year 2009 | January 2009 | February 2009 | March 2009 | |
|---|---|---|---|---|
| Digital Phones | 12,000,000 | |||
| T100 | ||||
| T950P | ||||
| T1500C |
After the top down spread is performed, the leaf members reflect an equal distribution of the 12,000,000 among the three members of Digital Phones and the 12 months of Total Year 2009 (only the first three months are shown). The consolidation members reflect the sum of the new leaf values as a result of the automatic local consolidation.
| Total Year 2009 | January 2009 | February 2009 | March 2009 | |
|---|---|---|---|---|
| Digital Phones | 12,000,000 | 1,000,000 | 1,000,000 | 1,000,000 |
| T100 | 4,000,000 | 333,333 | 333,333 | 333,333 |
| T950P | 4,000,000 | 333,333 | 333,333 | 333,333 |
| T1500C | 4,000,000 | 333,333 | 333,333 | 333,333 |
Current values exist for consolidated and leaf members
In this example, values already exist for the consolidation members Digital Phones and Total Year 2009 and all leaf members in Quarter 1 (the remaining periods have null values).
| Total Year 2009 | January 2009 | February 2009 | March 2009 | |
|---|---|---|---|---|
| Digital Phones | 18,000 | 4,000 | 6,500 | 7,500 |
| T100 | 6,000 | 1,000 | 2,000 | 3,000 |
| T950P | 3,000 | 500 | 1,000 | 1,500 |
| T1500C | 9,000 | 2,500 | 3,500 | 3,000 |
| Total Year 2009 | January 2009 | February 2009 | March 2009 | |
|---|---|---|---|---|
| Digital Phones | 12,000,000 | 2,666,667 | 4,333,333 | 5,000,000 |
| T100 | 4,000,000 | 666,667 | 1,333,333 | 2,000,000 |
| T950P | 2,000,000 | 333,333 | 666,667 | 1,000,000 |
| T1500C | 6,000,000 | 1,666,667 | 2,333,333 | 2,000,000 |
The leaf members reflect a pro-rated distribution of the 12,000,000, based on previous ratios for the three members for Digital Phones and the 12 months for Total Year 2009 (only the first three months are shown). For example, before the change, the January 2009 ratio is:
.22222222222 (ratio) = 4,000 (existing leaf value)/18,000
(existing consolidated value)
When 12,000,000 is top down spread as the new consolidated value, the new January 2009 value is:
2,666,667 (new leaf value) = 12,000,000 (new consolidated
value) * .22222222222 (ratio)