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
3I 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
Dear Friend, According to my knowledge, the formula for attrition is = ( No of Employees left * 100 )/ Total No of Employees. Regards, Sinju
From India
From India
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
From India, Delhi
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
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
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
From India, Delhi
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
From India, Delhi
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
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
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
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.
Calculating Employee Attrition.pptx
Attrition-rate. xls