Annelisa G.

asked • 08/22/16

I need to find a formula to calculate commission based on % of work and % of commission

monthly sales =100,000k 
there are 3 sales people.
salesperson #1 makes 1.5 % commission from total
salesperson #2 makes 1.5 % commission from total
salesperson #3 males 1% of total
 
HOWEVER I need to make a calculate in the % of hours they worked relative to one another
sales person #1 = 47.4% of the hours
salesperson #2 = 42.1% of the hours
salesperson #3 = 10.5 % percent of the hours
 
help!

1 Expert Answer

By:

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.