Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
I am new to this forum. I am looking for a formula to forecast staffing attrition. I'd like to come up with a projection so that we can overhire appropriate staffing allowing for sufficient recruiting and training time. Can anyone help me with such a formula, please?
Jan
Jan
Hello JanM: If you are not changing anything, then use the past year’s data as the best estimate for this year’s attrition data. Bob Gately
Bob,
Thank you and I will use last year's data. Can you tell me how to forecast an overhire number so that we can maintain full staffing? I have the attrition rate and possible retirement dates for the next five years.
Appreciate your help, thank you!
Jan
Thank you and I will use last year's data. Can you tell me how to forecast an overhire number so that we can maintain full staffing? I have the attrition rate and possible retirement dates for the next five years.
Appreciate your help, thank you!
Jan
Hello Jan:
Look at last year's attrition rate by month and assume it is the same for this year. Hire in anticipation of the next month's expected turnover. I'm sure that you'll be wrong each month but you'll be closer to what you need than if you don't anticipate turnover.
Bob Gately
Look at last year's attrition rate by month and assume it is the same for this year. Hire in anticipation of the next month's expected turnover. I'm sure that you'll be wrong each month but you'll be closer to what you need than if you don't anticipate turnover.
Bob Gately
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.
Add the url of this thread if you want to cite this discussion.
Attrition Rate formula.pdf
Attrition-rate_ 1__1__727.xls
