Calculating Annual Attrition Percentage Xls Download.. CiteHR
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Human Resource Section > Human Resource Management

Chanda Batra Started The Discussion:

Hi,

Request you to tell me the formula to calculate Annual Attrition Percentage? To calculate per month attrition, we use (Total attrites/Avg Headcount)*100 and avg headcount= (opening+closing)/2. How do I calculate annual attrition percentage? Please give the details.



Regards,
CB

sv_ht2000 -  Member Since: May 2007
Hi Govind.

I was looking at your attrition sheet but couldn't understand it well.
Can you tell me what the following means

Good people
Managed attritions
non managed attritions.

Thanks,
Shalini.

suparnaavasthi -  Member Since: May 2009
Hi Govind, My query is similar to that of shalini. Please let me know the same. Regards, Suparna

kshantaram -  Member Since: Dec 2006
Attrition rate is percentage rate of people leaving the organisation, people left - and is relative to the total number of people who have worked for the organisation during the period under consideration, hence :

Attrition Rate =

number of people left/number of people worked for the organisation =

number left/opening balance+new joinees x 100

the number left could be from old employees or those who join and immediately leave in a short period

i understand those who have been asked to leave also reflects the effectiveness of the organisation in attracting and retaining the right kind of people and hence need to be included to have an overall measure of attrition in the organisation including those who retire and are not given extensions.

say, the opening balance was 100 people, joined 50 people
therefore total people worked during the period = 150

left at different points of time 30 people

therefore Attrition Rate =

30/100 + 50 = 30/150x100 = 20%

if you calculate Attrition on the closing strength ie 150-30 = 120

the rate would be 30/120 = 25% which is wrongly exaggerated

which would show the wrong flow rate, 120 is the figure after attrition

we would rather want to know the rate of attrition, how many people joining the organisation leave for a given period.

hope the above makes sense,

regards,


kshantaram

mrinalinichat -  Member Since: Feb 2008
Govindi, The detailed excel sheet is excellent know-how, one which I would like to continue but my understanding is not very clear. My queries are same as Shalini, can you please clarify.

shashi sharma -  Member Since: Mar 2007
What is non-Managed people and Managed People??

Please help with the same.
I have to submit the Attrition calculation by end of Next week. My company is small company but growing rapidly., so we have deceded to track the attrition rate.

pleasse suggest the best way to calculate it.




 
 
 
 





POSTING RULES OF CONDUCT
  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.
  • Found This Useful? +Vote Up This Via Google.  

    Why Vote? User validation is extremely important for good content to prosper.
    Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.



    3M Users, 100K+ Documents & 450K+ Discussions

    Share »


    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Community Support & Professional Insights. Login or Register.
    Email/Username    
    Password  

    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network