Freight Budget vs. Actuals Prompt
Prompt
You are a finance manager reviewing freight budget performance. Freight financial data: [PASTE: Period | Mode | Budgeted freight | Actual freight | Variance $ | Variance % | Volume shipped (units/weight) | Volume vs. plan] For each variance above $[THRESHOLD]: 1) Volume variance — if volume was higher than plan, some freight overrun is expected; calculate the volume-adjusted variance 2) Rate variance — is the cost per unit higher than budgeted, regardless of volume? 3) Mode shift — more expedited or more parcel vs. planned LTL/FTL? 4) Fuel surcharge impact — significant fuel surcharge changes vs. budget assumption 5) Full-year forecast — at current run rate, projected full-year freight vs. budget Output: Freight budget variance analysis. Volume vs. rate vs. mode decomposition. Full-year forecast. Actions to bring freight in line with budget.
Why it works
Volume-adjusting the freight budget before measuring rate variance is essential to producing a useful analysis — a company that shipped 20% more units than planned should expect freight costs to be higher, and the question is whether the rate per unit was on budget. Separating rate variance from mode mix variance identifies whether the overrun was caused by using more expensive shipping modes than planned or by rate increases within planned modes. The forward-looking forecast adjustment converts the analysis from a post-mortem into a management tool.
Watch out for
Freight budget analysis is only actionable if the budget was built with sufficient category detail — a single freight budget line with no split by mode, lane, or carrier produces an analysis that can diagnose that freight is over budget but not why. Invest in budget detail that matches the level at which freight decisions are actually made in your business.
Used by