Formula for Attrition is supported here by giving a suitable example.:
No of Head Counts in a Month start : 100
No of additions in a month : 50
Attrition : 20
Closing Head Counts at the end of the month : 100+50-20=130
Formula for calculation of Attrition is : 20*100/130 =15.38%
Regards
Moina
From India, Mumbai
No of Head Counts in a Month start : 100
No of additions in a month : 50
Attrition : 20
Closing Head Counts at the end of the month : 100+50-20=130
Formula for calculation of Attrition is : 20*100/130 =15.38%
Regards
Moina
From India, Mumbai
Attrition in an organisation means number of resignations in a particular month or year or it refers to the number of employees who leave an organization.
Formula for attrition :
Number of people leaving the organization during the period X 100
average head count
or
Attrition % = (No. of separations/Total employees) *100
From India, Madras
1Formula for attrition :
Number of people leaving the organization during the period X 100
average head count
or
Attrition % = (No. of separations/Total employees) *100
From India, Madras
Dear Sree, Formula of Attrition is as under: Total manpower During Month/Total manpower at the end of the month*100 Rgds
From India, Mumbai
From India, Mumbai
Let's understand why we need to calculate Attrition %:
Attrition % is a measure of lost productivity due to Attrition i.e employees leaving the org.
therefor Attrition % = Number of Employees Left / (Average Employee HC for that period)
Average Employee HC = (Opening HC + Closing HC)/2
From India, Mumbai
Attrition % is a measure of lost productivity due to Attrition i.e employees leaving the org.
therefor Attrition % = Number of Employees Left / (Average Employee HC for that period)
Average Employee HC = (Opening HC + Closing HC)/2
From India, Mumbai
I would still recommend using Avarage HC as the dinominator in the attrition equation as it is a more accurate measure of the average productivity available through the month.
From India, Mumbai
From India, Mumbai
Hi Lawrence...m richa..i guess d excel sheet tht u hv attached with ur post does nt have d correct calculations as it does nt consider d the correct closing head count i.e.it does nt consider d new employees who join nd hence d clsogin head count figure goes wrong and thereby the attrition% also comes out to be wrong......
CALCULATION OF ATTRITION RATE
The Logical approach for calculating Attrition.
Remarks: Typically this method is more oriented towards HR aspect. Recruiter do not necessarily use this method, though a good indicative, and also this does not provide the attrition numbers specifically from Recruitment view point.
Opening Balance: OB
Resignations: R
New Joinings: NJ
ATTRITION % = [(R) / (OB + NJ)] * 100
Now for example:
Opening Balance: 197
Resignations: 22
New Joinings: 36
ATTRITION % = [(22) / (197 + 36)] * 100 = [22 / 233 ] * 100 = 9.44%
To check the formula, in the above example Opening Balance is 197 & New Joinees are 36. Hence Total onboard strength is 197 + 36 = 233. Now if I say attrition is @ 9.44%, then 9.44% of 233 (that is onboard strength) should give us the Resignee count, which is 233 * 9.44% = 22. In our example also we took 22 Resignations. Hence proved that the formula is accurate.
Remarks: Internationally also this is a fairly acceptable formula, yet in my view this fails to account for negative attrition.
Rameswar Prasad
HR
From India, Pune
The Logical approach for calculating Attrition.
Remarks: Typically this method is more oriented towards HR aspect. Recruiter do not necessarily use this method, though a good indicative, and also this does not provide the attrition numbers specifically from Recruitment view point.
Opening Balance: OB
Resignations: R
New Joinings: NJ
ATTRITION % = [(R) / (OB + NJ)] * 100
Now for example:
Opening Balance: 197
Resignations: 22
New Joinings: 36
ATTRITION % = [(22) / (197 + 36)] * 100 = [22 / 233 ] * 100 = 9.44%
To check the formula, in the above example Opening Balance is 197 & New Joinees are 36. Hence Total onboard strength is 197 + 36 = 233. Now if I say attrition is @ 9.44%, then 9.44% of 233 (that is onboard strength) should give us the Resignee count, which is 233 * 9.44% = 22. In our example also we took 22 Resignations. Hence proved that the formula is accurate.
Remarks: Internationally also this is a fairly acceptable formula, yet in my view this fails to account for negative attrition.
Rameswar Prasad
HR
From India, Pune
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.
Attrition-rate. xls
What to do when you spot a mistake on your credit info report.pdf