Companion files · The Private Markets Career Guides

The HR Director

How to Run Human Resources by the Numbers: Headcount Plans, Total Labor Cost, Pay Structures, Merit Budgets, Benefits Renewals, Turnover, Hiring and the Executive Team.

These are the companion files of the book. Six workbooks follow Corlethby Building Products, the fictional company of the case, across two calendar years: headcount and turnover, labor cost, pay structure and merit, benefits, hiring, and the decisions put to the executive team in November 2025. Each opens on one sheet of inputs and ends on a Checks sheet. A toolkit holds the check-lists of Appendix B in editable form.

The six workbooks, the toolkit and the read-me, in one archive176 KB

The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

Production turnover116 / 231.1 = 50.2 percent in 2025: departures over average headcount
Production total labor cost$14,891,129 in 2025: wages, employer payroll taxes, workers’ compensation, benefits and the 401(k) match
Self-funding$7,653,192 expected for 2026 against $8,473,511 fully insured, and $9,394,692 in the worst case: projections

The files are provided as they are, without warranty of any kind. The model is illustrative: Corlethby Building Products, its sites, its officers, its staff, its broker and every party are fictional; the pay rates, salaries, premiums, fees and costs are the book’s assumptions, not market terms or the practice of any real company. Nothing here promises lower turnover or lower costs. Where state law sets a rule, ask counsel.