A flat rate price book is not complicated. It is a spreadsheet with one row per job you do, and three prices on each row. What makes it hard is that every one of those prices has to be right, and there are a few hundred of them.
You can build one yourself. Plenty of guys do. Here is how I would go about it, with the math shown, so whether you build your own or buy one you know what a good one looks like.
Start with the rate, not the list
Every price in the book is built on one number: what you bill for an hour of labor. Get that wrong and every line is wrong in the same direction, and no amount of work on the list fixes it.
That rate comes from two steps. First your break-even, which is what an hour on the job actually costs you once wages, payroll burden, insurance, vehicles, tools, the office and the hours you do not bill are counted. Then your margin on top of it. The true hourly rate guide walks through the break-even, and the free labor rate calculator does it for you.
For the example in this guide, say your break-even is $98 an hour and you want a 25 percent margin. Margin is a share of the price, not a markup on the cost, so the billed rate is $98 divided by 0.75, which is $131 an hour. If margin and markup still blur together, this one sorts it out.
The columns every line needs
| Column | What goes in it |
|---|---|
| Code | A short ID like EL-104. You need it the day you import the book into field service software. |
| Category | Outlets, panels, water heaters, drains. It is how a tech finds the line on a tablet in a basement. |
| Service | The job, named the way a customer would say it. |
| Unit | Each, per foot, per opening. Most service lines are each. |
| Labor hours | One figure per tier. Real time on site, start to clean-up, not the time it takes on a good day. |
| Material | One allowance per tier, at your cost from your supply house. |
| Good, Better, Best price | The formula below, never typed in by hand. |
| Notes and add-ons | What is not included, and the named add-ons that cover it. |
The formula
For each tier:
Price = (labor hours × billed rate) + (material cost × (1 + material markup)), rounded to the nearest $5.
Keep the billed rate and the markup in their own cells at the top and point every row at them. That way when your insurance goes up in January you change one cell and the whole book moves, instead of retyping three hundred prices. Round at the end, not before, so the rounding never stacks up.
One worked line
Replace a receptacle with a GFCI in an existing box. Billed rate $131 an hour, material markup 50 percent. The material allowances here are for the example only, so use your own supply house prices.
| Tier | Scope | Labor | Material | Price |
|---|---|---|---|---|
| Good | 15 amp tamper-resistant GFCI | 0.5 hr = $65.50 | $18 cost = $27.00 | $92.50, rounded to $95 |
| Better | 20 amp self-test GFCI, downstream outlets tested and labeled | 0.75 hr = $98.25 | $45 cost = $67.50 | $165.75, rounded to $165 |
| Best | Dual-function GFCI and AFCI receptacle, new cover plate, downstream tested and labeled | 1.0 hr = $131.00 | $70 cost = $105.00 | $236.00, rounded to $235 |
Notice what is not in there: the trip. The dispatch or diagnostic fee sits on its own line, charged once per visit, so a customer who wants three outlets done does not pay for three trips. Notice too that each tier is the same job done better, not a different job. Best is not a panel upgrade. It is the best way to do the thing they called about.
Where the time goes
The formula takes ten minutes. The list is the job. For every line you have to decide the scope of three tiers, put honest hours on each, and price the material. Call it ten minutes a line if you know the work cold. Three hundred lines is fifty hours, which is more than a week of evenings, before you have tested a single price on a customer.
Then it has to stay right. Material moves, so the allowances need checking a few times a year. Your rate should be looked at every January and any time your overhead changes, a new truck, a new hire, a new insurance bill.
Mistakes that make a homemade book wrong
- Using somebody else's rate. The guy down the street does not have your truck payment. Work out your own.
- Padding the base price. If every clean job carries the cost of the messy one, you lose the clean ones. Price the base honestly and name the add-ons: aluminum branch wiring, a box that has to be replaced, a meter socket the utility wants changed.
- One markup for everything. Fifty percent on a $3 part and fifty percent on a $3,000 condenser are not the same decision. Most shops step the markup down as the part cost goes up.
- No after-hours rule. Decide the multiplier once and put it in the book, or you will decide it at eleven at night with a customer in front of you.
- Prices typed in by hand. The minute one price is a typed number instead of a formula, the book stops moving with your rate and you will not notice which one.
Build it yourself or start from one that is already built. Either way, the book is only as good as the rate under it and the honesty of the hours on each line. Get those two right and the customer gets the same price in July that they would have got in March, which is most of what they are paying for.