Relative Commission Calculator

Projected Sales
Base Salary
Commission Below Quota
Commission Above Quota
Total Commission Earned
Total Compensation

Relative commission calculator

A relative commission calculator that is  based on relative performance or contribution within a group or team. Unlike traditional commission calculators that rely solely on individual sales or performance metrics, a relative commission calculator takes into account the comparative performance of team members and assigns commissions accordingly.

What is a relative commission calculator?

A relative commission calculator is a tool used to determine commissions or bonuses for individuals within a group or team based on their relative performance compared to their peers. 

Unlike traditional commission calculators, which often rely solely on an individual's personal sales or performance metrics, a relative commission calculator takes into account the performance of the entire team or group to assign commissions in a way that reflects each member's contribution within that collective context.

Why use a relative commission calculator?

The use of a relative commission calculator:

  1. Fairness and equity

A relative commission calculator ensures that team members are compensated fairly and equitably based on their actual contributions within a group or team. It prevents situations where top performers feel unfairly rewarded or underappreciated team members feel demotivated.

  1. Team collaboration

It encourages teamwork and collaboration because individuals understand that their commissions are linked to the overall success of the team. This fosters a cooperative atmosphere where team members support each other to achieve shared goals.

  1. Complex performance metrics

In situations where individual contributions are challenging to isolate or where team success depends on multiple factors, relative commission calculators provide a method for fairly distributing rewards. 

  1. Complex performance metrics

 In situations where individual contributions are challenging to isolate or where team success depends on multiple factors, relative commission calculators provide a method for fairly distributing rewards. This is especially important in fields such as project management, where outcomes often result from collective efforts.

How to calculate relative commission?

To calculate relative commission:

  1. Define performance metrics

Define the performance metrics that will be used to evaluate team members' contributions. These metrics could include sales revenue generated, the number of leads brought in, project completion rates, customer satisfaction scores, or any other relevant key performance indicators (KPIs).

  1. Collect performance data

Gather data on each team member's individual performance based on the chosen metrics. Ensure that this data is accurate and up-to-date.

  1. Rank team members

Rank team members based on their performance relative to their colleagues. You can do this by comparing each team member's performance metric scores to those of their peers. This ranking will determine their position within the team in terms of performance.

  1. Assign commission pools

Determine the total commission pool or bonus budget that is available to distribute among the team members. This could be a fixed amount or a percentage of the total revenue generated by the team.

  1. Allocate commissions

Allocate commissions or bonuses based on the ranking. There are several ways to do this:

a. Percentage allocation: Assign a specific percentage of the commission pool to each rank. For example, the top performer might receive a higher percentage, while lower-ranked team members receive a smaller percentage.

b. Point system: Assign points to each rank and distribute commissions based on the points earned. The top rank might receive more points and, consequently, a larger share of the commission pool.

c. Proportional distribution: Calculate each team member's commission as a proportion of their performance relative to the team's total performance. For example, if one team member contributed 20% of the total revenue, they would receive 20% of the commission pool.

How does a relative commission calculator work?

The relative commission calculator works as:

  1. Input bariables
  • Sales amount: The total amount of sales generated by the salesperson or affiliate.
  • Commission rate: The percentage of the sales amount that the salesperson earns as commission. This rate can vary depending on different factors.
  • Commission structure: This could include various tiers or levels of commission rates based on sales targets or categories.
  1. Calculate commission

Multiply the Sales Amount by the Commission Rate to calculate the initial commission amount. This gives you the commission amount based on the base commission rate.

  1. Apply relative commission rules

Depending on the relative commission rules in place, you may need to adjust the commission amount. For example:

Tiered commission: If there are different commission rates for different sales levels (e.g., 5% for sales up to $1,000, 7% for sales between $1,001 and $5,000, and 10% for sales over $5,000), you would need to apply the appropriate rate to each sales range.

Product-based commission: If the commission rate varies based on the type of product or service sold (e.g., 10% for Product A and 15% for Product B), you would apply the relevant rate to each product category's sales.

  1. Calculate the total commission

Sum up the commission amounts calculated in step 3 to get the total commission earned by the salesperson.

Relative commission calculator formula

The formula is the total commission earned and the total compensation for a salesperson based on their projected sales (n2), quota (n1), base salary (n3), commission rate below quota (n4), and commission rate above quota (n5). Here's a breakdown of how this formula works:

n1= Quota
n2=Projected Sales
n3=Base Salary
n4=Commission Below Quota
n5=Commission Above Quota

if(n2 > n1){


TotalCommissionEarned = (n4 * n1)/100 + (n5 * (n2 - n1))/100;
Total Compensation= TotalCommissionEarned + n3



  • Quota (n1): This is the sales target or benchmark the person is supposed to achieve.
  • Projected sales (n2): This is the amount of sales the person is expected to make.
  • Base salary (n3): This is the fixed amount the person earns, regardless of sales made.
  • Commission below quota (n4): If the person achieves sales up to the quota, they earn this percentage as commission on those sales.
  • Commission above quota (n5): If the person achieves sales above the quota, they earn this percentage as commission on the sales above the quota.

The if condition checks if the Projected Sales (n2) is greater than the Quota (n1). If so, then:

They get a commission of n4% on the quota (n1).

For sales above the quota, they earn a commission of n5% on the difference between projected sales and the quota (n2 - n1).

Finally, the Total Compensation is the sum of the Total Commission Earned and the Base Salary (n3).

For example:

Let's say:

The Quota (n1) is $10,000.

The Projected Sales (n2) is $15,000.

The Base Salary (n3) is $2,000.

Commission Below Quota (n4) is 5%.

Commission Above Quota (n5) is 10%.

If we plug these numbers into the formula:

Since $15,000 (n2) is greater than $10,000 (n1):

Commission for achieving quota: (5% of $10,000) = 0.05 * $10,000 = $500

Commission for sales above quota: (10% of $5,000) = 0.10 * $5,000 = $500

Total commission earned = $500 + $500 = $1,000.

Total compensation = $1,000 (Total Commission Earned) + $2,000 (Base Salary) = $3,000.

So, in this example, if someone with a base salary of $2,000 has projected sales of $15,000 against a quota of $10,000, they would earn a total of $3,000 (base + commission).


How is the commission calculated with relative commission calculator?

The commission is calculated in two parts:

  • Commission on sales up to the quota.
  • Commission on sales that exceed the quota.

What happens if my projected sales do not exceed the quota?

If the projected sales do not exceed the quota, then only the "Commission Below Quota" rate is applied to those sales. The "Commission Above Quota" is not applicable.

Why are there two different commission rates?

Having two rates can incentivize salespersons to exceed their quotas. By offering a higher commission rate for sales above the quota, it motivates individuals to push beyond their targets.

Does the calculator take into account base salary?

Yes, the calculator considers the base salary. Once the total commission is calculated, it's added to the base salary to determine the total compensation.

Can I use this relative commission calculator calculator for different sales roles with different quotas and commission structures?

Yes, the relative commission calculator is versatile. As long as you input the correct quota, projected sales, base salary, and commission rates, it can be used for any sales role or structure.

Boost the performance of your sales team with automated commission
Try automated commission to elevate & boost the sales performance of your sales team. Get a demo now!

Quick Links