ZeroDelay Academy · Owner worksheet

Service job cost worksheet: estimate versus actual

A higher quote is not automatically a better job. Compare what you actually collect on similar completed work with the labor, materials and other costs that work actually consumes.

By ZeroDelay.ai · An educational framework, not a customer case study

Compare one job: estimate versus actual

Fictional teaching example, not a customer result or benchmark: this completed job collected $900 before sales tax. Difference means actual cost minus estimated cost; positive amounts are overruns. Callback costs below are extra costs not already counted in original-visit labor, parts or travel.

Direct costEstimateActualChange
Parts$250$250$0
Loaded original-visit labor$250$315+$65
Paid travel$70$70$0
Extra callback cost$0$65+$65
Total direct cost$570$700+$130

Using the same $900 collected revenue for both comparisons: estimated contribution = $900 − $570 = $330; actual contribution = $900 − $700 = $200. Actual contribution rate = $200 ÷ $900 × 100 = 22.2% (rounded). Contribution is before overhead and tax, not net profit; the remainder still has to cover those costs and any unpaid owner time.

The $130 overrun is $65 in labor plus $65 in extra callbacks. Investigate job duration, scope and rework before assuming prices alone are wrong. No margin target or price increase follows from this fictional example.

Copy or print this blank job-cost worksheet

Copy the table into your own document or use your browser's Print command. Fill it in there or on paper; there are no entry fields here. Job/reference: __________. Collected revenue before sales tax: $__________. Compare the same job and cost boundary in both columns.

Direct costEstimateActualChange
Parts$____$____$____
Loaded original-visit labor$____$____$____
Paid travel$____$____$____
Extra callback cost$____$____$____
Other direct costs$____$____$____
Total direct cost$____$____$____

Estimated contribution = collected revenue − estimated direct cost: $__________. Actual contribution = collected revenue − actual direct cost: $__________. If collected revenue is positive, actual contribution rate = actual contribution ÷ collected revenue × 100: ______%. Keep overhead and tax separate; do not count callback costs twice.

This is a manual worksheet, not a new calculator. Numbers you write or copy do not transfer into the diagnostic.

Three checks to do first

  1. Step 1

    Choose comparable completed jobs

    Pick one repeatable service and a recent set of paid invoices. Separate urgent, warranty and unusually large jobs. Record collected revenue before sales tax, discounts and approved change orders; do not compare a list price with a final cost.

  2. Step 2

    Reconcile quoted and actual costs

    For each job, write estimated and actual parts, loaded crew hours, subcontractor charges, paid travel and callbacks not already counted. Note changes in scope separately. Use a consistent definition of direct cost across jobs.

  3. Step 3

    Check contribution before deciding on price

    Direct contribution = collected revenue − actual direct job costs. Contribution rate = direct contribution ÷ collected revenue when revenue is positive. Then consider overhead, unpaid owner time, taxes and the actual market response before deciding whether to change a price, scope or process.

A worksheet using your own records

  1. 1. Invoice cohort

    One row per comparable paid job: quoted amount, approved scope changes, final collected amount, service type and completion date. Keep unpaid invoices outside collected revenue.

  2. 2. Cost bridge

    Add actual parts, loaded original-visit labor, paid travel and separately recorded return-visit costs. If callback hours are already in actual labor, do not add them again. Compare quoted direct costs with actual direct costs for the same job.

  3. 3. Estimate vs actual variance

    For each cost line, write actual − estimated. A positive number means the job consumed more than the quote allowed. Sort jobs by the largest variance and read the job notes: unpriced scope, slower work, extra trips and rework need different fixes.

  4. 4. Decision log

    Mark whether a thin result was driven by price/discount, unapproved scope, materials, job duration, rework or overhead allocation. Test one change at a time and review customer response; the arithmetic alone cannot tell you what the market will accept.

What to decide next

If a consistent job type has thin contribution, investigate scope, time, parts and rework before assuming a blanket price increase. If costs are controlled but collected prices remain low, test a clearly documented price or scope change on comparable quotes and track acceptances and completed-job results.

What this check cannot tell you

An illustrative contribution rate is not a recommended target or a forecast. The free diagnostic can identify a top business constraint from your answers; it does not inspect invoices or set your prices. The optional paid 90-Day Plan adds ranked priorities and financial analysis grounded in the information available, not a guaranteed price or margin.

The free Profit Leak Check's plumbing mode compares hours and callback cost with collected revenue. It is not a pricing engine and does not calculate full net profit. Explore the free Service Business Profit Leak Check. Calculations stay in your browser.

Share this worksheet

Nothing is posted automatically.