Anamika Chauhan
Hi, I have recently joined citehr..could u plz mail the attrition calculation method to me also.
From India, New Delhi
Chanda Batra
4

Hi,
The attrition rate for the year is calculated using the following formule:
No. of attrites in a year/Average Headcount
Avg Headcount=(Headcount at the starting of the year+ Headcount at the end of the year)/2

From India, Delhi
Aashitsrivastava
1

Dear, Pls find the attrition calculator Aashit Srivastava
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls attrition-rate_1_.xls (12.0 KB, 175 views)

Aashitsrivastava
1

Dear, Pls find the desired Aashit Srivastava
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls attrition-rate_1_.xls (12.0 KB, 111 views)

Prasanna_J
9

Dear Aashitsrivastava,
There is something I don't Quite understand about this template
Attrition Rate = Employees Termed/Average HC For the timeperiod
The template gives a very deflated value of attrition.
Lets consider an egzample
Opening HC = 100
New Joinees= 10
Resignations= 2
ATT Rate =2/((100+108)/2) = 1.9%
Rationale for the same
On an average the number of employees I had during a month is approximately the average of my opening and closing headcounts and not thir sum.
The template returns a value of .91% (Not ACCURATE)
I have attached a modified template
There is something odd about the data in my template . It will look odd but it is accurate.

From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls attrition-rate-Template.xls (11.5 KB, 474 views)

riyarodeshia
26

If you want to calculate Attrition Rate for a perticular month you can Calculate it like below:
(Total no of resignation)/(total no of employees at the beginning of the month+total no of new joinees-total no of resignation in that month)*100

From India, Delhi
bansari
Hi Frds,
Thanx for such a valuable information.. I would be highly thankful if anyone provides me with the data on attrition rate in a manufacturing company. I am doing my project in a manufacturing company and so it would be of gr8 help if I get the data. This is my e mail id: [IMG]https://www.citehr.com/misc.php?do=email_dev&email=YmFuc2FyaXNoYWg4N0B5YW hvby5jb20=[/IMG]
Regards,
Bansari

From India, Pune
HITESH_73
this is the formula to calculate the attrition rate.......
first decide for which period you want to calculate the said rate...
than
1. take the opening manpower available for that period
2. take the closing manpower available for that period
3. add this two numbers
4. devide that by 2.
5. take the total resignations during that period and devide this total resignations by the numbers that arrived by step 4
6. multiply the answer by 100 & this is your attrition rate.

From India
abhatia@ariba.com
a) Opening Manpower
b) Resignations
c) Month you are currently in.
Annualized attrition = (b / a) * (12 / c)
Amit bhatia
[IMG]https://www.citehr.com/misc.php?do=email_dev&email=YWJoYXRpYUBhcmliYS5jb2 0=[/IMG]

From India, Delhi
Pranavkumar
plz forward to me how to calculate attrition rate in my email id [IMG]https://www.citehr.com/misc.php?do=email_dev&email=cHJhbmF2X2FjaGFyQHlhaG 9vLmNvbQ==[/IMG]
Pranav Kumar


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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.