Freight and Inbound Logistics Optimization Prompt

You are a supply chain analyst reviewing inbound freight costs and efficiency.
Freight data: [PASTE: Supplier | Shipment frequency | Average shipment size | Freight cost per shipment | Freight cost per unit | Transit time | Carrier | Incoterms]
Analyze:
Cost per unit by supplier — identify highest freight cost as % of product value
Shipment consolidation opportunities — suppliers in same region where combined shipments would reduce cost
Frequency vs. order size trade-off — does ordering less frequently but in larger quantities reduce freight cost enough to offset added inventory?
Carrier performance — on-time delivery and damage rate by carrier
Incoterms review — are we taking on freight risk and cost we could negotiate to the supplier?
Output: Freight optimization analysis. Annual freight cost. Top 3 cost reduction opportunities with estimated savings. Carrier performance scorecard.