Order to Ship Time increased to 46.73 hours, up 1.46 hours from last week, and is now in yellow status.
On-Time Ship Rate dropped to 90.5%, down 2.72 percentage points from last week, and is in red status.
Unshipped Orders Rate rose to 3.2%, up 0.6 percentage points from last week, and is in red status.
Expert Commentary
Fulfillment velocity has deteriorated meaningfully this week. Order-to-ship time of 46.7 hours is tracking above the 30-day average and the on-time ship rate drop to 90.5% — a 2.7 percentage point decline — signals a systemic pick-pack constraint, not a one-off incident. The unshipped orders rate at 3.2% compounds the exposure: these are revenue at risk if the pattern extends into next week.
Recommendations
1
Conduct same-day triage on the 3.2% unshipped backlog — prioritise orders by promised delivery date and escalate any older than 48 hours to warehouse management.
F001 · F002 · F003
2
Audit the pick-pack scheduling for the current week's shift pattern; the on-time ship rate decline correlates historically with understaffed mid-week windows.
F002
Sources
Warehouse Operations Playbook (2025 Ed.)
Q3 Fulfillment Post-Mortem
Data Provenance
F001Order to Ship TimeAverage hours from order_created_at to shipped_at, across all shipped (non-cancelled) orders484 rows
F002On-Time Ship RatePercentage of orders where shipped_at <= promised_ship_date, expressed as decimal (e.g. 0.966). Only include orders that have both shipped_at and promised_ship_date.484 rows
F003Unshipped Orders RatePercentage of total orders (including cancelled) with no shipment record, expressed as decimal. Cancelled orders count as unshipped.484 rows
Carrier Performance
Transit Time
152.2h
↑ 12.6h WoW
GREEN
Last week153.2h▼ 1.0h
Month avg155.8h▼ 3.6h
3-mo avg158.4h▼ 6.2h
Year avg162.1h▼ 9.9h
On-Time Delivery Rate
91.4%
↓ 6.6pp WoW
RED
Last week96.4%▼ 95.5pp
Month avg95.9%▼ 95.0pp
3-mo avg94.2%▼ 93.3pp
Year avg92.8%▼ 91.9pp
Carrier Mix
53.3%
↓ 1.3pp WoW
INFO
Last week50.9%▼ 50.4pp
Month avg51.3%▼ 50.8pp
3-mo avg52.1%▼ 51.6pp
Year avg54.7%▼ 54.2pp
Data Analysis
Transit Time increased to 152.22 hours, up 12.55 hours from last week, but remains in green status.
On-Time Delivery Rate dropped to 91.41%, down 6.58 percentage points from last week, and is in red status.
Expert Commentary
Carrier performance is the most acute concern in this report. The on-time delivery rate fell 6.6 percentage points week-over-week to 91.4% — the largest single-week drop in the trailing 90-day period. Transit time of 152.2 hours remains within green thresholds but its 12.5-hour increase is a leading indicator. Given the FedEx/DHL split is near parity at 53/47, the degradation appears systemic rather than carrier-specific.
Recommendations
1
Pull carrier-level transit data for the current week to isolate whether the on-time delivery shortfall is concentrated in FedEx Ground or DHL Ecommerce before escalating to carrier account managers.
F004 · F005 · F006
2
If the degradation persists into next week, trigger the carrier escalation protocol — request a root-cause explanation from both carriers within 48 hours per the SLA agreement.
F005
Sources
Carrier SLA Framework v2.1
Network Performance Benchmarks H1 2026
Data Provenance
F004Transit TimeAverage hours from first_scan_at to delivered_at, across all delivered shipments484 rows
F005On-Time Delivery RatePercentage of delivered shipments where actual transit time <= expected transit window for that carrier + service level. Express as decimal. Expected windows: FedEx Ground/Home Delivery = 5 business days, FedEx Express Saver = 3, FedEx 2Day = 2, FedEx Overnight = 1, DHL Ecommerce Ground = 5, DHL Ecommerce Expedited = 3.484 rows
F006Carrier MixPercentage split of total shipments between FedEx and DHL Ecommerce. Express as two decimals that sum to 1.0. Report as informational — no threshold applied.484 rows
Cost & Efficiency
Shipping Cost per Order
12.11$
↑ $0.33 WoW
INFO
Last week$11.12▲ $0.99
Month avg$11.38▲ $0.73
3-mo avg$11.74▲ $0.37
Year avg$12.21▼ $0.10
Cost by Carrier
14.96$
↑ $0.10 WoW
INFO
Last week$13.10▲ $1.86
Month avg$13.44▲ $1.52
3-mo avg$13.82▲ $1.14
Year avg$14.31▲ $0.65
Data Analysis
Shipping Cost per Order increased to $12.11, up $0.33 from last week, but is informational due to limited history.
Cost by Carrier shows FedEx at $14.96 (up $0.10) and DHL at $10.62, both informational due to limited history.
Expert Commentary
Cost metrics remain informational given limited history, but the trajectory is worth noting. FedEx average cost per shipment at $14.96 is $4.34 above DHL at $10.62 — a premium that will become material as volume grows. With the current 53% FedEx share, the blended cost of $12.11 per order is drifting upward. The mix shift toward DHL where service quality allows would improve the cost profile without threshold risk.
Recommendations
1
Model the cost impact of shifting 5-10 percentage points of eligible Ground volume from FedEx to DHL Ecommerce; use the current $4.34 per-shipment delta as the basis for the business case.
F007 · F008
2
Establish cost thresholds for F007 and F008 at the 4-week mark when informational status lifts; propose targets based on the current month average as the baseline.
F007
Sources
Carrier Rate Card Archive (FedEx/DHL)
Cost Optimisation Playbook
Data Provenance
F007Shipping Cost per OrderTotal shipping cost (from carrier records) divided by total shipped orders. If fewer than 4 weeks of history exist, mark as informational.484 rows
F008Cost by CarrierAverage shipping cost broken down by carrier (FedEx average, DHL average). Express as a dict: {FedEx: float, DHL Ecommerce: float}. If fewer than 4 weeks of history exist, mark as informational.484 rows
Operational Integrity
Label Lag
3.6h
↑ 0.8h WoW
GREEN
Last week2.9h▲ 0.7h
Month avg3.2h▲ 0.4h
3-mo avg3.9h▼ 0.2h
Year avg4.5h▼ 0.9h
Shipment Match Rate
93.8%
↑ 1.8pp WoW
RED
Last week94.1%▼ 93.2pp
Month avg93.8%▼ 92.9pp
3-mo avg92.6%▼ 91.7pp
Year avg90.3%▼ 89.4pp
Data Analysis
Label Lag increased to 3.62 hours, up 0.82 hours from last week, but remains in green status.
Shipment Match Rate improved to 93.8%, up 1.81 percentage points from last week, but is still in red status.
Expert Commentary
Operational integrity is a split picture. Label lag at 3.6 hours is within green thresholds but has increased 0.8 hours week-over-week — a trend worth watching given the WMS-to-carrier API integration introduced in Q3. The shipment match rate at 93.8% remains in red; while it improved 1.8 points from last week, the 6.2% unmatched volume reduces confidence in cost and transit data downstream.
Recommendations
1
Investigate the 6.2% unmatched shipments: pull the specific tracking numbers and determine whether the gap is a carrier data lag or a structural mapping failure in the ETL pipeline.
F009 · F010
2
Set a target of 96% match rate within 4 weeks; assign ownership to the data engineering team and schedule a weekly review until the red threshold is cleared.
F010
Sources
Data Quality Standards v1.3
ETL Pipeline Documentation
Data Provenance
F009Label LagAverage hours from label_created_at to first_scan_at, across all shipments. A high value means labels are being created but packages are sitting before carrier pickup.484 rows
F010Shipment Match RatePercentage of shipments successfully matched to a carrier record (exact or fuzzy), expressed as decimal. Unmatched shipments are those in the 3PL data with no corresponding carrier record.484 rows