{"product_id":"cost-of-turnover-calculator","title":"Cost of Turnover Calculator","description":"\u003cp\u003eBuild the real cost of losing one employee from the ground up. Enter the salaries of the people involved and your time and cost assumptions, and the workbook prices the exit, the open vacancy, recruiting a replacement, and the ramp to full speed, then returns the total per departure, the cost as a percent of salary, and the annual cost at your turnover volume.\u003c\/p\u003e\u003ch3\u003eOne Excel workbook that prices a departure from the ground up\u003c\/h3\u003e\u003cp\u003eA working model, not a blank grid. You enter the salaries and your time assumptions, the workbook builds the cost across four stages, and it opens on a worked example so the logic is clear before you change anything.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eCost of Turnover Calculator.\u003c\/strong\u003e Enter the salaries of the role that left, the manager, a coworker, and HR, set your working days, then work down four stages: separation, the open vacancy, recruiting, and onboarding. The workbook prices each person’s time from their pay, adds the output lost while the role is open and while a new hire ramps, and returns the total per departure, the share from each stage, the percent of salary, and the annual cost at your turnover volume. It opens on a worked example so the logic is clear before you change the inputs.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eA board-ready summary, sourced benchmarks, and the math in plain English.\u003c\/strong\u003e A one-page Summary pulls the four stage subtotals and the total into a snapshot for a budget conversation. A Benchmark tab holds turnover-cost ranges by role type from Gallup, SHRM, and public research to sanity-check your result, and the Notes tab documents how each number is built.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eThree steps from a departure to its real cost\u003c\/h3\u003e\u003cp\u003eYou set the pay basis, enter your time and cost assumptions across four stages, and the workbook returns the cost per departure and the annual figure.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSet the pay basis.\u003c\/strong\u003e Enter the annual salary of the role that left, plus the manager, coworker, and HR salaries and your working days, so every hour of time below is priced from real pay.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWork the four stages.\u003c\/strong\u003e Fill the amber cells for separation, the open vacancy, recruiting, and onboarding: the hours each person spends, the days the seat stays open, the recruiting costs, and the ramp time. Everything else calculates.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead the total and the percent.\u003c\/strong\u003e The workbook shows the cost per departure, the share from each stage, the cost as a percent of salary, and the annual cost at your turnover volume, so the number is built up rather than guessed.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eThe cost is mostly lost output, not invoices\u003c\/h3\u003e\u003cp\u003eThe cash you write a check for, job ads and an agency fee, is the small part. The larger cost is the output lost while the seat is empty and while a new hire climbs to full speed, which is why this workbook prices time, not just spend.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eTime is priced, not assumed.\u003c\/strong\u003e Each person’s hours are valued from their own salary spread over working days and an eight-hour day, so the separation, recruiting, and onboarding time carries a real dollar figure.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe two biggest pieces are the ones people skip.\u003c\/strong\u003e Coverage loss while the role is open and lost output while a new hire ramps are usually the largest costs, so the coverage and ramp percentages are the assumptions that move the result most.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOne departure scales to a year.\u003c\/strong\u003e The workbook multiplies the per-departure cost by the exits you expect for the role, so a high-turnover seat shows its full annual cost instead of a single instance.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWho this calculator fits and where to go if that is not you\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eBuilt for\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAn HR or finance partner who needs the real cost of a departure to weigh against the cost of retaining people.\u003c\/li\u003e\n\u003cli\u003eA manager building the case for a counteroffer, a retention program, or a faster backfill, with a number instead of a guess.\u003c\/li\u003e\n\u003cli\u003eAn HR leader who wants a board-ready figure for what turnover in a given role costs per exit and per year.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eIf you are looking for\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eThe yearly cost of seats sitting open from your turnover and time to fill, not the cost of one departure. The Vacancy Cost Calculator prices the drag of open roles across the year.\u003c\/li\u003e\n\u003cli\u003eThe all-in cost of filling a role, recruiting spend and hours on their own, not the full turnover cost. The Cost Per Hire Calculator builds the cost-per-hire figure on the ANSI\/SHRM formula.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eBefore you buy\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eWhat format is it and can I edit it?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt 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 cost a second role, since one average hides where the cost concentrates.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThere is a free version of this calculator. Why pay for this one?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThe free tool gives a quick browser estimate from a few inputs and resets when you close the tab. This workbook is the model you keep: it builds the cost from the ground up across four stages, prices each person’s time from their own salary, separates the output lost while the role is open from the output lost while a new hire ramps, and rolls it into a board-ready summary, a percent of salary, and an annual figure at your turnover volume. Sourced benchmarks let you sanity-check the result. You set your assumptions once, duplicate the file per role, and read every formula instead of trusting a single number.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow accurate is the result?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt is only as good as the salaries and the time assumptions you enter, so treat the output as a planning estimate. The figures are most sensitive to the coverage and ramp percentages, the share of output lost while the role is open and while a new hire is still learning, so set those to your situation. The math is correct for the inputs; use your own numbers rather than the example figures.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat does the cost include?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eFour stages, each with its own subtotal. Separation is the time to process the exit, accrued PTO, and any severance. Vacancy is the output lost while the seat is empty. Recruiting is job ads, any agency fee, and the hours HR and the manager spend. Onboarding is training, equipment, and the output lost while the new hire ramps to full speed. You can see which stage carries the most cost.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat is the refund policy?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eDigital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat happens after I buy?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eCheckout delivers an instant download link, and a receipt with the same link arrives by email. Open the workbook in Excel or Google Sheets, enter your salaries and time assumptions, and read the total. If a file gives you trouble, email support@truestephr.com.\u003c\/p\u003e\u003cp\u003ePlanning estimates and general business information, not legal or tax advice. The result is sensitive to the time-lost assumptions, so treat the coverage and ramp figures as your best estimate and adjust them to your situation. Last reviewed June 2026.\u003c\/p\u003e","brand":"TrueStep HR","offers":[{"title":"Default Title","offer_id":52641502298388,"sku":"TSHR-003","price":29.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1013\/9048\/3732\/files\/TSHR-003__cost-of-turnover-calculator-hero.jpg?v=1780978978","url":"https:\/\/shop.truestephr.com\/products\/cost-of-turnover-calculator","provider":"TrueStep HR","version":"1.0","type":"link"}