hello i need to work out leavers attrition rates only but am confused...
can someone work a formular backwards and tell me how it was calculated..
if my closing headcount was 1736.... leavers were 33, how does that equate to 21%? annualised...(rounded up)
the same with the following...
closing 1081..leavers 14...result 18% annualsed.?
closing 1672 ..leavers 20...result 20% annulaised....
are these resultss correct..
also how do i calculate a rolling attrition rate/..
say i have leavers from month 1, plus leavers from month 2...and closing balance from month 2....what willbe the combined attrition for month 2..( annulised?)
does any one have a calulator sheet they can send me... i dont want to add averages , just confirmed leavers for the month against a closing headcount for the month...
this is very urget..helpppppppppppppppppppppp!!!
i have a caculation as per below..
(closing balance)plus a+b....a+b are leavers for 2 months /2 X12/100
is this correct
can someone work a formular backwards and tell me how it was calculated..
if my closing headcount was 1736.... leavers were 33, how does that equate to 21%? annualised...(rounded up)
the same with the following...
closing 1081..leavers 14...result 18% annualsed.?
closing 1672 ..leavers 20...result 20% annulaised....
are these resultss correct..
also how do i calculate a rolling attrition rate/..
say i have leavers from month 1, plus leavers from month 2...and closing balance from month 2....what willbe the combined attrition for month 2..( annulised?)
does any one have a calulator sheet they can send me... i dont want to add averages , just confirmed leavers for the month against a closing headcount for the month...
this is very urget..helpppppppppppppppppppppp!!!
i have a caculation as per below..
(closing balance)plus a+b....a+b are leavers for 2 months /2 X12/100
is this correct