This is a free electrical estimate template for electricians and small contractors. The Excel file has a project block, a device takeoff table, a labor rate, overhead and markup percentages, a totals block that works by formula, and a space for exclusions and clarifications. The PDF is the same form for printing and filling in by hand.
Five rows in the table are labeled "Example". They show how the formulas behave. Their prices and hours are placeholders. They are not labor units from any book, and you should replace them with your own numbers.
What is in the Excel file
1. Project info. Project name, address, client or general contractor, who prepared the estimate, the date, and the bid due date.
2. Device takeoff table. One row per item:
| Column | What you enter or what it does |
|---|---|
| Item | Description, for example "Duplex receptacle, 20 A" |
| Qty | The count from your takeoff |
| Unit | each, feet, and so on |
| Material $ each | Your supplier price per unit |
| Labor hours each | Your own hours per unit |
| Material $ extended | Formula: qty × material price |
| Labor hours extended | Formula: qty × hours each |
| Labor $ extended | Formula: extended hours × your labor rate |
There are 24 rows. Add more by inserting a row inside the table and copying the formulas down.
3. Rates and totals. You enter the labor rate (dollars per hour), overhead percent and markup percent. The sheet then calculates the material subtotal, total labor hours, labor cost, direct cost, overhead, cost with overhead, markup, and the total bid.
4. Exclusions and clarifications. Ten lines, with a few starter lines you can edit or delete.
Yellow cells are for you to fill in. Everything else is a formula.
How the math works
Every number comes from the same chain:
- Extended material = quantity × material price each.
- Extended hours = quantity × hours each.
- Labor cost = total hours × labor rate.
- Direct cost = material subtotal + labor cost.
- Overhead = direct cost × overhead percent.
- Markup = (direct cost + overhead) × markup percent.
- Total bid = direct cost + overhead + markup.
Markup is applied to cost with overhead, not to direct cost alone. If you prefer to add markup to direct cost only, change the markup formula in the totals block. Know which method you use, because the same percentages give different totals.
Worked example
Example, with made-up rates. Not real prices or labor units. Take 20 receptacles, 12 switches and 14 recessed lights, a labor rate of $60 per hour, overhead of 12% and markup of 15%.
Line cost = qty × (material each + minutes ÷ 60 × labor rate).
| Item | Qty | Material each | Minutes each | Labor each | Line |
|---|---|---|---|---|---|
| Receptacle | 20 | $4.50 | 18 | 18 ÷ 60 × $60 = $18.00 | 20 × $22.50 = $450.00 |
| Switch | 12 | $5.00 | 15 | 15 ÷ 60 × $60 = $15.00 | 12 × $20.00 = $240.00 |
| Recessed light | 14 | $38.00 | 30 | 30 ÷ 60 × $60 = $30.00 | 14 × $68.00 = $952.00 |
- Direct cost (subtotal): $450.00 + $240.00 + $952.00 = $1,642.00
- Overhead, 12%: $1,642.00 × 0.12 = $197.04
- Cost with overhead: $1,642.00 + $197.04 = $1,839.04
- Total with 15% markup: $1,839.04 × 1.15 = $2,114.90 (rounded)
Price per opening. Divide the total by the number of devices: 46 devices, so $2,114.90 ÷ 46 = about $45.98 per opening. It is a rule-of-thumb sanity check, not a pricing method. It hides large differences between items (here a light costs more than three times a switch), and it shifts with wire runs, ceiling height, wall type and how much equipment is on the job. Compare it only with your own past jobs of a similar type.
Where the numbers come from
The template does not include prices or labor units. That is on purpose.
- Quantities come from your takeoff: you count the devices on the drawings. If you want a faster count, see electrical takeoff software and the sample takeoffs to judge how an AI count looks on real drawings.
- Material prices come from your supplier quotes. They change often, so date every quote.
- Labor hours come from your own history: jobs you have finished and timed. Many contractors also buy a published labor-unit book. If you do, enter the figures yourself from your own copy. We do not copy anyone's published units into this file.
- Labor rate should be loaded: wages, taxes, insurance and benefits, not just the pay rate.
- Overhead and markup are business decisions. Use your own numbers.
Filling it in, step by step
- Fill in the project block.
- Finish your takeoff. Count devices by type and sheet, and separate new work from existing and relocated devices. Our guide on how to read electrical blueprints covers the symbols and the traps.
- Delete the Example rows and type your own items. Keep one line per device type.
- Enter prices and hours.
- Enter the labor rate, overhead and markup.
- Write the exclusions: permits, patching, items by others, working hours, and anything the drawings leave open.
- Check the total against a rough check, such as price per opening or per square foot from your past jobs. A bid far from that range needs a second look.
Use RFIs to protect the number
Every open question on the drawings changes the price. If a drawing leaves something unclear, write down how you priced it and ask. Our construction RFI template has a "priced as" line for exactly this. Put the same assumption in your clarifications so the estimate and the RFI say the same thing. For a wider view of the bidding process, see how to bid electrical jobs.
Before you finalize, cross-check device counts against the circuit loads with the electrical panel schedule template. Long feeders may need a voltage drop calculator pass, and conduit sizing may need the conduit fill calculator.
What the template does not do
- It does not calculate wire and conduit lengths. Our takeoff software estimates lengths from the drawings (estimates, not field measurements); in this template you enter feet yourself.
- It does not include tax, bonds, or payment terms.
- It does not add a contingency line. Add a row if you carry one.
- It is not a legal proposal. Your contract terms go in a separate document.
FAQ
Yes. Type your hours in the "Labor hours each" column. The file has no built-in units, so what you enter is what the totals use.
In this file, overhead is added first and markup is applied to the sum of direct cost and overhead. You can change the formula if your company does it differently.
Yes. The PDF has the same layout, with blank rows and lines for totals. It is useful for field estimates or a quick written quote. The Excel file does the math for you.
References
Sources
This page uses no outside documents. The formulas are plain arithmetic, the layout is our own, and the worked example uses made-up numbers. The template has not been reviewed by a working estimator. Overhead is added before markup, which is one common method; change the formula if you do it differently.
