Hello seniors,
I have to write an analytical report on employee turnover. I have gathered the information like emp. name, desg., dept, joining date, terminateion date, tennure and salary. But have no clue where to start and how to go for a self explanatory report. Please guide me.
If any of you can share a format. I will be grateful.

From India, New Delhi
Dear Rimpy,

Analysis can be done under following heading:

a) Employee exits for the last five years

b) % of manpower attrition per annum for the last five years

c) Department-wise break up of employee exits

d) Employee exits as per the quarter of financial year

e) Break up of manpower attrition between managers and non-managers

f) Gender-wise break up of manpower attrition per annum

g) Qualification-wise break up of manpower attrition per annum

h) Cost of manpower attrition per annum against total HR budget (provided the records are maintained. Many organisations do not measure it at all

i) Average length of stay per employee per annum for the last five years

j) % of terminations on disciplinary grounds against total exits per annum

k) % of employees abandoned their employment against total exits per annum

l) Top three reasons quoted by employees for their exit in the exit interview

m) % of employees put up resignation but later withdrew after counselling against total exits

n) Total recruitment cost per annum against total HR budget (provided systematically the data is maintained)

o) Is there any seasonality factor in employee attrition? If yes, then in which months of the year the company witnesses a maximum attrition?

Hope the above reasons are more than sufficient. Once you prepare the report, please come back and confirm to us whether the above information was useful.

All the best!

Dinesh Divekar


From India, Bangalore
Dear All, I Working as HR cum Payroll, I just want prepare yearly report for the employee head counting report. so Can anyone help me how to prepare employee attrition with formula? ( head count)
From United Arab Emirates, Dubai
Hello All,
I am working for a revenue cycle management firm involved in A/R, A/P, Billing and coding process, working night shifts. I am needed to attrition analysis and a prepare an attrition template, can anyone help me in this regard and provide me with a sample.

From India, Hyderabad
How to calculate the absenteeism Attrition per month. Pls advise friends
From India, Chennai

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™