Attrition Rate calculation in Excel
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)
MTD – Total Nos of attrition/ Total Nos of Head count
YTD – total attrition from starting month to end month / average HC of starting month to end month
Don’t forget in headcount calculation we will also consider headcount attrited as a total calculation
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)MTD – Total Nos of attrition/ Total Nos of Head countYTD – total attrition from starting month to end month / average HC of starting month to end month Don’t forget in headcount calculation we will also consider headcount attrited as a total calculation Read More