Calculation Methods for Volume Rebates
The SuiteApp provides you two ways to calculate volume rebates on sales transactions. You can select Volume Amount or Volume Quantity.
Volume Amount
In volume amount, rebates are calculated on transactions based on the monetary tier you reach.
In a Marginal rebate scheme, the calculated volume rebate is based on the currently achieved tier.
Example #1
This uses Marginal rebate scheme then Rate per Unit as the rebate rate type.
|
Tier |
Minimum Tier |
Maximum Tier |
Rebate Value |
|---|---|---|---|
|
Tier 1 |
$1 |
$100 |
$5 |
|
Tier 2 |
$101 |
$350 |
$10 |
|
Tier 3 |
$351 |
$500 |
$15 |
Items A and B are both given a $5 default tier value multiplied by the item quantity. After the reconciliation process, the rebate values update to $10 and $7.5 respectively.
The $200 for Item B qualifies for both Tier 1 and Tier 2. The first $100 on that amount qualifies for Tier 1 with $5 rebate, then the remaining amount is for Tier 2 with $10 rebate.
After recalculation, the rebates are calculated this way:
(maximum tier 1/amount)* tier 1 rebate value + ((amount-maximum tier 1)/amount)* tier 1 rebate value
(100/200) * 5 + (100/200) * 10 = 7.5
|
Item |
Quantity |
Rate |
Amount |
Rebate (Before Reconciliation) |
Tier |
Rebate (After Reconciliation) |
|---|---|---|---|---|---|---|
|
Item A |
2 |
$30 |
$60 |
$10 |
Tier 1 |
$10 |
|
Item B |
1 |
$200 |
$200 |
$5 |
Tier 1, Tier 2 |
$7.5 |
Example #2
This transaction uses Marginal rebate scheme then Percentage as the rebate rate type.
Similar to the Rate per Unit calculation, a line item is given a default tier rebate. After evaluating tier achievement, rebates are recalculated as follows:
rebate tier value * amount
Item A: 0.05 * 60 = $3
Item B: 0.05 * 100 + 0.1*100 = $15
|
Tier |
Minimum Tier |
Maximum Tier |
Rebate Value |
|---|---|---|---|
|
Tier 1 |
$1 |
$100 |
5% |
|
Tier 2 |
$101 |
$350 |
10% |
|
Tier 3 |
$351 |
$500 |
15% |
|
Item |
Quantity |
Rate |
Amount |
Rebate (Before Reconciliation) |
Tier |
Rebate (After Reconciliation) |
|---|---|---|---|---|---|---|
|
Item A |
2 |
$30 |
$60 |
$3 |
Tier 1 |
$3 |
|
Item B |
1 |
$200 |
$200 |
$10 |
Tier 1, Tier 2 |
$15 |
Volume Quantity
In volume quantity, rebates are calculated on transactions when you achieve target quantity tiers.
Unlike the Marginal rebate scheme where the total calculated rebates includes the sum of the rebates calculated at individual tiers, the Linear rebate scheme only looks at the highest tier you achieve and calculates rebates based on that tier. As you achieve higher tiers, all related rebates are recalculated at the highest achieved tier.
Example #1
This transaction uses Linear rebate scheme and Rate per Unit as the rebate rate type.
The Aggregate box is checked in the rebate agreements of Items A, B, and C.
|
Tier |
Minimum Tier |
Maximum Tier |
Rebate Value |
|---|---|---|---|
|
Tier 1 |
1 |
10 |
$2 |
|
Tier 2 |
11 |
20 |
$4 |
|
Tier 3 |
21 |
30 |
$6 |
Three units of Assembly Item A earn a $30 rebate, that is a $10 default tier rebate value multiplied by the item quantity.
|
Item |
Quantity |
Rate |
Amount |
Rebate (Before Reconciliation) |
Tier |
Rebate (After Reconciliation) |
|---|---|---|---|---|---|---|
|
Item A |
15 |
$100 |
$1,500 |
$30 |
Tier 3 |
$90 |
|
Item B |
10 |
$120 |
$1,200 |
$20 |
Tier 3 |
$60 |
|
Item C |
5 |
$150 |
$750 |
$10 |
Tier 3 |
$30 |
After the transaction is evaluated for tier achievement, the total quantity for the transaction is 30, which qualifies for Tier 3. The calculated rebates for all items that qualified for tier 3 rebate value is $6.
The $6 rebate value replaces the default tier value of $2, and is applied to each item after the recalculation process.
Example #2
This transaction uses Linear rebate scheme and Percentage rebate rate type. The agreement is also set to aggregate the item inclusion when calculating for rebates.
The default tier value is multiplied to the item rate, then multiplied to item quantity.
The rebates for the following example are calculated this way:
rebate tier value * rate * quantity
0.10 * $600 = $60
After the transaction is evaluated for tier achievement, the accumulated quantity for the transaction is equals to 6, which qualifies for Tier 2. The calculated rebates for the item using tier 2 rebate value is $180.
0.20 * $600 = $120
|
Tier |
Minimum Tier |
Maximum Tier |
Rebate Value |
|---|---|---|---|
|
Tier 1 |
1 |
5 |
10% |
|
Tier 2 |
6 |
10 |
20% |
|
Item |
Quantity |
Rate |
Amount |
Rebate (Before Reconciliation) |
Tier |
Rebate (After Reconciliation) |
|---|---|---|---|---|---|---|
|
Kit Item A |
3 |
$300 |
$900 |
$60 |
Tier 2 |
$120 |
|
Item A |
3 |
$300 |
$330 |
$64 |
Tier 2 |
$128 |
When you edit a line item in a transaction after the daily recalculation process, the rebate is calculated based on the default tier. After another recalculation process and tier re-assignment, the updated rebate tier values are reflected the next day.