Top-Down Scenario 

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

--

--