Attrition Rate Calculator
Attrition Rate Calculator
A company starts year with 500 employees. Throughout the year, 50 employees leave for various reasons, the attrition rate calculator help determine the percentage of employees who left, providing valuable insights into the company’s employee retention efforts.
Attrition Rate Calculation Chart
| Year | Starting Employees | Employees Left | Attrition Rate (%) |
|---|---|---|---|
| 2020 | 500 | 50 | 10.00 |
| 2021 | 480 | 40 | 8.33 |
| 2022 | 460 | 35 | 7.61 |
| 2023 | 450 | 30 | 6.67 |
| 2024 | 440 | 25 | 5.68 |
Attrition Rate Calculation Formula
The formula to calculate the attrition rate is:
Attrition Rate = (Number of Employees Who Left / Average Number of Employees) x 100Where:
- Number of Employees Who Left is the total number of employees who departed during the period.
- Average Number of Employees is typically calculated as (Starting Employees + Ending Employees) / 2.
Let’s calculate the attrition rate for 2020 from our chart:
Number of Employees Who Left = 50
Starting Employees = 500
Ending Employees = 500 – 50 = 450
Average Number of Employees = (500 + 450) / 2 = 475
Attrition Rate = (50 / 475) x 100 = 10.53%
How Do You Calculate Attrition Rate?
To calculate the attrition rate, follow these steps:
Find the number of employees at the start of the period.
Count how many employees left during the period.
Calculate the average number of employees.
Apply the formula: (Number of Employees Who Left / Average Number of Employees) x 100.
Calculate the attrition rate for a company in 2024:
Starting employees: 1000
Employees who left: 80
Ending employees: 1000 – 80 = 920
Average number of employees: (1000 + 920) / 2 = 960
Attrition Rate = (80 / 960) x 100 = 8.33%
The attrition rate for this company in 2024 is 8.33%.