AI-Assisted TA Capacity Calculator

	A	B	C	D	E	F	G	H
1	AI-Assisted Capacity Model (CLICK File -> Make a Copy to download an editable version)
2
3	Step 1a. Funnel Assumptions (activity per hire)					Step 1b. Activity time assumptions
4		Inbound Heavy	Outbound Heavy	Evergreen		(time per activity in mins)	% Decrease	New Activity time
5	Prospects Viewed	1000	1000	1000		1	60%	0.4
6	Prospects Contacted	0	100	200		10	40%	6
7	Screened by Recruiter	20	20	20		45	45%	24.75
8	Screened by Hiring Manager	10	10	10		15	0%	15
9	Interviewed	5	5	5		120	0%	120
10
11	Old Activity / Hire (hrs)	44	61	78		Legend
12	New Activity / Hire (hrs)	27	37	47		Data Input
13	Active Hrs / Mth	112	112	112		Calc. Field
14	Old Hires / Month	2.54	1.84	1.45		Key Metric
15	New Hires / Month	4.09	2.99	2.36
16
17	Step 2. Planned Recruiter Req Load
18	Total Annual Reqs:	130	80	50
19
20		Inbound Heavy	Outbound Heavy	Evergreen	TOTAL	Est Hires / Mth	Est Hires / Yr	Capacity
21	Current Recruiters Needed	5	4	3	12	24	293	89%
22	New Recruiters Needed	3	3	2	8	26	312	83%
23
24	Step 3. Review Cost Savings
25	Avg Recruiter FLC	$ 80,000	$ 120,000	$ 100,000
26	Current HC Cost	$ 400,000	$ 480,000	$ 300,000	$ 1,180,000
27	New HC Cost	$ 240,000	$ 360,000	$ 200,000	$ 800,000
28	Total Savings	$ 160,000	$ 120,000	$ 100,000	$ 380,000	32%
29
30				License Cost	$ 80,000
31				Net Savings	$ 300,000
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