How do we calculate the rate of attrition for a amonth and also the rate of attrition for a year. Came across a formula for the calculation of rate of monthly attrition which says
Monthly attrition rate= {No. of seperations for the month/(Opening headcount for the month + Closing headcount for the month)/2}*12*100.
Need to know whether this formula is correct or not and if it is then plz explain it. And if it is not, plz give the appropriate formula.

From India, Mumbai
Acknowledge(0)
Amend(0)

Dear Neha, Please visit the following link for your querry Regards SK Jena
From India, New Delhi
Acknowledge(0)
Amend(0)

Hi Neha,
Attrition Rate = No. of resigned of that month/ Available manpower * 100
For example, if in any of the starting day of previous month the manpower was 80 and during that month 5 resigned and 10 joined.. then on the last day of the month Manpower would be 80-5+10 = 85
So Attrition rate = 5/85*100
Hope, the query must been solved now..
Regards,
Amit Seth.

From India, Ahmadabad
Acknowledge(0)
Amend(0)

Dear Friend,
Kindly click on the following link, it will give you some required information,
https://www.citehr.com/download-list...ion+Calculator
Pls let me know was this information useful,,
If not let me try out more & give information,,,,
Regards
Mohamed Sardhar
093831 93832

From India, Coimbatore
Acknowledge(0)
Amend(0)

Multiply by 100 means, we are converting it into Percentage. Example:- Suppose 8 employees left, and total staff is 80 in a month. The attrition rate = (8/80)*100 = 10% Hemant Agarwal
From India, Faridabad
Acknowledge(0)
Amend(0)

----------------------------------------------------------------------
Thanks a lot this is good

From India, Mumbai
Acknowledge(0)
Amend(0)

Attrition rate has to be calculated only for the year or has to be annualized; The formula is = (No. of employees left during the year) / ((Opening Balance) + (addition during the year)) * 100. Assume the number of employees at the beginning of the year: 100. Added during the year: 300. Left during the year: 200.

Therefore, the calculation would be: (200) / (100 + 300) * 100 = 200 / 400 * 100 = 50%.

From India, Chennai
Acknowledge(0)
Amend(0)

how can we calculate leave reserve ?
From India, Delhi
Acknowledge(0)
Amend(0)

Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.