Distribution & logistics dashboards
Carrier scorecards without the Monday merge
Orders live in the ERP, picks in the WMS, freight in the TMS and delivery scans in each carrier portal. RapidDashboard joins them in a private data store and answers plain-English questions with a full operations dashboard.
Live examples
One question, one full dashboard
Pick a question. RapidDashboard answers with KPIs, charts, the records behind them and an AI summary of what to do next. Hover any chart for values or open its table view.
Show on-time delivery by carrier and fill rate for the last 30 days.
Delivery performance
On-time delivery
94.1%
-1.2 pts vs prior 30 days
OTIF
92.4%
-0.9 pts on time and in full
Line fill rate
97.2%
-0.3 pts lines shipped complete
Backorder lines
42
+11 open today
- Line fill rate
- On-time delivery
- OTD goal 96%
| Line fill rate | On-time delivery | |
|---|---|---|
| W29 | 97.6% | 95.8% |
| W30 | 97.8% | 96.0% |
| W31 | 97.5% | 95.6% |
| W32 | 97.9% | 95.9% |
| W33 | 97.6% | 95.6% |
| W34 | 97.4% | 95.2% |
| W35 | 97.5% | 95.1% |
| W36 | 97.5% | 95.3% |
| W37 | 97.3% | 94.6% |
| W38 | 97.1% | 94.0% |
| W39 | 97.3% | 93.8% |
| W40 | 97.2% | 94.1% |
- Carrier delay61256%
- Late release24122%
- Weather12812%
- Address issue10610%
| Segment | Value | Share |
|---|---|---|
| Carrier delay | 612 | 56% |
| Late release | 241 | 22% |
| Weather | 128 | 12% |
| Address issue | 106 | 10% |
| Carrier | Mode | Shipments | On time | Late | Status |
|---|---|---|---|---|---|
| Summit Parcel | Ground parcel | 9,400 | 96.1% | 367 | Above goal |
| Redline Express | Ground parcel | 5,600 | 95.4% | 258 | Below goal |
| Lakeshore Freight | Regional next-day | 3,160 | 85.9% | 445 | Corrective action |
| Crossroads LTL | LTL | 260 | 93.5% | 17 | Below goal |
What changed and what to do
- Critical: Lakeshore Freight on-time delivery fell 4 points in three weeks to 85.9%, and it carries 41% of all late shipments. A corrective-action call is logged for this afternoon.
- Warning: 241 late shipments trace to late warehouse release, most from orders dropped after the 2 p.m. wave cutoff.
- Good: Summit Parcel held 96.1% on time across 9,400 shipments, above the 96% goal.
AI summary
On-time delivery slipped to 94.1% over the last 30 days, 1.2 points below the prior period, while line fill rate held at 97.2%. Lakeshore Freight drives the decline, with 445 late shipments on 3,160 tendered. Recommend moving the Nashville and Louisville lanes to Summit Parcel while Lakeshore works its corrective-action plan, and adding a 3 p.m. release wave for late-dropped orders.
Ask next
- Which lanes does Lakeshore run late on?
- Show OTIF by top customer
- How many late shipments were weather related by region?
Break down freight cost into base, fuel surcharge and accessorials by quarter, and show where September invoices landed against accrual.
Freight cost & accruals
Freight invoiced
$199.7K
+$2.7K September
Cost per shipment
$10.68
+$0.12 Q3, all modes
Fuel share
14.6%
-0.7 pts of freight, vs Q2
Accrual variance
$7.7K
+$2.5K invoiced over accrual, Sep
- Base freight
- Fuel surcharge
- Accessorials
| Base freight | Fuel surcharge | Accessorials | |
|---|---|---|---|
| Q4 '25 | $420K | $82K | $28K |
| Q1 '26 | $440K | $91K | $31K |
| Q2 '26 | $458K | $88K | $29K |
| Q3 '26 | $472K | $86K | $32K |
| Step | Change |
|---|---|
| Accrued | $192.0K |
| Fuel | +$3.4K |
| Liftgate | +$4.9K |
| Detention | +$1.9K |
| Credits | -$2.5K |
| Invoiced | $199.7K |
What changed and what to do
- Warning: September invoices came in $7.7K over accrual. Liftgate, residential and detention fees, mostly on Crossroads LTL, add $6.8K that the accrual did not include.
- Good: Fuel surcharge fell to 14.6% of freight in Q3 from 15.3% in Q2, as diesel indexes eased.
- Info: Base freight grew 3.1% quarter over quarter, in line with shipment volume, so the rate per shipment is holding.
AI summary
Q3 freight cost was $590K, up 2.6% on Q2, and cost per shipment rose 12 cents to $10.68. Base freight tracks volume, fuel share improved, and accessorials are the line that moved. Recommend adding liftgate and residential fees to the accrual model for LTL shipments and putting accessorial caps on the agenda for the Crossroads renewal.
Ask next
- Which customers trigger the most accessorials?
- Show cost per shipment by lane
- Compare contracted vs billed rates by carrier
What is pick productivity and pick accuracy by warehouse zone this week?
Warehouse productivity
Lines picked per hour
128
+6% per picker, blended
Pick accuracy
99.82%
+0.03 pts lines without error
Shipped same day
97.4%
+0.6 pts orders in by cutoff
Cycle count accuracy
99.6%
0.0 pts locations counted
Accuracy goal: 2.0
What changed and what to do
- Good: Zone B picks rose 6% to 125 lines per hour after last week's slotting change moved 140 fast movers into the golden zone.
- Warning: Cold zone runs 3.1 errors per 1,000 lines, and productivity drops after 1 p.m. Most mispicks are look-alike lots of the same item.
- Info: Every zone dips at 11 a.m. when breaks overlap with the second wave release.
AI summary
Blended pick productivity reached 128 lines per picker hour this week, up 6%, with accuracy at 99.82%. Zone B gained the most from re-slotting, while the cold zone trails on both speed and accuracy in the afternoon. Recommend shorter cold-zone rotations after 1 p.m., lot-level scan confirmation on look-alike items and staggering breaks around the 11 a.m. wave.
Ask next
- Show lines per hour by picker in the cold zone
- Which SKUs have the most mispicks?
- What if we re-slot Zone C?
Show dock-to-stock time today and which late inbound POs are causing backorders.
Inbound & receiving
Dock-to-stock
6.4 hrs
-0.8 hrs average, arrival to put-away
Receipts put away
44 / 72
61% of today's ASNs
Late inbound POs
11
+3 past promise date
Backorder lines
42
+11 tied to late POs
6.4 hrs
arrival to put-away · target 8 hrs
- ASNs expected 72
- Arrived at dock 64 89%
- Unloaded 58 91%
- Received in WMS 51 88%
- Put away 44 86%
| PO | Vendor | Days late | Backorder lines | Customers waiting | Status |
|---|---|---|---|---|---|
| PO-77812 | Hartwell Fasteners | 6 | 14 | 9 | Expedite |
| PO-77840 | Dynacore Electrical | 4 | 11 | 6 | Expedite |
| PO-77795 | Prairie Packaging | 3 | 8 | 4 | In transit |
| PO-77851 | Nordic Valve | 2 | 5 | 3 | Arrives Mon |
| PO-77866 | Atlas Bearing | 1 | 4 | 2 | At dock |
What changed and what to do
- Critical: PO-77812 from Hartwell Fasteners is 6 days late and holds 14 backorder lines for 9 customers. Hartwell confirms a partial ship today if requested.
- Warning: Seven of today's receipts sit received but not put away. Four of them carry backordered SKUs that could ship tonight.
- Good: Dock-to-stock improved to 6.4 hours, inside the 8-hour goal, after the second receiving shift started.
AI summary
Average dock-to-stock fell to 6.4 hours, and 44 of 72 expected receipts are put away. Eleven inbound POs are late, and five of them explain all 42 backorder lines. Recommend requesting a partial shipment on PO-77812, prioritizing put-away for backordered SKUs on the second shift and sending affected customers a revised ship date today.
Ask next
- Which vendors are late most often?
- Show vendor on-time rate by quarter
- Which backorders ship tonight?
Which customers are below their OTIF commitment in September, what did it cost in chargebacks, and which lanes drive it?
Customer OTIF & chargebacks
OTIF
92.4%
-0.9 pts all customers
Orders missing OTIF
1,240
+164 of 16,300 orders
Chargebacks
$18.4K
+$5.1K retailer deductions
Lanes below 90% OTD
2
+1 of 10 regional lanes
| Item | Cost per shipment | On-time delivery |
|---|---|---|
| Chicago | $8.40 | 96.8% |
| Detroit | $8.90 | 96.1% |
| Indianapolis | $7.60 | 97.2% |
| Cincinnati | $7.90 | 95.9% |
| Pittsburgh | $10.80 | 94.7% |
| Louisville | $8.10 | 88.2% |
| Nashville | $9.60 | 84.6% |
| St. Louis | $9.90 | 95.2% |
| Milwaukee | $9.20 | 96.4% |
| Cleveland | $8.70 | 95.8% |
$18.4K
deducted in September
- Late delivery
- $9.6K
- Short shipment
- $4.8K
- ASN or label errors
- $2.7K
- Early delivery
- $1.3K
What changed and what to do
- Critical: Northway Grocers is at 91.8% OTIF against a 98% requirement, and its stores sit on the Nashville and Louisville lanes Lakeshore Freight runs.
- Warning: Late-delivery deductions doubled to $9.6K, more than half of September chargebacks.
- Good: Harbor Supply Co. and Keller Hardware meet their OTIF commitments, and their lanes all run above 95% on time.
AI summary
OTIF was 92.4% in September, and 1,240 orders missed on time or in full. Retailer chargebacks rose to $18.4K, led by late-delivery deductions. The misses concentrate on two lanes, Nashville and Louisville, which also carry the lowest on-time rates. Recommend shifting both lanes to Summit Parcel for October and reviewing Northway's ship-window requirements with their buyer.
Ask next
- What would moving Nashville to Summit cost?
- Show chargebacks by retailer and reason
- Which orders were short-shipped?
Sample data for a fictional company. Your dashboards run on your own connected systems.
Sound familiar?
Where the numbers live today
Every carrier has its own portal
Blended on-time delivery appears once someone downloads each carrier's CSV and merges them by hand.
Fill rate moves before anyone looks
A late inbound PO turns into backorders for the best customers a week before the weekly ops review.
Freight accruals close the month
Accessorials and fuel surcharges reach finance with the carrier invoice, after the accrual is booked.
Zone productivity stays in the WMS
Lines per hour by zone and shift live in WMS reports, while leadership asks for them in the staff meeting.
Metrics glossary
The metrics behind these dashboards
How each number is defined, so everyone reads it the same way.
- On-time delivery (OTD)
-
Shipments delivered on or before the promised date, as a share of all shipments delivered.
FormulaShipments delivered on time ÷ Total shipments delivered
- OTIF (on time, in full)
-
Orders that arrive within the agreed delivery window with the full quantity ordered. Many retailers set an OTIF requirement in their vendor terms.
FormulaOrders delivered on time and complete ÷ Total orders
- Fill rate
-
Demand shipped from available stock on the first shipment. It can be measured by line, order or unit.
FormulaLines (or units) shipped complete ÷ Lines (or units) ordered
- Dock-to-stock time
-
Elapsed time from a shipment arriving at the dock until the goods are put away and available to pick.
FormulaPut-away timestamp − Arrival timestamp
- Lines picked per hour
-
Order lines a picker completes per hour of direct picking time, the standard measure of pick productivity.
FormulaLines picked ÷ Direct pick labor hours
- Cost per shipment
-
All-in freight cost, including fuel surcharges and accessorials, divided by the number of shipments.
FormulaTotal freight cost ÷ Shipments
Connections
How your systems connect
Supported APIs and exports sync into a private RapidDashboard store you approve. Dashboards read from that store, so source systems keep their normal load.
Epicor Prophet 21 / NetSuite
PullsSales orders, POs, inventory, customer terms
Official APIs on a scheduled, audited sync into your private store.
Manhattan Active WM
PullsPicks, receipts, put-aways, labor by zone
REST APIs and event exports feed productivity and dock-to-stock each hour.
MercuryGate TMS
PullsShipments, tenders, rates, freight invoices
Vendor-supported API, matched to orders for cost per shipment and accruals.
project44 / carrier APIs
PullsPickup and delivery scans, exceptions
Tracking events join each shipment, so OTD covers every carrier in one view.
What you can build
Dashboards and reports teams build next
Service levels
- Blended OTD and OTIF by carrier
- Fill rate and backorder alerts
- Customer OTIF vs commitment
Warehouse
- Lines per hour by zone and shift
- Pick accuracy and mispick causes
- Dock-to-stock and put-away queues
Freight
- Cost per shipment by lane
- Accrual vs invoice variance
- Accessorial charges by customer
Automated reports
- Weekly carrier scorecard
- Daily backorder list
- Monthly vendor on-time review
Customer pricing and lanes stay private
Distribution data holds customer pricing, rebate terms, vendor costs and contracted freight rates. RapidDashboard keeps it in a private data store with role-based access, so a warehouse lead sees zone productivity while pricing stays with finance and sales leadership. AI features are optional and run on enterprise endpoints whose terms prohibit training on your data.
FAQ
Distribution & Logistics dashboards: common questions
What should a distribution dashboard show?
Most distributors start with on-time delivery by carrier, OTIF by customer, fill rate and backorders, lines picked per hour by zone, dock-to-stock time and freight cost per shipment. RapidDashboard builds each of these from a plain-English question against your synced ERP, WMS and TMS data.
What is the difference between OTD and OTIF?
On-time delivery counts shipments that arrive by the promised date. OTIF also requires the order to arrive complete, so a shipment that is on time but short counts as a miss. OTIF is usually the lower number and is the one retailers use for chargebacks.
How is fill rate calculated?
Fill rate is the share of demand shipped complete from stock on the first shipment. Line fill rate divides lines shipped complete by lines ordered; order and unit fill rates use orders or units instead. RapidDashboard can show all three side by side from the same order data.
Can RapidDashboard combine data from multiple carriers?
Yes. Carrier tracking events from APIs or a visibility platform such as project44 are matched to each shipment in your TMS. Blended OTD, late shipments and cost per shipment then cover every carrier in one view.
Is our customer and pricing data used to train AI models?
No. Your data stays in a private store you approve, and AI features run on enterprise endpoints whose terms prohibit training on customer data. AI is optional; the dashboards work without it.
Keep exploring
Related example dashboards
See dashboards like these on your own data
Fifteen minutes with an AIBMM™ Certified Coach: bring one question, leave with the dashboard it would build on your systems.
Schedule a demo