Have an account? Log in to check out faster.
HR Staffing Ratio Calculator
See how your HR staffing compares with organizations of a similar size. Enter total HR headcount and employee count to calculate your HR-to-employee ratio and compare it with planning ranges by organization size. A board-ready summary includes your ratio and HR cost per employee.
Enter your total employees, current HR staff in full time equivalents, and a target ratio if you have one. The workbook calculates HR staff per 100 employees, employees per HR person, and the typical low and high for your organization’s size. It also shows the HR headcount implied by your target, the gap to target, and cost per employee at your current and target ratios when you add the average fully loaded HR salary. The Benchmark tab lists planning ranges by organization size and names ADP as the source for the published figures. The one-page Summary brings the ratio, benchmark range, and cost per employee together for a budget or headcount conversation. The workbook opens on a worked example so you can follow the calculations.
HR staffing ratios vary with organization size and the work the team handles. A finance partner may start with one HR person per 100 employees or a ratio from a previous employer. This workbook gives that comparison more context through planning ranges. ADP’s December 2023 Today at Work report shows about 2.6 HR staff per 100 employees, based on data through April 2023. The workbook uses planning ranges of 2.5 to 3.5 HR staff per 100 employees for organizations under 100 employees, and 0.8 to 1.2 for organizations with 1,000 or more. Higher ratios often reflect payroll or benefits administration handled in-house, while lower ratios can reflect heavy automation or outsourcing. The cost-per-employee figure connects staffing levels to the budget discussion.
For HR staffing based on workload volume and productive hours rather than a ratio, the FTE Headcount Planner converts demand into headcount.
What format is it, and can I edit it?
You get one Excel workbook that also works in Google Sheets. The download includes five files: the workbook, a Start Here, the one-page Quick Reference, the product license, and a short guide to using it in Google Sheets. Every input and formula is editable, so you can duplicate the file to model a future team size or track the ratio over time. Your download link appears immediately after checkout, and the same link is emailed on your receipt.
How useful are older staffing benchmarks?
The Benchmark tab labels its ranges as planning ranges and names ADP as the source for the published figures, and the Start Here tab shows the date the workbook was last reviewed. Staffing ratios shift slowly, so even a benchmark two or three years old can provide useful context for your staffing decisions.
How accurate is the result?
The workbook calculates your staffing ratio, employees per HR person, and cost per employee directly from the headcount and average HR salary you enter. Compare those figures with the benchmark ranges while considering how much payroll, benefits, and administration your team handles in-house or outsources. The gap gives you context for a staffing decision rather than a fixed target.
What is the refund policy?
Digital products are covered by a 30-day money-back guarantee. To request a refund, email support@truestephr.com or reply to your receipt within 30 days of purchase. Questions? Email support@truestephr.com.
How the download works
Your files arrive as a single ZIP download, best opened on a computer. Save it, extract it (right-click and select Extract All on Windows, or double-click on a Mac), then open the Start Here file first. PDFs open in any reader, and editable files work in Microsoft Excel or free equivalents, including LibreOffice and Google Sheets. No other software is needed. Step-by-step help for every device is at truestephr.com/pages/download-help.
This planning and analysis model produces estimates based entirely on the inputs and assumptions you enter. Use those estimates to support decisions, rather than as accounting, tax, or legal conclusions. Check the assumptions against your own data. Have qualified counsel review decisions involving pay, headcount, or separation against applicable law before acting. General information, not legal, tax, or financial advice.
FREE HR GUIDE
A five-minute screen that catches the most common and most expensive people decisions before they go wrong. Free guide, plus practical HR tools and guidance sent to your inbox.
No spam. Unsubscribe at any time.