How to estimate a remodel without spending the weekend on it

You get home from a remodel visit with measurements, photos, and another estimate waiting for the weekend. Copy a master sheet with one tab per trade, then fill the quantities and costs instead of rebuilding the bid.

This guide teaches how to estimate a remodel with a sheet layout and pricing checks you can use on your next visit. The goal is a repeatable estimate you can explain, with missing information clearly marked before it becomes a promise.

Software that sends the quote does not invent the number. You still need to decide what the job includes, who does the work, and what it costs your business to deliver it.

How to estimate a remodel from a master sheet

Start with the work you actually sell. If you remodel bathrooms, your workbook might have tabs for demolition, carpentry, plumbing, electrical, tile, and painting. A kitchen contractor might add cabinets and countertops. Do not build a commercial estimating manual for work you never bid.

Add a Summary tab and a Job costs tab. Summary holds the project name, scope version, trade totals, pricing calculation, and unresolved questions. Job costs holds items that cross trades: protection, disposal, delivery, rentals, supervision, and final cleanup.

Build the first master from a completed job whose costs you can check. Copy its useful scope rows, then remove the customer's details and old quantities. Keep descriptions such as “protect route from entry to bathroom” that remind you of work easily forgotten.

Save the master separately. For each bid, duplicate the whole workbook and name the copy with the client, project, and revision date. Never turn the master itself into the next estimate.

Keep optional rows and hide them when the job does not need them. Use an Included column to control whether a row contributes to the total. Hiding a spreadsheet row alone does not reliably remove its value from a SUM formula. An excluded row must calculate to zero before you hide it.

Give every trade the same columns

Use the same layout across tabs so you can check plumbing the same way you check painting. Separate your purchases, your labor, and the sub's number.

For a simple spreadsheet, use these columns: A Included, B Scope, C Quantity, D Unit, E Material unit cost, F Own labor hours, G Loaded labor cost/hour, H Sub number, I Other direct cost, J Row total, K Source/status, and L Notes.

The row-total formula in J2 is:

=IF(A2="Yes",C2E2+F2G2+H2+I2,0)

Use numeric zeros in unused cost fields. Keep explanations in the notes column. Protect formula cells so editing a quantity cannot overwrite the calculation.

A sub doing the entire tile installation gets a sub number. Your labor columns stay zero unless your crew has separate work, such as unloading materials. If that bid includes setting materials, those materials also stay out of your purchase columns.

Bring back scope, not just measurements

Use the master sheet as the visit checklist. For each trade, collect enough information to price the work or name the question that prevents it.

Measure the work area and photograph the conditions that affect access and installation. Record fixture locations, finish choices, stairs, parking, occupied rooms, and the route for hauling debris. A floor measurement will not tell you how long protection and cleanup take.

Write down who supplies each major item. “Owner supplies vanity” still leaves receiving, inspection, carrying, assembly, and installation to resolve. Decide which of those tasks you are pricing.

Separate three kinds of information:

• Known scope: measured work with a defined product or method.
• Selection allowance: a stated amount for something the client has not chosen, with a clear description of what that amount covers.
• Unresolved condition: something that could change the work, such as concealed damage or an unverified electrical requirement.

Do not turn the third category into a confident fixed price just to finish the sheet. Get the missing information, narrow the scope, or explain how additional work will be priced and approved.

A useful visit note reads: “Retain toilet location; owner supplies vanity; electrical bid pending; concealed subfloor condition unverified.” That gives you decisions to resolve at the desk. “Bathroom remodel” gives you another blank page.

Request sub bids with the same boundaries

A sub's number is only useful when you know what it buys. Send the same scope, photos, and relevant measurements you used in your sheet. Ask for exclusions alongside the price.

Copy this request and replace the brackets:

Subject: Plumbing bid request - [project/address] Please price the plumbing scope below using the attached photos and fixture information. Retain the toilet location. Replace the vanity faucet and connect the owner-supplied vanity. Replace the shower valve and trim with [specified model]. Please state whether your price includes materials, disposal, permit responsibility, and return visits for trim-out. List exclusions and any condition you need to inspect before confirming the number. Please reply by [date], or tell me when you can provide a confirmed bid.

Record the bid date and reference beside the number. If the sub excludes a task, assign it to your crew, another sub, or the quote's exclusions. An exclusion cannot stay buried in the attachment while your client quote promises the whole job.

Use a simple release rule: a material missing cost keeps a fixed-price quote in draft. You can send a clearly qualified preliminary budget while waiting, but label it accordingly.

Cost your own labor before adding markup

Your own time belongs in the estimate even when you do not run payroll for yourself. Enter the hours needed to perform the task and a labor cost rate that reflects how your business accounts for that work.

For employees, wages alone may leave out employer payroll costs and benefits. University of Maine Extension explains that those costs can sit in a loaded labor rate or in overhead; the calculation must account for them consistently. Do not include them in both places. University of Maine Extension pricing guide

Break labor into tasks you can check against completed jobs. “Install vanity” might need separate time for receiving, carrying, assembly, setting, and connecting, depending on who does each task. Include setup and cleanup where they belong.

Keep company overhead separate from direct job costs in your pricing method. You need a way to recover expenses such as insurance and office work, whether through an overhead allocation or through the amount added above direct costs. Use one consistent method so you can tell what remains as profit.

Put markup on the Summary tab

Keep the pricing calculation in one visible place. For this layout, trade tabs carry costs and Summary applies markup once. Do not mark up each tab and then unknowingly mark up the combined selling prices again.

The contractor markup vs margin distinction matters because the percentages use different bases. Markup divides the amount above cost by cost. Margin divides it by selling price. University of Maine Extension pricing guide

Use these formulas:

• Selling price with markup: Cost × (1 + markup).
• Selling price for a target margin: Cost ÷ (1 − margin).

Label the input “Markup on direct cost” if that is what your sheet uses. Add a note beside it: “For a target margin, use the margin formula; do not enter the same percentage here.”

The markup must support your overhead and profit needs. The example below demonstrates arithmetic, not a recommended rate or a market price.

Worked example: a small bathroom scope

These are invented teaching inputs, not customer results, supplier prices, or a bathroom cost benchmark. Replace every amount with your own records and confirmed bids. The example assumes the listed purchases already include their applicable acquisition costs and shows the selling price before any separately applicable customer sales tax.

At an illustrative 25% markup, the selling price is id="root"1,200 × 1.25 = id="root"4,000. The $2,800 above direct cost is 20% of the selling price, before company overhead and other expenses. It is not $2,800 of net profit.

For a 25% margin over the same direct-cost base, the calculation is id="root"1,200 ÷ 0.75 = id="root"4,933.33. That difference comes from the formula, not from extra scope.

Before using the total, inspect the tile bid. This example assumes its id="root",800 covers installation while your id="root",200 covers the materials you purchase. If the sub includes those same materials, remove the duplicated purchase cost.

Use a bounded desk session

For a familiar job with complete inputs, try the following one-hour working agenda. It is a suggested time budget, not a promise that every remodel can be priced in an hour. A missing sub bid or uncertain scope may require more work.

Use the gap check to look for unassigned tasks, stale prices, double-counted materials, and labor entered as crew-hours instead of person-hours. Then compare the client scope against the cost sheet line by line.

If you cannot finish, leave a short pending list with an owner and next action for each item. That lets you resume at the missing decision instead of rereading the whole job.

Send the scope with the finished number

The client needs a clear description of what the price buys. Your internal labor rate and sub costs can stay in the workbook. Carry inclusions, selections, allowances, and exclusions into the quote.

A copyable scope note might read:

This price covers the bathroom work listed in the attached scope, with the toilet and shower locations retained. The owner supplies the vanity listed in the selections schedule. Concealed damage outside the listed repair scope is excluded. If additional work is needed, we will describe it and provide a price for approval before proceeding.

PikeBuild is not a cost database and not a takeoff tool. It sends the finished number and helps you follow it up. Its default AI setting drafts client emails for your approval; those drafts are not automatically sent. A cost database is a different product category, supplying cost references rather than replacing your job-specific scope decisions.

Feed completed costs back into the master

Keep the sent estimate unchanged as the record of what you priced. After the job, compare estimated and actual costs by trade, separating scope changes from estimating misses. Update the master where the evidence supports a change.

If you are evaluating QuickBooks for remodelers, look at how your specific version handles job costs and estimated-versus-actual reporting. Intuit documents that comparison for QuickBooks Desktop Enterprise; that does not establish identical features across every QuickBooks plan. Intuit's contractor job-costing page

A useful correction names the task and cause: protection took longer because the access route crossed occupied rooms. Add that condition to the master so the next visit captures it.

Sources

• University of Maine Extension: Basic Pricing Strategies for Small Businesses - labor cost, overhead, and markup versus margin.
• Intuit: QuickBooks Desktop Enterprise contractor job costing - documented estimated-versus-actual cost comparison.

Once your number is ready, see how PikeBuild keeps AI emails under your control.