Transportation, Freight & Distribution worked example

Transportation Spend Variance at 110% affected spend share: a worked example

Push affected spend share up to 110% and the picture changes. This example computes every intermediate figure at that operating point. Use it to explain freight budget misses, carrier rate changes, fuel swings, service failures, and unplanned premium freight.

The inputs for this scenario

  • Affected shipments: 420 shipments (unchanged)
  • Variance per shipment: 24 $ / shipment (unchanged)
  • Affected spend share: 110 % (raised for this scenario; the documented default is 100)
  • Fixed freight exceptions: 3,800 $ (unchanged)

Working through the calculation

  • Applying the documented formula (Variable transportation spend variance = affected shipments × variance per shipment × affected spend share) to the inputs above produces each figure below.
  • At this operating point the engine returns 14,888 $ for total transportation spend variance, the number this scenario is built around.
  • At this operating point the engine returns 35.45 $ / unit for variance per shipment.
  • At this operating point the engine returns 11,088 $ for variable transportation spend variance.
  • At this operating point the engine returns 3,800 $ for fixed charges.

How this compares with the baseline

  • Against the tool's baseline example, where affected spend share sits at 100% and the headline result is 13,880 $, this scenario comes in 7.26% above the baseline at 14,888 $.
  • It computes total freight spend variance as affected shipments times per-shipment variance times the affected spend share, plus fixed freight exceptions. The value of this scenario is the size of the gap it exposes: that gap, priced out over a year, is the budget you can justify spending to close it.

Results at a glance

  • Total transportation spend variance: 14,888 $ (headline result)
  • Variance per shipment: 35.45 $ / unit
  • Variable transportation spend variance: 11,088 $
  • Fixed charges: 3,800 $

Run it with your numbers

  • Every input above is editable in the live Transportation Spend Variance calculator, which recalculates instantly and can be shared with the inputs intact.

Last reviewed 2026-05-12.