How to Build a Flat-Rate Plumbing Price Book
By Eric Hanson, Owner & Founder, PlumbRate
A flat-rate price book does one job: it lets anyone on your team quote the same price for the same job, every time, without calling you. Building one from scratch is very doable, it just takes more hours than most owners expect. Here is the process I would follow, whether you build your own spreadsheet or start from a prebuilt book.
1. Decide which services belong in the book
Start with the work you actually do every week, not every job you have ever touched. For a residential service shop that usually means faucet, toilet, and disposer repair and replacement, water heaters, drains, leaks, shut-off valves, and hose bibbs. A book that covers your top few dozen recurring services well beats a huge book full of jobs you quote once a year. You can always add rows later.
2. Use clear, specific service names
Give each service a name that the customer and technician can understand without decoding shop shorthand. When two jobs have materially different scopes, create separate rows with specific names instead of forcing both into one broad service. The owner should review any job-specific exception before the technician quotes the price. The customer-facing Print Price Sheet shows the service name and calculated price, not a dedicated field for scope notes.
3. Determine your fully loaded hourly rate
Your rate has to cover technician wages with burden, vehicle costs, and company overhead, divided by the hours you can actually bill, not the hours you schedule. That calculation deserves its own walkthrough: how to calculate a plumbing company's billable hourly rate. You can also run your own numbers through the free hourly rate calculator.
4. Assign realistic labor hours to each service
For each service, estimate how long a competent tech takes including setup, cleanup, and the trip to the truck. Do not use the best time you ever did it in. National service-plumbing averages are a reasonable starting point if you have no records, but treat them as starting points to review against your own experience, not as the right answer for your shop.
5. Add local material cost and markup
Enter what the material actually costs you locally, then apply your markup. The markup is not pure profit. It covers purchasing, stocking, waste, warranty callbacks, and the risk that a part fails or prices move between ordering and install. Keep it material-related only: the trip and labor to go back are already covered by your hourly rate and overhead, so do not count them here too. Keep the markup in its own column so you can adjust it per service. Review the full job economics, including rate, hours, materials, and markup, rather than any one number in isolation.
6. Set a minimum charge
Small jobs still cost a drive out and a diagnosis. A minimum charge keeps a ten-minute washer replacement from being priced below what the visit costs you. Every calculated price should round up to at least that floor.
7. Put the math together with an illustrative example
Here is one sample calculation with made-up round numbers, purely to show the shape of the math. It is not a recommended rate, markup, or price:
Labor: 1.5 hours × $170/hr = $255
Material: $40 cost at 50% markup = $60
Example sell price: $315 before taxes or any job-specific adjustments
Your rate, hours, costs, and markup will be different. That is the point of building the book from your own numbers.
8. Review, then print a customer-facing sheet
The working file contains your internal numbers, including labor hours, your rate, material costs, and markups. That stays with you. What your techs carry is a customer-facing print sheet: each service with one lump-sum price and no internal breakdown. Print it, laminate it, or save it as a PDF on their phones. Techs do not need the full workbook to quote. The full workbook exposes costs and rates you probably do not want shared.
9. Test it against real jobs, then revise
Before you trust the book, pull a handful of recently completed jobs and compare what the book would have charged against what you actually charged and how long the job really took. Where the book is off, adjust the labor hours or material cost for that service, not the whole rate. Expect a few rounds of this in the first months; a price book is a living document, not a one-time project.
The shortcut: start from a prebuilt book
I built my own price book in interrupted evening sessions over well over 40 hours. PlumbRate exists so you can skip that: 208 residential service rows, 191 commercial rows, or 399 combined, in an editable Excel workbook with unprotected formulas and a customer-facing Print Price Sheet already linked up. You set your rate, markup, and minimum, review the prices, and print.