piyush10
4

Hi HR Professionals, Can anybody among you lemme know about the Formula to calculate the Attirition Rate?? Piyush 99773-00779 naikpiyush2000@yahoo.co.in
From India, Indore
gayathri.suraparaju
14

Attretion = No of Heads that left the Organization in a Month
Number of Heads present at beginning of the Month
Attretion % = No of Heads that left the Organization in a Month
Number of Heads present at beginning of the Month *100
Cheers ,
Gayathri Suraparaju

From India, Hyderabad
welcomeumesh
141

Hi
Please read the following ellaboration:-
Attrition = employees left * 100 / (opening balance in a month+no of employees joined in a month+no of employees left + no of employees at the end of the month
say you have 100 employees at the start of the month, 10 new employees joined you during the month, 25 employees left in the month and you're finally left with 85 employees at the end of the month
Attrition = 100*100/100+10+25+85
the answer is 11.36%
I hope it's cleare to you now.
warm regards,
Umesh Chaudhary
(welcomeumesh@yahoo.com)

From India, Delhi
M.Peer Mohamed Sardhar
733

The information was useful,, Would be too good if the same is explained in an Excel Sheet,,, Regards MPMS
From India, Coimbatore
Subramaniam P G
1

Just to understand this from practices purpose, I wanted to understand who are considered for exit here. For example would you include following category of employee in number of exit for attrition rate:
1. Retirement/ Death/ Permanent DIsability
2. Forced Exit/ Terminations
3. Resignation within say 60/ 90 days or probation/ training.
PGS

From India, Madras
antra bhatnagar
HI! UMESH THE EXAMPLE DESCRIBING UR FORMULA SHOULD BE 25 X 100 / 100+10+85+25 =11.36%. ANTRA

Jagadishb
Pls find attached Excel Sheet
Attached Files (Download Requires Membership)
File Type: xls attrition_formula_592.xls (14.0 KB, 769 views)
File Type: xls attrition_formula_592.xls (14.0 KB, 618 views)

welcomeumesh
141

Hi,
There is only one exit door in the company whoever passes through it, is to be considered in calculating attrition, attrition doesn't exclude retiress, people terminated etc.
warm regards,
Umesh Chaudhary
(welcomeumesh@yahoo.com)

From India, Delhi
Balaji Raghunathan
1

In the Formula for Attrition Rate = No.of People left in the month
-------------------------------------
Total Strength at the begining
of the month
We should not include the newcomers who have joined and left in the same month.
Also care has to be taken that an employee after long absenteeism resigns in the month , he should not be considered for calculation of Abs% ; otherwise it will have double effect.
- Balaji

From India, Coimbatore
ani_dyn
Hi, This will help you calculate attrition in your organisation. Regards Anitha
Attached Files (Download Requires Membership)
File Type: xls attrition_calculator_and_register1_199.xls (26.0 KB, 102 views)
File Type: xls attrition_calculator_and_register1_199.xls (26.0 KB, 68 views)

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.