Dear All
This calculation sheet which I had posted is based on Annualised attrition. The use of annualised attrition is moreover like a FORECAST tool as to what will be your attrition over a period of 12 months. This percentage will definitely be more than our normal calculation.
The normal calculation which we use is to take the number of resignations in a particular month & divide it by the total number of employees & convert it into a percentage, but it is not taken as the right way to calculate attrition because in some months the manning might be more, in some other months the attrition could be more due to external reasons etc.
More details on Annualised attrition calculation
01. Enter the number of resignations & new joinees in a particular month
02. Enter the number of employees at the beginnnig of a month
03. Closing balance of the month is calculated adding the opening balance with the new joinees less the resignations
04. The monthly attrition proportionate to 12 monthly basis is calculated by multiplying 12 to the number of resignations in a month. This will give a projected number as to how many people will leave if this situation continues (ie., 8 people leaving in a month)
05. Average number of employees is calculated by adding the opening balance & the closing balance of the month and dividing it by 2
06. Annualised attrition is calculated by calculating by dividing the projected number of resignations with the average number of employees
07. The most important factor is the total - "which should not go wrong"
08. The sum of the annualised attrition rate mentioned against each month,should be divided by the number of months it is being calculated. ie., if you are calculating the attrition rate as of closing March 2007 from January 2007 then the total of the annualised % of attrition rate should be divided by 3, if it is for april then by 4 & so on
For further clarifications if any, please feel free to mail me
Regards
G.GANESH