Voluntary + involuntary departures
Enter values to see detailed analysis and insights.
How to Use
- 1Enter total number of employees at period start
- 2Input number of employees who left
- 3Add average annual salary
- 4Review attrition rate and total costs
- 5Target: <10% attrition is good, <5% is excellent
Attrition & Retention Formulas
Attrition Rate = (Employees Left ÷ Total Employees) × 100%
Retention Rate = 100% - Attrition RateVariables:
Attrition Rate% of employees who leftRetention Rate% of employees retainedTurnover CostReplacement + lost productivity costsExample
Inputs:
Steps:
- 1.Attrition Rate = (15 ÷ 100) × 100 = 15%
- 2.Retention Rate = 100% - 15% = 85%
- 3.Replacement cost = 15 × ($50,000 × 20%) = $150,000
- 4.Total turnover cost = 15 × ($50,000 × 150%) = $1,125,000
