Companion files · The Private Markets Career Guides
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 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.
Chapters 2 and 12
Authorized positions against filled positions month by month, the headcount bridge by site, average headcount and turnover by group. Sheets: Inputs, Positions, Flow, Turnover. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 131 KBChapters 3 and 8
The five lines of total labor cost by group, the load factor of an hourly group and overtime by month. Sheets: Inputs, Total Labor Cost, Load Factor, Overtime. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 232 KBChapters 6 and 7
Grades and ranges, compa-ratios by group, the merit matrix and the merit budgets. Sheets: Inputs, Structure, Compa-Ratio, Merit Matrix. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 320 KBChapters 9, 10 and 11
Medical tiers and the renewal, the employee contribution, full insurance against self-funding with stop-loss, and the 401(k) match. Sheets: Inputs, Tiers, Renewal, Funding, Match. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 422 KBChapter 13
The hiring funnel, hires by group and site, days to fill, offer acceptance and cost per hire. Sheets: Inputs, Funnel, Days to Fill, Cost per Hire. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 521 KBChapters 10, 14 and 16
Three plant options over two years and the health funding choice, all projections. Sheets: Inputs, Plant Options, Health Funding. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 617 KBAppendix B
the first 90 days of an HR director, reading the numbers; the headcount plan and the labor cost budget; the annual pay review; the benefits renewal; hiring one position; an employee’s departure and the exit interview; annual compliance (conditional, counsel decides); the monthly dashboard to the executive team.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| Production turnover | 116 / 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.