Fleet reports: utilization, costs and exceptions

Fleet reports connect vehicle availability, completed trips and operating costs for the same period, then show which depot needs attention. Start with vehicle-level exports, calculate the measures, and prove that the depot totals equal the fleet totals. A recurring package needs a short exception list alongside the headline figures.

Start with activity and cost exports

Use a closed reporting week and one stable vehicle identifier across files. The activity export needs week, depot, vehicle, scheduled hours, downtime hours, dispatched hours, completed trips and miles. The cost export needs the same identifiers plus fuel, maintenance and the other costs included in your management definition.

Make the activity file one row per vehicle per week. Aggregate trip records to that level before connecting them to costs; otherwise a weekly lease charge can be repeated on every trip.

Allocate depot transfers consistently. Keep vehicles with no trips in the export so idle capacity remains visible.

Calculate availability and utilization

Consider a US regional delivery company's week ending October 16, 2026. These figures are illustrative inputs. Scheduled hours describe the dispatch window, and dispatched hours include both loaded and empty running within that window.

Available hours = Scheduled hours − Downtime hours

Utilization = Dispatched hours / Available hours

Put these fields on an Activity worksheet: A week, B depot, C vehicle, D scheduled hours, E downtime, F dispatched hours, G trips and H miles. Add available hours in I2 and utilization in J2, then fill through row 5:

=D2-E2
=IF(I2=0,NA(),F2/I2)

Format J as a percentage. The fleet has 160 − 16 = 144 available hours, so utilization is 108 / 144 = 75.0%. Retain the 16 downtime hours on the report; utilization alone cannot show the capacity unavailable for dispatch. The fleet utilization glossary covers the broader concept; this package specifically uses road-vehicle hours.

Add costs and a comparable plan

Here the company sets a simple operating-cost allowance of $1.00 per actual mile for each vehicle. This is its chosen management allowance, not an industry benchmark. A fuller plan should separate fixed costs from costs that vary with mileage.

On a Costs worksheet, use A week, B depot, C vehicle, D fuel, E maintenance, F other operating costs and H allowance per mile. Enter 1.00 in H2:H5. Align rows 2–5 with Activity, verify the vehicle IDs match, and enter these formulas in G2, I2 and J2:

=SUM(D2:F2)
=Activity!H2*H2
=G2-I2

Spending exceeds the mileage allowance by 3,390 − 3,240 = $150, or 150 / 3,240 = 4.6%. Read cost variance for the wider budget comparison; here the allowance has already adjusted to actual miles. Percentages are rounded to one decimal place and cost per mile to two decimals.

Roll up the depot package

On Summary, put East in A2 and West in A3. Use the following formulas for available hours, dispatched hours and actual cost:

=SUMIFS(Activity!$I$2:$I$5,Activity!$B$2:$B$5,$A2)
=SUMIFS(Activity!$F$2:$F$5,Activity!$B$2:$B$5,$A2)
=SUMIFS(Costs!$G$2:$G$5,Costs!$B$2:$B$5,$A2)

The files contain only this reporting week; include a week criterion when retaining multiple weeks. Microsoft documents SUMIFS as adding values that meet the specified criteria. Covirage is not affiliated with Microsoft.

Calculate depot ratios from summed amounts. East utilization is 50 / 68; fleet cost per mile is 3,390 / 3,240. West's modest net variance conceals W2's $150 overrun and W1's $120 underrun. Review those vehicle rows before deciding the depot is within plan.

Prove the figures and assign exceptions

Reconcile fuel, maintenance and other costs to the same-period management ledger: 1,362 + 660 + 1,368 = $3,390. Check that 108 dispatched hours do not exceed 144 available hours and that every trip has a unique identifier. These are separate control-total and identity checks.

The depot manager owns the weekly exception list; finance confirms cost coverage and the fleet maintenance lead explains unavailable time. Retain vehicle-level maintenance evidence: 49 CFR 396.3 requires covered motor carriers to maintain inspection, repair and maintenance records. A spending summary alone does not provide those records.

Where fleet reports go wrong

• Downtime changes the denominator. Publish scheduled hours and downtime alongside utilization so reduced availability stays visible.
• Costs arrive in another week. Accrue or clearly flag missing costs; do not read an incomplete week as an efficiency gain.
• Trip rows multiply invoices. Aggregate each source to vehicle and week before combining its totals.
• Unlike routes share a ranking. Review vehicle class and route type before setting a common cost expectation.

Run the fleet comparison on your own file

Bring your vehicle activity and cost exports to Covirage; its tools map the columns, compute depot comparisons and check the figures. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for freight teams for the supporting business context.