Dinesh Divekar
Business Mentor, Consultant And Trainer
Hr Executive
+3 Others

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.
Cite.Co is a repository of information created by your industry peers and experienced seniors made possible with help from our prime sponsors like:

TALENTEDGE Who provide a platform for "interactive anywhere learning". Courses from top reputed institutes like IIM, XLRI, MICA. View Courses

FACTOHR - Provides Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS that can help streamline your organisation. Explore Features

Register Here and help by adding your inputs. Contributions From Other Members Follow Below...
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)

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

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)
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.

How to calculate the absenteeism Attrition per month.
Pls advise friends
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™