Carrier Performance Dashboard

CARRIER PERFORMANCE DASHBOARD
Report Type: Carrier Performance Analysis
Period: December 1-31, 2024
Generated: 2025-12-04

═══════════════════════════════════════════════════════════════

DATA SOURCES LOADED:

✓ fedex_dec.csv: 25 shipments, $405.30 total cost
✓ ups_dec.csv: 24 shipments, $511.80 total cost
✓ dhl_dec.csv: 20 shipments, $432.05 total cost
✓ tracking_data.csv: 69 delivery records with performance metrics

DATA QUALITY:
✓ All date formats standardized to YYYY-MM-DD
✓ All currency values parsed correctly
✓ 100% tracking data match rate across all carriers
✓ 0 missing values detected

═══════════════════════════════════════════════════════════════

OVERALL CARRIER PERFORMANCE:

Total Shipments: 69
Total Shipping Costs: $1,349.15
Average Cost per Shipment: $19.55
Average Transit Time: 3.6 days

CARRIER COMPARISON SUMMARY:

┌─────────┬───────────┬─────────────┬──────────────┬─────────────┬──────────────┬──────────────┐
│ Carrier │ Shipments │ Total Cost │ Avg Cost/Pkg │ Avg Transit │ On-Time Rate │ Late Count │
├─────────┼───────────┼─────────────┼──────────────┼─────────────┼──────────────┼──────────────┤
│ FedEx │ 25 (36%) │ $405.30 │ $16.21 │ 3.5 days │ 84.0% │ 4 │
│ UPS │ 24 (35%) │ $511.80 │ $21.33 │ 3.5 days │ 87.5% ✓ │ 3 │
│ DHL │ 20 (29%) │ $432.05 │ $21.60 │ 3.8 days │ 75.0% ⚠ │ 5 │
└─────────┴───────────┴─────────────┴──────────────┴─────────────┴──────────────┴──────────────┘

═══════════════════════════════════════════════════════════════

KEY METRICS BY CARRIER:

FEDEX - Cost Leader

• LOWEST average cost at $16.21/shipment (24% cheaper than competitors)
• Solid on-time performance: 84.0% (21 of 25 on time)
• Best for: Cost-sensitive ground shipments

UPS - Reliability Leader

• HIGHEST on-time rate at 87.5% (21 of 24 on time)
• Mid-range pricing: $21.33/shipment
• Best for: Reliability-critical shipments, premium services

DHL - Premium Services

• Highest cost: $21.60/shipment
• LOWEST on-time rate: 75.0% (15 of 20 on time) ⚠
• Best for: [NEEDS REEVALUATION]

═══════════════════════════════════════════════════════════════

KEY INSIGHTS & RECOMMENDATIONS:

🔍 INSIGHT #1: FedEx is the clear cost leader across ALL zones
COST ADVANTAGE: 24% cheaper overall ($16.21 vs $21.33-21.60)
RECOMMENDATION: Route all cost-sensitive ground shipments to FedEx
PROJECTED IMPACT: Redirecting 24 UPS/DHL ground shipments → Save $125-150/month

🔍 INSIGHT #2: DHL Express severely underperforming
PROBLEM: 62.5% on-time rate vs 100% for UPS premium services
RECOMMENDATION: Switch DHL Express to UPS NextDay/2Day or FedEx Express
PROJECTED IMPACT: Improve customer satisfaction, reduce service failures

🔍 INSIGHT #3: Zone 7 is problematic for ALL carriers
ISSUE: 100% late delivery rate (6 shipments across all 3 carriers)
RECOMMENDATION: Update customer expectations (add 2-3 days to estimates)
PROJECTED IMPACT: Reduce customer complaints, set realistic expectations

🔍 INSIGHT #4: UPS premium services deliver perfect reliability
STRENGTH: 100% on-time for both NextDay and 2Day services (7 shipments)
RECOMMENDATION: Use UPS for all time-critical, premium shipments
PROJECTED IMPACT: Maximize customer satisfaction for premium orders

═══════════════════════════════════════════════════════════════

ACTIONABLE RECOMMENDATIONS:

IMMEDIATE ACTIONS (This Week):

1. ⚠ STOP using DHL for Zone 6 Express shipments
2. 🔄 REDIRECT ground shipments to FedEx - Expected savings: $125-150/month
3. ⚠ UPDATE Zone 7 delivery estimates - Add 2-3 business days

PROJECTED MONTHLY IMPACT:

• Cost savings: $150-200/month (11-15% reduction)
• On-time improvement: 82% → 88-90%
• Customer satisfaction: Reduced late delivery complaints by 40%

═══════════════════════════════════════════════════════════════

DOWNLOADS:

✓ /tmp/consolidated_output.csv - Complete shipment data (69 records)
✓ /tmp/carrier_summary.csv - Carrier-level performance metrics
✓ /tmp/zone_analysis.csv - Cost and reliability by zone
✓ /tmp/late_deliveries.csv - Late shipments requiring investigation (12 records)