turnover analysis

System · November 2006

we are using the formula: # terminations per month/average number of ee's per month x 100 to determine our monthly turnover. What is the best way to determine yearly turnover from those results? We have 13 companies- how do we determine turnover rates across all companies? Finding the sum of all companies together seems way to high- am I really looking for the average across companies?

System · November 2006

Turnover Rate (Annual)

# of employees exiting the job

÷

avg. actual # of employees during the period

x 12

÷ # mos. in period

durasupreme · November 2006

I use this formula to calculate turnover: # of terminations/# of average number of employees per month/# of months preparing data for (e.g. 10 through October) x 12.

pork1 · November 2006

needahero: I use a comparsion of last year's performance to this year's performance over the entire year. To do this I must start with last year's ending total of employees on-board(198); we do not count anyone leaving our employment before 90 days has been registered.

I have a spreadsheet that I will be glad to send by e-mail, you may use my e-mail to send me your e-mail address. I also use this report for a comparsion of W/C opportuniies over the entire year by month.

PORK

System · November 2006

Pork:

Yes- I would appreciate you emailing your spreadsheet to me. my email is [email]hr@mnw-inc.com[/email]

At the risk of sounding stupid, I do not understand how the turnover formulas above tell me how to determine turnover across companies. I have determined the turnover per month and per year for each of our 13 locations separately, but I want to determine a total turnover of our companies combined.

Is company wide yearly total turnover simply the average of total turnover of all companies?

System · November 2006

combine all employee separations for all companies, divide by average number of employees at all locations. Plug those numbers in the above formulas to get either a monthly turnover rate or the annual rate as indicated above.

shandy · November 2006

Hi Pork!

Would you mind forwarding your spread sheet to me also? We always have total confusion in trying to do the same thing at the beginning of each year. The HR Director, my boss, did this before I came on and I hate to say it, but her #'s just don't add up. Can't tell the boss she doesn't know how to figure it, but it's the truth!

Thanks,
Shandy

pork1 · November 2006

Shandy: Your e-mail icon is enabled; you need to send me a seperate e-mail with your address, so that I can tag the spreadsheet back to you.

PORK

shandy · November 2006

OOPS! My e-mail is [email]flipflopsnmb@netzero.com[/email]. Thanks!

HRVolley · November 2006

I would greatly apprciate the use of this spreadsheet.
[email]eyordy@fuse.net[/email]
Thanks!!

pork1 · November 2006

Shandy: Your e-mail is enabled, so use this e-mail to respond with your e-mail address.

PORK

CAHR · November 2006

Hi Pork! Could you please also send me your spreadsheet? Thanks so much!

CAHR · November 2006

Sorry...but I never did get the spreadsheet... not sure what happened... maybe can you send to me here at [email]Kterlau@carsonind.com[/email]? Thanks!!

Missie · November 2006

Would you send me the spreadsheet as well?

[email]puppyville4@yahoo.com[/email]

Sue2 · November 2006

I would also appreciate your spreadsheet.
Thanks!
[email]slong@gswsa.com[/email]

Sassy · November 2006

I would appreciate your spreadsheet as well. Thank you.
[email]ghcshr@gpcom.net[/email]

gingerflwrs · November 2006

[font size="1" color="#FF0000"]LAST EDITED ON 11-29-06 AT 10:04AM (CST)[/font][br][br]One more spreadsheet request...please.

Thanks so much.

Oops...forgot email - [email]rchamplain@impea.com[/email]

x:-8

gingerflwrs · November 2006

One more spreadsheet request...please.

Thanks so much.

[email]rchamplain@impea.com[/email]

Rockie · June 2007

Hey Pork!

This is an old email, but if you still have this spreadsheet, I'd appreciate a copy of it.Send to [email]scallender@scheart.com[/email]

Thanks!

3959635 · June 2007

[font size="1" color="#FF0000"]LAST EDITED ON 06-29-07 AT 06:16AM (CST)[/font][br][br]Yes another request for the spread sheet - it will be much appreciated

OOPS email address [email]llerche@duperon.com[/email] - please
Thanks

rcarter · June 2007

[font size="1" color="#FF0000"]LAST EDITED ON 06-28-07 AT 06:53AM (CST)[/font][br][br]Would you also share your spreadsheet with me too? I would greatly appreciate it. My email address is [email]recarter@fnbsouth.net[/email].

pork1 · November 2006

[font size="1" color="#FF0000"]LAST EDITED ON 11-29-06 AT 02:26PM (CST)[/font][br][br]HRHero's: I am sorry that I have not been able to spend more time on the network, but my company issues have to take first place, so I had to wean myself from this addiction. My righ hand woman found her man and he took her off to TN, where she has a new learning experience as a " Retirement Benefits Manager" for a very large company. I was able to replace her with another experienced HR and she is handling Payroll and pay issues. I picked up the W/C and it has really taken me a while to get loose of the loose ends, so that I might get back on-line with you guys and girls and HR Professionals. I will tune in when I can.

Richard and sometimes known as PORK!

cthr123 · November 2006

Hi PORK, one more request for your spreadsheet, please?? Please email to [email]hr@btarc.org[/email]

Thanks,
Cindy T.

ACU Frank · June 2007

Me too! Me too!

[email]fevans@alliancecu.com[/email]

neveradull · June 2007

Me too Please. [email]jimp@kcr.org[/email]

Lisa In Iowa · June 2007

Will you also share your turnover report with me, too?

[email]lisa.wolf@iwireless.com[/email]

Thanks!

ACU Frank · June 2007

This underscores the need for a "Files" repository here. That way, Pork could just upload once and we could get it as needed. My trade associate website has one, but you guys are smarter.

Catbert46 · June 2007

Could I please have a copy as well?
[email]ginger.mason@btol.com[/email]

Thanks!!

Texas Katz · June 2007

Greetings Pork!

Could you please send me your spreadsheet, too?

[email]kbrunner@prodigy.net[/email]

Many thanks from a wet, soggy Texan....k x:D

ray a · June 2007

You guys might want to email Pork directly. He doesn't stop in very often and he posted this last fall.

turnover analysis

Comments