This is easy I'm sure, but I can't work it out - have tried several ways, but here's the one that is easiest to explain:
Let's say that my company starts the year with 0 employees. At the end it has 202. I recruited 346 new people during the year. I need to work out the percentage that leave so I can predict for next year.
So, that means I lost 144 (346-202). The average employee number over the year is 101 ([202-0]/2). So leave percentage is 144/101 = 143% but that's ridiculous...
thanks again... sorry to not explain well - I'm basically trying to work out a formula that would work out Leave % - sometimes we might not recruit anyone, so the above formula of End/Recruits wouldn't work as Recruits=0.
So for example, say we start with 1836, end with 1610, no recruits (so we lost 226). So leave % is clearly 226/1836 in this case (12%). So the number at the start is important, but we haven't taken it into account in the previous bits - I need a formula that works in all cases, it looks like it needs Start, End and Recruits in it but not sure how... I'm kind of assuming it needs average employee number in it somewhere.
if u need an average number of people that worked in company in one or more years u need to do this ...
number of people at the end of year let's say B and number at the start of year let's say A.... (that can be on any interval to calculate average of that interval ) average is let's say X
but if u need to know how much of ur people stay (in percentage) u need to know how much did u get to work (W) and how much did stay (S) and just put in :
where Y is percentage of those that stay the company
or to see how much did leave :
H= how many did u have
S= how many did stay