Progressive Commission


Criteria NameAmount FromAmount ToPercentage
Criteria one0200002%
Criteria two20001400004%
Criteria three40001600005%
Criteria four >=6000110%

Scenario 1:

Assume if the total amount is 30000. Then the progressive commission is calculated as following.

So the amount is 30000 and it lies under criteria name Criteria two.First the commission is calculated for Criteria one then commission is calculated for Criteria two. The criterias in which amount is greater than ‘Amount To’ then commission is calculated on the amount ‘Amount To – Amount From’ field and the criteria in which the amount lies, in that case commission is calculated on total amount. Total commission is the sum of all commissions calculated in upper criterias.

For Criteria one : 2% of 20000 = 400

For Criteria two : 4% of Total amount (30000) = 1200

Total Commission : 400 + 1200 = 1600

Scenario 2:

Assume if the total amount is 70000. Then the progressive commission is calculated as following.

So the amount is 70000 and it lies under Criteria four. So First the commission is calculated for Criteria one then calculated for Criteria two.then commission is calculated for Criteria three and then calculated for Criteria four. The criterias in which amount is greater than ‘Amount To’ then commission is calculated on the amount ‘Amount To – Amount From’ field and the criteria in which the amount lies, in that case commission is calculated on total amount. Total commission is the sum of all commissions calculated in upper criterias.

For Criteria one : 2% of (20000-0) = 400

For Criteria two : 4% of(40000-20001) = 799.96

For Criteria three : 5% of (60000-40001) = 999.95

For Criteria four : 10% of 70000 = 7000

Total Commission : 400 + 799.96 + 999.95 +7000 = 9199.91