Commission formula

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top