The cost of a billable hour turned into a selling rate and a flat rate, and a year of costs turned into the calls a month a plumbing company needs. One sheet of inputs, live formulas and four checks.
The file opens on the book's fictional company and its price build of September 2025. Six service technicians, 2,340 paid hours a year each, 62 percent of them billable: 1,450.8 billable hours each. A year of field, truck and fixed costs of $1,416,960 makes $162.78 a billable hour, a selling rate of $192 at a 15 percent target margin, and a tank water heater at $2,608. At $650 a converted call the plan breaks even at 300.4 calls a month.
One Excel file, no macros, nothing locked on the Inputs tab. Free: enter your email address and the download opens at once, along with the other free models.
Plumbing_Company_Flat_Rate_Price_and_Break_Even_Planner.xlsx (11 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is drawn from workbooks 1 and 2 of The Plumbing Company Owner, which follows one fictional plumbing company through two fiscal years: the move from time and materials to flat-rate prices, water heaters and consumer financing, memberships, technician pay with commission and spiffs, trucks and shrink, break-even in calls a month, a new sewer crew and a letter of intent from a platform.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.
Raise the target margin to 20 percent. The cost per billable hour does not move; the selling rate goes from $192 to $203 and the tank water heater from $2,608 to $2,652. Only the hours part of the price moves.
Cut the billable share. Type 55 percent instead of 62 and watch the cost per billable hour climb: the same people and trucks spread over fewer hours that can be sold.
Add a fixed cost. In the case, $60,000 more a year moves the closed year's break-even from 353.4 to 367.0 calls a month. Do it before signing a lease, a hire or a truck.
Because a flat rate is a price for a task, and the task's cost is mostly the hours of a technician and a truck. Divide the year's cost by the hours that can be billed, not by the hours paid, or the price will not cover the hours spent driving, waiting and training.
No. The task hours, parts and prices are the book's teaching assumptions, not market prices, and nothing here says how a job must be done or what a code requires.