Cost Per Hire Calculator Apple Numbers Template is a Numbers Template for Mac users which helps us to calculate the cost of filling an empty position of any organization. These costs include advertising, recruiting and staffing etc borne by a company during the recruiting process.
Cost Per Hire or CPH is an HR metric used by Human resource professional to measure the effectiveness of the recruitment process.
Direct Expenses include the salaries of staff indulged in recruiting, other expenses incurred by recruiting staff, background and other checks for the job candidate.
Indirect Expenses include job portal fees, advertisement cost, Job fair expenses, and other costs related to job posting etc.
To simplify and ease the calculations of Cost Per hire, we have created a Cost Per Hire Calculator Apple Numbers Template with predefined formulas.
Just enter the applicable cost in the given cell and it will automatically calculate the CPH for you.
Click here to download Cost Per Hire Calculator Apple Numbers Template.
You can also download the Cost Per Hire Calculator in Microsoft Excel from the link below:
You can also download other Numbers templates like Salary Sheet, Simple Tax Calculator, and Itemized Deduction Calculator.
Let us discuss the contents of the template in detail.
This template consists of total 6 sections:
You don’t need to enter any data in this section as this section is auto-populated. It consists of the total of all the associated costs like advertising, reviewing, interviewing, joining and other miscellaneous expenses related to filling the job post.
Companies need to advertise through different media for the job post. All such expenses are included in this section. It includes newspapers, job portals, and other media.
Advt. Cost Per Candidate = Sum of all advertising expenses / no. of CVS received
The advertising brings in a lot of CVS and then they are reviewed and shortlisted. This process also incurs manpower and expenses. The costs associated with this process are inserted in this section.
Reviewing Cost Per Candidate = No. of HR staff employed X No. of days X Cost per Day / No. candidates selected for the interview.
The number of employees carrying out the interview process and all costs related to this are reported in this section.
Interviewing Cost Per Candidate = No. of interviewers X No. of days X Cost Per Day / No. of Candidates Selected.
Each employee recruited by the company has to do some government paper works, medical examinations etc. These costs are borne by the company. All such costs are reported in this section.
Joining Cost Per Candidate = Medical Examination Expenses + Training Expenses + Other Expenses / No .of Candidates Recruited
All the expenses other than the above mentioned 4 categories are reported in this section. These costs include background and reference checks on the recruited candidates.
Misc. Cost per Candidate = Background or reference check + Other Costs / No. of Candidates Recruited
CPH is usually calculated annually or quarterly. Type of recruitment like part-time, full-time, temporary or permanent should also be kept in mind while calculating CPH.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.
To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…
Every business has to register for VAT with HM Revenue and Customs if their VAT…
We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…
We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…
We have created a simple and easy UK VAT Sales Register Excel Template with predefined…
We have created a ready to use UK VAT Progress Billing Invoice template in excel…