Average Turnover Rate Calculator: Formula & Guide
- Average employees
- Result
- Employees at start
- 100
- You entered
- Employees at end
- 95
- You entered
This calculator works out the average employee turnover rate for a period you choose. You enter the number of employees at the start, the number at the end, and how many left during that time; you get back the turnover rate as a percentage, plus the average number of employees. The standard formula is: (Separations ÷ Average Number of Employees) × 100.
Formula
Turnover rate (%) = (Separations ÷ Average number of employees) × 100
- Separations – total employees who left during the period (resignations, terminations, retirements, layoffs).
- Average number of employees – (headcount at start + headcount at end) ÷ 2.
This is the most widely used method, often called the “separation rate” or “crude turnover rate.” It treats all departures the same and uses a simple midpoint average, which works well for stable workforces.
Worked Example
Using the defaults: start = 100, end = 95, separations = 10.
- Average employees = (100 + 95) ÷ 2 = 97.5
- Turnover rate = (10 ÷ 97.5) × 100 = 10.256%
- Rounded to one decimal: 10.3%
The calculator shows the same result. This means roughly 10.3% of the average workforce left during the period.
When to Use This Calculator
Use it for monthly, quarterly, or annual HR reporting. It helps you compare turnover across teams, locations, or time periods. It also gives a baseline for budgeting recruitment and training costs. Because it only needs three numbers, it works even with limited data.
For a more detailed picture, you can break turnover down by department, tenure, or reason (voluntary vs. involuntary). Those sub-analyses use the same formula but with a narrower numerator.
How to Read the Result
There is no single “good” turnover rate. It varies by industry, role, and location. For example, retail and hospitality often see annual turnover above 60%, while government and education may be under 15%. Instead of judging a single number, track the trend over time and compare with industry benchmarks if you have reliable sources.
A high rate may indicate engagement or compensation problems, but it can also be normal for seasonal work. A very low rate might signal stagnation or lack of new ideas. Always interpret turnover in context.
Common Mistakes and Misconceptions
- Using ending headcount only – This ignores the average, which can skew the result if the workforce grew or shrank sharply.
- Counting internal transfers – Moves within the company are not separations; exclude them unless you are measuring department-level turnover.
- Including temporary or contract workers – Decide a consistent definition. If you include them one period and exclude them the next, the rate is not comparable.
- Mixing time periods – An annual rate should use 12 months of separations, not a quarter’s worth. For a monthly rate, use only that month’s separations.
- Forgetting that the average is a midpoint – If headcount changes unevenly, a simple average may not reflect the true exposure. A more accurate method uses the sum of headcounts at each day divided by the number of days, but that data is rarely available.
Limits of the Formula
The simple formula treats every departure equally. A resignation after 20 years counts the same as one after 2 weeks. It also ignores whether the position was backfilled, which affects workload and cost. For deeper analysis, you might calculate:
- Voluntary turnover – only resignations, not layoffs or retirements.
- First-year turnover – separations within the first 12 months of hire, divided by total new hires.
- Stability index – employees with 1+ years of service divided by total headcount at the start of the year.
None of these are better universally; they answer different questions. The basic rate is a good starting point, not a complete diagnosis.
How to Choose the Right Turnover Metric
Match the metric to the decision you need to make:
- If you are reporting to executives, use the overall rate.
- If you are evaluating a recruitment source, use first-year turnover for that source.
- If you are assessing manager effectiveness, use voluntary turnover per team.
- If you are planning budget, use total separations (including retirements) because replacement costs apply.
Whatever you choose, document the definition and apply it consistently.
Frequently Asked Questions
What is a normal turnover rate?
It depends heavily on industry and region. The U.S. Bureau of Labor Statistics publishes monthly and annual rates by industry; for example, total private-sector annual turnover often hovers around 40-50%, while government is much lower. Without a benchmark, a single number is hard to judge.
Should I include layoffs in the separation count?
Yes, if you are calculating overall turnover. Layoffs are separations. If you want to show voluntary turnover, exclude them and label the metric clearly.
How do I annualize a monthly turnover rate?
Multiply the monthly rate by 12 for a rough estimate. A more accurate method is to sum the monthly average headcounts and separations over 12 months, then apply the formula once. The simple multiplication assumes the rate is constant, which is rarely true.
What is the difference between turnover and attrition?
Turnover includes all separations, including those that are replaced. Attrition usually refers to positions that are not backfilled, so headcount shrinks. The formula for attrition is the same, but the numerator is limited to separations that are not replaced.
Can I calculate turnover for a single department?
Yes. Use the department’s headcount at the start and end, and the number of people who left that department. Just be careful with transfers: if someone moves from department A to B, they are a separation from A but not from the company.
Why does my result differ from a report I saw?
Different data sources use different definitions. Some count only voluntary resignations, some use ending headcount instead of average, some include interns. Check the methodology behind any published figure before comparing.
Related
Formula used
in start | Employees at start | - | 100 | 0 in end | Employees at end | - | 95 | 0 in sep | Separations during period | - | 10 | 0 out rate | Turnover rate | % | (sep / ((start + end) / 2)) * 100 | 1 out avg | Average employees | - | (start + end) / 2 | 1
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.