Free Plumbing Estimate Template (Excel)
Example bid in this template: $8,921 · Timeline: 1 weeks
Real-World Scenario: New Bath Rough & Finish
Materials Cost Breakdown
Direct Material| Line Item | Cost | Notes |
|---|---|---|
| PEX Pipe & Fittings | $650 | Supply lines for h/c |
| PVC Waste & Vent | $480 | 3-inch stack + branch lines |
| Rough-in Valves | $350 | Pressure-balanced shower unit |
| Materials Subtotal | $1,480 |
Labor Cost Breakdown
Direct Labor| Task | Cost | Notes |
|---|---|---|
| Waste/Vent Rough | $1,800 | Core drilling + assembly |
| Supply Line Rough | $1,200 | Homerun system to manifold |
| Fixture Trim & Set | $950 | Setting toilet, sink, tub |
| Labor Subtotal | $3,950 |
Markup ≠ Margin — Don't Make This Mistake
A 30% markup on $5,430 gives 23% gross margin — not 30%. To hit a true 30% gross margin, divide your cost by 0.70.
→ Verify with the Profit CalculatorFrequently Asked Questions
How do I estimate a plumbing job?
Split the work into waste and vent rough-in, supply rough-in and fixture trim, then price materials and labor for each. Add overhead and divide by (1 minus your margin) to get the bid price.
How is the example price calculated?
Materials are $1,480 and labor is $3,950, so direct cost is $5,430. Adding 15% overhead ($815) gives about $6,245. At a 30% gross margin, divide by 0.70 to reach a bid price of about $8,921.
What access assumptions are built into the example?
The scenario assumes a first-floor bathroom with crawlspace access for waste and supply lines. If access is harder, for example a slab or second floor, add labor time or a clearly stated exclusion.
Should permits and inspections be on the estimate?
Plumbing work usually needs a permit and inspection, and the rules vary by jurisdiction. Include a permit line or state that fees are billed separately so the cost does not come out of your margin.
Does this template match the real-world costs you see on-site?
Your answer helps us improve our financial tools and guides for the trade.
"Does this template match the real-world costs you see on-site?"
Feedback Received
Thank you. Your real-world input helps us build better financial tools for the trade.