somabiswas2005
3

Dear All,
I m very confuse that what formula should i use for calculating Attrition rate (%), monthly as well as quartely & annually.
which formula is right:-
1) Attriotion = ((no. of attrition *100)/(actual emp. + new joinee))/100
OR
2) Attrition = (no. of attrition)/((Op. bal+Cl. bal.)/2))*100
from both formula the % come is different.
Pls. I need your inputs & guidance in this frnds. & need any standard formula which is being used in every organization.
som

From India, Mumbai
sinju.george
Dear Friend, According to my knowledge, the formula for attrition is = ( No of Employees left * 100 )/ Total No of Employees. Regards, Sinju
From India
Monika Vaid
3

Hey Som !!!!!!!!!! I m attaching an excel sheet with this ........... This sheet was posted by some citehr member only........... Hope u find it useful......... Regards, Monika
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls attritionrate_revisedformula_1_216_143.xls (19.5 KB, 1029 views)
File Type: xls attritionrate_revisedformula_1_216_143.xls (19.5 KB, 712 views)

somabiswas2005
3

Dear Monica,
Thank you so much, for attaching the excel sheet for attrition cal., and I have used ur sheet for calculating % but, monica in your sheet both the formula Attrition 1 & Attrition 2 give different %age.
And that was my problem is, that which formula or %age is right????
waiting for your response.
Soma

From India, Mumbai
khyat
6

Hi Soma
I have a attrition calculation register in which u just need to fill in details about some particulars and it automatically tells u d attrition %....
Unfortunately m unable to attach it here....kindly mail me at and i wil, mail it to u

From India, Khopoli
Monika Vaid
3

Hello !!!!!!!!! I m attaching another format............... this is better one........... try this n let me know wether its helpful or not.......... Regards, Monika
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls attrition_calculator_and_register_584.xls (23.5 KB, 519 views)
File Type: xls attrition_calculator_and_register_584.xls (23.5 KB, 349 views)

Monika Vaid
3

Hello Vinay!!!!! The formula is correct for sure.......... r u finding any kind of problem...................... if yes than let me know.............. Warm Regards, Monika
From India, Delhi
M.Peer Mohamed Sardhar
733


Dear Friend,
Kindly click on the following link, it will give you some required information,
https://www.citehr.com/search_new.ph...tion&submit=Go
Pls let me know was this information useful,,
If not let me try out more & give information,,,,
In CiteHR you will get A to Z information on HR…..
Regards
M. Peer Mohamed Sardhar
093831 93832

From India, Coimbatore
charankedar
1

Hi Monica,
I am in need of comp & Benefits details and also various appraisal systems used in across the organizations.
Is there any particular appraisal system are followed by each industries? If so what are they and how they differ from each of its...
1) 360 appraisal
2) Score card
3) Bell curve analysis
and methodologies most commonly used in appraisal system which are in practiced by most of the organizations.
Kindly provide me with related documents if possible with the explanations for the same. So that i can move on further
Kindly help me out at the earliest.
You can post the same on below mail id's also...


Awaiting for your earliest reply...
Thanks & Regards
Charan Kedar.C.
+91-98407-18607

From United States, Palo Alto
rahulverma
1

hi monika
this is in reference to the attritin calculator u have sent. Actually i want to see the formula for the second sheet which is password protected. can u pls provide me the passsword because d formula i m using has some different value.
my e mail id is
rahul verma

From India, Delhi
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.