Calculating Employee Turnover Using Excel

Employee Turnover is a measure of how well an organization is hiring and retaining talent. A high turnover indicates that the organization is not hiring the right people & is not able to retain talent possibly due to inadequate working atmosphere, less pay etc.

Below data shows the employment changes in an organization over 12 month period. New hires are added and separations are subtracted from the number of employees at the beginning of the month to get the ending employee count.

 

How it works:

 

Employee turnover is the ratio of separations to average monthly employment. The Average function is used to calculate the average ending count of employees over the months. Separations are calculated using SUM and are divided by the average monthly employments.

The result can be compared to industry averages or companies in the same industry. Different industries experience different turnover rates, so comparing them can lead to poor decisions.

Do share your views in comments section.[Download not found]

 

Be the first to comment

Leave a Reply

Your email address will not be published.


*