bsutherland
New Member
- Joined
- Oct 23, 2019
- Messages
- 2
Trying to setup a spreadsheet to do this but here's the grid below. Bonuses are ONLY given on the amount between the threshold.
For instance, if you do 500K of commission and fee's, you get a bonus on tier 1 on 99,999 of production, then you also get a bonus on the 299,999 of production.
You get 999.99 on tier 1 + 5,999.98 on tier 2 comming to a sum of 6999.97.
A bonus of 1% of Gross Commissions and Fees between $100,000 and $199,999.*
A bonus of 2% of Gross Commissions and Fees between $200,000 and $499,999.*
A bonus of 3% of Gross Commissions and Fees between $500,000 and $749,999.*
A bonus of 4% of Gross Commissions and Fees between $750,000 and $999,999.*
A bonus of 5% of Gross Commissions and Fees between $1,000,000 and $1,999,999.*
A bonus of 6% of Gross Commissions and Fees between $2,000,000 and $2,999,999.*
A bonus of 7% of Gross Commissions and Fees between $3,000,000 and $3,999,999.*
A bonus of 8% of Gross Commissions and Fees in excess of $4,000,000.*
If someone could build this out or help me with the formula's that would be great.
For instance, if you do 500K of commission and fee's, you get a bonus on tier 1 on 99,999 of production, then you also get a bonus on the 299,999 of production.
You get 999.99 on tier 1 + 5,999.98 on tier 2 comming to a sum of 6999.97.
A bonus of 1% of Gross Commissions and Fees between $100,000 and $199,999.*
A bonus of 2% of Gross Commissions and Fees between $200,000 and $499,999.*
A bonus of 3% of Gross Commissions and Fees between $500,000 and $749,999.*
A bonus of 4% of Gross Commissions and Fees between $750,000 and $999,999.*
A bonus of 5% of Gross Commissions and Fees between $1,000,000 and $1,999,999.*
A bonus of 6% of Gross Commissions and Fees between $2,000,000 and $2,999,999.*
A bonus of 7% of Gross Commissions and Fees between $3,000,000 and $3,999,999.*
A bonus of 8% of Gross Commissions and Fees in excess of $4,000,000.*
If someone could build this out or help me with the formula's that would be great.