J
jaywerth
Trying to build a formula for a tiered commission plan so that the sales
person can calculate commissions based on the number of accounts and
dollar volume of each account on a monthly/yearly basis.
The commission structure:
7.5% of the first 0-$5,000 of sales each month
12.5% of the next $5,000-10,000 each month
15% of $10,001 +
The salesperson should see the commission earned at each tier after
inserting the variable numbers.
I know this is pretty basic, but I need the help. Thanks.
person can calculate commissions based on the number of accounts and
dollar volume of each account on a monthly/yearly basis.
The commission structure:
7.5% of the first 0-$5,000 of sales each month
12.5% of the next $5,000-10,000 each month
15% of $10,001 +
The salesperson should see the commission earned at each tier after
inserting the variable numbers.
I know this is pretty basic, but I need the help. Thanks.