How it works
Apply each rate only to the sales slice inside that cumulative band. The final * band is unbounded.
Input definitions
- Eligible sales
- Enter the value in the labeled unit.
- CSV: cumulative upper sales limit,commission percent; final limit is *
- Plain text; maximum 200,000 characters.
A worked example
- Eligible sales
- 15000
- CSV: cumulative upper sales limit,commission percent; final limit is *
- upper,rate 10000,5 *,10
Assumptions & limits
Entered-data planning worksheet. No legal, payroll, tax-filing or accounting certification.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Does entering a higher tier reprice all earlier sales?
No. This is a marginal commission model: only sales within each band receive that band’s rate. An all-sales or retroactive commission plan needs another formula.
How does Tiered marginal commission plan work?
Apply each rate only to the sales slice inside that cumulative band. The final * band is unbounded.
What are the limits of Tiered marginal commission plan?
Entered-data planning worksheet. No legal, payroll, tax-filing or accounting certification.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.