TA Capacity & Cost Optimization Dashboard

Q4 2024 Q3 2024 All Departments Engineering Product
Avg Weighted Recruiter Load
108%
↑ 14% vs Q3
Agency Spend % of Total
38.2%
↑ 17.2pp YoY
Admin Time Ratio
22%
↓ 3% vs Q3
Avg Cost Per Hire
$6,840
↑ $1,860 YoY
Reqs > 90 Days Aging
18
5 critical
Time-to-Fill Avg (days)
47
↑ 9d vs target

Recruiter Capacity Load

S. Park
13 reqs
M. Chen
9 reqs
L. Rodriguez
11 reqs
K. Patel
8 reqs
J. Williams
10 reqs
T. Nguyen
7 reqs

Requisition Aging by Department

Aging Risk Summary

0-30 days 124
31-60 days 38
61-90 days 7
91-120 days 13
120+ days (Critical) 5
Estimated Emergency Cost
$127,400
5 ML Eng reqs → agency escalation

Cost Per Hire Waterfall by Sourcing Channel

Sourcing Outreach Conversion Rate

Offer Letter Cycle Time Trend

Recruiter Performance & Cost Analysis

Recruiter Active Reqs Load % Hires Q4 Avg CPH Agency % Avg TTF Admin Time %
S. Park 13 127% 8 $8,240 52% 58d 19%
M. Chen 9 94% 11 $5,980 28% 42d 24%
L. Rodriguez 11 112% 9 $6,420 35% 51d 21%
K. Patel 8 88% 13 $5,140 18% 38d 23%
J. Williams 10 103% 10 $6,890 41% 49d 20%
T. Nguyen 7 76% 12 $4,720 12% 36d 26%

Administrative Time Breakdown

Automation ROI Projection

Current Admin Hours/Week
168 hrs
Automatable Hours (Est.)
94 hrs
56% reduction potential
Annual Cost Savings
$287k
@ $59/hr blended rate × 94 hrs × 52 wks
Key Targets: Interview scheduling automation, candidate email sequences, ATS data entry, offer letter generation, onboarding checklist setup.

Critical Aging Requisitions (120+ Days)

Req ID Role Title Department Recruiter Days Open Stage Est. Emergency Cost
REQ-2847 Senior ML Engineer AI Research S. Park 147d Agency Escalation $28,400
REQ-2891 ML Platform Engineer AI Research S. Park 134d Agency Escalation $26,200
REQ-2903 Staff ML Engineer AI Research L. Rodriguez 128d Agency Escalation $31,800
REQ-2774 Principal ML Scientist AI Research S. Park 156d Agency Escalation $35,600
REQ-2821 ML Infrastructure Lead Engineering J. Williams 122d Agency Escalation $5,400
Root Cause Analysis: 4 of 5 critical reqs owned by S. Park (127% capacity). ML hiring volume tripled post-Series E; specialized skill requirements exceed internal sourcing bandwidth. Immediate action: redistribute 3 VP-level reqs to T. Nguyen (76% capacity), deploy LinkedIn Recruiter seats to K. Patel for ML sourcing support.