{"product_id":"hr-staffing-ratio-calculator","title":"HR Staffing Ratio Calculator","description":"\u003cp\u003eSee how your HR team stacks up against the typical ratio for your size, and what reshaping it would do to cost. Enter your headcount and your HR staff, and the workbook returns your HR-to-employee ratio, how it compares to the typical range for your size, the gap to a target, and what your HR function costs per employee now and at that target.\u003c\/p\u003e\u003ch3\u003eOne Excel workbook that turns a headcount and an HR count into a benchmarked ratio and a cost\u003c\/h3\u003e\u003cp\u003eA Start Here tab orients you, and the workbook opens on a worked example so the logic is clear before you change anything.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eHR Ratio Calculator and Cost.\u003c\/strong\u003e Enter your total employees, your HR staff in full-time equivalents, and a target ratio, and the workbook returns your HR-per-100 ratio, employees per HR FTE, the typical low and high for your size, the FTE a target would call for, and the gap to your count today. The Cost tab turns an average loaded HR salary into your HR cost per employee now and at your target.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBenchmark, Summary, and Notes.\u003c\/strong\u003e A Benchmark tab holds typical HR-per-100 ratios by organization size, with sources from SHRM, Bloomberg Law, ADP, and Indeed and a note on what moves the ratio. A one-page Summary carries the headline numbers, and the Notes tab documents how each figure is built and what to count as HR FTE.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eThree steps from a headcount to a benchmarked ratio and its cost\u003c\/h3\u003e\u003cp\u003eEnter the organization, read your ratio against your size, then cost the gap to a target.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eEnter your headcount and HR staff.\u003c\/strong\u003e Fill the amber cells: total employees including HR, your HR staff in full-time equivalents, and a target ratio if you have one in mind.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead your ratio against your size.\u003c\/strong\u003e The workbook returns your HR-per-100 ratio, employees per HR FTE, and the typical low and high for your size band, with the gap to a target alongside.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCost the gap.\u003c\/strong\u003e On the Cost tab, enter an average fully loaded HR salary and read your HR cost per employee now and at your target, then read the Summary for the headline numbers.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWhat the right ratio depends on\u003c\/h3\u003e\u003cp\u003eA single benchmark hides more than it shows. The ratio that fits you depends on the work your HR team does and the tools it has, which is why this reads your ratio against a range, not a target.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eBenchmarks are a starting point, not a rule.\u003c\/strong\u003e Regulated and people-intensive sectors such as healthcare, finance, and consulting tend to run higher, and HR technology and self-service stretch a team further, so the typical range is context to weigh, not a number to hit.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe ratio falls as you scale.\u003c\/strong\u003e Under 100 employees HR covers everything with little scale to spread it, while at a thousand and above shared services and automation stretch the team, so compare yourself to your size band rather than to the overall average.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat you count as HR FTE drives the number.\u003c\/strong\u003e Count generalists and benefits, compensation, and labor relations, and decide consistently whether payroll belongs in or out, because that choice moves your ratio more than anything else.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWho it is built for and where to go if that is not you\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eBuilt for\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAn HR leader benchmarking the size of the team against organizations of the same size, with a figure for a budget conversation.\u003c\/li\u003e\n\u003cli\u003eA finance or operations partner sizing the cost of the HR function now and at a target ratio.\u003c\/li\u003e\n\u003cli\u003eA founder or owner checking whether HR is under-resourced or carrying more than the work needs.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eIf you are looking for\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eThe number of people a team needs based on its workload, rather than the HR-to-employee ratio. The FTE Headcount Planner sizes that.\u003c\/li\u003e\n\u003cli\u003eHow many direct reports each manager carries and your org layers, rather than the HR ratio. The Span of Control Calculator covers that.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eBefore you buy\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eWhat format is it and can I edit it?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt is one Excel workbook that also works in Google Sheets. Every input and formula is editable, and the file is yours to keep. Duplicate it to compare divisions or model a target.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThere is a free version of this calculator. Why pay for this one?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThe free tool gives a quick browser read of your ratio against the typical range and resets when you close the tab. This workbook is the file you keep: it adds the cost side the free tool does not touch, turning an average loaded HR salary into your HR cost per employee now and at a target, with a sourced benchmark tab, a one-page summary built for a budget conversation, and every formula open so you can set what counts as HR FTE to your own operation.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow accurate are the benchmarks?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThe benchmark ranges are general estimates from public sources, and the surveys differ: the most-cited figure, from SHRM, is near 1.7 HR staff per 100 employees, while Bloomberg Law lands near 1.5 and broad surveys average near 1.4. Read them as a range to weigh, not a standard, and your own result foots to the headcount and HR count you enter.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat should I count as an HR FTE?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eCount generalists plus benefits, compensation, and labor relations, and decide consistently whether to include payroll. How you draw that line is the single biggest influence on your ratio, so the Notes tab has a place to record it.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat is the refund policy?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eDigital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat happens after I buy?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eCheckout delivers an instant download link, and a receipt with the same link arrives by email. Open the workbook in Excel or Google Sheets, enter your total employees and your HR staff, and read your ratio against the typical range for your size. If a file gives you trouble, email support@truestephr.com.\u003c\/p\u003e\u003cp\u003ePlanning estimates and general business information, not legal or tax advice. The right ratio depends on your industry, your HR technology, and how strategic HR needs to be, so treat the benchmarks as a starting point, not a rule, and confirm your figures before you act on them. Last reviewed June 2026.\u003c\/p\u003e","brand":"TrueStep HR","offers":[{"title":"Default Title","offer_id":52641502920980,"sku":"TSHR-016","price":24.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1013\/9048\/3732\/files\/TSHR-016__hr-staffing-ratio-calculator-hero.jpg?v=1780979021","url":"https:\/\/shop.truestephr.com\/products\/hr-staffing-ratio-calculator","provider":"TrueStep HR","version":"1.0","type":"link"}