This document provides a worksheet for calculating cost per hire metrics according to the ANSI standard. It allows organizations to showcase their cost per hire calculations in a standardized visual layout. The author encourages sharing the worksheet to advocate for adoption of the ANSI standard. The worksheet is copyrighted but intended for free use to calculate and compare cost per hire metrics. Support is available from members of the workforce team that developed the ANSI standard.
1 of 6
More Related Content
ANSI CPH Worksheet
1. ABOUT THIS WORKSHEET
When completed in full, this worksheet enables any organization showcase their cost per hire
calculations per the suggested visual layout of the ANSI standard, and adopt the ANSI standard. The
author has designed this worksheet for widespread and public use. It is not part of the standard itself,
but simply a tool that allows for easy access, adoption, and engagement with the ANSI standard.
DISTRIBUTE AND SHARE THIS WORKSHEET FREELY
Users are encouraged to share this worksheet in order to advocate and adopt the standard. This
document was designed for free advocacy and adoption of the ANSI Cost Per Hire standard, and to
allow users to have an easy way to compare cost per hire metrics with other organizations and
internally.
This worksheet has been designed by Aspen Advisors, and is copyright protected. All rights of this
document are retained by Aspen Advisors. Any commercialization of this worksheet or its contents that
is performed without permission of Aspen Advisors is a violation of copyright law, and all parties that
are involved in such activities will be subject to legal action by Aspen Advisors.
USE THIS WORKSHEET FOR LIMITED DATA SEGMENTATION
This worksheet can be used to highlight the Cost Per Hire of a specific group, business or data
segment within an organization, just as easily as it can be used for an entire business or enterprise.
However, this worksheet does not offer the ability to showcase different data segments simultaneously.
For additional information on data segmentation regarding the ANSI Cost Per Hire standard, please
refer to section 10.3 of the standard.
ABOUT THE AUTHOR OF THE WORKSHEET
Andrew Gadomski is the CEO and Founder of Aspen Advisors, a strategic consulting company that
helps socially and globally responsible companies align and optimize their talent acquisition
organizations. Andrew was the Associate Workgroup Leader on the ANSI Cost Per Hire Standard, and
designed this tool to help advocate the standard. Andrew also leads a small group of workforce
members who worked on the standard that have decided to stay engaged and advocate the usage of
the standard. Andrew created this worksheet in the spirit of social responsibility and sustainability. The
worksheet is designed to make adoption readily available to all companies who want to engage the
ANSI standard, and lift any financial barriers in doing so.
SUPPORT IS AVAILABLE
Several members of the workforce team that designed the ANSI standard are available to help support
the standard and its usage. Andrew can be reached at Andrew@myaspenadvisor.com and he will
facilitate support with that group as requested. Additionally, several webinars and downloads are
available through several human resource associations that offer instruction on the adoption of the
ANSI standard.
VERSION 1.05
2. ANSI / SHRM 0006.2012 Cost Per Hire Comparable, Internal, and RCR
COMPILER / AUTHOR:
The suggested format for visually displaying a cost per hire metric was used.
裡(External Costs) + 裡(Internal Costs) COST PER HIRE, INTERNAL
Total Number of Hires in Time Period Date Range
Last Updated
Total Costs
Total Hires
Cost Details See below
裡(External Costs) + 裡(Internal Costs) COST PER HIRE, COMPARABLE
Total Number of Hires in Time Period Date Range
Last Updated
Total Costs
Total Hires
Cost Details See below
裡(External Costs) + 裡(Internal Costs) RCR, INTERNAL
Date Range
Last Updated
Total Costs
Total Hires
Total Compensation
Cost Details See below
裡(External Costs) + 裡(Internal Costs) RCR, COMPARABLE
Date Range
Last Updated
Total Costs
Total Hires
Total Compensation
Cost Details See below
RCRC=
Total 1st Year Compensation
CPHI=
of Hires in Time Period
STANDARDS IMPLEMENTED
DOCUMENTATION UPDATED
CPHC=
GENERAL INFORMATION:
RCRI=
of Hires in Time Period
Total 1st Year Compensation
(" )"
(" )"
(" )"
(" )"
2372
01/05/12
01/05/12
Chris Smith,
chris@ABCcompany.com
-
01/05/12
04/01/12
01/05/12
06/01/12
06/01/12
06/01/12
$ 0.00
04/01/12
04/01/12
04/01/12 06/01/12
01/05/12
$ 0.00
-
-
-
This document is designed as a counterpart to the ANSI Standard for Cost Per Hire. Download a published version of the standard.
This document is updated on a regular basis. This version has been updated as of April 19, 2012. It is version 1.05. Verify this is the latest version
of the worksheet by downloading the most recent version.
VERSION 1.05
$ 73,600.00
$ 118,600.00
0.00%
$ 118,600.00
0.00%
50
1472
50
50
50
$ 73,600.00
3. SUPPORTING DOCUMENTATION
KNOWN ISSUES
REPRESENTATIVE DATA SET
DESCRIPTION OF THE NUMBER OF HIRE DATA USED
(denominator):
DATA QUALITY STATEMENT
[EXAMPLE ONLY] This data set represents the hires that were performed over the last year (Jan 2011 to Dec
2012) for the entire global business. It includes all departments, all businesses, and all full time and part time
hires. The data was gathered from the ATS and an analysis of the general ledger, cost centers, and expenses. All
costs have been validated and quality checked.
[EXAMPLE ONLY] The data used for # hires was taken from our HRIS system (iVantage) for the time period
selected.
VERSION 1.05
This document is designed as a counterpart to the ANSI Standard for Cost Per Hire. Download a published version of the standard.
This document is updated on a regular basis. This version has been updated as of April 19, 2012. It is version 1.05. Verify this is the latest version
of the worksheet by downloading the most recent version.
[EXAMPLE ONLY] It is our process during the calculation
of this metric to analyze the data for inconsistencies as
follows:
External costs that are incurred as an annual fee are
prorated for the time period selected. Example: Resume
access contract is $6,000 annually, and the report is for 6
months. This cost would be calculated as $6,000 / 12
months x 6 = $3,000 for the 6 months.
To look for missing cost data, we review recruiting costs in
the general ledger and in
the HRIS system and ask the following questions:
> Is there usually a cost for this type of hire that we do not
see in our data?
> Is there an unusually low cost for a usually expensive
hire?
To look for data errors and anomalies, we review
recruiting costs and ask the following questions:
> Are there any expenses in the general ledger that have
been miscategorized?
> Are there higher than normal expenses on a typically
lower-cost hire type?
>Are there expenses that are counted in this reporting
period that are actually used
year-round?
[EXAMPLE ONLY] The compiler of this metric
acknowledges that the following issues have been
identified with the data. Although these issues do not
affect the use of the metric, the compiler wishes to ensure
that reviewers are aware of the following:
> In partnering with Finance, we have determined that
although travel costs may be more comprehensive using
the general ledger system, it does not routinely capture
expenses run through our employee expense system. We
have decided to use the travel and expense system for
those costs, understanding that some costs (expected to
be trivial) are not captured in the system.
> Our newly acquired company, Company X, is not yet on
our talent acquisition system. We have decided to use the
same metric calculations for Company X, reported
separately until it is fully integrated into our systems,
estimated to be completed in Q2 2011.
> Third-party agency fees are known to be within 5%
accurate, as one division is not directly using central
recruiting for all hiring needs.
4. DESCRIPTION OF COST FACTORS USED:
EXTERNAL COSTS DATA SOURCE
DATE DATA QUALITY
CHECKED
COST CENTER / NOTES
Advertising and Marketing
Expenses
Background Checks and
Eligibility to Work Expenses
Campus Recruiting
Expenses
Contingency Fees
Drug Testing Expenses
Employee Referral Awards/
Payments
Job Fair/Recruiting Event
Expenses
Pre-screening Fees
Relocation Fees
Sourcing Costs
Travel and Expenses,
Candidate
Travel and Expenses,
Recruiting
Technology Costs
Third-party Agency Fees
INTERNAL COSTS DATA SOURCE
DATE DATA QUALITY
CHECKED
COST CENTER / NOTES
Cost of Recruiting Staff
Cost of Sourcing Staff
Non-labor Office Costs
Recruiting Learning and
Development
Internal Overhead for
Government Compliance
Secondary Management
Cost of Time
from Bernard HodesReceipts
Vendor Report
General Ledger
General Ledger
Vendor Invoices
General Ledger
Cost Center
Vendor Report
Cost Center
Estimated
Estimated
Estimated
General Ledger
General Ledger
06/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
01/01/12
Payroll
Payroll
General Ledger
Cost Center
Vendor Report
Estimated
VERSION 1.05
This document is designed as a counterpart to the ANSI Standard for Cost Per Hire. Download a published version of the standard.
This document is updated on a regular basis. This version has been updated as of April 19, 2012. It is version 1.05. Verify this is the latest version
of the worksheet by downloading the most recent version.
5. EXTERNAL COSTS
Advertising and Marketing Expenses
Background Checks / Eligibility to Work
Campus Recruiting Expenses
Consulting Services*
Contingency Fees: Contingent to Regular*
Drug Testing Expenses
Employee Referral Awards / Payments
Immigration Expenses*
Job Fair / Recruiting Event Expenses
Pre-hire Health Screens*
Pre-screening Fees*
Recruitment Process Outsourcing (RPO) Fees
Relocation Fees*
Sign-on Bonuses*
Recruitment process / efficiency
EEO consulting / fees
Legal fees associated with recruiting
Other (specify as needed)
Legal fees
Fees for consulting services
Fees for federal applications
Other (specify as needed)
Health screens fees / costs
Background checks fees and services
Tertiary screening, assessments, or testing fees and services
Reference checks fees and services
I9 / E-Verify / Validations fees and services
Other (specify as needed)
Indirect costs (for healthcare providers only)
Other (specify as needed)
Testing Services
Validated Assessments
Event fees or tickets
Booth and rental costs
Labor, shipping, construction, assembly
Other (specify as needed)
Other (specify as needed)
Employment Branding Vendor Fees - any that are not included above
Other (specify as needed)
Travel and Expenses (not included in summation / tracking only)
Expense (specify as needed)
Expense (specify as needed)
Job Board Expenses - job postings, advertisements, special placement
Social Media Expenses - facebook, linkedin, twitter, youtube, other
Search Engine Marketing - optimization, landing pages, keyword purchases
Marketing Material Production - brochures, displays, etc
Website(s) - career pages, landing pages, email messaging
Print Media - newspaper ads, magazine ads, specialized print
$ 73,600.00
$ 73,600.00
exceptions here
$ 10,000.00
$ 0.00
$ 2,000.00
$ 0.00
$ 60,000.00
$ 0.00
$ 600.00
$ 1,000.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
VERSION 1.05
Expenses marked with an asterisk (*) will be used during the calculation of the Cost Per Hire Internal only.
This document is designed as a counterpart to the ANSI Standard for Cost Per Hire. Download a published version of the standard.
This document is updated on a regular basis. This version has been updated as of April 19, 2012. It is version 1.05. Verify this is the latest version
of the worksheet by downloading the most recent version.
6. Sourcing Costs
Technology Costs
Travel and Expenses
Third-party Agency Fees
INTERNAL COSTS
Cost of Recruiting Staff
Cost of Sourcing Staff
Internal Overhead for Government Compliance*
Non-labor Office Costs
Recruiting Learning and Development
Secondary Management Cost of Time*
Events / Job Fairs Interviews: Internal Rate:
Requisitions / Normal Business Interviews: Internal Rate:
NUMBER OF HIRES IN TIME PERIOD
Requisitions Executed - Full Time - Internal Hires
Requisitions Executed / Full Time - External Hires
Requisitions Executed / Part Time - Internal Hires
Requisitions Executed / Part Time - External Hires
Temporary Staff Already on Payroll Converted to Full Time
Other (excluded from types above, and NOT included in any CPH calculations)
Supplemental workers, agency staff, contractors not on payroll
Employee contracts that automatically renew
Temporary assignments, secondments, or rotation hires
Hires that were executed in systems as part of restructure or reclassification
Percentage of overall office costs based on headcount
Other (specify as needed)
Full Time Sourcers
Part Time Sourcers
Contract Sourcers
Other (specify as needed)
Direct Office Expenses
Candidate T&E
Recruiter T&E
Other (specify as needed)
Full Time Recruiters
Part Time Recruiters
Contract Recruiters
Other (specify as needed)
Membership dues for associations
Networking services
Other (specify as needed)
Applicant Tracking Systems (CRM)
Candidate Relationship Management Systems (CRM)
Metrics, Reporting, and Business Intelligence Systems (BI)
List purchases, research lists, purchased contacts
Database licensing access - includes LinkedIn Recruiter, Jigsaw, and others
$ 0.00
$ 45,000.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 45,000.00
$ 45,000.00
$ 0.00
300 $ 150.00
0 $ 0.00
50
10
10
10
10
10
8
2
2
2
2
VERSION 1.05
Expenses marked with an asterisk (*) will be used during the calculation of the Cost Per Hire Internal only.
This document is designed as a counterpart to the ANSI Standard for Cost Per Hire. Download a published version of the standard.
This document is updated on a regular basis. This version has been updated as of April 19, 2012. It is version 1.05. Verify this is the latest version
of the worksheet by downloading the most recent version.