Transportation, Freight & Distribution worked example

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

Here is what the math looks like when conditions slip. We hold every other input steady and drop affected spend share to 72%, then walk the calculation through step by step. Estimate transportation spend variance from affected shipments, variance per shipment, affected share, and fixed freight exceptions.

The inputs for this scenario

  • Affected shipments: 420 shipments (held at the documented default)
  • Variance per shipment: 24 $ / shipment (held at the documented default)
  • Affected spend share: 72 % (the input this scenario stresses; the baseline uses 100)
  • Fixed freight exceptions: 3,800 $ (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: Variable transportation spend variance = affected shipments × variance per shipment × affected spend share.
  • Total transportation spend variance works out to 11,058 $ at these inputs, and this is the headline figure for the scenario.
  • Variance per shipment works out to 26.33 $ / unit at these inputs.
  • Variable transportation spend variance works out to 7,258 $ at these inputs.
  • Fixed charges works out to 3,800 $ at these inputs.

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 20.33% below the baseline at 11,058 $.
  • The practical read: the gap between this scenario and the baseline is entirely attributable to affected spend share, so recovering it is worth quantifying in dollars before considering equipment or staffing changes. It assumes a single average variance per shipment, so it will not distinguish a few large outliers from many small overages without segmenting your data first.

Results at a glance

  • Total transportation spend variance: 11,058 $ (headline result)
  • Variance per shipment: 26.33 $ / unit
  • Variable transportation spend variance: 7,258 $
  • Fixed charges: 3,800 $

Run it with your numbers

  • To rerun this with your own numbers, open the live Transportation Spend Variance calculator, set affected spend share to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.