Annual Attrition Rate Calculation
Please inform the annual attrition rate as per the following numbers:
- April 11 Headcount: 157
- March 12 Headcount: 180
- Resignations from April 11 - March 12: 40
What will be the annual attrition percentage? Please share the formula as well.
Thanks,
Ankur Khanna
From India, Gurgaon
Acknowledge(0)
Amend(0)
Please inform the annual attrition rate as per the following numbers:
- April 11 Headcount: 157
- March 12 Headcount: 180
- Resignations from April 11 - March 12: 40
What will be the annual attrition percentage? Please share the formula as well.
Thanks,
Ankur Khanna
From India, Gurgaon
Acknowledge(0)Amend(0)
Please provide headcount for all the months to calculate the Annual Attrition. Annualized attrition is a term used to calculate projected attrition on an annual basis if the current trend continues. In this case, you multiply the above numbers by 12 to get the "Annualized attrition." This is a projected figure only. If you are tracking month over month, you can use the actual data from past months.
Let's consider an example where we are calculating on May 31st, and the calendar year starts from January. We sum the average number of people employed in Jan, Feb, Mar, Apr, and May. Then, sum the number of people who left in Jan, Feb, Mar, Apr, and May. Apply the formula, but before multiplying by 12, divide by 5 to get the annualized number.
If you have data for the last 12 months, you can calculate the actual attrition for the last 12 months. This figure is known as "Annual Attrition" and does not involve any projected elements. For this calculation, you do not multiply by 12 because you already have the actual data for the last 12 months.
Thank you.
From India
Acknowledge(0)Amend(0)
36Let's consider an example where we are calculating on May 31st, and the calendar year starts from January. We sum the average number of people employed in Jan, Feb, Mar, Apr, and May. Then, sum the number of people who left in Jan, Feb, Mar, Apr, and May. Apply the formula, but before multiplying by 12, divide by 5 to get the annualized number.
If you have data for the last 12 months, you can calculate the actual attrition for the last 12 months. This figure is known as "Annual Attrition" and does not involve any projected elements. For this calculation, you do not multiply by 12 because you already have the actual data for the last 12 months.
Thank you.
From India
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Calculation of Attrition Rate.doc
Attrition-rate. xls