No Tags Found!


Sanjeev.Himachali
94

Thanks Rajat.
For others...the formula is:
(Total number of seperations in the month divided by Average Number of Employees During the Month) multipled by 100.
Here Average number of employees means:
(Number of People at the beginning of the month + Number of people at the end of the month) divided by 2.
I hope this will help.
Regards
Sanjeev Sharma
(blog: http://sanjeevhimachali.blogspot.com/)

From India, Mumbai
gaurav_kh1
Well these formula's seems to be correct but still i have a doubt in my mind why dont they take into factors like employee experience because in industry like bpo and kpo's its the freshers who leave the firm more frequently then experinced one
So how does experience affect the attrition ???

From India, New Delhi
Priyanka Nikumbha
Hi Aditi and Bob I really had a big learning experience as I was hunting for the same for the past few days. Regards Priyanka

Vb_bala
Hi
You will notice that attrition if calculated each month based on the employees on roll for that month will be misleading. We need to report it as annulaised basis. Then the data becomes meaningful as you can interpret it and take corrective actions. I agree with other comments on granularity like skill, geography,experience, reasons - Some of the attributes for which you need to map the attrition.
Cheers
Bala


rajshakerreddy
hi any one plz mail me xact attrition formula,, iam very poor in maths yaar,,, but wt can i do,, plz mailany one ifu have formula,, for attrition as welll as aht,, i have for aht but i need for attrtion ,, plzz ,, my id is
From India, Hyderabad
Amith R Murthy
16

Dear Friends,
I have one doubt when it comes to attrition do we need to consider the opening balance of a month or closing balance or both to calculate the attrition rate. Can anyone clarify me..........
Regards
Amith R.

From India, Bangalore
pallavi.prabhu
1

Hi Rajat,
I tried using th excel sheet u posted to claculate attrition but there seems to be a formula change in H7 and the rest of the attrition rate column
Can you please help me in sorting this out
Regards,
Pallavi[prabhu.pallavi@gmail.com]

From India, Bangalore
riank
1

Hi Rajat,
Thanks for the information, But i'm really confused you have written the formula for attrition as :
Total Number of Resigns per month (Whether voluntary or forced) divided by (Total Number of employees at the beginning of the month plus total number of new joinees minus total number of resignations) multiplied by 100.
& the formula you are using in attached excel sheet is totally different
((F7*100)/(D7+E7+F7+G7))/100
Please correct me if I'm worng........
Please mail me to , if possible....

From India, Pune
ckums
Employees on Record at the Beginning of the Year+No. of Employees Joined during the Year+No. of Employees Left during the Year+Employees on Record at the end of Year/ 100 -C.Kums
From India, Madras
kings
hey guys can u plz explin me as to wat is opening balance in the execl sheet for attrition rate.
From India, Mumbai
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.