Hiring Pipeline Math: Applicants Needed, Time-to-Fill & Recruiter Capacity
Work backwards from a hiring plan to the applicants, interviews and recruiter hours you need: funnel conversion, time-to-fill in working days, source costs, panel load, recruiter capacity, quality of hire and a monthly tracker at one fictional retailer, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you plan hiring for one fictional retailer in a live spreadsheet, every formula checked as you go. You count how many applicants reached each stage with COUNTIFS and turn the counts into conversion rates and yield, then run the funnel backwards to the applicants a hiring plan needs, rounded up at the right moment. You measure time to fill and time to start in working days with NETWORKDAYS and closure days, compare average and median, rank sources by cost per applicant and cost per hire, total interviewer hours per ISO week, weight requisitions to size the recruiting team, track offer acceptance and early leavers, and finish with a monthly plan tracker and a funnel chart.
Lessons
- The Hiring Funnel: Stage Counts, Conversion & Yield Pro
- Working Backwards: Applicants Needed for a Hiring Plan Pro
- Time-to-Fill and Time-to-Start in Working Days Pro
- Which Source Works? Cost per Applicant vs Cost per Hire Pro
- Interview Panel Load by ISO Week Pro
- Recruiter Capacity: Weighted Requisition Loads Pro
- Quality of Hire: Offer Acceptance & 90-Day Early Leavers Pro
- Capstone: Monthly Hiring Plan Tracker & Funnel Chart Pro