ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
⚠️ SAMPLE DATA BELOW - REPLACE WITH YOUR ACTUAL NUMBERS ⚠️
2
INSTRUCTIONS: Delete the sample numbers in YELLOW cells and enter YOUR actual data
3
RECRUITING BUDGET REALLOCATION CALCULATOR
4
5
CURRENT RECRUITING SPEND BY CHANNEL (Enter YOUR numbers)
6
ChannelAnnual Spend ($)Number of HiresAvg Time-to-Fill (days)
7
Job Boards1000002035← SAMPLE
8
Recruiting Agencies2000001040← SAMPLE
9
Employee Referrals300001525← SAMPLE
10
Career Site200001030← SAMPLE
11
Other Channels10000545← SAMPLE
12
TOTAL (Auto-calculated)3600006035
13
14
COMPANY INFORMATION (Enter YOUR numbers)
15
Total Employees500← SAMPLE
16
Total Hires Planned (Next Year)70← SAMPLE
17
IndustryHealthcare
(Healthcare, Technology, Logistics, Retail)
← SAMPLE
18
Average New Hire Salary ($)75000← SAMPLE
19
20
CURRENT REFERRAL PROGRAM STATUS (Enter YOUR numbers)
21
Have referral program?Yes(Yes or No)← SAMPLE
22
Employee Participation Rate (%)30← SAMPLE
23
Current Referral Bonus ($)1500← SAMPLE
24
Total Referrals Received (Last Year)50← SAMPLE
25
26
COLOR KEY:
27
YELLOW cells = YOUR INPUT (replace sample data)
28
GREEN cells = AUTO-CALCULATED (don't touch)
29
ORANGE cells = IMPORTANT TOTALS
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100