Unit Price Book Template: Contractor Price List and Estimating Spreadsheet with Customer Price Sheet, Excel & Google Sheets

Every estimate rebuilt from scratch. Two estimators, two prices for the same storm inlet. A unit price book fixes both.

The Unit Price Book Template is for owners, estimators and project managers who want every bid to start from the same numbers. Price your common work once, per unit, from your own costs, then reuse it on every estimate, change order and customer price list. One workbook opens in Excel or Google Sheets. A printable worksheet, a customer price sheet and a short guide are included.

WHAT'S INCLUDED

- Price book workbook (.xlsx, no macros). The same file opens in Excel or Google Sheets.

- Start Here: how a unit price is built, markup vs margin, units, printing

- Company Rates: burdened labor rate by class, equipment rates by the hour, overhead method (% of direct cost, $ per labor hour or % of price), target net margin and price rounding

- Price Book: 57 editable starter items across sitework, earthwork, erosion control, storm, sanitary and water, concrete, paving, restoration and hourly rates, with room for 200. Enter labor hours, material, equipment hours and sub cost per unit; get direct cost, overhead, break-even, unit price, net margin and markup on every line

- Assembly Builder: 6 assemblies of up to 10 items each (for example, a storm inlet complete), priced per assembly unit

- Customer Price Sheet: a printable price list with code, description, unit and price only. Your costs and margins never show

- Examples: every starter item with fictional EXAMPLE hours and costs worked out, clearly labeled EXAMPLE

- Printable unit price worksheet (PDF, fill by hand): build-up page and price book log

- Printable customer price sheet (PDF)

- Short PDF guide: how unit pricing works, building your book from past jobs, assemblies, keeping it current, an optional AI workflow, opening it in Google Sheets

COMPATIBILITY

PDFs print on US Letter. The workbook works in Excel 2016 or later (Windows or Mac, including Microsoft 365) and in Google Sheets. No macros.

GOOD TO KNOW

- Instant download. One-business license: use it on all your company's projects and print as many copies as you need.

- The starter items ship with descriptions, units, labor classes and equipment filled in. Hours and costs are yours to enter: unit prices from another company or region would be wrong for you. The Examples tab shows fictional EXAMPLE values so you can see the math. They are not market rates.

- Not tax, legal or accounting advice. Example figures are fictional and labeled EXAMPLE. Verify every price with your own costs.

- Margin means net margin as a share of the price: price = (direct cost + overhead) / (1 - margin). A 10% margin is an 11.1% markup on break-even cost.

- AI disclosure: designed by Patrick Foundry with AI assistance. Files were checked by automated QC (formula recalculation and page renders).

- Questions about the files? Email kits@patrickfoundry.com with your order number.

PRICE

$24. One price for the full kit.

MORE KITS

Need a real burdened labor rate for your price book? Pair this with the True Hourly Cost / Labor Burden Calculator: https://payhip.com/b/6g0vx

Need your overhead rate and target margin? Pair it with the Overhead & Markup vs Margin Calculator: https://payhip.com/b/0w3gJ

SKUFF

Want pricing and job costing in an app? Join the SKUFF field app waitlist: https://patrickfoundry.com/skuff

GET EVERY KIT

Get every Foundry Field Office kit, and each new one as it ships, with the Foundry Field Office Membership: $15/mo or $149/yr. https://payhip.com/b/2V97I

REFUND POLICY: These are instant digital downloads. If a file won't open, is damaged, or isn't what the listing describes, email kits@patrickfoundry.com within 14 days of purchase with your order number and we'll fix it or refund you in full. Because the files can't be returned once downloaded, we don't otherwise offer refunds for change of mind.