JC_COMP
Dear Peers,
Can anybody tell me wats the logic behind attrition calculation formula in the attached file. As per me simple calculation for attrition is = ( Left emp/(Ope bal+new joinees)*100). But I found some other formula for the attrition rate calculation in that file.
Tell me which is correct and why?
Rgds
JC

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls attrition-rate(1).xls (21.0 KB, 1699 views)

vinodyadav@tsneel.com
The formulla of attrition is given in the attached file is not correct, It should be No. left employees/Opening balance+new joinee*100. Regards Vinod Yadav
From India, Delhi
JC_COMP
Yes Krishna you are right opening balance is present employees or closing balance of last month.
From India, Bangalore
satyasikha
Can somebody help me with the proper division for salary structure ?Also what does closing balanace mean ?
From India, Bhubaneswar
vinodyadav@tsneel.com
There is no fix salary structure, It is depend on the organizational need accordingly salary structure is fixed in keeping view of taxes.
From India, Delhi
infomerly
2

Hi, As per my observation, In the attached format, the calculation not correct only for january month. For Feb, Mar, & April, the caculation is correct.. Regards, Starlet
From India, Madras
parthapratimbose
Closing balance of a particular month= (Opening no. of employees of the month + No. of new joinees during the month)- No. of left employees during the month.
From India, Delhi
versunil
Dear Members,
1. Formula to calculate the monthly Attrition rate = Total no of resigned employee/(Opening Balance+New Joinees)*100
You can also used without multiplying by "100" by using in %.
2. Opening balance is called as total no. of active employees Head count at beginning of 1st day of an month.
3. Closing Balance is called as Total No. of active employees head count by End of month on on closure date or last date or month.
4. Also find the attached CTC structure may be helpful for you to calculate the Monthly as well as Annual CTC.
Regards,
Sunil Kumar Verma
AM-HR
Indiabulls

Attached Files (Download Requires Membership)
File Type: xls CTC Structure.xls (30.5 KB, 444 views)

anujsaini6@gmail.com
24

Hi seniors formula of january month is wrong, but other’s months expected jan is correct,
From India, Dehra Dun
farz23
12

Dear All
I believe following formula is correct to calculate attrition.

No. of employee left / ((Opening balance + closing Balance)/2) *100
You have to find out average no. of employee during month.
for better clarity i have attached attrition register and calculator
Regards,
Aliabbas

From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls Attrition Calculator and Register(1).xls (23.5 KB, 688 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.