Graduated Sales Commission

Calculate using the labelled inputs: Graduated Sales Commission.

Commission earned
5400.00
Commission after advance (negative = excess advance)
4400.00
Fixed pay plus earned commission
5400.00
Effective commission rate (%)
4.5

Calculation and assumptions

C=round(Σmax(0,min(S,Uᵢ)−Lᵢ)rᵢ/100,2); owed=C−A; pay=B+C.

Enter 1–100 tiers with strictly increasing positive upper limits (two decimals) and rates 0–100% (six decimals). The last limit must be *. Each rate applies only to its sales slice; zero-rate tiers allow thresholds. Round the sum once, halves away from zero. No taxes or bonus curves. A dash means the corresponding ratio is undefined because its denominator is zero. In one chosen two-decimal currency; no taxes or current market rates are supplied.

Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Frequently asked questions

How is the result calculated?

C=round(Σmax(0,min(S,Uᵢ)−Lᵢ)rᵢ/100,2); owed=C−A; pay=B+C.

What assumptions apply?

Enter 1–100 tiers with strictly increasing positive upper limits (two decimals) and rates 0–100% (six decimals). The last limit must be *. Each rate applies only to its sales slice; zero-rate tiers allow thresholds. Round the sum once, halves away from zero. No taxes or bonus curves. A dash means the corresponding ratio is undefined because its denominator is zero. In one chosen two-decimal currency; no taxes or current market rates are supplied.

How precise are the results?

Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Also try:

Back to category →