Help with Tricky Salesperson Revenue Forecast Model

bryantjet

New Member
Joined
Jun 18, 2015
Messages
1
Good evening,

I am currently working on building out a revenue model that takes into account new salespeople being hired, along with their quotas, productivity ramp up (time it takes for them to achieve increasing percentages of their quota), and how this all feeds into increased monthly recurring revenue.

My question for you all: how might I go building into the model that every $90K (or some summed revenue criteria) increase in total revenue triggers the hiring of a new salesperson?

I'm new to forums and it's been a long day so this probably isn't the best explanation, but any help is greatly appreciated.


Thank you!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Hi,

You could test : =INT(total revenue / $90K)

HTH
 
Upvote 0

Forum statistics

Threads
1,214,523
Messages
6,120,034
Members
448,940
Latest member
mdusw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top