Calculation guide
The higher tier applies only to the excess above its threshold. Subtract rebates already booked to find the current adjustment.
Inputs
Cumulative eligible spend
Example entry 15000 (in the selected currency).
First threshold
Example entry 5000 (in the selected currency).
Second threshold
Example entry 10000 (in the selected currency).
First rebate rate
Example entry 3 %. Allowed range 0 to 100.
Second rebate rate
Example entry 5 %. Allowed range 0 to 100.
Previously accrued rebate
Example entry 200 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Cumulative eligible spend | 15,000 |
| First threshold | 5,000 |
| Second threshold | 10,000 |
| First rebate rate | 3% |
| Second rebate rate | 5% |
| Previously accrued rebate | 200 |
| Result | Value |
|---|---|
| Total earned rebate | 400 |
| Current accrual adjustment | 200 |
Calculation steps
Total earned rebate = (((max(0, (min(Cumulative eligible spend, Second threshold) − First threshold)) × First rebate rate) ÷ 100) + ((max(0, (Cumulative eligible spend − Second threshold)) × Second rebate rate) ÷ 100))
(((max(0, (min(15,000, 10,000) − 5,000)) × 3) ÷ 100) + ((max(0, (15,000 − 10,000)) × 5) ÷ 100)) = 400
Current accrual adjustment = (Total earned rebate − Previously accrued rebate)
(400 − 200) = 200
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Cumulative eligible spend | 15,000 | 16,500 | Total earned rebate | 400 | 475 |
| First threshold | 5,000 | 5,500 | Total earned rebate | 400 | 385 |
| Second threshold | 10,000 | 11,000 | Total earned rebate | 400 | 380 |
| First rebate rate | 3% | 4% | Total earned rebate | 400 | 450 |
| Second rebate rate | 5% | 6% | Total earned rebate | 400 | 450 |
| Previously accrued rebate | 200 | 220 | Current accrual adjustment | 200 | 180 |
