hiring budget plan spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2	Recruiting Method
3	Job Boards		January	February	March	April	May	June	July	August	September	October	November	December	Annual Total	Annual Equivalent
4	Linkedin	Spend	80	160	240	0	0	240	0	320	0	0	0	80	1120	93.33333333
5		# of Postings	1	2	3	20	15	3	2	4		1	1	1	53	4.416666667
6		cost per Posting	80	80	80			80		80	80			80	560	46.66666667
7	Indeed	Spend	135	90	630	45	90	45	135	90	135	45	90	90	1620	135
8		# of Postings	3	2	14	1	2	1	3	2	3	1	2	2	36	3
9		cost per Posting	45	45	45	45	45	45	45	45	45	45	45	45	540	45
10	Career Builder	Spend	60	25	0	0	0	0	0	0	0	0	0	0	85	7.083333333
11		# of Postings	2	1											3	0.25
12		cost per Posting	30	25											55	4.583333333
13	Total	Spend	275	275	870	45	90	285	135	410	135	45	90	170	2825	235.4166667
14		# of Postings	6	5	17	21	17	4	5	6	3	2	3	3	92	7.666666667
15		average cost	45.83333333	55	51.17647059	2.142857143	5.294117647	71.25	27	68.33333333	45	22.5	30	56.66666667	480.1967787	40.01639823
16	Assessment		January	February	March	April	May	June	July	August	September	October	November	December	Annual Total	Annual Equivalent
17	General Aptitude Testing	Spend	96	160	16	0	0	0	0	0	0	0	0	0	272	22.66666667
18		# of candidates	12	20	2										34	2.833333333
19		cost per candidate	8	8	8										24	2
20	Personality test	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
21		# of candidates													0	0
22		cost per candidate													0	0
23	Total	Spend	96	160	16	0	0	0	0	0	0	0	0	0	272	22.66666667
24		# of Candidates	12												12	1
25		average cost	8	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
26	External Recruiting		January	February	March	April	May	June	July	August	September	October	November	December	Annual Total	Annual Equivalent
27	Acme recruiting	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
28		# of times services were used													0	0
29		cost per unit													0	0
30	ABC staffing	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
31		# of times services were used													0	0
32		cost per unit													0	0
33	Total	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
34		# of times services were used	0	0	0	0	0	0	0	0	0	0	0	0	0	0
35		average cost	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
36	Employer Branding		January	February	March	April	May	June	July	August	September	October	November	December	Annual Total	Annual Equivalent
37	Career Fairs	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
38		# of times paid													0	0
39		$ per time													0	0
40	Employment Events sponshorships	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
41		# of times paid													0	0
42		cost per unit													0	0
43	Branding material	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
44		# of units													0	0
45		cost per unit													0	0
46	Conferences participation	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
47		# of times paid													0	0
48		cost per unit													0	0
49	Total	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
50	Career Page		January	February	March	April	May	June	July	August	September	October	November	December	Annual Total	Annual Equivalent
51	Development	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
52		# of times paid													0	0
53		cost per unit													0	0
54	Maintenance	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
55		# of times paid													0	0
56		cost per unit													0	0
57	Redesign	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
58		# of times paid													0	0
59		cost per unit													0	0
60	Total	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
61		# of times paid	0	0	0	0	0	0	0	0	0	0	0	0	0	0
62	Partnerships		January	February	March	April	May	June	July	August	September	October	November	December	Annual Total	Annual Equivalent
63	University Alumni	Spend	800												800	66.66666667
64	Institutions	Spend	600												600	50
65	Total	Spend	1400	0	0	0	0	0	0	0	0	0	0	0	1400	116.6666667
66	Salary costs of hiring team		January	February	March	April	May	June	July	August	September	October	November	December	Annual Total	Annual Equivalent
67	Recruiter (in-house)	Spend	375	0	0	0	0	0	0	0	0	0	0	0	375	31.25
68		# of hours spent	15												15	1.25
69		cost per hour	25												25	2.083333333
70	Hiring manager 1	Spend	350	0	0	0	0	0	0	0	0	0	0	0	350	29.16666667
71		# of hours spent	5												5	0.4166666667
72		cost per hour	70												70	5.833333333
73	Hiring manager 2	Spend	0	0	0	0	0	0	0	0	0	0	0	0	0	0
74		# of hours spent													0	0
75		cost per hour													0	0
76	Total	Spend	725	0	0	0	0	0	0	0	0	0	0	0	725	60.41666667
77		# hours spent	20	0	0	0	0	0	0	0	0	0	0	0	20	1.666666667
78	Total Recruitment Spend per month		2496	435	886	45	90	285	135	410	135	45	90	170	5222	435.1666667
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100