Skip to content
SheetModel
Real EstateE-commerceConstructionB2B SaaSWorkforceAbout
Workforce 3 Excel tabs included 9 min read Updated Jan 2026

Employee turnover cost & retention ROI calculator

Price the full cost of losing an employee — recruitment, vacancy, ramp-up and manager time — then calculate the ROI of the retention program that prevents it.

Typical cost per hire
30–60% of salary
Hourly role turnover
40–60%
Break-even lift
Often < 5 pts
Advertisement
Advertisement

Turnover is expensive in places that never appear on an invoice

Most managers price turnover as the recruitment fee plus a bit of training. That captures perhaps a fifth of the real cost. The largest component is usually the productivity lost while the seat is empty and while the replacement ramps — paid salary producing partial output, for weeks.

Replacing an employee at an average salary of $68,000 typically costs $22,000–42,000 once recruitment, vacancy output loss, ramp-up productivity loss, onboarding, manager time and formal training are included. At a 28% annual turnover rate across 45 employees, that is roughly $350,000 a year — a number large enough to justify a serious retention program.

Cost per departurelive formula
Cost = Recruitment
     + (Vacancy weeks × weekly revenue per employee × output loss %)
     + (Ramp months × monthly salary × (1 − ramp productivity %))
     + (Onboarding weeks × weekly salary)
     + (Manager hours × manager hourly cost)
     + (Training hours × trainer hourly cost)
     + Separation & offboarding
The workbook builds every line as a formula so you can substitute your own assumptions and see which driver dominates.

Turnover is never uniform — target the department, not the average

A company-wide turnover rate of 28% could be 9% in engineering and 55% in the warehouse. The economics of those two numbers are completely different, and averaging them produces a retention program that over-serves the department that needs it least.

The departmental loss matrix prices turnover by department using a cost multiplier for seniority, then ranks them by annual loss. In most organisations, one or two departments account for 70%+ of the total cost. That concentration is what makes a targeted intervention financially obvious.

Typical turnover cost multipliers by function
FunctionTypical turnoverCost multiplier vs average hire
Warehouse / operations45–60%0.6–0.8×
Customer support35–50%0.7–0.9×
Sales25–40%1.2–1.5×
Skilled trades / engineering10–18%1.5–2.0×
Finance & admin8–15%1.0–1.2×
Advertisement

The retention program business case, in three numbers

Retention spending competes with every other budget line, so it needs a business case rather than an appeal to culture. Three numbers make the case: the cost per departure, the number of departures a program is expected to prevent, and the annual cost of the program.

The break-even calculation is usually the most persuasive figure. If your total turnover cost is $350,000 a year and a program costs $19,000, the program pays for itself with a 5.4% reduction in turnover. That is a low bar — one and a half avoided departures in a 45-person company.

Retention ROI and break-evenlive formula
Savings      = Departures avoided × Cost per departure
ROI          = (Savings − Program cost) ÷ Program cost
Break-even   = Program cost ÷ Total turnover cost
Payback      = Program cost ÷ (Savings ÷ 12) months
Publish the break-even percentage, not the ROI multiple. It is much harder to argue with internally.

Which retention levers actually work

Retention interventions vary enormously in cost-effectiveness, and the cheapest ones are usually the most effective for hourly workforces. Ranked by evidence and by cost, the sequence below is a reasonable order of operations.

  • Pay band correction at the bottom quartile: the single largest lever for hourly roles, and often a one-time cost.
  • Predictable scheduling two or more weeks ahead: materially reduces turnover for workers with caregiving responsibilities, at almost no direct cost.
  • Structured 90-day onboarding: cuts first-year attrition by 20–30% because most turnover happens in the first 90 days.
  • Manager coaching cadence: regular one-to-ones reduce regrettable attrition at low cost.
  • Clear promotion ladder: retains high performers who would otherwise leave at the 18-month mark.
  • Perks (food, gym, events): high visibility, low measured effect on turnover. Fund them after the above.

How to use this tool

  1. Enter salary, headcount and turnover. Use your actual averages. Blended salary across the affected population is more accurate than a single title.
  2. Build the cost per departure. Recruitment, vacancy weeks, ramp months and productivity percentage, manager hours and training hours. The ramp assumption usually drives the result.
  3. Rank departments by loss. The workbook applies per-department turnover and a cost multiplier, then ranks by annual loss so you can target the biggest exposure first.
  4. Download and test the retention case. Enter a program cost and an expected turnover reduction to get ROI, payback in months and the break-even retention lift that makes the program self-funding.

What is inside the download

A cost-per-departure build across seven drivers, a departmental loss matrix that shows where turnover actually costs the most, and a retention program ROI sheet with a break-even retention lift calculation.

  • Turnover Cost Drivers — a separate worksheet in turnover-cost-model.xlsx.
  • Department Loss Matrix — a separate worksheet in turnover-cost-model.xlsx.
  • Retention Program Savings — a separate worksheet in turnover-cost-model.xlsx.

Where these defaults come from

Every pre-filled value in the calculator above is listed below with its basis. None of it is proprietary to us — we do not run primary research. Statutory figures come from the regulator, fee schedules from the vendor that charges them, ranges from published industry surveys, and conventions are labelled as rules of thumb. When you have your own numbers, replace the default: the workbook formulas do not care where an input came from.

DefaultValue usedBasisSource
Cost per departureHigher for specialised roles with long ramp times; the ramp-up productivity loss is usually the largest component.30–60% of annual salaryMarket surveyUS Bureau of Labor StatisticsJob Openings and Labor Turnover Survey (JOLTS)Cited by name · link pending verification
Hourly role turnoverStructural in many service industries and not automatically a problem — compare the cost of turnover against the cost of reducing it.40–60% annuallyMarket surveyUS Bureau of Labor StatisticsJob Openings and Labor Turnover Survey (JOLTS)Cited by name · link pending verification

Full source registry, verification status and review cadence: data sources & methodology.

Frequently asked questions

Add seven components per departure: recruitment cost, vacancy output loss, ramp-up productivity loss, onboarding time, manager time, formal training and separation costs. For an average $68,000 salary, the total commonly lands between 30% and 60% of annual salary — and higher for specialised roles with long ramp times.

Software that pairs with this model

These are the platforms our models are designed to work alongside, chosen because their pricing or data appears in the model itself. Some links are affiliate links — they cost you nothing, and they never influence a formula, a default value or a result.

Related models