# The Staffing Agency Owner: companion files

Julian R. Sterling

## What is here

- **Staffing_Agency_1_Bill_Rate_and_Markup.xlsx** (Chapters 2 and 4; Bill Rate and Markup workbook of Appendix A): sheets Inputs, Rate, then Checks. One straight hour of one temp: bill rate, spread, burden line by line, loaded cost and gross margin of the hour (Ollerwick Foods, FY2026: bill rate $25.55, gross margin $4.92 an hour, 19.3 percent of the bill rate).
- **Staffing_Agency_2_Burden_and_Wage_Bases.xlsx** (Chapter 3; Burden and Wage Bases workbook): sheets Inputs, Burden, then Checks. One temp's wages across a calendar year, each unemployment tax stopped at its wage base (one Quarbeck temp in 2026: burden $2,994.85, $2.88 an hour).
- **Staffing_Agency_3_Payroll_Gap.xlsx** (Chapter 13; Payroll Gap workbook): sheets Inputs, Gap, then Checks. Thirteen weeks of payroll paid against cash received for one client, and the cumulative gap (Quarbeck, weeks 53 to 65: largest gap $564,429).
- **Staffing_Agency_4_Factoring_and_the_Line.xlsx** (Chapter 14; Factoring and the Line workbook): sheets Inputs, Factoring and Line, then Checks. One invoice sold to a factor and the same invoice financed on a line of credit (Quarbeck's invoice for week 30: a fee of $2,475 against interest of $605).
- **Staffing_Agency_5_Recruiter_Desk.xlsx** (Chapter 9; Recruiter Desk workbook): sheets Inputs, Desk, then Checks. One desk's quarterly commission under a threshold plan, and its output per recruiter (the Quarbeck desk, Q4 FY2026: commission $5,625).
- **Staffing_Agency_6_Conversion_Fee.xlsx** (Chapter 7; Conversion Fee workbook): sheets Inputs, Fee, then Checks. The conversion fee when a client hires temps, in two blocks side by side (Q4 FY2026: Ollerwick $29,120, Quarbeck $0 past the 520-hour line).
- **Staffing_Agency_7_Sale_Price.xlsx** (Chapter 16; Sale Price workbook): sheets Inputs, Price, then Checks. The letter of intent's price formula, from EBITDA to the owner's proceeds at closing (enterprise value $3,272,216, proceeds $2,686,656 before taxes and fees).
- **Staffing_Agency_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (Check-list 1: the rate sheet (chapters 2 and 5); Check-list 2: the burden review each January (chapters 3 and 12); Check-list 3: the weekly payroll and cash review (chapters 13 and 14); Check-list 4: the client agreement (chapters 7 and 8); Check-list 5: the new client (chapters 6 and 15); Check-list 6: the recruiter desk review (chapter 9); Check-list 7: the factoring or line review (chapter 14); Check-list 8: before a sale (chapter 16)).

## How to use the workbooks

Every workbook opens on its Inputs sheet: blue type on a light blue background is an input, and nothing else is typed by hand. The subject sheet is read top to bottom, one line per step. Black type is a formula, green type a figure read from another sheet of the same workbook. The Checks sheet holds the checks of Appendix A: each one is an IF test on your own inputs that shows OK when they hold together and CHECK when they do not. A comparison shown beside a result (the factor's fee beside the line's interest, a desk below its threshold) is a reading aid, never a check.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No date function is used: a week, a quarter or a fiscal year is a label you type. Rates and shares are typed in percent (8, not 0.08), and every division by an input that can be zero is wrapped in IF and shows 0 instead of an error.

To use a workbook on your own agency, start with a copy, replace every blue input from the record that owns each figure (the client agreements and invoices, the payroll register, IRS Publication 15, the state's rate notice, the insurer's rates, the bank statements, the signed factoring or line agreement, the recruiters' written plans, the letter of intent), keep every check at OK, and compare a result only with the same agency's own earlier weeks, quarters and years. Never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share (a pay rate, a burden rate, the line's terms) is typed again where it is used.

## A word of caution

Brevanton Staffing, Inc., the town of Dransmere, Quarbeck Packaging, Ketterbrook Distribution, Ollerwick Foods, Larkhewn Capital, Mossgarrow National Bank and every party in the case are fictional. Pay rates, markups, burden rates, wage bases, payment terms, factoring and line terms, commission plans, fees, prices and multiples are teaching assumptions, not market norms or recommendations. Federal rates are those of November 2026; state unemployment, workers' compensation, staffing agency rules and minimum wages depend on the state: read them with counsel in the agency's state, the insurer's representative and the outside CPA. Nothing here is legal, tax, insurance or accounting advice.
