Thread: Average employee number

Hi!

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...

Help!

Originally Posted by corington

Hi!

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...

Help!

so u have percent of people leave your company

thanks! So now... what about the next year? I start this year with some employees... How do they fit into the formula? eg. I start with 202 employees, recruit 549, end up with 306. What's the leave % then?

Originally Posted by corington

thanks! So now... what about the next year? I start this year with some employees... How do they fit into the formula? eg. I start with 202 employees, recruit 549, end up with 306. What's the leave % then?

hmmmm don't really get what u need do u know that u end up at the end of second year with 306 ? or ?

if u know that would be 306... just put again ...

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 :



where
H= how many did u have
S= how many did stay