Recognizing revenue for ROI against sales rep cost

Hi,

I am looking at how I am understanding my ROI on a sales rep. I think I know the answer but am looking for some confirmation.

Here is the scenario -- 

I have two sales reps... they are each getting 10% on a sale of $100,000 job after certain job related costs. Let's assume the job costs are $25,000.  That would mean the Gross profit after job related costs is $75,000 and they each would get 10% or $7,500 as commission on the job.  So if I deduct the $15,000 in total commission plus the $25,000 job related costs from the $100K the Net profit on the job is $100K minus 40K or $60K, so 60% ROI on the job. 

Now, let's assume that each rep is also paid a salary of $10,000 and for the sake of simplicity, let's assume that that is there entire salary for the year, and this one job is the entire revenue for the year.

So my question is - seeing that the return on the job is $60K and now I am having to pay an additional $20,000 in labor costs, my actual return on the business is $40K or 40%.

When I look at each individual REP, what is there ROI?
So if a REP is costing $10K salary and the job itself, after total commissions and job costs  was $60K, then did I make $50K on the rep or did I make $40K on the rep because I had to pay the other rep their salary of $10K? Now, I know the the business only made $40K or 40% net profit, but how do I spell out what is the return on the worker/rep?
 

The issue becomes more complicated because let's take the fact that they each sell a second job - separately -

so they each sell another $100K job with $25,000 in jobs costs BUT, they do NOT each get commission on these jobs. 

So now they each get $7,500 in commission on their separate jobs, and these jobs would produce a greater return (total cost $32,500 from $100K) of $67,500 or 67.5%... 

So now - let's assume that they were not paid any additional base salary...


So total costs for the rep are $10K base, plus $7500 x 2 for commission or total of $25K cost for the year...

But since the first job they split commission, do I split the attribution of revenue from the first job to each of them?

I am looking at right now like this and I think it is a mistake...

Job one revenue minus all costs (including both commissions) = $60K

Job two revenue minus all costs (only one commission) = $67,500

Total Gross profit on the two jobs equals $127,500.

Total cost of each rep $10K.

Return on REP = $127,500/10K or 12,750%..

Or again - should I NOT attribute 100% revenue that they each get commission on - should I attribute 50% of the revenue that they are splitting to what they should get credit for? Does it matter?


Obviously the business made:

$300K gross revenue, minus $75K in job costs, minus 30K in commission = $195,000 minus $20,000 in salaries or $175,000 on $300K gross revenue... or 58% return to the business.... but again what is my return on each rep?

 

Saepe alias at aspernatur sint. Illum minus provident in consequatur modi atque fugiat.

Dignissimos maxime excepturi aut. Fuga id dolores ad. Expedita odio aliquid ipsam iure. Vel recusandae pariatur necessitatibus et quis. Optio beatae ipsam veritatis tenetur sed.

Vitae sint natus est nemo. Earum est suscipit ut vitae. Ex inventore beatae molestiae beatae et.

Et architecto sit consequatur eligendi sed assumenda magnam. Libero recusandae labore soluta enim ipsam ut. Ut neque maiores in. Atque non in at non tempore.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
GameTheory's picture
GameTheory
98.9
7
dosk17's picture
dosk17
98.9
8
kanon's picture
kanon
98.9
9
bolo up's picture
bolo up
98.8
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”