Distribution Center Hiring Funnel and Early Attrition
You are the talent acquisition lead for a regional grocer opening a 450,000-square-foot distribution center that will employ 300 warehouse associates within 10 months. Current staffing is 120; the forecast requires 180 net new hires by peak season. Last year's similar site had 28% first-90-day attrition among pickers, 52-day average time-to-fill against a 30-day target, and $420,000 in agency fees. The funnel for the last 12 months shows 1,200 applications, 240 phone screens, 96 onsite interviews, 72 offers, 58 acceptances, and 41 still employed at 90 days. Referrals made up 38% of hires and had 82% 90-day retention; agency hires had 61% retention. The site director wants to 'just increase pay' and double agency use for peak. HR has a limited recruitment budget of $150,000 for the next year, plus a new apprenticeship tax credit.
1. Calculate the funnel conversion rates. Where is the real bottleneck, and what does source quality tell you?
Read the worked answer
Applications to phone screen: 240/1,200 = 20%. Phone to onsite: 96/240 = 40%. Onsite to offer: 72/96 = 75%. Offer acceptance: 58/72 = 80.6%. Acceptance to 90-day retention: 41/58 = 70.7%. Overall application-to-retained: 41/1,200 = 3.4%.
The biggest leak is after acceptance: 17 of 58 hires (29.3%) leave within 90 days. Offer acceptance is also below a healthy 90% level, but the retention loss is more expensive because it repeats recruiting, onboarding, and training. Source quality differs sharply: referrals retain at 82% versus 61% for agency hires. Doubling agency use would buy bodies at high cost and worsen the retention problem. The constraint is not application volume; it is conversion to stable employees. Investigate schedule predictability, physical work, supervisor quality, pay versus local market, and whether the realistic job preview is honest.
2. Build a 10-month workforce plan to reach 180 net new associates. What channels and milestones do you use?
Read the worked answer
Demand is 180 net new associates. If 28% early attrition persists, gross hires needed are approximately 180/(1 - 0.28) = 250. If early attrition improves to 15%, gross hires fall to about 212, a reduction of 38 hires. Plan in monthly cohorts of 18-25 hires rather than a last-minute surge.
Use three channels: referrals targeted at 45% of hires; an apprenticeship and tax-credit pipeline at 20%; and agency or community sources for no more than 15% surge coverage. Allocate the $150K budget to referral bonuses paid at 90 days, realistic job previews, onboarding buddies, and supervisor training. Reserve agency spend for a documented peak gap. Track time-to-fill, offer acceptance, and 30/60/90-day retention by source. Start apprenticeship recruiting in month 1 because training lead time is 8-10 weeks. Hold weekly hiring reviews with operations so the plan is adjusted on data, not on optimism.
3. How do you respond to the site director's proposal to increase pay and double agency use?
Read the worked answer
Pay may be part of the problem, but doubling agency use is the most expensive and least durable fix: agency hires retain at 61%, so you pay more for a higher replacement rate. Recommend a targeted market adjustment only if salary data show the site is below the local 50th percentile. Communicate it as a market correction, not a retention bonus, and apply it consistently.
Before spending, compare pay of leavers and stayers and run exit interviews. Pair any pay change with schedule predictability, realistic job preview, and first-90-day support. If the $150K budget is fixed, redirect agency spend toward referrals and apprenticeships. Set a decision rule: use agency only when projected hires fall more than 10% below the monthly plan. Ask the site director to own retention metrics jointly, because the current proposal shifts the cost of turnover to TA without fixing the cause.