Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
160x Filetype XLSX File size 0.07 MB Source: assets.website-files.com
Sheet 1: CPH Calculator
| WayUp//Talent Tech Labs Cost-Per-Hire Calculator | Fill this out first: | ||||||||||||||||||||
| Start Date | End Date | Total # Hires During the Period | |||||||||||||||||||
| 1/1/2018 | 12/31/2018 | 0 | |||||||||||||||||||
| Total Costs | |||||||||||||||||||||
| $0 | |||||||||||||||||||||
| Cost Per Hire | |||||||||||||||||||||
| - | |||||||||||||||||||||
| Summary of Expenses by Category (Do Not Edit) | Total Expense | ||||||||||||||||||||
| Events Sponsorships: Total | $0 | ||||||||||||||||||||
| Travel Expenses: Total | $0 | ||||||||||||||||||||
| Recruiter Team Salaries: Total | $0 | ||||||||||||||||||||
| Technology Expenses: Total | $0 | ||||||||||||||||||||
| Hiring Manager Costs: Total | $0 | ||||||||||||||||||||
| Overhead/facilities Costs | $0 | ||||||||||||||||||||
| Total Hire Expenses: | $0 | ||||||||||||||||||||
| Total Hires | 0 | ||||||||||||||||||||
| Cost per hire | - | ||||||||||||||||||||
| Enter your firm's expenses below: | |||||||||||||||||||||
| Events Sponsorships: Total | $0 | ||||||||||||||||||||
| Career Fairs -- General | Enter your Events and Sponsorships expenses here (exclude travel and food as that is accounted for below). Where appropriate, you can allocate the percent of the expense for early career hiring (we have input 100% as a default, but this can be adjusted as necessary). | ||||||||||||||||||||
| Career Fairs -- General, Allocation | 100% | ||||||||||||||||||||
| Career Fairs -- On Campus | |||||||||||||||||||||
| Career Fairs -- On Campus, Allocation | 100% | ||||||||||||||||||||
| Diversity Events | |||||||||||||||||||||
| Diversity Events, Allocation | 100% | ||||||||||||||||||||
| Hackathons | |||||||||||||||||||||
| Hackathons, Allocation | 100% | ||||||||||||||||||||
| Travel Expenses: Total | $0 | ||||||||||||||||||||
| Flights | Include any travel-related expenses related to early career hiring. | ||||||||||||||||||||
| Hotels | |||||||||||||||||||||
| Food and Beverage | |||||||||||||||||||||
| Recruiter Team Salaries: Total | $0 | ||||||||||||||||||||
| Recruiter and Sourcer Salaries: Directly Responsible For Early Hires | Include salaries associated with early career hiring, and allocate management based on time spent in early career hiring management | ||||||||||||||||||||
| Recruiting Manager Salaries (attributable to Early Hires) | |||||||||||||||||||||
| Non-salary employee costs (enter as %) | 10% | ||||||||||||||||||||
| Technology Expenses: Total | $0 | ||||||||||||||||||||
| ATS Costs | Include spend on job boards, diversity career sites, Linkedin recruiter licenses, social search tools, recruitment marketing costs, career site costs, and ATS costs. Allocate a percent attributable to early career hiring, e.g. by dividing the number of early career hires by total hires. | ||||||||||||||||||||
| ATS Costs Allocation | 100% | ||||||||||||||||||||
| Job Board Advertising | |||||||||||||||||||||
| Job Board Advertising Allocation: Early Career | 100% | ||||||||||||||||||||
| Recruitment Marketing Costs | |||||||||||||||||||||
| Recruitment Marketing Costs Allocation: Early Career | 100% | ||||||||||||||||||||
| Other Talent Acquisition Technology Costs (CRM, assessments, Social Search, etc.) | |||||||||||||||||||||
| Other TA Tech Allocation: Early Career | 100% | ||||||||||||||||||||
| Hiring Manager Costs: Total | $0 | ||||||||||||||||||||
| Hours Recruiting Per Hire | 4 | Estimate average hours spent by hiring managers recruiting per hire (we've input 4 as a default). Adjust average manager salary based on your org's comp structure (we have used 27.77 as a default) | |||||||||||||||||||
| Total # of Hires | 0 | ||||||||||||||||||||
| Hiring Manager Hourly Cost | $27.77 | ||||||||||||||||||||
| Overhead/facilities Costs | $0 | ||||||||||||||||||||
| "Desk cost" per head per month | $650 | You can either enter the total direct facilities expense attributable to recruiting in cell C59 if you have this info available. Else, calculate your cost per head and enter in cell C57 (we've input $650/mo as a default) and recruiting headcount in cell C58. | |||||||||||||||||||
| Time period (months) | 12 | ||||||||||||||||||||
| Total Recruiting Headcount (Early Career Hire) | |||||||||||||||||||||
| Total rent/facilities expense attributable to early career hiring (Enter directly here if you know this -->) | |||||||||||||||||||||
no reviews yet
Please Login to review.
