# The Plumbing Company Owner: companion files

Julian R. Sterling

## What is here

- **Plumbing_1_Flat_Rate_Price_Builder.xlsx** (Chapter 5; Workbook 1 of Appendix A): tabs Inputs, Price, Checks. The cost of the field for a year, the cost per billable hour, the selling rate and the flat rate of a task (the price build of September 2025: 162.78 dollars an hour of cost, a selling rate of $192, a tank water heater at $2,608, a repair at $360).
- **Plumbing_2_Call_Economics_and_Break_Even.xlsx** (Chapter 12; Workbook 2): tabs Inputs, Break-Even, Checks. Break-even in calls a month from a budget (margin per call 393.12 dollars, 300.4 calls a month) and from a closed year (FY2026: 353.4 calls a month against an actual 412.8, a margin of safety of 59.4).
- **Plumbing_3_Technician_Pay_and_Overtime.xlsx** (Chapter 9; Workbook 3): tabs Inputs, Pay, Checks. One technician's workweek with commission, spiffs and an on-call stipend: the regular rate and the extra half-time they add to overtime (week 69: 51.98 dollars an hour, $105 of extra half-time, $3,171 for the week).
- **Plumbing_4_Membership_Plan.xlsx** (Chapter 7; Workbook 4): tabs Inputs, Members, Checks. Membership plans sold week by week, the money received, the money still unearned at the close and the revenue earned (434 plans sold or renewed in FY2026, $44,764 unearned at 27 September 2026, $71,077 earned).
- **Plumbing_5_Trucks_Stock_and_Shrink.xlsx** (Chapters 8 and 11; Workbook 5): tabs Inputs, Fleet, Checks. Shrink against the weekly truck stock counts and the cost of the fleet (FY2026: $12,112 of actual shrink against $32,320 at the old rate, $20,208 saved).
- **Plumbing_6_New_Line_Payback.xlsx** (Chapter 13; Workbook 6): tabs Inputs, Payback, Checks. A new line's payback at its run-rate and at a stressed rate (the sewer line: $167,000 invested, 8.1 months, 16.2 at half the run-rate).
- **Plumbing_7_Value_and_Offer.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from adjusted EBITDA to the cash at closing (enterprise value $1,659,065, rollover $331,813, holdback $132,725, cash at closing $1,029,951).
- **Plumbing_Company_Owner_Check_Lists.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (The license, code and permit file (chapter 2); The weekly call board review (chapters 3 and 4); The price book (chapters 5 and 8); Water heaters, financing and memberships (chapters 6 and 7); Pay and overtime (chapter 9); Hiring, apprentices and contractors (chapter 10); Trucks, stock and a new line (chapters 11 and 13); Before answering an offer (chapters 15 and 16)).

Every workbook opens pre-filled with the exercise of Appendix A, so you can check each result against the book before typing your own figures.

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light yellow background is an input, and nothing else is typed by hand. The subject tab holds formulas only and is protected against overtyping, with no password. The Checks tab holds the tests of Appendix A: each one shows OK or CHECK, and the cell All checks shows OK only when every test below it does. A comparison line informs and carries no OK or CHECK.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No cell holds a date: a week is a numbered row. Percentages are typed as percent (15 percent shows as 15%), and every division by an input that can be zero is wrapped in IF and shows 0 instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN or a MAX over a range skips it. The last section of Appendix A lists, workbook by workbook, what the checks do not catch.

To use a workbook on your own company, start with a copy, replace every blue input from the record that owns each figure (the price book, the call board, the payroll register, the membership list, the truck stock counts, the statements, the bank's schedule, the letter itself), keep every check at OK, and 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 (the total cost of workbook 1, used again in workbook 2) is typed again where it is used.

## A word of caution

Drevington Plumbing & Drain, Inc., the town of Wyckhollow, Fennacre Holdings, Ashlemoor Community Bank, Haskerley Builders and every party in the case are fictional. Call counts, conversion rates, task times, parts costs, prices, markups, trip fees, wages, commissions, spiffs, truck costs, stock levels, shrink rates, rents, loan terms, quotes and multiples are teaching assumptions, not market norms, not the rule of any state and not recommendations. Nothing here is a plumbing, code or safety instruction. What a state requires is for its licensing board, the building department and counsel; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
