Combination groups offer quantity break discounts on the combined total of items bought from all sell groups included in the combination group.
For example, when a customer places an order, the system determines if any of the items are in sell groups that belong to a combination group. Combination group items are added together and the system determines if the total quantity qualifies for quantity break pricing. If the quantity meets a break point, on the matrix cell, the system looks at the matrix type to determine which items qualify for quantity breaks.
The following examples explain how the system determines quantity breaks for:
Combination group matrix cells that all have the matrix type C - combination quantity break.
Combination group matrix cells that do not all have the matrix type C - combination quantity break.
When combination group matrix cells are all matrix type C
The table below shows the combination group DELTA, which contains sell groups DELTA1, DELTA2, and DELTA3. All of the sell groups are combined with customer price class 1 in sell matrix cells. These are all C-type (combination quantity break) matrix cells. The combination group has quantity breaks defined at 10 ea (each), 20 ea, and 30 ea, with pricing formulas for the matrix cells defined.
|
Customer Price Class 1 |
Customer Price Class 1 |
Customer Price Class 1 |
|||
|
Qty Brk |
Formula |
Qty Brk |
Formula |
Qty Brk |
Formula |
|
<10 |
LIST x 1.0 |
<10 |
LIST x 1.0 |
<10 |
LIST x 1.0 |
|
10 |
LIST x .90 |
10 |
LIST x .85 |
10 |
LIST x .75 |
|
20 |
LIST x .80 |
20 |
LIST x .75 |
20 |
LIST x .65 |
|
30 |
LIST x .70 |
30 |
LIST x .65 |
30 |
LIST x .55 |
A class 1 customer places an order for:
Four items from DELTA1.
Five items from DELTA2.
Two items from DELTA3.
Though the customer does not reach the first quantity break (10), the total number of items (11) exceeds the quantity break for the combination group.
The system calculates the formula in the class/group matrix cells at the quantity break level (10), shown shaded in the table above, and determines the price for the items in each group, itemized as follows:
Sell group DELTA1 - Price = 4 at LIST x .90
Sell group DELTA2 - Price = 5 at LIST x .85
Sell Group DELTA3 - Price = 2 at LIST x .75
When combination group matrix cells are not all matrix type C
The table below shows the combination group DELTA, which contains sell groups DELTA1, DELTA2, and DELTA3. All of the sell groups are combined with customer price class 1 in sell matrix cells:
Class 1/sell group DELTA1 and class 1/sell group DELTA2 are C-type (combination quantity break) matrix cells.
Class 1/sell group DELTA3 is an N-type (no quantity break) matrix cell.
The combination group has quantity breaks defined at 10 ea (each), 20 ea, and 30 ea, with pricing formulas for the matrix cells defined.
|
Customer Price Class 1 |
Customer Price Class 1 |
Customer Price Class 1 |
|||
|
Qty Brk |
Formula |
Qty Brk |
Formula |
Qty Brk |
Formula |
|
<10 |
LIST x 1.0 |
<10 |
LIST x 1.0 |
<10 |
LIST x 1.0 |
|
10 |
LIST x .90 |
10 |
LIST x .85 |
10 |
|
|
20 |
LIST x .80 |
20 |
LIST x .75 |
20 |
|
|
30 |
LIST x .70 |
30 |
LIST x .65 |
30 |
|
A class 1 customer places an order for the following:
Four items from DELTA1.
Five items from DELTA2.
Two items from DELTA3.
The total number of items ordered (11) in this combination group exceeds the first quantity break, but eligibility of items receiving quantity break pricing works as follows:
For the 9 items in sell groups DELTA1 and DELTA2 the matrix cell is a type C, so these products receive quantity break pricing.
For the 2 items ordered in sell group DELTA3 the matrix cell is type N, so these items do not receive quantity break pricing.
The system then calculates the formula in the class/group matrix cells at the quantity break level (10), shown shaded in the table above, and determines the price for the items in each group, itemized as follows:
Group DELTA1 - Price = 4 at LIST x .90
Group DELTA2 - Price = 5 at LIST x .85
Group DELTA3 - Price = 2 at LIST x 1.0
See Also: