Tiered sales commission · Calculation guide

Apply a marginal commission rate to each sales band.

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

InputValue
Eligible sales80,000

Commission bands

Upper cumulative sales thresholdCommission rate in band
25,0003%
50,0004%
75,00010%
ResultValue
Commission earned4,750
Blended commission rate5.9375%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Eligible sales80,00088,000Commission earned4,7505,550
Upper cumulative sales threshold (row 1)25,00027,500Commission earned4,7504,725
Commission rate in band (row 1)3%4%Commission earned4,7505,000
Tiered sales commission →