Logistics Review
Evaluate and improve logistics operations across the transportation network to reduce cost, improve service reliability, and increase visibility.
Input Gathering
| Input |
Description |
Required |
| Shipment data |
Origin, destination, weight, mode, carrier, cost, dates |
Yes |
| Carrier contracts |
Rate cards, accessorial schedules, SLA commitments |
Yes |
| Time period |
Review window (recommend minimum 6 months) |
Yes |
| Delivery performance data |
Promised vs. actual delivery dates, damage/claim records |
Yes |
| Network map |
Warehouse/DC locations, customer density, lane volumes |
No |
| Benchmark data |
Industry rates, peer comparisons, market indices |
No |
| Customer requirements |
Delivery windows, special handling, compliance mandates |
No |
Step-by-Step Process
Step 1 — Shipment Profile Analysis
Build a complete picture of the logistics operation:
| Dimension |
Analysis |
| Mode split |
% of spend and volume by TL, LTL, parcel, air, ocean |
| Lane concentration |
Top 20 lanes by volume and spend; Pareto analysis |
| Shipment density |
Average weight, cube utilization, pieces per shipment |
| Temporal patterns |
Day-of-week, monthly, seasonal volume fluctuations |
| Geographic coverage |
Heat map of origin-destination pairs, delivery zones |
Flag anomalies: shipments below minimum weight, excessive accessorials, split shipments that could consolidate.
Step 2 — Carrier Performance Scorecard
Score each carrier on a weighted composite:
| KPI |
Weight |
Measurement |
Target |
| On-time delivery (OTD) |
30% |
Delivered within promised window |
> 95% |
| Damage / claims rate |
15% |
Claims filed per 1,000 shipments |
< 2 |
| Invoice accuracy |
15% |
% of invoices matching contracted rates |
> 98% |
| Tender acceptance rate |
15% |
% of loads accepted on first tender |
> 90% |
| Transit time consistency |
15% |
Std deviation of transit days per lane |
Low variance |
| Responsiveness |
10% |
Time to resolve exceptions and inquiries |
< 4 hours |
Produce a quarterly ranking and identify carriers eligible for volume increase or reduction.
Step 3 — Cost Benchmarking and Spend Analysis
Analyze logistics spend against benchmarks:
- Cost per unit shipped (by mode and lane).
- Cost as % of revenue — compare to industry median (typically 4-8% for manufacturing, 8-15% for e-commerce).
- Accessorial spend breakdown — fuel surcharge, detention, liftgate, residential, redelivery.
- Rate trend analysis — contracted rates vs. spot market over the review period.
- Spend leakage — shipments moving outside contracted rates, unauthorized carriers, off-contract accessorials.
Build a savings waterfall identifying each opportunity by category and estimated annual value.
Step 4 — Lead Time Analysis
Map end-to-end lead times for key lanes:
| Lead Time Component |
Measurement |
Optimization Lever |
| Order processing |
Order placed to ship-ready |
Automation, cut-off times |
| Warehouse dwell |
Ship-ready to carrier pickup |
Pickup scheduling, dock slots |
| Transit time |
Pickup to destination arrival |
Mode selection, routing |
| Customs / clearance |
Border arrival to release |
Pre-clearance, broker perf |
| Last-mile delivery |
Hub arrival to customer receipt |
Network design, carrier mix |
| Total order-to-delivery |
Sum of above |
Process redesign |
Identify the longest and most variable components; quantify the opportunity from reducing each by 10-25%.
Step 5 — Last-Mile Delivery Assessment
Evaluate last-mile performance specifically:
- Cost per delivery by zone, package size, and delivery type (standard, express, same-day).
- First-attempt delivery success rate — target > 92%.
- Customer satisfaction scores tied to delivery experience.
- Returns logistics cost — reverse logistics as % of forward cost.
- Alternative delivery model evaluation — gig economy, locker networks, micro-fulfillment, crowd-shipping.
Step 6 — Recommendations and Action Plan
Prioritize opportunities using an impact-effort matrix:
| Priority |
Initiative |
Annual Savings |
Effort |
Timeline |
| 1 |
Quick wins (rate corrections) |
$... |
Low |
0-30 days |
| 2 |
Carrier mix optimization |
$... |
Medium |
30-90 days |
| 3 |
Mode shift opportunities |
$... |
Medium |
60-120 days |
| 4 |
Network redesign |
$... |
High |
6-12 months |
Output Format
## Logistics Review — [Scope/Region] — [Period]
### Executive Summary
- Total logistics spend reviewed: [$X]
- Shipments analyzed: [count]
- Identified savings opportunities: [$Y] ([%] of spend)
- Service level: [current OTD%] -> [projected OTD%]
### Shipment Profile
| Mode | Shipments | Spend | Avg Cost/Shipment | Volume Trend |
|--------|-----------|-----------|-------------------|--------------|
| TL | ... | ... | ... | ... |
| LTL | ... | ... | ... | ... |
| Parcel | ... | ... | ... | ... |
### Carrier Scorecard
| Carrier | OTD | Damage Rate | Invoice Accuracy | Tender Accept | Composite Score |
|---------|-------|-------------|------------------|---------------|-----------------|
| ... | ... | ... | ... | ... | ... |
### Cost Benchmarking
- Cost per unit shipped: [$X] vs. benchmark [$Y]
- Accessorial spend: [%] of total (target: < 15%)
- Savings waterfall: [chart or table]
### Lead Time Breakdown
| Component | Current (days) | Target (days) | Gap |
|-------------------|----------------|---------------|-------|
| Order processing | ... | ... | ... |
| Transit | ... | ... | ... |
| Last mile | ... | ... | ... |
### Recommendations (Prioritized)
1. [Initiative — savings — timeline]
2. ...
Quality Checklist
Edge Cases
- Multi-modal shipments (e.g., ocean + truck): Analyze each leg separately; attribute cost and transit time per segment; watch for dwell time at transshipment points.
- Cross-border / international lanes: Include customs brokerage, duties, and compliance costs; factor in trade agreement impacts and tariff changes.
- Peak season vs. off-peak distortion: Normalize metrics by season; benchmark peak performance separately; evaluate surge capacity strategy.
- Small parcel high-volume shippers: Focus on zone skipping, regional carrier diversification, and dimensional weight optimization.
- Dedicated fleet vs. common carrier: Run total cost of ownership comparison including fixed fleet costs, empty miles, and driver utilization.
- Fragile or hazardous goods: Assess specialized carrier performance separately; include regulatory compliance cost in benchmarking.
1---2name: logistics-review3description: Review logistics operations including route optimization, carrier performance, cost benchmarking, lead time analysis, and last-mile delivery assessment. TRIGGER when: user says /logistics-review, "review logistics", "shipping analysis", "freight audit", "carrier review", "transportation analysis".4---56# Logistics Review78Evaluate and improve logistics operations across the transportation network to reduce cost, improve service reliability, and increase visibility.910---1112## Input Gathering1314| Input | Description | Required |15|----------------------------|--------------------------------------------------------------|----------|16| Shipment data | Origin, destination, weight, mode, carrier, cost, dates | Yes |17| Carrier contracts | Rate cards, accessorial schedules, SLA commitments | Yes |18| Time period | Review window (recommend minimum 6 months) | Yes |19| Delivery performance data | Promised vs. actual delivery dates, damage/claim records | Yes |20| Network map | Warehouse/DC locations, customer density, lane volumes | No |21| Benchmark data | Industry rates, peer comparisons, market indices | No |22| Customer requirements | Delivery windows, special handling, compliance mandates | No |2324---2526## Step-by-Step Process2728### Step 1 — Shipment Profile Analysis2930Build a complete picture of the logistics operation:3132| Dimension | Analysis |33|----------------------|-------------------------------------------------------|34| Mode split | % of spend and volume by TL, LTL, parcel, air, ocean |35| Lane concentration | Top 20 lanes by volume and spend; Pareto analysis |36| Shipment density | Average weight, cube utilization, pieces per shipment |37| Temporal patterns | Day-of-week, monthly, seasonal volume fluctuations |38| Geographic coverage | Heat map of origin-destination pairs, delivery zones |3940Flag anomalies: shipments below minimum weight, excessive accessorials, split shipments that could consolidate.4142### Step 2 — Carrier Performance Scorecard4344Score each carrier on a weighted composite:4546| KPI | Weight | Measurement | Target |47|----------------------------|--------|-------------------------------------------|---------------|48| On-time delivery (OTD) | 30% | Delivered within promised window | > 95% |49| Damage / claims rate | 15% | Claims filed per 1,000 shipments | < 2 |50| Invoice accuracy | 15% | % of invoices matching contracted rates | > 98% |51| Tender acceptance rate | 15% | % of loads accepted on first tender | > 90% |52| Transit time consistency | 15% | Std deviation of transit days per lane | Low variance |53| Responsiveness | 10% | Time to resolve exceptions and inquiries | < 4 hours |5455Produce a quarterly ranking and identify carriers eligible for volume increase or reduction.5657### Step 3 — Cost Benchmarking and Spend Analysis5859Analyze logistics spend against benchmarks:6061- **Cost per unit shipped** (by mode and lane).62- **Cost as % of revenue** — compare to industry median (typically 4-8% for manufacturing, 8-15% for e-commerce).63- **Accessorial spend breakdown** — fuel surcharge, detention, liftgate, residential, redelivery.64- **Rate trend analysis** — contracted rates vs. spot market over the review period.65- **Spend leakage** — shipments moving outside contracted rates, unauthorized carriers, off-contract accessorials.6667Build a savings waterfall identifying each opportunity by category and estimated annual value.6869### Step 4 — Lead Time Analysis7071Map end-to-end lead times for key lanes:7273| Lead Time Component | Measurement | Optimization Lever |74|--------------------------|----------------------------------|-------------------------------|75| Order processing | Order placed to ship-ready | Automation, cut-off times |76| Warehouse dwell | Ship-ready to carrier pickup | Pickup scheduling, dock slots |77| Transit time | Pickup to destination arrival | Mode selection, routing |78| Customs / clearance | Border arrival to release | Pre-clearance, broker perf |79| Last-mile delivery | Hub arrival to customer receipt | Network design, carrier mix |80| **Total order-to-delivery** | **Sum of above** | **Process redesign** |8182Identify the longest and most variable components; quantify the opportunity from reducing each by 10-25%.8384### Step 5 — Last-Mile Delivery Assessment8586Evaluate last-mile performance specifically:8788- **Cost per delivery** by zone, package size, and delivery type (standard, express, same-day).89- **First-attempt delivery success rate** — target > 92%.90- **Customer satisfaction scores** tied to delivery experience.91- **Returns logistics cost** — reverse logistics as % of forward cost.92- **Alternative delivery model evaluation** — gig economy, locker networks, micro-fulfillment, crowd-shipping.9394### Step 6 — Recommendations and Action Plan9596Prioritize opportunities using an impact-effort matrix:9798| Priority | Initiative | Annual Savings | Effort | Timeline |99|----------|----------------------------------|----------------|--------|--------------|100| 1 | Quick wins (rate corrections) | $... | Low | 0-30 days |101| 2 | Carrier mix optimization | $... | Medium | 30-90 days |102| 3 | Mode shift opportunities | $... | Medium | 60-120 days |103| 4 | Network redesign | $... | High | 6-12 months |104105---106107## Output Format108109```110## Logistics Review — [Scope/Region] — [Period]111112### Executive Summary113- Total logistics spend reviewed: [$X]114- Shipments analyzed: [count]115- Identified savings opportunities: [$Y] ([%] of spend)116- Service level: [current OTD%] -> [projected OTD%]117118### Shipment Profile119| Mode | Shipments | Spend | Avg Cost/Shipment | Volume Trend |120|--------|-----------|-----------|-------------------|--------------|121| TL | ... | ... | ... | ... |122| LTL | ... | ... | ... | ... |123| Parcel | ... | ... | ... | ... |124125### Carrier Scorecard126| Carrier | OTD | Damage Rate | Invoice Accuracy | Tender Accept | Composite Score |127|---------|-------|-------------|------------------|---------------|-----------------|128| ... | ... | ... | ... | ... | ... |129130### Cost Benchmarking131- Cost per unit shipped: [$X] vs. benchmark [$Y]132- Accessorial spend: [%] of total (target: < 15%)133- Savings waterfall: [chart or table]134135### Lead Time Breakdown136| Component | Current (days) | Target (days) | Gap |137|-------------------|----------------|---------------|-------|138| Order processing | ... | ... | ... |139| Transit | ... | ... | ... |140| Last mile | ... | ... | ... |141142### Recommendations (Prioritized)1431. [Initiative — savings — timeline]1442. ...145```146147---148149## Quality Checklist150151- [ ] Shipment data validated for completeness (no missing lanes, costs, or dates)152- [ ] Carrier scorecard uses weighted composite, not a single metric153- [ ] Cost benchmarks sourced from current market data or industry reports154- [ ] Accessorial charges broken out and anomalies flagged155- [ ] Lead time analysis covers end-to-end, not just transit156- [ ] Last-mile assessment includes customer experience metrics157- [ ] Savings estimates are conservative and assumption-documented158- [ ] Recommendations prioritized by impact and feasibility159- [ ] Quick wins separated from structural changes160- [ ] Stakeholder review scheduled for findings presentation161162---163164## Edge Cases165166- **Multi-modal shipments (e.g., ocean + truck)**: Analyze each leg separately; attribute cost and transit time per segment; watch for dwell time at transshipment points.167- **Cross-border / international lanes**: Include customs brokerage, duties, and compliance costs; factor in trade agreement impacts and tariff changes.168- **Peak season vs. off-peak distortion**: Normalize metrics by season; benchmark peak performance separately; evaluate surge capacity strategy.169- **Small parcel high-volume shippers**: Focus on zone skipping, regional carrier diversification, and dimensional weight optimization.170- **Dedicated fleet vs. common carrier**: Run total cost of ownership comparison including fixed fleet costs, empty miles, and driver utilization.171- **Fragile or hazardous goods**: Assess specialized carrier performance separately; include regulatory compliance cost in benchmarking.