Hi Can anyone plz tell me how Attrirtion anaysis is done? How can i calculate Attrition rate? Regards SAKSHI ARORA hr_sakshi84@yahoo.com
From India, Lucknow
Acknowledge(0)
Amend(0)

chum
18

Hi Sakshi,
Attrition rate (%) = (Resignatios+dissmisal / total manpower) %. For attrition analysis, you have to have the details of past years attrition data by tat u can analyze the trend...if u have more queries......post me.....Keep rockin......

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

Hi Attrition: No. Of Employees leaving the organization in a year X 100/Average no. of employees during the period
From India, Mumbai
Acknowledge(0)
Amend(0)

Hey Sakshi, The below mentioned is attrition formula: Attrition% = {Attrition nos.*(Opening Head count+Closing Head count)/2}*100
From India, Gurgaon
Acknowledge(0)
Amend(0)

Search the downloads for "to_rate.xls" which is an Excel workbook that allows the user to track turnover for 12 months.
Also, track turnover by job title, by manager, by department, by executive, by shift, etc.

From United States, Chelsea
Acknowledge(0)
Amend(0)

hi.. i did my project in Turn over of IT employeees, much related to attrition... try this...
From India
Attached Files (Download Requires Membership)
File Type: doc Final hard copy.doc (407.5 KB, 310 views)

Acknowledge(0)
Amend(0)

Hello Tinajosh:
"i did my project in Turn over of IT employeees, much related to attrition..."
Reducing turnover is easy, the hard part is getting employers to try something new.
The right person to hire is seldom the best candidate.
The best candidates make the best employees about 20% of the time.
The best employers are not hired 80% of the time.

From United States, Chelsea
Acknowledge(0)
Amend(0)

Thank you for the information. Achually i had asked in an interview to calculate attrition: Existing employees: 100 New Joinees: 50 Resignees: 30 What will be attrintion rate then? Plz guide SAKSHI
From India, Lucknow
Acknowledge(0)
Amend(0)

[QUOTE=Bob Gately;815948]

Reducing turnover is easy, the hard part is getting employers to try something new.

The right person to hire is seldom the best candidate.

The best candidates make the best employees about 20% of the time.

The best employers are not hired 80% of the time.[/QUOTE]

That's true, Bob..

Thank you..

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

chum
18

Hi Sakshi,
No of employees left : 30
No of employees Joined : 50
Opening head count during that period: 100
Average head count = 50+100 / 2 = 75
Attrition rate = 30/75 = 40%
Hope this vl help u......more queries??....post me.....keep rockin

From India, Mangaluru
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.