Dear All,
Attrition Calculation:
Number of employees left = X
Number of Employees Joined = A
Opening headcount during the period = B
Average Headcount (C) = (A + B) / 2
Attrition Rate = (X / C) * 100
Is this formula correct?
Regards,
Amrita
From India, Delhi
Acknowledge(0)
Amend(0)
2Attrition Calculation:
Number of employees left = X
Number of Employees Joined = A
Opening headcount during the period = B
Average Headcount (C) = (A + B) / 2
Attrition Rate = (X / C) * 100
Is this formula correct?
Regards,
Amrita
From India, Delhi
Acknowledge(0)Amend(0)
Please find the formula that we use.
Annual attrition rate: Total number of resigned employees in the past 12 months / (headcount at month 1-Jan + headcount at month 12-DEC)/2.
Monthly attrition rate: Total number of resignees in a month / (headcount at the beginning of the month + headcount at the end of the month)/2.
Opening Balance = 415. New addition = 115. Attrition = 129.
Attrition formula to % = 129 / 472.5 * 100 = 27.3%
From India, Delhi
Acknowledge(0)Amend(0)
Annual attrition rate: Total number of resigned employees in the past 12 months / (headcount at month 1-Jan + headcount at month 12-DEC)/2.
Monthly attrition rate: Total number of resignees in a month / (headcount at the beginning of the month + headcount at the end of the month)/2.
Opening Balance = 415. New addition = 115. Attrition = 129.
Attrition formula to % = 129 / 472.5 * 100 = 27.3%
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.
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Calculation of Employee Turnover.doc