Hi Seniors, Warm Greetings... Please let me know that how should we calculate attrition of a particular month... Sana
From India, New Delhi
Acknowledge(0)
Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
Hi Sana,
Attrition Rate = No. of resigned of that month / Available manpower * 100. For example, if on any starting day of the previous month the manpower was 80 and during that month 5 resigned and 10 joined, then on the last day of the month, the Manpower would be 80 - 5 + 10 = 85. So, the Attrition rate = 5 / 85 * 100.
Hope the query has been solved now.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
508Attrition Rate = No. of resigned of that month / Available manpower * 100. For example, if on any starting day of the previous month the manpower was 80 and during that month 5 resigned and 10 joined, then on the last day of the month, the Manpower would be 80 - 5 + 10 = 85. So, the Attrition rate = 5 / 85 * 100.
Hope the query has been solved now.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
Hai Sana, You can use this ready calculator. Thanks Binu
From India, Thiruvananthapuram
Acknowledge(0)Amend(0)
From India, Thiruvananthapuram
Acknowledge(0)Amend(0)
Hi Sana,
You can use this formula: TNORPM / TNOEB + TNONJ - TNOR * 100
TNORPM - Total number of resignations per month (voluntary or forced)
TNOEB - Total number of employees at the beginning
TNOJ - Total number of new joiners
TNOR - Total number of resignees
Regards,
Dhamotharan
From India, Madras
Acknowledge(0)Amend(0)
You can use this formula: TNORPM / TNOEB + TNONJ - TNOR * 100
TNORPM - Total number of resignations per month (voluntary or forced)
TNOEB - Total number of employees at the beginning
TNOJ - Total number of new joiners
TNOR - Total number of resignees
Regards,
Dhamotharan
From India, Madras
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.
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Calculation of Employee Turnover.doc