No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


mlindenbach
Can you review this spreadsheet and let me know if anything else should be considered in the attrition rate to report up to an execuative level. Thanks for your input!
From Canada, Edmonton
Attached Files (Download Requires Membership)
File Type: xls Turn Over Ratio.xls (53.5 KB, 2190 views)

sand_kri
5

I feel you have to check on two things
a) Are you reporting annualized attrition? Check on the attrition figures (are you using the standard formula) . Also it is the trend to report annualized attrition eventhough it is calculated on a monthly basis. 4% looks good..but on an annualized basis it might be upto 40% + !
b) What are the reasons of attrition. At an executive level they might be more interested in that.
c) what are you doing to reduce the same !
studies in hr
http://linkedin.com <link updated to site home>

From India, Bangalore
ramakrishna81
Your formula for calculating attrition rate seems to be incorrect. Try divinding the no of employees left by avg employees for the month which will be =E6/((C6+F6)/2). And always calculate attrition as an annualised figure as monthly average is no indicator since it is a small number compared to the annual one....
From India, Mumbai
pravin.rai
The formula which we use to calculate attrition is as follows

Attrition %: Number of Employees Attrite / Average Strength of Employees

Average Strength of Employees : (Employee count in the Beginning /Employee Count in the end)/2
Correct formula : =E6/(AVERAGE(C6,F6)) = 2.61%

Month
Opening Balance
New Employees
Employees Left
Closing
Attrition Rate
Balance
January
75
5
2
78
2.61%
February
78
0
3
75
3.92%
March
75
3
2
76
2.65%
April
May
June
July
August
September
October
November
December
TOTAL
228
8
7
229
3.06%

From India, Pune
mlindenbach
How does this look? Specifically the YTD calculation. Thanks for your time!
From Canada, Edmonton
Attached Files (Download Requires Membership)
File Type: xls Turn Over Ratio (2).xls (39.5 KB, 719 views)

phaniacp
6

hi folks, just have alook on this formula. this wil clarify all your doubts Attrition%=(No. of Employees Quit) /(Avg. Employees during that time frame) %100 Thanks all
From India, Warangal
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.




About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.