Blog · Board and management reporting · Logistics
A transportation dashboard should compare lane costs with delivery performance on the same shipment population. This worked example calculates shipment costs, cost per mile, and on-time delivery, then checks a change in accessorial charges.
A Power BI transportation dashboard should compare lane costs with delivery service using the same shipment population. Show total cost beside cost per shipment, cost per mile, and on-time delivery so a volume change is not mistaken for a rate change. The dashboard becomes useful when an expensive lane can be traced to its shipments and charges.
Use an overview for total shipments, total freight cost, and on-time delivery. Under it, place a lane comparison and a cost breakdown into base freight, fuel, and accessorial charges. Keep exception shipments available for the person investigating late deliveries or unexpected fees.
Microsoft defines a Power BI dashboard as a single page of visual highlights. That supports a compact operating view rather than crowding every shipment onto the overview. Other Power BI dashboard examples cover broader layouts; the focus here is proving the cost and service measures behind the transportation view.
Covirage is not affiliated with Microsoft or Power BI.
Assign an owner to each question. Transportation operations owns delivery exceptions, procurement reviews carrier charges and contract terms, and finance reconciles costs. Microsoft's dashboard design guidance emphasizes the audience's decisions and the context around important figures. A high freight bill without shipment volume is missing that context.
Start with a shipment export containing shipment identifier, lane, carrier, actual delivery date, promised delivery window, actual arrival timestamp, and loaded miles. Bring an invoice-charge export with shipment identifier, charge type, and amount. Use the business identifiers already present in the files.
In this example, an illustrative US wholesaler reviews shipments delivered in September 2026. Each delivered shipment has one agreed delivery window and a complete, approved freight cost. On time means arrival within that window. Canceled shipments and shipments still in transit are outside this completed-delivery population and remain visible in a separate exception list.
The cost scope includes purchased base freight, fuel surcharges, and approved accessorials. It excludes warehouse labor and inventory cost. Loaded miles measure the purchased shipment movements, not a carrier's empty vehicle miles. Do not compare this result with a carrier operating-cost measure using a different mileage base.
Freight cost = Base freight + Fuel surcharges + Accessorial charges
Cost per shipment = Freight cost / Distinct completed shipments
Cost per loaded mile = Freight cost / Loaded miles
On-time delivery = On-time completed shipments / Eligible completed shipments
Keep a separate count of missing delivery timestamps and unmatched freight charges. An unknown arrival time should trigger investigation rather than silently being treated as on time.
The checked exports produce the following lane summary. Lane names are internal operating groups, and all shipments use the same cost scope and reporting cutoff.
| Lane group | Shipments | On-time shipments | Loaded miles | Base freight (USD) | Fuel (USD) | Accessorials (USD) |
|---|---|---|---|---|---|---|
| Midwest | 100 | 92 | 30,000 | 45,000 | 6,000 | 3,000 |
| Texas | 60 | 57 | 24,000 | 39,000 | 6,000 | 3,000 |
| Southwest | 40 | 34 | 22,000 | 44,000 | 7,000 | 4,000 |
| Total | 200 | 183 | 76,000 | 128,000 | 19,000 | 10,000 |
The Midwest freight cost is 45,000 + 6,000 + 3,000 = $54,000. Texas is 39,000 + 6,000 + 3,000 = $48,000, and Southwest is 44,000 + 7,000 + 4,000 = $55,000. Total cost is 128,000 + 19,000 + 10,000 = $157,000.
Apply the formulas to those inputs. Dollar unit costs are rounded to cents and service rates to one decimal place. Retain unrounded calculations when aggregating.
| Lane group | Freight cost (USD) | Cost per shipment (USD) | Cost per loaded mile (USD) | On-time delivery |
|---|---|---|---|---|
| Midwest | 54,000 | 540.00 | 1.80 | 92.0% |
| Texas | 48,000 | 800.00 | 2.00 | 95.0% |
| Southwest | 55,000 | 1,375.00 | 2.50 | 85.0% |
| Total | 157,000 | 785.00 | 2.07 | 91.5% |
The company cost per shipment is 157,000 / 200 = $785.00. Cost per loaded mile is 157,000 / 76,000 = $2.07 after rounding. On-time delivery is 183 / 200 = 91.5%, leaving 200 - 183 = 17 late shipments in this fully classified population.
Southwest has both the highest unit costs and the lowest on-time result. That is a reason to inspect shipment and charge detail, not proof that its carrier is underperforming. Longer movements, delivery restrictions, equipment requirements, and stop patterns can make lanes economically different.
Prove the cost total in two ways. The lane costs sum to 54,000 + 48,000 + 55,000 = $157,000. The charge categories independently sum to the same amount. Match that total to approved invoice lines for the selected shipments, with any late invoices or accrual adjustments documented separately.
Then check distinct shipment identifiers. Every eligible shipment must belong to one lane, appear once in the shipment count, and have a service outcome. Cost lines can repeat a shipment identifier because a shipment can have several legitimate charges. Those lines must not multiply its miles or delivery count.
For a spreadsheet preparation step, the Excel dashboard guide explains the broader presentation workflow. Keep the shipment and invoice checks with the working file so a reviewer can follow the totals.
Suppose the Southwest accessorial total changes from $4,000 to $8,000 after an invoice correction. Every shipment count, mile, base freight charge, fuel charge, and delivery outcome stays fixed. Only that cost input changes.
| Measure | Original | Revised | Calculation |
|---|---|---|---|
| Southwest accessorials (USD) | 4,000 | 8,000 | 4,000 + 4,000 |
| Southwest freight cost (USD) | 55,000 | 59,000 | 44,000 + 7,000 + 8,000 |
| Southwest cost per shipment (USD) | 1,375.00 | 1,475.00 | 59,000 / 40 |
| Company freight cost (USD) | 157,000 | 161,000 | 157,000 + 4,000 |
| Company cost per shipment (USD) | 785.00 | 805.00 | 161,000 / 200 |
| Company cost per loaded mile (USD) | 2.07 | 2.12 | 161,000 / 76,000 |
| Company on-time delivery | 91.5% | 91.5% | Delivery outcomes unchanged |
The cost movement comes entirely from accessorials. Procurement should examine the corrected charge descriptions and contract treatment before discussing base rates. The unchanged service result keeps that investigation separate from the delivery-exception review.
Use the operations dashboard for the broader operating review, and Power BI alternatives when choosing how to analyze the underlying files.
Bring a sample of your own shipment and freight-charge exports, or a Google Sheet containing the same business columns, to Covirage. Covirage maps the columns, and its tools compute and check lane costs and service measures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your own files.
See Covirage for shipping and logistics teams for the industry context.
Start with completed shipments, total freight cost, mileage, on-time deliveries, and the related unit costs and service rate. Add lane and carrier detail for investigation. Each measure needs an explicit reporting cutoff, cost scope, and eligible shipment population.
Divide the total eligible freight cost by the number of distinct shipments in the same population. Include the agreed charge categories consistently. Multiple invoice lines for one shipment increase its cost but should not increase the shipment count.
Use the delivery population defined for the service measure, such as shipments delivered during the reporting month. Compare actual delivery with the agreed delivery window. Invoice dates can support accounting checks, but they do not establish delivery performance.