Calculator Inputs
Example Data Table
Sample scenarios to illustrate how inputs shape outputs. Use your own data for decisions.
| Scenario | Headcount | Attrition | Avg salary | Vacancy days | Cost per exit | Annual cost |
|---|---|---|---|---|---|---|
| Customer Support (high churn) | 120 | 28% | $34,000 | 25 | $15,800 | $531,000 |
| Sales (mixed ramp impact) | 60 | 18% | $68,000 | 45 | $38,600 | $417,000 |
| Engineering (high continuity risk) | 40 | 12% | $120,000 | 55 | $98,400 | $472,000 |
Numbers shown are illustrative, rounded, and not computed from your entries.
Formula Used
This calculator combines five cost drivers into a per-exit estimate, then multiplies by expected exits.
Daily Cost = Loaded Salary ÷ Workdays per Year
Vacancy Cost = Daily Cost × Vacancy Days × Vacancy Loss%
Ramp-up Loss = Daily Cost × Ramp Days × Ramp Loss%
Replacement Cost (Percent) = Loaded Salary × Replacement%
Replacement Cost (Itemized) = Recruiting + Onboarding + (Manager Hours × Manager Hourly Cost)
Knowledge Loss = Loaded Salary × Knowledge Loss%
Separation & Admin = Severance + HR/Admin Cost
Cost per Exit = Vacancy + Ramp + Replacement + Knowledge + Separation
Annual Cost = (Headcount × Attrition Rate%) × Cost per Exit
Avoidable Cost = Annual Baseline Cost − Annual Target Cost
- Use itemized replacement costs when you can source real recruiting and onboarding figures.
- Use percent-of-salary when benchmarking across roles or teams.
- NPV applies a discount rate to future net benefits for planning.
How to Use This Calculator
- Enter headcount and a baseline attrition rate from your HRIS.
- Add average salary and benefits load for fully loaded costs.
- Estimate vacancy days and productivity loss with your hiring team.
- Choose a replacement cost model: percent or itemized line items.
- Set a target attrition rate and retention budget for comparison.
- Click Calculate to view breakdown, annual impact, and projections.
- Export CSV for spreadsheets or PDF for stakeholders.
Direct cost drivers per exit
The calculator builds a loaded salary by adding benefits and payroll load, which often ranges from 18% to 30% in many plans. Vacancy and ramp losses then convert time into money using workdays per year. Knowledge and continuity loss is modeled as 5% to 15% of loaded salary when departures affect customers, systems, or handoffs. Separation costs, including HR administration and severance, typically add a fixed amount per exit.
Vacancy time sensitivity
Vacancy cost is calculated as Daily Loaded Cost × Vacancy Days × Vacancy Loss%. For example, a loaded salary of 65,000 with 260 workdays produces 250 per day. At 40 vacancy days and 70% loss, the vacancy component is about 7,000 per exit. Reducing vacancy by 10 days lowers this component by roughly 1,750 per exit. This makes time-to-fill improvements measurable.
Ramp-up productivity gap
Ramp-up loss estimates the performance gap while new hires reach expected output. Many teams plan 30 to 90 ramp days, with 20% to 50% average productivity loss depending on role complexity. Using the same 250 daily loaded cost, 60 ramp days at 35% loss produces about 5,250 per hire. If enablement reduces ramp loss from 35% to 25%, the savings is 1,500 per exit, supporting investments in onboarding design and coaching.
Replacement model selection
Percent-of-salary replacement cost is useful for benchmarking and cross-team comparisons, often modeled between 25% and 50% of loaded salary depending on role. Itemized costing supports operational planning by combining recruiting spend, onboarding costs, and manager hours. If manager time is 18 hours at 55 per hour, that line alone adds 990 per exit. Keeping both models in one tool helps HR and finance align on assumptions before decisions.
Budget planning and ROI interpretation
Annual avoidable cost equals baseline exits minus target exits, multiplied by cost per exit. A retention budget can then be tested against savings: Net Benefit = Avoidable Cost − Budget. ROI is expressed as Net Benefit divided by Budget. For multi-year plans, salary growth scales salary-linked costs, while discounting converts future benefits into present value. When NPV net benefit is positive, the retention program is financially justified under the stated assumptions today.
FAQs
1) What counts as “avoidable cost” in this calculator?
Avoidable cost is the difference between baseline and target annual attrition cost, using the same per-exit cost model. It represents savings if the target attrition rate is achieved.
2) Should I use percent-of-salary or itemized replacement costs?
Use percent-of-salary for quick benchmarking across teams. Use itemized costing when you know recruiting spend, onboarding costs, and manager time, and you need a defensible operating plan.
3) How do I estimate vacancy productivity loss?
Start with coverage reality: what percentage of work is delayed, dropped, or redistributed. Roles with tight SLAs or single-thread ownership often have higher vacancy loss than roles with deep redundancy.
4) What does knowledge or continuity loss represent?
It approximates disruption from handoffs, customer context loss, reduced quality, and rework. Set it higher for specialized roles, long project cycles, or high coordination costs.
5) Why does the projection include salary growth and a discount rate?
Salary growth scales salary-linked components over time for realistic forward planning. Discounting translates future net benefits into today’s value so multi-year programs can be compared consistently.
6) Can I use this for one department instead of the whole company?
Yes. Enter department headcount, a department-specific attrition rate, and salary averages. Adjust vacancy and ramp assumptions to match hiring velocity and role complexity for that group.