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
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
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
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
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
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
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
From India, Faridabad
----------------------------------------------------------------------
Thanks a lot this is good
From India, Mumbai
Thanks a lot this is good
From India, Mumbai
Attrition rate has to be calculated only for the year or has to be annualised;
The formula is = (No.of employees Left during the year)/((Opening Balance)+(addition during the year) ) * 100
Assume No of employees at the beginning of the year : 100
Added during the year :300
Left during the year : 200
=(200)/(100+300)*100=200/400*100=50%
From India, Bangalore
The formula is = (No.of employees Left during the year)/((Opening Balance)+(addition during the year) ) * 100
Assume No of employees at the beginning of the year : 100
Added during the year :300
Left during the year : 200
=(200)/(100+300)*100=200/400*100=50%
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.