Free Excel templates

A free plumbing flat-rate price and break-even planner in Excel

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.

Get the planner

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.

The book behind this planner

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

What is in the file

Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.

Inputs
Service technicians, paid hours, billable share, the full cost of a technician and of a truck, fixed costs a month and the target margin; one typical task (hours, parts, markup); the average ticket, calls a day, working days, conversion, parts and selling shares; and four figures of your last closed year: revenue per call, variable cost per call, fixed costs and actual calls a month.
Planner
Billable hours, total cost a year, cost per billable hour, selling rate and the flat rate of the task; calls a month, margin per call, break-even calls a month, the margin of safety and the owner's income above break-even; then the closed year's contribution per call, break-even (353.4 in the case) and margin of safety (59.4).
Checks
Technicians above zero, a ticket above zero, every share typed as a percent and in range, a positive contribution per call, and an All checks cell.

Three things to try

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.

Questions

Why start from the cost of a billable hour?

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.

Is this a plumbing price book or a code guide?

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.

Related reading