Recruiting capacity planning template: hires needed, hires possible, and the gap

A recruiting capacity plan answers one question: can the recruiters you have deliver the hires the business wants, quarter by quarter, and if not, how big is the gap? The template below does it in four spreadsheet tabs: Demand (planned hires plus backfills), Productivity (hires per recruiter per quarter from your own history), Supply (each recruiter's effective capacity after ramp and leave), and Gap (demand minus supply, in hires and in recruiters). The formulas work in Google Sheets and Excel, and the method follows Gem's published capacity planning approach.

If your question is how many open reqs one recruiter should carry today, start with how many reqs per recruiter. This page is for planning next quarter or next year.

What goes into a capacity plan?

• The hiring plan by department and quarter: new roles the business has approved or expects to approve.
• Current headcount and annual attrition by department, to estimate backfills. Plans that leave out backfills are short from day one.
• Two years of hires by recruiter and department from your ATS. Gem's 7-step guide to capacity planning recommends two years to smooth out seasonal swings, with anomalies such as a hiring freeze removed.
• The recruiter roster: who works which department, start dates for new joiners, and known long leave.
• Two assumptions: how fast a new recruiter ramps, and a buffer for holidays and ordinary time off.

Tab 1: Demand

One row per department per quarter.

A Department | B Quarter | C New hires | D Current headcount |
E Annual attrition rate | F Backfills | G Total demand

F2  =ROUND(D2*E2/4,0)        backfills expected this quarter
G2  =C2+F2                   hires needed this quarter

Dividing annual attrition by four assumes leavers are spread evenly through the year. If your departments have a known pattern, such as sales attrition after annual bonuses, enter backfills by quarter by hand instead.

Tab 2: Productivity

One row per department or role tier.

A Department | B Hires in the last 8 quarters |
C Recruiter FTE-quarters on this department in the same period |
D Hires per recruiter per quarter

D2  =B2/C2

An FTE-quarter is one full-time recruiter working on that department for one quarter; a recruiter split evenly across two departments contributes half a quarter to each. Gem's guide calls the result productivity per recruiter and suggests separating role types that differ in difficulty, noting that tech roles are generally twice as hard to fill. If you have no history, borrow numbers from peers at similar companies, label them as borrowed, and replace them after two quarters.

Tab 3: Supply

One row per recruiter per quarter.

A Recruiter | B Department | C Quarter | D Allocation (share of time
on this department) | E Ramp factor | F Long leave weeks this
quarter | G Availability | H Buffer | I Effective FTE |
J Capacity in hires

G2  =(13-F2)/13              a quarter is 13 weeks
I2  =D2*E2*G2*(1-H2)
J2  =I2*VLOOKUP(B2,Productivity!A:D,4,FALSE)

The ramp factor is 1 for a fully productive recruiter. Gem's guide says a ramping recruiter "may only be expected to hire at 50% capacity", and Gem's senior director of recruiting operations, describing Gem's own capacity model, wrote that they assumed three months of ramp per new resource and a 10% buffer so that everyone is effectively expected to operate at 90%. A reasonable starting point is 0.5 for a recruiter's first quarter and 1 after that, with a 10% buffer, until your own data says otherwise. Use the long leave column for parental leave, sabbaticals or a known departure; the buffer covers ordinary holidays and time off.

Tab 4: Gap

A Department | B Quarter | C Demand | D Supply | E Gap in hires |
F Recruiter FTE needed

C2  =SUMIFS(Demand!G:G,Demand!A:A,A2,Demand!B:B,B2)
D2  =SUMIFS(Supply!J:J,Supply!B:B,A2,Supply!C:C,B2)
E2  =C2-D2
F2  =MAX(0,E2)/(VLOOKUP(A2,Productivity!A:D,4,FALSE)*0.9)

The 0.9 in F2 is the same 10% buffer; change it if yours differs. Add conditional formatting to column E: green when the gap is zero or below, amber up to a quarter of demand, red above that. That one colored column is usually the slide a leadership team needs to see.

A worked example

All numbers below are invented to show the arithmetic.

Demand, Q1. Engineering plans 12 new hires, has 120 people and 12% annual attrition, so backfills are 120 × 0.12 ÷ 4 = 3.6, rounded to 4, and demand is 16. Sales plans 8 new hires, has 60 people and 20% attrition, so backfills are 3 and demand is 11.

Productivity. Over the last eight quarters, engineering recruiters averaged 4 hires per recruiter per quarter and sales recruiters 6.

Engineering is short by about five hires, or 1.4 recruiter equivalents, mostly because of one leave and one ramping joiner. Note what the plan does not say: hiring a recruiter now does not close the Q1 gap, because a new recruiter would also start at half capacity. The realistic options for Q1 are a contract recruiter already experienced in the roles, a sourcer to raise the existing team's output, moving some hires to Q2 with the engineering leader's agreement, or a combination. Sales is balanced, which also means it has no spare capacity to lend.

How do you get hires per recruiter out of your ATS?

1. Export hires for the last eight quarters with hire date, department and the recruiter who owned the req.
2. Build a small table of which recruiters worked which departments each quarter, and at what share of their time.
3. Divide hires by recruiter FTE-quarters per department.
4. Remove quarters that do not represent normal operation, such as a freeze or a one-off campus drive, and note what you removed.
5. Check the result against what recruiters actually carried. If productivity looks high but reqs per recruiter were also far above normal, the history may include burnout you should not plan to repeat.

Weighting by role difficulty, so that a recruiter filling executive roles is not compared with one filling repeatable roles, is covered in recruiter productivity metrics.

Can a recruitment agency use the same template?

Yes, with different units. Demand becomes expected placements: job orders you expect to win in the quarter multiplied by your fill rate for that kind of job order. Productivity becomes placements per consultant per quarter, split by contract and permanent if your desk does both. Supply works the same way, with ramp for new consultants. The agency definitions and formulas are in recruiting agency metrics.

How often should you update the plan, and how do you present the gap?

Refresh it monthly with actual hires and any change to the hiring plan, and rebuild it each quarter. Gem's guide makes a point worth copying: check the numbers with department leaders before you treat them as a commitment. When you present the gap, present choices, not a complaint:

• Add capacity: a contract recruiter, a sourcer or a coordinator, with the quarter they become productive.
• Move hires: which roles shift to the next quarter, and what that costs the department.
• Reduce scope: which roles come off the plan.
• Reduce work per hire: fewer interview rounds, faster feedback, less admin per screen.

The ranking that decides which roles move or wait belongs with hiring leaders; our guide to prioritizing open requisitions has a rubric for that conversation.

What mistakes make capacity plans wrong?

• Planning in requisitions. A req can hold one opening or thirty. Plan in hires.
• Leaving out backfills. Attrition is hiring demand, whether or not it is in the headcount plan.
• Counting new recruiters as fully productive. They are not, for at least a quarter.
• One productivity number for every role. A blended average hides the department that is drowning.
• Treating the plan as finished. A plan not refreshed since January is a guess by April.