Example: Turnover Report by Quarter

  1. With the Turnover Report displayed, select By Quarter.
  2. Use the back and forwards scroll buttons to select the time period you want to display. The chart and data table remain 12 quarters wide.

The calculation uses the same logic as that for monthly data; in place of months, substitute quarters. Each annualized turnover data point displayed on the line chart use the same calculation method:

  1. Calculate the average headcount over the previous 12 quarters:

    1. Take the starting headcount 12 quarters ago.
    2. Calculate the headcount at the end of the 12 quarter period by adding the total number of new hires and subtracting the total number of terminations.
    3. Add the starting headcount and the headcount at the end of the 12 quarters and divide by 2.
  2. Take the total number of terminations in the previous 12 quarters and divide it by the average headcount over the previous 12 quarters.
  3. Multiply the result by 100 to convert it to a percentage.

When repeated for each quarter through the year the calculation produces a rolling, quarter by quarter series of annualized turnover figures.