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?

Comments (1)

Start Discussion

Popular Content See all

HELP: Sticky Situation with Boss
+155OFFby 2nd Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 2 in IB-M&A
Arranged Marriage
+40OFFby Intern in Real Estate - Commercial">Intern in RE - Comm
Ask a girl
+36OFFby 1st Year Analyst in Investment Banking - Generalist">Analyst 1 in IB - Gen
tipping point - mental breakdown
+33IBby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
To Snitch or not to Snitch?
+32OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind
Would you date a girl without a college degree?
+31OFFby Intern in Consulting">Intern in Consulting
Caught relaxed vibing to music by my MD
+17OFFby 1st Year Analyst in Investment Banking - Corporate Banking">Analyst 1 in IB - CB

Total Avg Compensation

March 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (31) $349
  • Associates (168) $231
  • 2nd Year Analyst (98) $151
  • Intern/Summer Associate (93) $145
  • 3rd+ Year Analyst (23) $145
  • 1st Year Analyst (371) $131
  • Intern/Summer Analyst (308) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Jamoldo's picture
Jamoldo
98.4
3
Secyh62's picture
Secyh62
98.3
4
CompBanker's picture
CompBanker
97.8
5
redever's picture
redever
97.7
6
Addinator's picture
Addinator
97.6
7
frgna's picture
frgna
97.6
8
bolo up's picture
bolo up
97.5
9
Edifice's picture
Edifice
97.5
10
NuckFuts's picture
NuckFuts
97.5