Attrition Rate Calculation - Xls Download

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

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

Yes Krishna you are right opening balance is present employees or closing balance of last month.

Can somebody help me with the proper division for salary structure ?Also what does closing balanace mean ?

There is no fix salary structure, It is depend on the organizational need accordingly salary structure is fixed in keeping view of taxes.

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

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.

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

Hi seniors
formula of january month is wrong, but other's months expected jan is correct,

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
[Login to view]