Revenue is planned in two different categories:
The following plan data was planned at the level of the characteristic Region (in addition to the revenue not split by region).
Country |
Region |
Revenue in USD (thousands) |
USA |
East |
100 |
USA |
West |
80 |
The following plan data was planned at the level of the characteristic Country (in addition to the regionally assigned values).
Country |
Region |
Revenue in USD (thousands) |
USA |
-- |
90 |
For the country USA, the planned revenue is to be newly distributed based on the previous year’s values for the key figure sales volume.The following was selected as reference data:
Country |
Region |
Sales volume |
USA |
East |
50 |
USA |
West |
100 |
The distribution of the previous year’s sales volume data means that the revenue is to be distributed in a 1:2 relationship to the regions East and West. This distribution can be carried out using either of two strategies:
1. Result: Distribution by the ‘Distribute total value’ method
The planned values are summed to a total value of USD 270,000 and are newly distributed at regional level according to the reference base:
Country |
Region |
Revenue in USD (thousands) |
USA |
East |
90 |
USA |
West |
180 |
2. Result: Distribution by the ‘Distribute unassigned values only’ method
Only the value at the higher level (Country), USD 90,000 is distributed based on the actual previous year’s data for the key figure sales volume, and summed to a total value per region:
Country |
Region |
Revenue in USD (thousands) |
USA |
East |
130 |
USA |
West |
140 |
The value at country level is deleted in both cases after the top-down planning.
Country |
Region |
Revenue in USD (thousands) |
USA |
-- |
-- |