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
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
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
+5 Others
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
From India, Delhi
Yes Krishna you are right opening balance is present employees or closing balance of last month.
From India, Bangalore
From India, Bangalore
Can somebody help me with the proper division for salary structure ?Also what does closing balanace mean ?
From India, Bhubaneswar
From India, Bhubaneswar
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
From India, Delhi
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
2From India, Madras
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
From India, Delhi
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
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
Hi seniors formula of january month is wrong, but other’s months expected jan is correct,
From India, Dehra Dun
From India, Dehra Dun
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
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
Calculation of Attrition Rate.doc
Attrition-rate. xls