What does hiring now cost you next January?
Put in the assumptions for each hiring plan and get back what each costs this year and commits you to next. Three hiring plans, saved side by side. This year the fast plan costs $1.48M; the number nobody puts on the slide is the $5.22M it commits you to in January.
SaaS Starter Scenarios free
After you install, this is the model to open.
What Three Hiring Plans Cost
- In your spreadsheet, click the Sortia icon in the strip of icons down the right-hand edge. No strip? Click the arrow at the bottom-right to open it. You can also use Extensions, then Sortia, then Open Sortia.
- Click Start from a template and put that name in the search box.
- Pick the card with that name and click Load this template. It arrives on a new tab with real numbers already in it.
The answer
- The fast plan this year
- $1.48M 15 hires from April, on top of committed payroll
- What January inherits
- $5.22M run-rate cost entering next year, against $4.33M planned
- Operating result
- -$380K fast, against +$434K planned and +$903K slow
Three hiring plans, one company, and a distinction that costs startups their runway: what a cohort costs this year is not what it costs. The cost of this year's hires is the fully loaded cost multiplied by the fraction of the year each person is actually there, which is why an average start month of 6 halves the bill. Save the Planned case, then copy the Slow column over the three assumptions and save that, then Fast.
Planned hires 9 people at an average start of June, costs $666,000 this year, and the company still ends the year $434,000 ahead on $4.1M of revenue. Fast hires 15 people starting in April, costs $1,480,000, and turns that into a $380,000 loss. Slow hires 4 starting in August, costs $197,333, and finishes $902,667 ahead. So far, so ordinary.
Now read the run-rate result, which is the third one the summary compares and the reason to save these as scenarios rather than argue about them. Entering next January, Planned is running at $4,332,000 a year, Slow at $3,592,000 and Fast at $5,220,000. The fast plan appears in this year's budget as $1.48M and appears in next year's as $2.22M, every year, until something changes.
Against $4.1M of revenue the fast plan needs revenue to grow 27 percent just to stand still, and the difference between the plans next year is $1,628,000, which is roughly three quarters of runway on a typical burn. Save a fourth case called Fast, later starts, with 15 hires and an average start month of 8: this year turns from a $380,000 loss into a $360,000 profit and January is completely unchanged at $5,220,000.
That is the trap stated as plainly as a sheet can state it, because the year that looks fixed is the year you were not worried about. The model assumes every hire costs the same and none of them leave, and it says nothing at all about what the 15 people would have produced, which is the actual argument. Put your own committed payroll, revenue and loaded cost in, and if your cohorts differ a lot, split the three assumptions into one block per role.
The model
It arrives on a tab called Template: Three Hiring Plans, carrying these columns:
- This plan
- Planned
- Slow
- Fast
with the model computed beside the data:
| Cost of this year's hires ($) | 666,000 |
| Total operating cost this year ($) | 3,666,000 |
| Operating result this year ($) | 434,000 |
| Headcount at the end of the year | 33 |
| Run-rate cost entering next January ($) | 4,332,000 |
| Revenue needed next year to break even ($) | 4,332,000 |
Once it is in your sheet
- The model arrives with real numbers in it and runs as it stands, so you can press the button first and understand it second.
- Change the numbers to yours. The sheet marks which cells are inputs and which hold formulas, and most labels carry a note explaining the row.
- Press the run button at the bottom of the panel. It is labeled for the tool you are in, and the result lands on its own tab, with a written reading of it beside the figures.
Never used Google Sheets? Start here goes the whole way, in seven steps, and assumes nothing.
Next question
- Your traffic is fixed. What lift can it even see?What Lift Could We Even Detect?
- Do the service credits or the churn cost you more?What Would an Outage Cost Us?
- Commit to the servers or rent them by the hour?Which Instance Mix Holds the Load for the Least Money?
- Is the migration in trouble, or just early?Buffer the Migration, Not the Tasks
- Is it cheaper to staff the night or to buy it in?Cover the Support Hours for the Least Money
- How late will the release really be?Can We Ship on That Date?
Every model like this one, and the method behind them: What-if analysis in Google Sheets.