New Hire Ramp Calculator

See how long it takes a new hire to reach full output, and what the ramp costs. Enter the salary, the productivity curve, and the support you give them, and the workbook returns the weeks to full speed, the lost output during ramp, and what the whole first year costs.

A working model, not a blank grid

Enter the new hire’s annual salary, the weeks to half-output and to full output, the manager time during ramp, any formal training costs, and a productivity cost rate. The workbook builds the productivity ramp between the two points, then returns the productivity cost per week at partial output, the total lost output during ramp, the management time cost, and the total first-year cost with and without the recruiting cost. A one-page Summary carries the ramp length, the output lost, and the total first-year cost, a Benchmark tab holds ramp length and ramp-cost ranges by role type from SHRM and academic research, and it opens on a worked example so the logic is clear before you change anything.

The cost of a hire does not stop at the salary or the recruiting fee

A new hire who takes six months to reach full output is delivering partial value for half the year while you pay for all of it. Lost output during the learning curve is usually the largest piece: at half output for eight weeks and three-quarters for another eight, a mid-level hire gives up a month of full productivity before they are up to speed, $6,000 or more at a $300 daily loaded cost, before training and manager time land on top. Manager hours spent orienting and reviewing work are priced from the manager’s own salary, so the support carries a dollar figure. Add the recruiting cost and the total first-year cost makes clear why replacing people costs more than keeping them.

Built for

• An HR leader or finance partner who wants the true cost of a departure, including the output lost while the replacement ramps, not just the recruiting fee.
• A manager making the case for better onboarding investment, with the ramp length and its cost before and after the improvement.
• An owner or operator setting realistic expectations for how long a new hire takes to contribute fully.

If you are looking for the full all-in cost of a departure from exit through ramp, the Cost of Turnover Calculator covers that. For a program to shorten the ramp with structured onboarding, see the New Hire Onboarding 30-60-90 Kit.

Before you buy

What format is it, and can I edit it?

It is one Excel workbook that also works in Google Sheets. Every input and formula is editable, and the file is yours to keep; duplicate it to model a second role or test different ramp curves side by side. Checkout delivers an instant download link, with the same link emailed on your receipt.

What is the productivity cost rate?

It is the daily loaded cost of one FTE at full output, the salary plus benefits and payroll taxes divided by working days. It prices each day a new hire spends below full output: at 50% productivity, half the daily cost is lost output. The Employee Cost Calculator or the Labor Burden Rate Calculator will give you this figure for a specific role.

How accurate is the result?

It is a planning estimate, and the ramp curve drives it. How long a new hire takes to reach full output depends on role complexity, the onboarding program, and the individual, so the weeks to half and full output are the inputs to calibrate to your real experience. The math is correct for the inputs; use your own ramp times rather than the example figures.

What is the refund policy?

Digital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms. Questions? Email support@truestephr.com.

How the download works

Your files arrive as a single ZIP download, best opened on a computer: save it, extract it (right-click and Extract All on Windows, double-click on a Mac), and open the Start Here file first. PDFs open in any reader, and the editable files work in Microsoft Word and Excel or their free equivalents, including LibreOffice and Google Docs and Sheets. No other software is needed. Step-by-step help for every device is at truestephr.com/pages/download-help.

Scope

These are planning estimates built from your inputs, not legal advice. The result rests on the ramp curve and the cost rate you enter, so calibrate them to your own experience and sense-check the total against the Benchmark tab.