Flat Sales Commission and Split

Calculate using the labelled inputs: Flat Sales Commission and Split.

Commission earned
2000.00
Fixed pay plus earned commission
3000.00
Commission after advance (negative = excess advance)
1500.00
Base commission share per seller
666.66
Sellers receiving an extra 0.01
2
Sales needed for separate desired commission
40000.00

Calculation and assumptions

C=round(S·r/100,2); pay=B+C; owed=C−A; reverse=100T/r.

Round commission once, halves away from zero; split that commission in cents, excluding fixed pay and advance. The reverse result is independent and undefined at zero rate. Excess advance is shown as a negative balance; repayment terms are not inferred. No taxes, minimum commissions or contract rules. 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(S·r/100,2); pay=B+C; owed=C−A; reverse=100T/r.

What assumptions apply?

Round commission once, halves away from zero; split that commission in cents, excluding fixed pay and advance. The reverse result is independent and undefined at zero rate. Excess advance is shown as a negative balance; repayment terms are not inferred. No taxes, minimum commissions or contract rules. 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 →