Example of Distribution Methods
The following planning data was planned at the product group level:
Product group |
Product |
Revenue |
PRGRA |
-- |
90 |
The following planning data was planned at the product level:
Product group |
Product |
Revenue |
PRGRA |
P1 |
100 |
PRGRA |
P2 |
80 |
You want to redistribute the revenue planned for product group PRGRA on the basis of the reference value field Quantity sold.
Selection in the planning package for which distribution is executed:
Characteristic |
Selection |
Product group |
PRGRA |
Product |
Distribution characteristic:
Characteristic |
Selection |
Product group |
Sender |
Product |
Receiver |
Reference data:
Product group |
Product |
Sales quantity |
PRGRA |
P1 |
50 |
PRGRA |
P2 |
100 |
Result 1: The Distribute total value procedure
The planned values are aggregated to a total value of 270 USD, and then distributed to the products again on the basis of the value field specified as the distribution basis.
The following line items are created:
Product group |
Product |
Revenue |
PRGRA |
-- |
90- |
PRGRA |
P1 |
10- |
PRGRA |
P2 |
100 |
Result:
Product group |
Product |
Revenue |
PRGRA |
P1 |
90 |
PRGRA |
P2 |
180 |
Result 2: The Distribute "nonassigned" only procedure
Only the value planned directly at the product group level - 90 USD -is distributed according to the sales quantity.
The following line items are created:
Product group |
Product |
Revenue |
PRGRA |
-- |
90- |
PRGRA |
P1 |
30 |
PRGRA |
P2 |
60 |
Result:
Product group |
Product |
Revenue |
PRGRA |
P1 |
130 |
PRGRA |
P2 |
140 |