Hi,
I have attached a very basic analysis template.
Sheet 1 gives a month on month Attrition Rate along with Annual Att %. (No biggie)
I sheet 2 enter the information and then this will give you a broad classification as to why there is attrition.
The real task is to set up a good exit interview which examines all dimensions that caused the employee to choose to leave the job.
So design a good exit interview. If you already have one in place then analyse each question individually. ensure that there are sufficient number of Questions pointing towards relationship with immediate manager, facilities, benifits, relationship with peers, relationship with other departments etc.
Analysing these with the additional comments the ex employee provides will be helpful in arriving at the root of the problem.
There is also a situation where a particular demographic is likely to contribute to most of your attrition worries . What do I mean? for e.g. in BPOs Fresh Graduates, engineers and those joining in Vacations/Drops tend to attrite very early even before they have returned the cost incurred in training! this may be true for your industry to so go in for a Demographic wise analysis i.e. What Kind of people are leaving the most.
One of the other challeges faced by HR is sensitising other departments to Attrition. Trust me people in operations and sales do not understand words like talent, Loyalty, retention,and anything else that we choose to explain the importance of retention.
Heres something that will definitely ring their bells
Present a "Cost of Attiriton Analysis"
I don't have that Handy right now but will post that soon