Field service dashboard: jobs, capacity and margin

A field service dashboard compares jobs completed, first-time completion, technician capacity and job margin from service exports. The useful view connects the work performed with the time and cost it consumed. A busy team can still require repeat visits or earn less contribution on each completed job.

Define the work before comparing teams

This example uses a fictional US commercial HVAC service company with East, Central and West teams. Its review covers jobs first visited and completed during October 12–16, 2026, with return-work records checked through October 23. Every eligible job in this deliberately small example reached completion during the service week.

The cohort therefore has the same count for first visits and completed jobs. In a real review, keep those counts separate whenever some jobs remain open. First-time completion here means completion on the initial visit without a return required during the agreed follow-up window; planned multivisit installations are outside this repair cohort.

Record the completion evidence required for each job type. Federal Acquisition Regulation guidance on performance work statements illustrates the value of defining required results and measurable standards rather than counting hours alone. Use your own service agreement and operating definitions for private work.

For commitments across several service functions, use the neighboring service delivery dashboard. The field review below concentrates on technician work and job economics.

Bring four exports with a shared job identifier

The work-order file needs a job identifier, team, service type, opening date and completion date. The visit file needs visit dates, completion outcomes and return reasons. Time entries need job identifiers and hours, while the cost file needs revenue, direct labor cost and parts cost for those jobs.

These are ordinary operational records. The US Department of Labor's O*NET description of HVAC technician work specifically includes recording time, materials, faults and other occurrences on work orders, along with keeping repair records. Those details support an explainable review better than a total jobs column alone.

Keep available technician hours in a separate capacity report by team and week. Here they exclude leave and training but include time that may be used for travel and general administration. Job-coded hours include on-site service and job-specific paperwork. They do not include general travel or unassigned time.

The service manager owns job and visit definitions. Team leads confirm time entries, and finance approves the cost allocation. A shared customer service dashboard can summarize the service outcome, while this view retains the technician and cost detail.

A fully worked team comparison

The table is an aggregation of the same eligible work orders. Labor cost uses an assumed loaded rate of $50 per job-coded hour. The job contribution measure deducts that allocated labor and parts; it excludes unassigned labor, general travel costs and company overhead.

First-time completion rate = First-time completions / Eligible first visits

Job-hour utilization = Job-coded hours / Available hours

Job contribution margin = (Revenue − Allocated job labor − Parts) / Revenue

Use summed numerators and denominators for the company result. Percentages below are rounded to one decimal place; dollars are exact under the stated allocation.

Central's contribution is 21,000 − 10,200 − 4,800 = $6,000. Its margin is 6,000 / 21,000 = 28.6%. The company result is 63,000 − 31,200 − 11,800 = $20,000, divided by $63,000 for a 31.7% contribution margin.

The company job-hour utilization is 624 / 800 = 78.0%. That leaves 800 − 624 = 176 hours outside the job-coded category. Reconcile those hours to travel, administration and other permitted categories before interpreting them as unused capacity.

What the manager should investigate

Central has the highest job-hour utilization and the lowest first-time completion rate. That combination warrants a review of repeat-work reasons, parts availability and job complexity. It does not establish that Central's technicians perform worse: the service mix may differ.

Compare similar repair types and service conditions before setting an improvement action. A return caused by an unavailable part has a different owner from a planned follow-up or an incorrectly recorded job closure. Keep the original reason on the work order rather than turning every return into the same exception.

The margin comparison also needs context. Central earns more revenue than West but the same job contribution. The costs explain the arithmetic; the job records explain whether those costs reflect necessary complexity or avoidable repeat work. Use the gross profit margin guide for the broader accounting measure, which depends on your company's full cost-of-sales policy.

A variation: change only the parts cost

Suppose a late supplier charge adds $2,000 to Central's parts cost. Its parts total changes from $4,800 to $6,800. The jobs, completion outcomes, hours, labor and revenue stay unchanged.

Central's revised contribution is 21,000 − 10,200 − 6,800 = $4,000. Company parts cost becomes $13,800, so company contribution is 63,000 − 31,200 − 13,800 = $18,000. Capacity and first-time completion do not move because their source inputs did not change.

Checks and common mistakes

Reconcile completed job identifiers to the work-order export and first-time completions to visit records. The company contribution must equal the sum of the team contributions. Total time categories must tie to the available-hours report using the same exclusions.

• Counting visits as jobs. A return visit consumes time but does not create another completed customer job.
• Excluding unfinished work silently. A completion-only cohort can make first-time success look better by dropping unresolved jobs. Show open first-visit jobs separately.
• Moving the follow-up window. A shorter return-work observation period makes recent jobs look more successful.
• Treating job contribution as company profit. Unassigned labor and overhead remain costs even when they are outside the job allocation.
• Mixing work and cost periods. A late parts invoice belongs to its job cohort for this comparison, rather than whichever week happens to receive the bill.

Review your own field service files in Covirage

Bring work orders, visit outcomes, time entries and job costs with a consistent job identifier. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.

See capacity planning with Covirage for the supporting business context.