Calculation guide
Enter strictly increasing upper thresholds. Rates apply only to incremental sales in each band. The last rate extends above the last threshold. No retroactive accelerators.
Commission = Σ(incremental sales per band × band rate); above final threshold use last rate.
Inputs
Eligible sales
Example entry 80000 (in the selected currency).
Upper cumulative sales threshold
Example entry 25000 (in the selected currency). Minimum 0.01.
Commission rate in band
Example entry 3 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Eligible sales | 80,000 |
Commission bands
| Upper cumulative sales threshold | Commission rate in band |
|---|---|
| 25,000 | 3% |
| 50,000 | 4% |
| 75,000 | 10% |
| Result | Value |
|---|---|
| Commission earned | 4,750 |
| Blended commission rate | 5.9375% |
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 |
|---|---|---|---|---|---|
| Eligible sales | 80,000 | 88,000 | Commission earned | 4,750 | 5,550 |
| Upper cumulative sales threshold (row 1) | 25,000 | 27,500 | Commission earned | 4,750 | 4,725 |
| Commission rate in band (row 1) | 3% | 4% | Commission earned | 4,750 | 5,000 |
