Hi All,
Greetings!!
Can anybody please help me in calculating the attrition rate. I am not able to figure out the actual formula. Tried Google as well but too many formulae & can't make out which is the actual one.
Thanks,
Axita
From India, Chandigarh
21Greetings!!
Can anybody please help me in calculating the attrition rate. I am not able to figure out the actual formula. Tried Google as well but too many formulae & can't make out which is the actual one.
Thanks,
Axita
From India, Chandigarh
Opening balance
No. of Emp Joined
No. of Emp Left
Closing Balance : Opening balance + No. of Emp Joined - No. of Emp Left
Avg. Head Count : Opening balance + Closing Balance / 2
Attrition % : No. of Emp Left / Avg. Head Count * 100
From India, Delhi
No. of Emp Joined
No. of Emp Left
Closing Balance : Opening balance + No. of Emp Joined - No. of Emp Left
Avg. Head Count : Opening balance + Closing Balance / 2
Attrition % : No. of Emp Left / Avg. Head Count * 100
From India, Delhi
Opening balance : 817
No. of Emp Joined : 35
No. of Emp Left : 19
Closing Balance : 833
Avg. Head Count : 825
Attrition % : 2.30
Formula :
= Opening balance (817) + No. of Emp Joined (35) - No. of Emp Left (19)
= Closing Balance (833)
= Opening balance (817) + Closing Balance (833) / 2
= Avg. Head Count (825)
= No. of Emp Left (19) / Avg. Head Count (825) * 100
= Attrition % (2.30)
Now, the Attrition Rate is 2.30%.
From India, Delhi
No. of Emp Joined : 35
No. of Emp Left : 19
Closing Balance : 833
Avg. Head Count : 825
Attrition % : 2.30
Formula :
= Opening balance (817) + No. of Emp Joined (35) - No. of Emp Left (19)
= Closing Balance (833)
= Opening balance (817) + Closing Balance (833) / 2
= Avg. Head Count (825)
= No. of Emp Left (19) / Avg. Head Count (825) * 100
= Attrition % (2.30)
Now, the Attrition Rate is 2.30%.
From India, Delhi
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 formula.pdf
Attrition-rate- in-different-se ctors_906.jpg
Attrition-rate- Template.xls