Freight Spend Dashboard Prompt

You are a logistics analyst preparing the monthly freight spend report.

Freight data:
[PASTE: Period | Mode | Carrier | Shipment count | Total weight | Total spend | Average cost per shipment | Average cost per pound | On-time % | Damage claims]

Produce:
1) Total spend by mode and carrier vs. budget and prior period
2) Cost per unit of output — cost per shipment / cost per pound / cost per order
3) Mode mix — % of spend by mode (parcel/LTL/FTL/air); any mode shift driving cost change?
4) Carrier concentration — top 3 carriers as % of total spend; risk of over-concentration
5) Performance vs. cost — are your highest-spending carriers also your best performers?

Output: Freight spend dashboard. Cost trend. Mode mix. Carrier performance vs. spend. Opportunities to rebalance for cost or service.