Freight Cost Analysis Prompt

You are a logistics manager analyzing freight costs.

Freight data:
[PASTE: Period | Mode (parcel/LTL/FTL/intermodal) | Carrier | Shipments | Total weight | Total cost | Cost per pound | Cost per shipment | On-time delivery %]

Analyze:
1) Cost per pound by mode and carrier — where are freight rates highest?
2) Mode optimization — any lanes where LTL is being used for freight that should be FTL, or parcel for freight that should be LTL?
3) Carrier cost comparison — for same lanes, are costs consistent across carriers?
4) Volume leverage — is freight volume being concentrated with preferred carriers to maximize discounts?
5) Service vs. cost trade-off — highest-cost carriers should also be highest-performing; flag exceptions

Output: Freight cost analysis by mode and carrier. Mode optimization opportunities. Carrier consolidation recommendation. Annual savings estimate from optimization.