sourcetable

Calculate Cost Per Hire

Calculate anything using Sourcetable AI. Tell Sourcetable what you want to calculate and see your results in a spreadsheet.


Learn more
Jump to

Introduction

Understanding the cost per hire is crucial for optimizing recruitment strategies and budgeting effectively within human resources departments. This metric encompasses all expenses associated with the recruitment process, from advertising job openings to the onboard training of new employees. Calculating cost per hire helps organizations measure the efficiency and effectiveness of their hiring procedures. Employers who track this key performance indicator can strategically adjust their recruitment efforts to save costs while attracting top talent.

Sourcetable simplifies this essential calculation, offering a unique AI-powered spreadsheet assistant designed specifically for such HR metrics. By providing tools that automate data collection and analysis, Sourcetable helps HR professionals and recruiters effortlessly monitor and optimize their hiring costs. We'll explore how Sourcetable lets you calculate cost per hire and more using its AI-powered spreadsheet assistant, which you can try at app.sourcetable.com/signup.

sourcetable

How to Calculate Cost Per Hire

To effectively determine your cost per hire, follow a systematic approach that includes data collection, analysis, and calculation. Start by gathering data on both internal and external recruitment expenditures.

Gathering Recruitment Costs

Compile internal recruiting costs such as salaries of the talent acquisition team and hiring managers, and spending on learning and development for recruitment purposes. For external costs, account for expenses like agency fees, job board postings, and costs related to assessment centers and relocation. Place these costs in separate columns in a spreadsheet to maintain organization.

Calculating Total Costs

Sum the internal and external costs to find the total recruitment expenses. This can be formulaically represented as (total internal costs + total external costs).

Determining the Number of Hires

Record the total number of hires within your measurement period, which can be monthly or annually. Accurate recording is crucial for precise calculations.

Final Calculation

Use the standard cost per hire formula: (total internal costs + total external costs) / total number of hires. This will provide the average expense incurred to hire each new employee, enabling better budgeting and resource allocation for future recruitment.

Employ tools like Workable for real-time analytics and refer to SHRM and ANSI standards for data collection guidance to streamline and enhance the accuracy of your calculation process.

sourcetable

How to Calculate Cost Per Hire

Gather Relevant Data

Start by collecting data on all internal and external expenses related to recruitment. Include costs like employment branding, labor, and recruiting tools for internal expenses. Add external costs such as agency fees and relocation expenses.

Organize Costs

Input all internal costs in one column and external costs in another within a spreadsheet. This method simplifies the aggregation process.

Determine Total Hires

Record the total number of hires made during the specific measurement period, which can be monthly, quarterly, or annually.

Calculate the Cost Per Hire

Use the formula (sum of internal and external recruitment expenses) / total number of hires to find the cost per hire. This calculation gives you a clear overview of your recruitment cost efficiency.

Analyzing Costs

For a deeper insight, analyze costs per department or role to identify areas for financial optimization.

By closely following these steps, businesses can accurately manage and potentially reduce their recruitment expenses.

sourcetable

Calculating Cost Per Hire: Practical Examples

Example 1: Basic Calculation

To begin, add all recruitment expenses for a given period and divide by the number of hires made. For instance, if the total recruitment cost for a month, including job fairs, advertising, and recruiter salaries, is $5,000 and the company hired 10 employees, the cost per hire would be $500.

Example 2: Including Onboarding Costs

Extend the calculation by including onboarding costs such as training and orientation expenses. If the onboarding costs amount to $2,000 and the recruitment costs remain at $5,000, with the same 10 hires, the revised cost per hire is $700.

Example 3: Factoring Employee Referral Bonuses

Consider scenarios where employees receive a referral bonus. If the total recruitment costs are $5,000, onboarding costs are $2,000, and $1,000 was spent on referral bonuses, the total expense is $8,000. With 10 hires, this finalizes the cost per hire at $800.

Example 4: High and Low Season Variations

Account for seasonal variations in hiring. For example, during a high season, recruitment costs might spike to $12,000 due to intensive campaigns, with 20 hires. This scenario leads to a cost per hire of $600, suggesting the influence of hiring volume on recruitment costs.

Example 5: Advanced Metrics Integration

Incorporate advanced metrics like employee turnover rates. If an organization notices a high turnover where, say, 2 out of 10 initial hires leave prematurely, leading to additional hires and increased costs (e.g., $10,000 in total costs for 12 hires), the adjusted cost per hire would be about $833.

sourcetable

Discover the Efficiency of Sourcetable for All Your Calculation Needs

Utilizing Sourcetable, an AI-powered spreadsheet, enhances the accuracy and efficiency of various financial calculations. Whether you're tackling simple arithmetic or complex formulas, Sourcetable provides precise outcomes swiftly. This tool is particularly indispensable when learning how to calculate cost per hire, a critical metric in human resources management.

Simplifying Complex Calculations

Sourcetable's AI assistant excels in processing complex calculations effortlessly. By simply inputting your data, the AI analyzes and computes the required information, such as Cost Per Hire = (Total External Costs + Total Internal Costs) / Total Number of Hires, presenting the results directly in an easy-to-understand spreadsheet format.

Real-Time Explanation

What sets Sourcetable apart is its interactive chat interface. As it performs calculations, Sourcetable explains each step in real-time. This feature is incredibly beneficial for educational purposes, whether for students mastering new concepts or professionals needing a refresher on vital calculations like cost per hire.

By incorporating Sourcetable into your daily tasks, whether for academic, work-related, or personal use, you ensure not just speed and precision, but also a deeper understanding of your financial calculations. This tool is not only a calculator but a comprehensive learning companion.

sourcetable

Use Cases for Calculating Cost Per Hire

1. Budget Optimization

By calculating cost per hire on a regular basis, organizations can manage and allocate their recruitment budgets more efficiently, ensuring financial resources are used effectively.

2. Process Enhancement

Understanding the monetary outlays in recruitment allows companies to streamline their hiring processes, cutting unnecessary expenses and focusing on cost-effective strategies. This may include automation of recruitment tasks or re-evaluating third-party services.

3. Strategic Recruitment Planning

Knowledge of cost per hire aids in making informed strategic decisions about where and how to invest in recruitment efforts. This can involve choosing which roles or departments to prioritize based on their hiring costs.

4. Financial Forecasting and Planning

With insights from cost per hire data, HR departments can forecast future hiring expenses and budget accordingly, making annual financial planning more predictable and controlled.

5. Performance Measurement

Cost per hire metrics serve as a benchmark for evaluating the effectiveness of the recruitment function within an organization. By tracking changes over time, HR can assess improvements or declines in efficiency.

6. Departmental Assessment

Calculating average cost per hire per department or role allows for the assessment of specific recruitment practices and resource use in different parts of the organization, identifying areas for improvement.

sourcetable

Frequently Asked Questions

What is cost per hire?

Cost per hire is a recruiting metric that measures the costs associated with the process of hiring new employees. It includes expenses such as sourcing, recruitment advertising costs, onboarding, and referral bonus program costs.

How is cost per hire calculated?

Cost per hire is calculated using the formula: (total internal costs + total external costs) / total number of hires. Here, internal costs are those incurred by the company, and external costs are those incurred by the candidate.

What costs are included in calculating cost per hire?

The costs included in calculating cost per hire encompass both internal costs like sourcing, recruitment advertising, and onboarding expenses, and external costs like referral & agency fees, and relocation fees.

What counts as a 'hire' when calculating cost per hire?

The total number of hires can include internal and external hires, temporary staff, freelancers, and fixed-term contracts but excludes employees transferred as a result of a merger or acquisition and employees that are on a third-party payroll.

Why is it important to calculate cost per hire?

Calculating cost per hire is crucial for understanding the efficiency of hiring processes and for informing budgeting decisions. It helps organizations manage and optimize their recruitment expenditure.

Conclusion

Calculating cost per hire is crucial for effective budgeting and financial planning in any organization. This figure encapsulates various expenses such as advertising, recruiter salaries, and other recruitment costs divided by the total number of hires, calculated as Total Recruitment Costs / Total Number of Hires. It provides valuable insights into the efficiency and effectiveness of the hiring process.

Streamline Calculations with Sourcetable

Sourcetable, an AI-powered spreadsheet, simplifies complex calculations including the cost per hire metric. With its intuitive interface and powerful calculation capabilities, Sourcetable ensures that human resource professionals can easily manage and analyze recruitment data. Additionally, Sourcetable allows users to test calculations on AI-generated data, which can enhance the accuracy and reliability of financial planning.

Experience the ease of recruitment calculations with Sourcetable today. Try it for free at app.sourcetable.com/signup.



Sourcetable Logo

Calculate anything you want with AI

Sourcetable takes the math out of any complex calculation. Tell Sourcetable what you want to calculate. Sourcetable AI does the rest. See the step-by-step result in a spreadsheet and visualize your work. No Excel skills required.

Drop CSV