Template
Job Costing Examples:Three Estimate-vs-Actual Cost Sheets for Electrical, Plumbing and Hardscape Jobs
Job costing examples for electrical, plumbing and hardscape jobs: estimate vs actual by labor, materials, equipment and subcontract, with published rates.
Job costing examples set one job's estimated cost against its actual cost, line by line: labor hours at a loaded rate, materials, equipment hours and subcontract bills, with the variance on each line and the margin left at the end. The three sheets below cost an electrical, a plumbing and a hardscape job in Rhode Island from published rates.
The sheets are among the free field service templates from FieldRanger, field service software that runs inside HubSpot. The method, defined on a plumbing repipe with overhead applied, is in the glossary entry what is job costing. This page applies its columns to three trades and stops at gross margin.
Job cost sheet fields and what goes in each
The table lists the template's fields, offered as a free .xlsx download with no sign-up; each example below fills it for one job.
| Field | What goes in it |
|---|---|
| Job number and customer | The number shared with the estimate and work order, the customer and the site |
| Trade and price basis | The work type, the contract price, and whether it is fixed price or time and materials |
| Estimate date | When the estimate was priced, and the rate tables it used |
| Cost category | Labor, materials, equipment or subcontract |
| Line description | The task, item or machine, specific enough to match a timesheet or invoice |
| Estimated quantity and unit | Hours, square feet, tons, each or lot |
| Unit cost | The loaded labor rate, supplier price, equipment hourly rate or subcontract price |
| Estimated cost | Quantity times unit cost |
| Actual quantity | Hours from timesheets, quantities from delivery tickets, machine hours from the equipment log |
| Actual cost | Actual quantity times unit cost, or the invoice amount for a subcontract |
| Variance | Actual cost less estimated cost, in dollars, and as a percent of the estimate at the total |
| Source document | Timesheet, supplier invoice, equipment log or subcontractor invoice behind each actual figure |
| Change orders | Approved changes, added to both the price and the estimate so the variance stays comparable |
| Gross profit and margin | Price less total cost, and that profit as a percent of the price |
| Variance note | The reason for each line that moved |
Rates behind the three sheets
Every rate comes from a published table; the materials prices, subcontract bills and contract prices are illustrative. Wages are Rhode Island medians from the state's Department of Labor and Training, in its 2025 Occupational Wage Report published May 2026 (RI DLT, Occupational Wage Report, checked November 2026).
Wages are then loaded for benefits and payroll taxes. In June 2026, wages and salaries were 69.5 percent of employer compensation costs in the construction industry, $36.13 of $51.96 an hour (BLS, Employer Costs for Employee Compensation, Table 4, released September 9, 2026). Each loaded rate is the median wage divided by 0.695.
Equipment is charged by the machine hour from FEMA's 2025 Schedule of Equipment Rates. The rates cover ownership and operation, including depreciation, overhead, maintenance, field repairs, fuel, lubricants and tires, and exclude the operator's labor (FEMA, Schedule of Equipment Rates, updated April 8, 2026). FEMA sets them for disaster reimbursement; here they are a published benchmark, not a rental quote (FEMA 2025 rate table).
| Resource | Published rate | Rate on the sheet |
|---|---|---|
| Electrician, Rhode Island median wage | $35.62 an hour | $51.25 loaded |
| Plumber, Rhode Island median wage | $36.77 an hour | $52.91 loaded |
| Hand laborer, Rhode Island median wage | $20.05 an hour | $28.85 loaded |
| Landscaping and groundskeeping worker, Rhode Island median wage | $21.51 an hour | $30.95 loaded |
| Articulating boom lift, 33 ft (FEMA code 8490) | $38.27 an hour | $38.27 |
| Hydraulic excavator, Caterpillar 305 CR (code 8280) | $57.14 an hour | $57.14 |
| Skid steer loader, Bobcat S70 (code 8540) | $31.06 an hour | $31.06 |
| Hand-held vibratory compactor (code 8220) | $15.52 an hour | $15.52 |
| Pickup, RAM 1500 (code 8071) | $15.29 an hour | $15.29 |
Job costing example 1: parking-lot light replacement in Warwick, Rhode Island
An electrical contractor replaced eight metal-halide pole heads with LED fixtures at a retail plaza for a fixed price of $6,950.00. Two electricians worked from a boom lift, and a recycler took the old lamps.
| Line | Est. qty | Actual qty | Unit cost | Estimate | Actual | Variance |
|---|---|---|---|---|---|---|
| Labor: electricians | 14.0 h | 16.5 h | $51.25 | $717.50 | $845.63 | +$128.13 |
| Materials: LED area fixtures | 8 | 8 | $385.00 | $3,080.00 | $3,080.00 | $0.00 |
| Materials: slip-fitter adapters | 8 | 8 | $42.00 | $336.00 | $336.00 | $0.00 |
| Materials: wire, fuses, connectors | 1 lot | 1 lot | invoice | $145.00 | $207.00 | +$62.00 |
| Equipment: boom lift | 7.0 h | 8.5 h | $38.27 | $267.89 | $325.30 | +$57.41 |
| Equipment: pickup | 7.0 h | 8.5 h | $15.29 | $107.03 | $129.97 | +$22.94 |
| Subcontract: lamp recycling | 1 | 1 | invoice | $180.00 | $180.00 | $0.00 |
| Total cost | $4,833.42 | $5,103.90 | +$270.48 | |||
| Gross profit on $6,950.00 | $2,116.58 | $1,846.10 | -$270.48 | |||
| Gross margin | 30.45% | 26.56% | -3.89 points |
The variance note for this job has one entry. Pole 6 had a corroded fuse holder in its base, so the crew replaced both holders and rewired the base: 2.5 extra labor hours, $62.00 of parts, and the same 1.5 hours on the lift and the truck. Labor carried $128.13 of the $270.48, or 47.4 percent.
Job costing example 2: sewer lateral spot repair in Cranston, Rhode Island
A plumbing company replaced a cracked 10-foot section of a house's sewer lateral under the driveway for a fixed price of $4,950.00. A plumber and a laborer dug with a compact excavator, and a paving subcontractor patched the asphalt.
| Line | Est. qty | Actual qty | Unit cost | Estimate | Actual | Variance |
|---|---|---|---|---|---|---|
| Labor: plumber | 10.0 h | 13.0 h | $52.91 | $529.10 | $687.83 | +$158.73 |
| Labor: laborer | 10.0 h | 13.0 h | $28.85 | $288.50 | $375.05 | +$86.55 |
| Materials: PVC sewer pipe, 10 ft lengths | 2 | 2 | $48.00 | $96.00 | $96.00 | $0.00 |
| Materials: couplings, adapters, cleanout | 1 lot | 1 lot | invoice | $165.00 | $165.00 | $0.00 |
| Materials: bedding stone | 3 tons | 5 tons | $42.00 | $126.00 | $210.00 | +$84.00 |
| Equipment: excavator | 6.0 h | 8.0 h | $57.14 | $342.84 | $457.12 | +$114.28 |
| Equipment: compactor | 1.5 h | 2.0 h | $15.52 | $23.28 | $31.04 | +$7.76 |
| Equipment: pickup | 10.0 h | 13.0 h | $15.29 | $152.90 | $198.77 | +$45.87 |
| Subcontract: driveway asphalt patch | 1 | 1 | invoice | $950.00 | $1,120.00 | +$170.00 |
| Total cost | $2,673.62 | $3,340.81 | +$667.19 | |||
| Gross profit on $4,950.00 | $2,276.38 | $1,609.19 | -$667.19 | |||
| Gross margin | 45.99% | 32.51% | -13.48 points |
Groundwater entered the trench at 5 feet. Pumping and shoring added 3 hours for both workers and 2 on the excavator; the soft bottom took 2 more tons of stone. The wider trench left a wider cut in the driveway, and the paving bill rose by $170.00. A cost overrun of 24.95 percent on a fixed price took 13.48 points of margin.
Job costing example 3: paver patio in Middletown, Rhode Island
A landscape company built a 300-square-foot paver patio with a curved edge for a fixed price of $8,400.00. A crew of three graded with a skid steer, compacted the base, and sent excavated soil away with a hauling subcontractor.
| Line | Est. qty | Actual qty | Unit cost | Estimate | Actual | Variance |
|---|---|---|---|---|---|---|
| Labor: landscape crew of three | 60.0 h | 66.0 h | $30.95 | $1,857.00 | $2,042.70 | +$185.70 |
| Materials: pavers | 315 sq ft | 330 sq ft | $4.10 | $1,291.50 | $1,353.00 | +$61.50 |
| Materials: base gravel | 7 tons | 7 tons | $38.00 | $266.00 | $266.00 | $0.00 |
| Materials: bedding sand | 2 tons | 2 tons | $42.00 | $84.00 | $84.00 | $0.00 |
| Materials: edge restraint | 70 ft | 70 ft | $1.60 | $112.00 | $112.00 | $0.00 |
| Materials: polymeric sand | 6 bags | 7 bags | $34.00 | $204.00 | $238.00 | +$34.00 |
| Equipment: skid steer | 10.0 h | 12.0 h | $31.06 | $310.60 | $372.72 | +$62.12 |
| Equipment: compactor | 6.0 h | 7.0 h | $15.52 | $93.12 | $108.64 | +$15.52 |
| Equipment: pickup | 20.0 h | 22.0 h | $15.29 | $305.80 | $336.38 | +$30.58 |
| Subcontract: soil haul-away | 1 | 1 | invoice | $420.00 | $560.00 | +$140.00 |
| Total cost | $4,944.02 | $5,473.44 | +$529.42 | |||
| Gross profit on $8,400.00 | $3,455.98 | $2,926.56 | -$529.42 | |||
| Gross margin | 41.14% | 34.84% | -6.30 points |
The curved edge cost more than its estimate allowed. Cuts along the curve consumed 330 square feet of pavers against 315 estimated, the estimate's 5 percent waste allowance on 300 square feet. Cutting added 6 crew hours. The excavation ran deeper than planned at the low corner, so a third load went to the hauler.
Labor, equipment and subcontract variance across the three sheets
The three jobs lost margin in different lines. Labor carried 47.4 percent of the variance on the lighting job, 36.8 percent on the sewer repair and 35.1 percent on the patio. Equipment carried 29.7, 25.2 and 20.4 percent, and each machine's extra hours rose with the crew's extra hours on the same day. A sheet that logs machine hours from the crew's timesheet will show that link; one that books equipment as a flat job charge will hide it.
Subcontract variance appeared where the subcontractor priced by area or by load: the asphalt patch and the haul-away. Both moved for the same reason as the labor, a site condition that enlarged the work. The materials lines moved least, and only where quantity depended on the site: stone in a wet trench, pavers along a curve.
The sheets measure gross margin. Overhead, applied per labor hour as in the glossary entry, would lower each margin further; the extra 3 hours on the sewer job would also carry 3 hours of overhead.
Job cost sheet entries in closeout order
- Copy the estimate onto the sheet line by line, by category, with the quantities and unit costs it used.
- Record the rate sources: the wage table and load factor for labor, the equipment rate table, and the supplier quotes.
- During the job, enter labor hours from timesheets and machine hours from the equipment log, by day.
- Enter materials from delivery tickets and supplier invoices, and subcontract amounts from the subcontractor's invoice.
- Add approved change orders to the price and to the estimated cost, as separate lines.
- At closeout, compute each line's variance and the total, then gross profit and margin against the price.
- Write a variance note for every line that moved, naming the site condition or task behind it.
- Check that the actual figures agree with the timesheets and invoices they came from, then carry each corrected quantity into the next estimate for the same job type.
Job cost sheet formats and related templates
A job costing spreadsheet lays out the same columns with formulas for each line, the variance and the margin. A cleaning contractor's work repeats on a schedule, so its costs are read per building and per month rather than per project: the janitorial job costing template covers that layout. Excel, Google Sheets and paper versions follow the field table unchanged. Examples of job costing also reach beyond the trades: OpenStax lists movie production companies, print service providers, advertising agencies, building contractors, accounting firms, consulting entities and repair service providers among users of job order costing (OpenStax, Principles of Managerial Accounting, 4.1, checked November 2026).
Job costing software and the actual-cost columns
A paper sheet falls behind in the actual columns: hours are copied from timesheets, quantities from delivery tickets, and machine hours from a log filled in after the shift.
In FieldRanger, technicians clock in and out with time logged against each job, and clock-ins record where the technician was. Parts and materials used on each job are logged for job costing, and technicians check stock out of a specific warehouse. Equipment is assigned to jobs, with a usage history of who used it and when. Revenue reports show job revenue and margin by customer or service type, and invoice and payment data sync with QuickBooks. The field service reporting software page describes the reports.
Custom reports are built in a drag-and-drop report builder and download as CSV or Excel, where the actual columns sit beside the estimate. Subcontractor bills stay in the accounting system, which receives each invoice and payment from FieldRanger.
Fill it in here, or download the spreadsheet
The form below is the same template: totals calculate as you type, with the spreadsheet's own formulas, and your entries stay in this browser. Download it filled in, print it or save it as a PDF, or take the blank file.
Frequently asked questions
What is an example of job costing?
A fixed-price job whose estimated labor, materials, equipment and subcontract costs are compared with the actual costs line by line. On this page, a parking-lot lighting job estimated at $4,833.42 cost $5,103.90, and its gross margin fell from 30.45 to 26.56 percent.
Which businesses use job costing?
Any business whose jobs differ from one another: OpenStax names building contractors and repair service providers alongside advertising agencies, accounting firms and print service providers.
How is labor costed on a job cost sheet?
Hours from timesheets times a loaded rate: the wage plus benefits and payroll taxes. The sheets on this page divide Rhode Island median wages by 0.695, the construction industry's wage share of compensation in June 2026.
How are equipment costs charged to a job?
By the machine hour, from an internal rate or a published table. The examples use FEMA's 2025 rates, which include ownership, fuel and maintenance and exclude the operator, whose hours sit on the labor line.
What does a job cost variance show?
Where the job's cost departed from its estimate, by line. A variance note names the site condition or task behind each change, and the corrected quantity feeds the next estimate of the same job type.
The next bids for the three jobs
Each sheet hands the next estimate a corrected quantity: 2.5 labor hours for each pole base that has to be opened, a groundwater allowance for a lateral below 5 feet, and 10 percent paver waste on a curved edge. The estimate, work order and invoice that feed the sheet come from the free field service templates hub. Logging one job's hours and materials in FieldRanger for the 14 days of Start free trial, with no card, fills the labor and materials columns from the job record; pricing lists the per-technician plans.
FieldRanger runs field service inside HubSpot
Estimates, scheduling and dispatch, a technician app and invoicing on the HubSpot records sales already keeps. Every plan starts with a free trial.
Book a demo