Turnover Rate by Department: How to Calculate

To calculate turnover rate by department, divide the number of separations in that department during a period by the average number of employees in that department during the same period, then multiply by 100. You enter the department’s headcount at the start and end of the period plus the number of leavers, and the calculator returns the annualized turnover percentage.

Formula

The standard formula for departmental turnover rate is:

Turnover Rate (%) = (Number of Separations ÷ Average Number of Employees) × 100

Where:

• Number of Separations = total employees who left the department during the period (voluntary resignations, retirements, terminations, layoffs)
• Average Number of Employees = (headcount at start of period + headcount at end of period) ÷ 2

The result is expressed as a percentage. For example, a rate of 20% means that, on average, one out of every five employees in that department left during the period. If the period is shorter than a year, you can annualize the rate by multiplying by (12 ÷ number of months) to compare departments on an equal footing.

Worked Example

Using the default values from the calculator: a department has 50 employees at the start of the year, 45 at the end, and 5 separations during the 12-month period.

1. Calculate average headcount: (50 + 45) ÷ 2 = 47.5
2. Divide separations by average headcount: 5 ÷ 47.5 = 0.1053
3. Multiply by 100: 0.1053 × 100 = 10.5%

The turnover rate for the year is 10.5%. Since the period is already 12 months, the annualized rate is the same. If the period had been 6 months with the same numbers, the annualized rate would be 10.5% × (12 ÷ 6) = 21.0%.

Why Department-Level Turnover Matters

Company-wide turnover hides wide variation between teams. A firm with an overall rate of 15% might have a stable finance team at 3% and a stressed customer service team at 40%. Calculating by department helps you:

• Identify which teams have retention problems early
• Target exit interviews and engagement surveys to specific groups
• Compare departments against industry benchmarks (which vary widely by role and sector)
• Evaluate the impact of a new manager or policy on a specific team
• Plan recruitment and training budgets more accurately

Department-level rates are also more actionable than a single company number. If you know that the sales team turns over at 35% while the rest of the company is at 10%, you can investigate compensation, workload, or management practices in that specific team.

How to Choose the Right Formula

There are several ways to measure turnover, and the “right” one depends on what you want to know:

• Simple turnover rate (used above) – best for a quick, standard metric. It counts all separations, regardless of reason.
• Voluntary turnover rate – exclude layoffs, retirements, and terminations for cause. Use this when you want to measure employee choice to leave.
• Involuntary turnover rate – count only layoffs and terminations. Useful for tracking workforce reductions.
• First-year turnover rate – count separations of employees with less than one year of service. This highlights recruitment and onboarding issues.
• Annualized rate – convert a partial-year rate to a full-year equivalent so departments with different measurement periods can be compared.

For a simple departmental comparison, the basic formula is usually sufficient. If you’re analyzing why people leave, split the numerator into voluntary and involuntary categories.

Common Mistakes and Pitfalls

Even with a simple formula, errors are common:

• Using ending headcount instead of average. If a department shrank from 50 to 45, using 45 as the denominator inflates the rate. Always use the average of start and end counts.
• Counting transfers as separations. An employee who moves from sales to marketing is not a turnover event for the company, though they are a loss for the sales department. Decide whether you want departmental turnover (count transfers out) or company turnover (exclude internal moves) and be consistent.
• Mixing periods. If you count separations over 6 months but use a headcount from the annual report, the rate is meaningless. Match the time frames.
• Rounding too early. Carry at least two decimal places through the calculation. Rounding the average headcount to 48 instead of 47.5 changes the result.
• Ignoring seasonality. A department that hires many temporary workers in summer will show high turnover if you measure only that quarter. Compare the same period year-over-year.

Also be aware that the formula assumes linear changes in headcount. If a department doubled in size mid-year, the simple average may not represent the true exposure to turnover. In that case, use the average of monthly headcounts for a more accurate denominator.

How to Interpret the Result

There is no universal “good” or “bad” turnover rate. It depends on industry, role type, and labor market conditions. For example:

• Retail and hospitality often see annual turnover above 60%
• Professional services and tech typically range from 10% to 20%
• Government and education often fall below 10%

Instead of comparing to an arbitrary benchmark, track your own department’s trend. A rate that rises from 8% to 15% over two years signals a problem worth investigating. A rate that drops from 30% to 15% after a management change suggests the change worked.

Also consider the cost of turnover. Replacing an employee costs time in recruiting, training, and lost productivity. For a department with 100 employees and a 20% turnover rate, that’s 20 replacements per year. Reducing the rate to 15% saves five hires – a meaningful reduction in cost and disruption.

Limitations of the Formula

The simple turnover rate is a useful snapshot, but it has limits:

• It treats all separations equally. Losing a top performer is different from losing a low performer, but the formula doesn’t distinguish.
• It doesn’t capture the quality of the workforce. A department with high turnover might still perform well if new hires are better.
• It ignores the reason for leaving. High turnover due to expansion (temporary contracts ending) is different from high turnover due to poor management.
• It doesn’t account for the timing of departures. Five people leaving in January is different from one per month, but the formula treats both the same.

For deeper analysis, pair the turnover rate with exit interview data, engagement survey scores, and tenure distribution. The rate tells you how many leave; the other data tells you why.

Frequently Asked Questions

Should I include interns and part-time workers in the headcount?

It depends on your definition of “employee.” For consistency, include anyone you count as a separation in the numerator. If you exclude interns from the headcount but count their departures as separations, the rate will be inflated. Define your population clearly and apply it to both the numerator and denominator.

What is a healthy turnover rate by department?

There is no single answer. A healthy rate for a call center might be 30%, while a healthy rate for an engineering team might be 10%. Compare your department to its own historical trend and to industry data for similar roles. A sudden spike is more concerning than a steady, moderate rate.

How do I annualize a turnover rate for a 6-month period?

Multiply the 6-month rate by 2 (12 ÷ 6). More generally, multiply by (12 ÷ number of months). This assumes turnover is evenly distributed throughout the year, which may not be true, but it gives a comparable figure.

What is the difference between turnover and attrition?

Turnover counts all separations, including layoffs and terminations. Attrition usually refers to positions that are not filled after someone leaves, often due to natural departures like retirement. Attrition is a subset of turnover, but the terms are sometimes used interchangeably.

Why does my department’s turnover rate seem too high?

Check whether you used the average headcount rather than the ending headcount. Also verify that you didn’t include temporary workers or interns in the numerator but not the denominator. Finally, make sure the period length is correct – a 3-month rate will be much higher than a 12-month rate if you don’t annualize.

Can I calculate turnover rate using only the number of employees at the end of the period?

Technically yes, but it’s not recommended. Using the ending headcount as the denominator understates the average number of employees at risk of leaving, which inflates the rate. The average of start and end is a better approximation, and monthly averages are even better.

Related

• Change Difficulty on a Sons of the Forest Server
• Garmin Watches and GoPro Control: What Works
• Tom Clancy Games Play Order: Best Ways to Start

in start | Employees at start | - | 50 | 0
in end | Employees at end | - | 45 | 0
in leavers | Separations during period | - | 5 | 0
in months | Period length | months | 12 | 1
out turnover | Turnover rate | % | (leavers / ((start + end) / 2)) * 100 | 1
out annualized | Annualized turnover | % | (leavers / ((start + end) / 2)) * (12 / months) * 100 | 1