### Title

Calculating Turnover Rate

### Post

I currently have the following fields but not sure if this is working right , if someone can help, I appreciate it. It does not seem to calc right or I just cannot get my head around it. I only have 2 employees in this trial database and I am showing both were hired this year and one terminated . I just ran the 2 dates from 1/1/13 - 12/31/13 and it came up with 0.2 average employees, 1 terminated with a turnover rate of 439.8%. Calculating turnover rate seems confusion to me , cannot get my head around it. These are the fields I currently have and below that I am posting internet defination of calculating turnover rate. If anyone can help , I appreciate it.

Should the date fields be global?????

Field Type

averageEmployeesPeriod Calculation unstored, = Average ( Calendar::countemployees)

countTerminationsPeriod Calculation unstored,= Sum ( Calendar::countTerminations )

dateEnd Date

dateStart Date

turnover Calculation unstored, = countTerminationsPeriod / averageEmployeesPeriod

**Tally up terminations and firings.** To effectively calculate turnover, you should start with a total number of people who are not with the company anymore. Most businesses also involve those who voluntarily quit in their turnover numbers.

**Apply the number of lost employees to a specific time frame.** To calculate turnover, you will need to figure out the scope of the turnover instance at which you are looking. For example, if you can ascertain that 12 people left a business or department from January 1 of one year to January 1 of the next year, that turnover statistic will be 12 per annum

**Divide your turnover number by the total staff number.** In the above example, if the business has 60 employees, divide 12 by 60 to come up with the overall turnover percentage, which is 20 percent

Another defination for turnover

## Turnover: How do we calculate monthly turnover rates for our company?

Monitoring turnover is an important function of human resources. Companies like to monitor the movement of employees out of the organization so they can look for and minimize causes of turnover. Controlling turnover is one of the many quantitative ways the HR department can impact the bottom line.

The formula for calculating turnover on a monthly basis is figured by taking the number of separations during a month divided by the average number of employees on the payroll . Multiply the result by 100 and the resulting figure is the monthly turnover rate.

Example:

Number of separations during month

--------------------------------------------------- X 100

Average number of employees on payroll during the month

The number of separations during the month includes both voluntary and involuntary terminations. Do not include employees who are on layoff.

There are times when employers would like to calculate the annual turnover rate. This can be done by adding each of the monthly rates together. January + February+March+April ......+Dec = Annual Turnover rate.