No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


suhanidutta
1

Dear All, Can anyone please guide me on how to calculate attrition rate. What is the standard formula used for attrition analysis.
From India, Kolkata
jkct15
183

hi Standard formula is no of left employees/total strength*100 will give you the attrtion percentage.

Rajendra Bhavsar
34

Hi Attached pl. find herewith format for calculating attrition rate. Regards Rajendra Bhavsar Manager (P&A) Afcons Infrastructure Ltd. CMRL Project, Chennai 8754543347
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls ATTRITION___REPORT.xls (31.0 KB, 6568 views)

aartri
Hi, As per my knowledge the attrition formula shall be : No. of employees left/Average no. of employees*100 Regards
From India
mrsharma
4

Hello All,
for attrition rate,formula is No. of left employees/average of (total employees at the starting of month & total no. of employee at the ending of month)* 100 and for employee turnover it is left employee/total employee in end of month*100 (in case if we calculate it on month basis)
Thanks

From India, Pune
iimt_studies
8

hi suhani, you can find number of formats and their clarifications from this booklet. its assured you will get fantastic knowledge out of this.
From India, Ahmedabad
Palaniswamy Ram
13

Dear Suhani,
The attrition formula is A/(B+C-A)*100
A = Nof of employees left in the Month
B = No.of employees on 01st DAY of the month
C= Newly joined during the month
Nof of employees left in the Month/ (No.of employees on 01st of the month + addition during the month - left employees)*100
If it is for year, Nof of employees left during the year/ (No.of employees on 01st January+ addition during the year upto 31st December - left employees during the year)*100

From India, Namakkal
legal@hidesign.com
Dear Members,
Can you please guide me whether we should take the employees present for the month or should we take the actual number of positions for calculating the attrition every month.
For example if a department has 10 positions, then should the opening balance be 10 for every month or should the closing balance of the previous month be the opening balance of the next month.
Regards
K Lakshme devi

From India, Pondicherry
hrlinked
3

Suhanidutta, You can use attached document to calculate attrition for the desired period. Formula = Relieved members / Average( Opening headcount & Closing headcount) Thanks
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls Attrition-Analysis.xls (19.0 KB, 3051 views)

access.ashis
2

Hii,
You can do it 2 ways.In my view attrition is 2 types,monthly attrition & annual attirtion.However,you will be always more interested for annual attrition.For that you may annualize each months actual attrition to reach at the avg. attrition at the end of the year.This will give you the correct picture & through out the year,you can have an eye on the end figure of Annual attrition.Its just like run rate per over In Cricket so that at end of 50 ovrs how much will be your total score.
One formula we may use is =
(Total employees resigned/avg. head count)*(12/no. of months you have completed in that financial year)*100
To explain,suppose after end of 4 months,total resignation no. is 200.Total head count in these 4 months being,3000,3050,3075,3065.
So the annualized attrition will be (200/3047)*(1/42)*100=19%.
That means your attrition after 4 months is & after 12 months will be 19 %..Next month,you can check considering 5 months & find if it has increased or decreased.

From India, Chennai
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.





About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.