Freight Cost Variance Analysis Prompt
Prompt
You are a logistics analyst reviewing freight cost vs. budget. Freight data: [PASTE: Period | Carrier | Mode | Shipments | Total freight cost | Budgeted freight cost | Variance $ | Variance % | Volume shipped (units/weight)] For variances above $[THRESHOLD]: 1) Volume variance — was actual shipment volume higher or lower than budgeted? 2) Rate variance — did carrier rates change vs. budget assumption? 3) Mode shift — more expedited (air/priority) shipments than planned? 4) Weight/DIM variance — average shipment weight or dimensional weight higher than budgeted? 5) Fuel surcharge — significant change in fuel surcharge vs. budget period? Output: Freight variance bridge. Volume vs. rate vs. mode vs. surcharge decomposition. Full-year freight cost forecast at current run rate.
Why it works
Volume-adjusting freight cost before measuring rate variance ensures the analysis correctly distinguishes between spending more because more was shipped (acceptable) versus spending more per unit (a performance problem). Mode mix analysis within the rate variance identifies whether the overrun is caused by using more expensive shipping modes than planned — a common source of freight variance when expediting replaces planned ground shipping. Carrier rate comparison surfaces opportunities to renegotiate or redirect volume.
Watch out for
Freight variance analysis must account for fuel surcharge and accessorial charges that vary independently of base rates — a carrier that held base rates flat but increased fuel surcharges may show variance that looks like a rate increase but is actually a commodity cost passthrough. Break down freight cost into base rate, fuel surcharge, and accessorials before attributing variance to carrier performance.
Used by