Dear All,
I am very confused about which formula I should use for calculating the Attrition rate (%), monthly as well as quarterly and annually.
Which formula is correct:
1) Attrition = ((no. of attrition * 100) / (actual emp. + new joinee)) / 100
OR
2) Attrition = (no. of attrition) / ((Op. bal + Cl. bal) / 2)) * 100
Both formulas result in different percentages.
Please, I need your inputs and guidance on this, friends. Also, I need a standard formula that is used in every organization.
Thank you,
som
From India, Mumbai
Acknowledge(0)
Amend(0)
4I am very confused about which formula I should use for calculating the Attrition rate (%), monthly as well as quarterly and annually.
Which formula is correct:
1) Attrition = ((no. of attrition * 100) / (actual emp. + new joinee)) / 100
OR
2) Attrition = (no. of attrition) / ((Op. bal + Cl. bal) / 2)) * 100
Both formulas result in different percentages.
Please, I need your inputs and guidance on this, friends. Also, I need a standard formula that is used in every organization.
Thank you,
som
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Friend, According to my knowledge, the formula for attrition is = ( No of Employees left * 100 )/ Total No of Employees. Regards, Sinju
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Monica,
Thank you so much for attaching the Excel sheet for attrition calculation. I have used your sheet to calculate the percentage, but I noticed that in your sheet, both the formulas for Attrition 1 and Attrition 2 give different percentages.
My problem is determining which formula or percentage is correct. I am looking forward to your response.
Soma
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you so much for attaching the Excel sheet for attrition calculation. I have used your sheet to calculate the percentage, but I noticed that in your sheet, both the formulas for Attrition 1 and Attrition 2 give different percentages.
My problem is determining which formula or percentage is correct. I am looking forward to your response.
Soma
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Hi Monica,
I am in need of compensation and benefits details, as well as information on the various appraisal systems used across organizations. Are there specific appraisal systems followed by industries? If so, what are they and how do they differ? The systems I am interested in are:
1) 360-degree appraisal
2) Scorecard
3) Bell curve analysis
I am also interested in the methodologies most commonly used in appraisal systems that are practiced by many organizations. Kindly provide me with related documents and explanations, if possible, so that I can proceed further.
Please assist me at your earliest convenience. You can also send the information to the email addresses below:
charankedar@yahoo.com
charan@livecjobs.com
I look forward to your prompt reply.
Thanks and Regards,
Charan Kedar C.
+91-98407-18607
From United States, Palo Alto
Acknowledge(0)Amend(0)
I am in need of compensation and benefits details, as well as information on the various appraisal systems used across organizations. Are there specific appraisal systems followed by industries? If so, what are they and how do they differ? The systems I am interested in are:
1) 360-degree appraisal
2) Scorecard
3) Bell curve analysis
I am also interested in the methodologies most commonly used in appraisal systems that are practiced by many organizations. Kindly provide me with related documents and explanations, if possible, so that I can proceed further.
Please assist me at your earliest convenience. You can also send the information to the email addresses below:
charankedar@yahoo.com
charan@livecjobs.com
I look forward to your prompt reply.
Thanks and Regards,
Charan Kedar C.
+91-98407-18607
From United States, Palo Alto
Acknowledge(0)Amend(0)
Hi Monika,
This is in reference to the attrition calculator you have sent. Actually, I want to see the formula for the second sheet, which is password-protected. Can you please provide me with the password because the formula I am using has a different value?
My email ID is rahulverma@sar-group.com.
Rahul Verma
From India, Delhi
Acknowledge(0)Amend(0)
This is in reference to the attrition calculator you have sent. Actually, I want to see the formula for the second sheet, which is password-protected. Can you please provide me with the password because the formula I am using has a different value?
My email ID is rahulverma@sar-group.com.
Rahul Verma
From India, Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
ATTRITION CALCULATION.pdf
HR Planning Tools.doc