How Do You Calculate Attrition Rate? Seeking Guidance on Attrition Analysis

Hi,

Can anyone please tell me how Attrition analysis is done? How can I calculate Attrition rate?

Regards,
SAKSHI ARORA
hr_sakshi84@yahoo.com

Hi Sakshi,

The attrition rate (%) can be calculated as follows: (Resignations + dismissals / total manpower) %. To conduct an attrition analysis, it is essential to have access to the details of past years' attrition data. By doing so, you can analyze the trend. If you have any further queries, feel free to reach out. Keep rocking!

Hi,

Attrition:

The number of employees leaving the organization in a year multiplied by 100, divided by the average number of employees during the period.

Hey Sakshi,

The attrition formula is as follows:
Attrition% = {Attrition nos. * (Opening Headcount + Closing Headcount) / 2} * 100

Would you like further clarification on this formula?

Best regards, [Your Name]

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.

Hi, I did my project on the turnover of IT employees, which is closely related to attrition. Give it a try!

Hello Tinajosh:

"I did my project on the turnover of IT employees, 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.

Hi Sakshi,

Number of employees left: 30
Number of employees joined: 50
Opening headcount during that period: 100
Average headcount = (50+100) / 2 = 75
Attrition rate = 30 / 75 = 40%

Hope this will help you... more queries? Post them... keep rocking

Thank you so much, Chum. But I had taken a file from citehr itself that has a different formula for calculating the attrition rate. Please go through and guide me.

Thank you,
SAKSHI