Analytics pack

Turnover and Absence Cost Pack

Put a number on people leaving and people away. The all-in cost of a departure, absence with the coverage ripple, the cost of open roles, and what better retention is worth.

$59USD

One-time purchase, no subscription. Instant download.

Built by expert HR practitioners and leaders

  • Cost of turnover calculator that totals one departure across separation, vacancy, recruiting, and ramp
  • Absence cost model with direct cost and a coverage ripple, by department
  • Vacancy cost calculator for what open roles cost over a year
  • Retention savings model that prices cutting turnover to a target rate
  • Benchmarks tab with public ranges by role and sector, sources noted
  • One-page summary with every figure pulled live from the four tools

The pack puts a number on the problem. It does not make the decision and does not replace finance review.

One-time purchase Instant download Editable files 14-day guarantee

Planning estimates and general business information, not legal or tax advice. The costs rest on the assumptions you set, so calibrate them to your own data.

Not the right fit? Take the 60-second match.

Last reviewed June 2026

One-time purchaseNo subscription
Instant downloadFiles you keep
Editable filesExcel, Word, PDF
14-day guaranteeMoney back
Secure checkoutSSL encrypted
What you get

Four cost tools in one workbook

Eight tabs in one Excel file. A Start Here page sets the order to work in, four tools put a number on turnover and absence, a benchmarks tab keeps the inputs honest, a one-page summary pulls the headlines together, and a Notes tab holds the assumptions you chose and why.

XLSXWorksheet

Cost of Turnover Calculator

Set the pay basis once, then fill each stage: separation, the vacancy while the role is open, recruiting the replacement, and onboarding and ramp. The all-in cost of one departure builds up, with subtotals and a percent of annual salary.

XLSXWorksheet

Absence Cost

Set the benefits load and a coverage multiplier, then list each department's headcount, pay, and absence days. Direct cost and the fully loaded cost with the coverage ripple calculate, plus what trimming a day or two per employee would save.

XLSXWorksheet

Vacancy Cost Calculator

Enter headcount, the turnover rate, time to fill, and pay. The yearly cost of open roles, the cost per vacancy, and the roles open at any one time calculate.

XLSXWorksheet

Retention Savings

Set a target turnover rate below your current one. Cost per departure, departures avoided, and the annual saving calculate, with the worth of each point of turnover.

XLSXWorksheet

Benchmarks

Public ranges to sense-check each result: cost of turnover by role, turnover by sector, time to fill and vacancy cost, and absence, with the source noted per section.

XLSXWorksheet

Summary

What turnover and absence cost you, on one page. Cost per departure, total absence cost, vacancy cost, and retention savings, every figure pulled live from the four tools.

How it works

From hidden costs to a number you can act on

Each tool puts a number on one piece of the people cost, and every result flows to the summary, so the picture stays current as you work.

STEP 01

Cost out one departure

Set the pay basis, then fill the four stages. The all-in cost of replacing one person builds up, separation through ramp.

STEP 02

Price absence and its ripple

List each department's headcount and absence days. Direct cost plus the coverage ripple gives the fully loaded cost, and the saving from trimming a day or two.

STEP 03

Total the open roles

Enter your turnover rate and time to fill. The yearly vacancy cost and the roles open at once make the standing cost visible.

STEP 04

Size the retention payoff

Set a target turnover rate and read the annual saving, plus what each point of turnover is worth, before you fund a retention move.

The standard

Cost numbers that hold up in a budget conversation

A people-cost number is only as strong as the assumptions under it, so the pack keeps every assumption on the surface and sources its benchmark ranges.

Turnover and absence are real money, and the cost is usually hidden across a dozen line items. This pack puts it in one place.
Assumptions on the surface. Pay basis, the benefits load, the coverage multiplier, and your turnover and target rates are visible, editable cells.
Benchmarks from public sources. Cost-of-turnover ranges from Gallup and SHRM, turnover by sector from Mercer, vacancy cost from SHRM, absence from CDC and BLS, with the source next to each range.
A worked example in every tool. The file opens on realistic roles and departments, not a blank sheet you have to decode.
Honest about the ripple. The coverage multiplier is a visible input you set, not a hidden factor, and the file says plainly it is an estimate of lost coverage.
Is this for you

Who it's built for

Who this pack fits, and where to go if that's not you.

Built for

  • An operator or finance partner who needs turnover and absence as a number, not a complaint.
  • An HR team of one building the business case for a retention or attendance program.
  • A consultant or fractional HR lead quantifying the cost of churn for a client.

If you are looking for

  • A staffing plan, not the price of churn. The Workforce Planning Pack covers FTE and headcount, shift coverage, overtime versus hiring, and labor burden.
  • The savings from a reduction, not retention. The RIF and Restructuring Savings Planner handles severance, the full one-time cost, and the payback period.
Questions

Before you buy

What format is it and can I edit it?
One Excel workbook, eight tabs. It works in Excel or Google Sheets, every cell is editable, and the file is yours to keep.
Is this legal or tax advice?
No. It is cost math with estimates and general business information. Pay, benefits, and turnover vary by company and location, so calibrate the assumptions to your own data before decisions that depend on them.
How is this different from a free turnover calculator?
Free calculators usually price one departure and stop. This pack connects four costs: an all-in cost of turnover across separation, vacancy, recruiting, and ramp; absence with a coverage ripple; the standing cost of open roles; and the saving from cutting turnover to a target. Sourced benchmarks and a one-page summary hold it together.
Where do the cost figures come from?
From your inputs. You set the pay basis, the benefits load, the coverage multiplier, and your turnover and time-to-fill numbers, and each tool calculates from those. Each tool opens with its own worked example, so the example figures differ from tab to tab; the Summary reflects your own numbers once you fill them in. The Benchmarks tab shows public ranges next to each result so you can see where your figure lands.
Is it a subscription?
No. One-time purchase, instant download, no recurring fee. You keep the file.
Will it stay current as rates change?
The workbook carries a last-reviewed date, the benchmark ranges show their sources next to the figures they support, and meaningful updates are released as the numbers change.
What is the refund policy?
Digital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms.
What happens after I buy?
Checkout delivers an instant download link, and a receipt with the same link arrives by email. Open the Start Here tab first; it tells you the order to work in. If the file gives you trouble, email support@truestephr.com.
Can I expense this purchase to my business?

Most customers buy TrueStep HR tools for business use, and a tool you use for work often qualifies as a deductible business expense. Whether it does for you depends on your situation, so confirm with your accountant or tax professional. Your receipt arrives by email at checkout and works as documentation.

Free guide

The 6 red flags to check before you discipline or fire someone

A five-minute screen that catches the most common and most expensive people-decision mistakes before they happen. Free PDF, sent to your inbox. Unsubscribe anytime.

Get the pack

Put a number on turnover and absence, once

The all-in cost of a departure, absence with the ripple, the cost of open roles, and what retention saves, with every assumption on the surface.

$59
One-time purchase, no subscription

Planning estimates and general information, not legal or tax advice. Last reviewed June 2026.