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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Hi,

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

HTH
 
Upvote 0

Forum statistics

Threads
1,214,405
Messages
6,119,323
Members
448,887
Latest member
AirOliver

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