Hello everybody, can anyone tell me the formula to calculate the attrition rate of the company thanks in advance Regards, Nipuna
From India, Delhi
Acknowledge(0)
Amend(0)
72From India, Delhi
Acknowledge(0)Amend(0)
Hi Nipuna,
The attrition rate is calculated as the number of resignations in a month divided by the available manpower, multiplied by 100. For instance, if at the beginning of the previous month the manpower count was 80, and during that month 5 employees resigned and 10 new employees joined, then on the last day of the month, the manpower count would be 80 - 5 + 10 = 85. Therefore, the attrition rate would be calculated as 5/85 * 100.
I hope this resolves the query.
Regards,
Amit Seth
From India, Ahmadabad
Acknowledge(0)Amend(0)
The attrition rate is calculated as the number of resignations in a month divided by the available manpower, multiplied by 100. For instance, if at the beginning of the previous month the manpower count was 80, and during that month 5 employees resigned and 10 new employees joined, then on the last day of the month, the manpower count would be 80 - 5 + 10 = 85. Therefore, the attrition rate would be calculated as 5/85 * 100.
I hope this resolves the query.
Regards,
Amit Seth
From India, Ahmadabad
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 Rate formula.pdf
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Calculation of Attrition Rate.doc