This tool is comprised of five worksheets as outlined below. Please click on the "Inputs" link below to begin.

HR Metrics Benchmarking Worksheet

3
4
5
This page shows a graphical display of your metrics benchmarked against those of comparable companies of the size
and industry you selected on the Inputs Worksheet.
Benchmarks by Size and
Industry
Lists benchmarks for all metrics by company size.
Lists benchmarks for all metrics by company industry.
Size Benchmarks
Industry Benchmarks
Source for all metrics including benchmarks, definitions, and formulas except Time-to-Fill are from the CEB HR Leadership Council's 2010 Budget, Spend &
Efficiency Survey and the Corporate Leadership Council's Turnover Benchmarking Survey. Time-to-fill benchmarks and definitions were obtained from the
SHRM Human Capital Benchmarking Study 2006 Executive Summary.
HR Management & Strategy Design & Execution Center
This tool provides a personalized scorecard with size and industry benchmarks for metrics in four key competency areas of HR performance: HR-
Employee Staffing Ratios, HR Cost Ratios, Workforce Turnover, and Recruiting and Training Efficiency.
Displays your HR metrics in four categories based on the inputs you provided from the previous page. To the left of
each number, the metric name and formula are shown. All metrics calculation is done by Excel after you enter the
inputs.
Inputs
Your Metrics Roster
1
2
Provides instructions and space for entering key HR measurement inputs that will drive metric calculation later in the
tool. This page also allows you to select your company size and industry so you can view personalized benchmarking
graphs.
HR Metrics Worksheet
HR Management & Strategy Design & Execution Center
Metric Inputs and Definitions
Input Definition Your Number
Human Resources Function
Operating Expense
The HR department's total operating expense for the last fiscal year. Included are those expense items for the traditional HR functions (e.g.
Compensation, Benefits, Staffing, Employee Relations, Training). Include all expenses that would be charged to the HR Budget. Exclude training
expenses funded outside of HR (e.g., by the business unit).
$700,000
Human Resources Function
FTEs
The total number of full time human resources employees. This includes anyone staffed within the HR department, even in non-traditional HR roles
such as internal communications or employee training staff.
30
Involuntary Separations
Total number of employees involuntarily separated during the last fiscal year. An involuntary separation is one that is initiated by the organization
rather than the employee.
10
Staffing Expense
The total cost incurred during the last fiscal year for all staffing activities. Included are advertising costs, agency fees, referral bonuses,
relocation/travel costs, job fair expenses, college-recruiting -related expenses, salaries and benefits costs for the HR staffing function, etc. Excluded
are hiring bonuses.
$800,000
Total Days Until Positions Filled
Added together for each available position that was filled during the last fiscal year, the number of days from when a job requisition was opened until
the offer was accepted by a candidate. This number is calculated using calendar days, including weekends and holidays.
9,000
Total Employees
The average monthly number of all full-time and part-time employees on staff during the last fiscal year. Excluded are temporary and contract
workers (individuals who work on company premises and under company supervision, but who are sponsored and paid by temporary help
organizations).
4000
Total FTE Employees
The average monthly number of all full-time and full-time equivalent (FTE) employees. Part-time employees are those who work less than the
normal hours per week. To convert part-timers to FTEs, sum all part-time hours and divide by baseline annual hours (e.g. 40 weekly hours x 52
weeks = 2080 annual hours). This number is then added to the number of total full-time employees to give you the total full-time equivalent (FTE)
employees. Excluded are temporary and contract workers.
3500
Total Hires
The total number of employees hired during the last fiscal year. A hire is considered to be the addition of an employee to the payroll. Excluded are
employees reinstated after returning from a leave of absence and employees who have transferred within the organization.
300
Total Separations
The total number of employees separated during the last fiscal year, whether voluntary or involuntary. A separation includes any employee who is
removed from payroll, including those employees collecting severance benefits. Excluded are those employees on leave of absence or those who
have transferred within the organization, and temporary/contact workers.
350
Training Expense
Training expenses include organizational development and effectiveness, leadership development, diversity, work-life, and succession planning. Also
include training staff travel expenses, administrative expenses, and delivery expenses. Excludes training expenses not funded by HR. These
expenses include the compensation and benefits cost for all HR staff specializing in this function directly.
$900,000
Voluntary Separations
The total number of employees voluntarily separated during the last fiscal year. A voluntary separation is one that is initiated by the employee rather
than the organization and includes those resulting from voluntary retirement, illness, or death. Excluded are temporary/contract workers.
200
Please enter your company name
in the next cell:
Your Company
Please select your company size
Please select your company industry
After you enter the relevant information, this tool will provide you with a personalized scorecard and graphical representations benchmarked by your
company size and industry. Please fill in the following input numbers under the "Your Number" (rightmost) column below and answer the three questions
at the bottom of this worksheet to specify your company name, size and industry. To assist you in calculating the inputs, the definitions for each figure
are also provided below.
Please insert your input
numbers below
Less than 1,000 FTEs
Financial Oil & Gas/Mining/Energy Technology Professional Services
Utilities
Banking & Insurance
1,000 - 1,999 FTEs 2,000 - 4,999 FTEs
5,000 - 10,000 FTEs 10,000+ FTEs
Total Number of Employees per Human Resources Function
FTE Employee
Total Number of Employees/ Number of Human Resources
Function FTE Employees
133
Total FTE Employees per Human Resources Function FTE
Employees
Total Number of FTE Employees/ Number of Human
Resources Function FTE Employees
117
Number of Separations as a Percent of Total Number of
Employees
(Number of Total Separations/ Total Number of Employees)
x 100
8.8%
Number of Involuntary Separations as a Percent of Total
Number of Employees
([Number of Total Separations - Number of Voluntary
Separations] / Total Number of Employees) x 100
3.8%
Number of Voluntary Separations as a Percent of Total
Number of Employees
(Number of Voluntary Separations / Total Number of
Employees) x 100
5.0%
Number of Hires as a Percent of Total Number of Employees
(Hiring Rate)
(Number of Hires/ Total Number of Employees) x 100 7.5%
Staffing Expense per Hire (Cost per Hire) Staffing Expense/ Total Hires $2,667
Average Time to Fill Total Days Until Positions Filled/ Total Hires 30
Training Expense per FTE Employee Training Expense/ Total Number of FTE Employees $257
Training Expense per Employee Training Expense/ Total Number of Employees $225
Human Resources Function Operating Expense per Employee
Human Resources Function Operating Expense/ Total
Number of Employees
$175
Human Resources Function Operating Expense per FTE
Employee
Human Resources Function Operating Expense/ Total
Number of FTE Employees
$200
Human Resources Function Operating Expense per Human
Resources Function FTE Employee
Human Resources Function Operating Expense / Number of
Human Resources Function FTE Employees
$23,333
This worksheet displays key HR metrics in four categories based on the inputs you provided from the previous page. To the left of each
number, the metric name and formula for calculation are displayed. The third column displays your number as calculated from the inputs column
on the previous page.
HR Metrics Worksheet
HR Management & Strategy Toolkit
Your Metrics Roster
Formula Your Number
HR Operating
Expense Ratios
Hiring and Training
Time and Expense
Category
HR-Employee
Staffing Ratios
Turnover Rates
Metric
HR Metrics Worksheet
HR Management & Strategy Toolkit
Benchmarks for: Less than 1000 Employees Financial
This page displays selected graphical outputs of your company metrics benchmarked against comparable companies of the size (left
hand column) and industry (right hand column) that you selected on the "Inputs" worksheet. Members can copy the graphs below and
paste them into dashboard reports and business presentations, or simply print them from this sheet for personal or departmental use.
HR-Employee Staffing Ratios
Benchmarks by Size
Turnover Rates
Benchmarks by Industry
Benchmarks by Industry Benchmarks by Size
$78
$67
133
$0
$40
$80
$120
$160
Average by Size Median by Size Your Company
T
o
t
a
l

E
m
p
l
o
y
e
e
s

/

H
R

F
T
E

E
m
p
l
o
y
e
e
s

Total Number of Employees per
HR Function FTE Employee Benchmark by Size
68
71
133
0
40
80
120
160
200
240
Average by
Industry
Median by
Industry
Your Company
T
o
t
a
l

E
m
p
l
o
y
e
e
s

/

T
o
t
a
l

H
R

F
u
n
c
t
i
o
n

F
T
E

E
m
p
l
o
y
e
e
s

Total Number of Employees per HR Function FTE
Employee Benchmark by Industry
19.49%
15.01%
8.8%
0.00%
5.00%
10.00%
15.00%
20.00%
25.00%
Average by Size Median by Size Your Company S
e
p
a
r
a
t
i
o
n
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Number of Separations as a
Percent of Total Number of Employees
Benchmark by Size
20.14%
15.45%
8.8%
0.00%
5.00%
10.00%
15.00%
20.00%
25.00%
Average by Median by Your Company
S
e
p
a
r
a
t
i
o
n
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Number of Separations as a
Percent of Total Employees
Benchmark by Industry
Turnover Rates
Benchmarks by Size Benchmarks by Industry
13.35%
11.80%
7.5%
0.00%
2.00%
4.00%
6.00%
8.00%
10.00%
12.00%
14.00%
16.00%
Average by
Size
Median by Size Your Company
H
i
r
e
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Number of Hires as a Percent of
Total Number of Employees
Benchmark by Size
18.12%
14.95%
7.5%
0.00%
2.00%
4.00%
6.00%
8.00%
10.00%
12.00%
14.00%
16.00%
18.00%
20.00%
Average by
Industry
Median by
Industry
Your Company
H
i
r
e
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Number of Hires as a
Percent of Total Number of Employees Benchmark by
Industry
0.00%
Average by Size Median by Size Your Company S
e
p
a
r
a
t
i
o
n
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s
5.96%
4.77%
3.8%
0.00%
2.00%
4.00%
6.00%
8.00%
Average by Size Median by Size Your Company
I
n
v
o
l
u
n
t
a
r
y

S
e
p
a
r
a
t
i
o
n
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Number of Involuntary Separations as a
Percent of Total Employees
Benchmark by Size
13.02%
8.44%
5.0%
0.00%
4.00%
8.00%
12.00%
16.00%
Average by
Size
Median by Size Your Company
V
o
l
u
n
t
a
r
y

S
e
p
a
r
a
t
i
o
n
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Number of Voluntary Separations as a
Percent of Total Employees
Benchmark by Size
0.00%
Average by
Industry
Median by
Industry
Your Company
S
e
p
a
r
a
t
i
o
n
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s
7.29%
5.04%
3.8%
0.00%
4.00%
8.00%
12.00%
Average by
Industry
Median by
Industry
Your Company
I
n
v
o
l
u
n
t
a
r
y

S
e
p
a
r
a
t
i
o
n
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Number of Involuntary Separations as a Percent of
Total Employees
Benchmark by Industry
12.95%
8.48%
5.0%
0.00%
4.00%
8.00%
12.00%
16.00%
Average by
Industry
Median by
Industry
Your Company V
o
l
u
n
t
a
r
y

S
e
p
a
r
a
t
i
o
n
s

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Number of Voluntary Separations as a Percent of
Total Employees
Benchmark by Industry
Benchmarks by Size Benchmarks by Industry
Hiring and Training Time and Expense
Average by
Size
Median by Size Your Company
$4,944
$2,791
$175
$400
$800
$1,200
$1,600
$2,000
$2,400
$2,800
$3,200
$3,600
$4,000
$4,400
$4,800
$5,200
H
R

O
p
e
r
a
t
i
n
g

E
x
p
e
n
s
e

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Human Resources Function
Operating Expense Per Employee
Benchmark by Size
Industry Industry
$11,128
$3,078
$175
$400
$800
$1,200
$1,600
$2,000
$2,400
$2,800
$3,200
$3,600
$4,000
$4,400
$4,800
$5,200
$5,600
$6,000
$6,400
$6,800
$7,200
$7,600
$8,000
$8,400
$8,800
$9,200
$9,600
$10,000
$10,400
$10,800
$11,200
$11,600
$12,000
H
R

F
u
n
c
t
i
o
n

O
p
e
r
a
t
i
n
g

E
x
p
e
n
s
e

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Human Resources Function
Operating Expense Per Employee
Benchmark by Industry
$2,710
$2,512
$2,667
$2,400
$2,450
$2,500
$2,550
$2,600
$2,650
$2,700
$2,750
Average by
Size
Median by Size Your Company
E
x
p
e
n
s
e

/

H
i
r
e

Staffing Expense Per Hire
Benchmark by Size
$7,086
$2,590 $2,667
$0
$1,000
$2,000
$3,000
$4,000
$5,000
$6,000
$7,000
$8,000
Average by
Industry
Median by
Industry
Your Company
S
t
a
f
f
i
n
g

E
x
p
e
n
s
e

/

H
i
r
e

Staffing Expense per Hire
Benchmark by Industry
$1,163
$185
$225
$0
$200
$400
$600
$800
$1,000
$1,200
$1,400
Average by Size Median by Size Your Company
T
r
a
i
n
i
n
g

E
x
p
e
n
s
e

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Training Expense per Employee
Benchmark by Size
$263
$225
$0
$400
$800
$1,200
Average by
Industry
Median by
Industry
Your Company
T
r
a
i
n
i
n
g

E
x
p
e
n
s
e

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s

Training Expense per Employee
Benchmark by Industry
HR Operating Expense Ratios
$175
$0
$400
$800
$1,200
Average by
Size
Median by Size Your Company
H
R

O
p
e
r
a
t
i
n
g

E
x
p
e
n
s
e

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s
$4,856
$2,520
$200
$0
$1,000
$2,000
$3,000
$4,000
$5,000
$6,000
Average by Size Median by Size Your Company
H
R

O
p
e
r
a
t
i
n
g

E
x
p
e
n
s
e
/

F
T
E

E
m
p
l
o
y
e
e
s

Human Resources Function Operating Expense per
FTE Employee
Benchmark by Size
$265,803
$136,917
$23,333
$0
$40,000
$80,000
$120,000
$160,000
$200,000
$240,000
$280,000
Average by Size Median by Size Your Company
H
R

O
p
e
r
a
t
i
n
g

E
x
p
e
n
s
e

/

H
R

F
T
E

E
m
p
l
o
y
e
e
s

Human Resources Function Operating Expense per Human
Resources Function FTE Employee
Benchmark by Size
$175
$0
$400
$800
$1,200
$1,600
$2,000
$2,400
Average by
Industry
Median by
Industry
Your Company
H
R

F
u
n
c
t
i
o
n

O
p
e
r
a
t
i
n
g

E
x
p
e
n
s
e

/

T
o
t
a
l

E
m
p
l
o
y
e
e
s
$12,125
$2,236
$200
$0
$2,000
$4,000
$6,000
$8,000
$10,000
$12,000
$14,000
Average by
Industry
Median by
Industry
Your Company
H
R

O
p
e
r
a
t
i
n
g

E
x
p
e
n
s
e

/

T
o
t
a
l

F
T
E

E
m
p
l
o
y
e
e
s

Human Resources Function Operating Expense per FTE
Employee
Benchmark by Industry
$767,388
$219,462
$23,333
$0
$40,000
$80,000
$120,000
$160,000
$200,000
$240,000
$280,000
$320,000
$360,000
$400,000
$440,000
$480,000
$520,000
$560,000
$600,000
$640,000
$680,000
$720,000
$760,000
$800,000
$840,000
Average by
Industry
Median by
Industry
Your Company
H
R

F
u
n
c
t
i
o
n

O
p
e
r
a
t
i
n
g

E
x
p
e
n
s
e

/

H
R

F
T
E

E
m
p
l
o
y
e
e
s

Human Resources Function Operating Expense per Human
Resources Function FTE Employee Benchmark by Industry
Percent of Total Number of Employees Benchmark by
Your Company
Your Company
Human Resources Function Operating Expense per FTE
$23,333
Your Company
Human Resources Function Operating Expense per Human
Resources Function FTE Employee Benchmark by Industry
Total Number of Employees per Human Resources
Function FTE Employee
Average: 78.
Median: 67
Average: 92
Median: 77
Average: 78 Median:
69
Average: 78
Median: 71
Total FTE Employees per Human Resources
Function FTE Employees
Average: 77
Median: 66
Average: 87
Median: 76
Average: 74 Median:
69
Average: 75
Median:71
Number of Separations as a Percent of Total
Number of Employees
Average: 19.49%
Median: 15%
Average: 18.02 %
Median: 15%
Average: 18.16%
Median:14.5%
Average: 16.58%
Median: 7%
Number of Involuntary Separations as a Percent of
Total Number of Employees
Average: 5.96%
Median: 4.8%
Average: 7.14%
Median: 9.8%
Average: 7.81%
Median: 5.6%
Average: 5.67%
Median: 3%
Number of Voluntary Separations as a Percent of
Total Number of Employees
Average: 13.02%
Median: 8.4%
Average: 10.88%
Median: 7.6%
Average:10.47%
Median: 8.7%
Average: 10.91%
Median: 4%
Number of Hires as a Percent of Total Number of
Employees
Average: 13.35%
Median: 11.8%
Average: 17.68%
Median: 13.5%
Average: 17.22%
Median: 13.4%
Average:16.57%
Median: 14.8%
Staffing Expense per Hire (Cost per Hire)
Average: $2710
Median: $2512
Average: $2361
Median: $1879
Average: $3803
Median: $2645
Average: $2548
Median: $2637
Average Time to Fill *
Average: 37
Median: 30
Average: 37
Median: 30
Average: 37 Median:
30
Average: 37
Median: 30
Training Expense per FTE Employee
Average: $14900
Median: $191
Average: $617
Median: $325
Average: $547
Median: $241
Average: $707
Median: $428
Training Expense per Employee
Average: $1163
Median: $185
Average: $505
Median: $279
Average: $424
Median: $247
Average: $399
Median: $407
Human Resources Function Operating Expense per
Employee
Average: $4,944
Median: $2,791
Average: $2,045
Median: $1,942
Average: $2,618
Median: $2,624
Average: $2,378
Median: $1,990
Human Resources Function Operating Expense per
FTE Employee
Average: $4,856
Median: $2,520
Average: $2,247
Median: $2,101
Average: $2,660
Median: $2,456
Average: $2,393
Median: $1,803
Human Resources Function Operating Expense per
Human Resources Function FTE Employee
Average: $265,803
Median: $136,917
Average: $174,958
Median: $156,928
Average: $195,855
Median: $189,303
Average: $168,029
Median: $148,181
*Average Time to Fill is not available by size differential. Averages and medians are listed as the same across the different sizes.
HR-Employee Staffing
Ratios
Turnover Rates
Hiring and Training Time
and Expense
HR Operating Expense
Ratios
1,000 - 1,999 FTEs 2,000 - 4,999 FTEs 5,000 - 9,999 FTEs
HR Metrics Worksheet
HR Management & Strategy Toolkit
Benchmark by Size
Category Metric Less than 1000 FTEs
Average: 77
Median: 73
Average: 76
Median: 70
Average: 22.31%
Median: 17%
Average: 7.80%
Median: 6.9%
Average: 14.44%
Median: 10.2%
Average: 16.72%
Median:12.4%
Average: $2961
Median: $2367
Average: 37
Median: 30
Average: $408
Median: $205
Average: $353
Median: $206
Average: $3,107
Median: $2,539
Average: $3,324
Median: $2,581
Average: $197,396
Median: $189,231
10,000+ FTEs
Total Number of Employees per Human
Resources Function FTE Employee
Average: 68 Median:
71
Average: 179
Median: 55
Average:98
Median: 81
Average: 88
Median: 71
Average: 83
Median: 59
Average: 67
Median: 69
Total FTE Employees per Human Resources
Function FTE Employees
Average: 66
Median: 68
Average: 204
Median: 69
Average: 90
Median: 59
Average: 87
Median: 80
Average: 90
Median: 87
Average: 60
Median: 58
Number of Separations as a Percent of Total
Number of Employees
Average: 20.14%
Median: 15.45%
Average: 21.37%
Median: 11.26%
Average: 13.33%
Median: 12.67%
Average: 26.44%
Median: 32.16%
Average: 7.96%
Median: 8.35%
Average: 23.20%
Median: 19.72%
Number of Involuntary Separations as a Percent
of Total Number of Employees
Average: 7.29%
Median: 5.04%
Average: 13.55%
Median: 3.93%
Average: 5.13%
Median: 4.87%
Average: 8.06%
Median: 6.87%
Average: 1.86%
Median: 1.81%
Average: 1.71%
Median: 7.86%
Number of Voluntary Separations as a Percent of
Total Number of Employees
Average: 12.95%
Median: 8.48%
Average:7.83%
Median: 6.69%
Average: 7.87%
Median: 7.31%
Average: 22.36%
Median: 23.43%
Average: 6.10%
Median: 6%
Average: 15.53%
Median: 12.10%
Number of Hires as a Percent of Total Number of
Employees
Average: 18.12%
Median: 14.95%
Average: 17.11%
Median: 10.59%
Average: 17.83%
Median: 15.63%
Average: 12.31%
Median: 11.55%
Average:5.37%
Median: 4.75%
Average: 15.63%
Median: 15.64%
Staffing Expense per Hire (Cost per Hire)
Average: $7,086
Median: $2,590
Average: $6,510
Median: 4,181
Average: $4,158
Median: $4,290
Average: $2,109
Median: $2,083
Average: $2,354
Median: $3,308
Average: $3,177
Median: $3,210
Training Expense per FTE Employee
Average: $1,465
Median: $345
Average: $1,114
Median: $474
Average: $294
Median: $368
Average: $189
Median: $172
Average: $155
Median: $116
Average: $786
Median: $453
Training Expense per Employee
Average: $1340
Median: $263
Average: 985
Median: 392
Average: $292
Median: $124
Average: $183
Median: $167
Average: $312
Median: $238
Average: $723
Median: $448
Human Resources Function Operating Expense
per Employee
Average: $11,128
Median: $3,078
Average: $5,964
Median: $110
Average: $2,052
Median: $1,498
Average: $2,084
Median: $1,574
Average: $2,394
Median: $2,499
Average: $2,769
Median: $2,293
Human Resources Function Operating Expense
per FTE Employee
Average: $12,125
Median: $2,236
Average: $6,014
Median: $3,434
Average: $2,073
Median: $1,594
Average: $1,963
Median: $1,605
Average: $2,293
Median: $2,373
Average: $3,025
Median: $2,322
Human Resources Function Operating Expense
per Human Resources Function FTE Employee
Average: $767,388
Median: $219,462
Average: $198,692
Median: $156,075
Average: $199,254
Median: $223,987
Average: $147,722
Median: $163,859
Average: $203,886
Median: $186,716
Average: $161,163
Median: $139,066
* Industry benchmarks for Time-to-Fill are not available
Hiring and Training
Time and
Expense *
HR Operating
Expense Ratios
Category
HR-Employee
Staffing Ratios
Turnover Rates
Oil &
Gas/Mining/Energy
Technology
HR Metrics Worksheet
HR Management & Strategy Toolkit
Benchmark by Industry
Professional Services Utilities Banking/Insurance Metric Finance