US Freight Scenario Dashboard: Show What Can Reverse a Choice
Organize the display around a decision
A freight scenario dashboard should show when the preferred alternative changes and why. A collection of attractive charts is less useful if the reader cannot identify the cargo, alternatives and commercial objective being compared. Start with one decision and a defined comparison basis, then display the assumptions capable of changing the result.
For a Gulf Coast cargo buyer, the objective might be the lowest comparable cost among feasible service proposals. Another buyer may prioritize a delivery requirement or a limit on cash exposure. The dashboard must state that objective. Otherwise, a green lowest-cost result can be mistaken for the best option even when it fails the buyer's essential condition.
GAO's estimating guide includes sensitivity and risk analysis among its described steps. GAO cost-estimating guide.
The dashboard design here is original commercial analysis. It uses a small number of transparent cases rather than presenting an unsupported forecast of what will happen.
Keep the base case visible but conditional
Show the base assumptions beside the base result. Identify which inputs are quoted, confirmed, estimated or unresolved. A base case is a reference point for comparison, not a promise that the shipment will unfold exactly that way. Users should be able to see which facts would need to remain true for the result to hold.
Display the alternatives on equivalent scope. If one proposal includes a service that another excludes, normalize that difference before sensitivity testing. Otherwise, the dashboard may spend considerable effort exploring variations around an invalid starting comparison. Keep the normalization adjustments visible so a reviewer can challenge them.
Microsoft describes What-If Analysis as changing inputs to examine effects on formula results. Microsoft What-If Analysis.
Software can support the calculation, but the analyst must choose commercially coherent inputs. A large grid of impossible or inconsistent combinations does not improve the decision simply because every cell contains a number.
Locate the reversal in a fictional comparison
Assume two hypothetical proposals cover the same service scope. A costs USD 400,000 before an uncertain delay and adds USD 20,000 for each modeled delay day. B starts at USD 440,000 and adds USD 10,000 per modeled delay day. These fictional daily amounts are planning costs, not contractual demurrage rates.
With no delay, A is USD 40,000 cheaper. At two days, A costs USD 440,000 and B costs USD 460,000, so A remains USD 20,000 cheaper. At four days, both cost USD 480,000. At six days, A costs USD 520,000 and B costs USD 500,000, making B USD 20,000 cheaper.
The dashboard should highlight the four-day crossover and the cost difference on either side. It should not simply show two rising cost lines without explaining the decision consequence. The useful next question is whether the buyer has evidence that makes one side of the crossover more relevant to the actual movement.
No probability has been assigned to these cases. The model shows conditional outcomes. A decision-maker can use them to request better timing information or assess tolerance for exposure without claiming that a particular delay is expected.
Add linked costs instead of varying everything independently
Now suppose A also incurs a fictional storage charge of USD 12,000 for each modeled delay day beyond three days. B has no additional storage charge in this example because its stated package already covers the relevant storage exposure. The extra charge is conditional on the delay, so it should move with that input.
At three days, A costs USD 460,000 and B USD 470,000. At four days, A costs USD 492,000, including one extra storage day, while B costs USD 480,000. The ranking therefore reverses between those displayed cases earlier than the original four-day equality suggested.
A dashboard that leaves storage fixed while varying delay would miss this linked effect. Equally, it would be wrong to add the storage charge to B without checking its scope. Model the actual causal relationship and the proposal's inclusions, not a generic percentage applied to every alternative.
For real work, obtain the applicable charging structure and confirm when each cost begins. The simplified fictional step illustrates the design principle; it is not a port storage rule or an instruction for calculating an actual invoice.
Separate financial ranking from feasibility
Before showing a winner, identify whether each case still meets the essential conditions. If a delay causes an option to miss an absolute customer requirement, the dashboard should show that status separately from its cost. Do not allow a low price to compensate numerically for an unmet condition unless the buyer has explicitly made it a tradeable preference.
Use distinct displays for comparable cost, cash timing and unresolved acceptance. These measures may affect the same decision, but adding them into one unexplained score obscures the trade-off. A manager should be able to see whether the preferred option changes because of economics, liquidity or feasibility.
Keep uncertainty ranges grounded in the decision context. Avoid broad arbitrary extremes chosen only to make the charts dramatic. Ask which changes are plausible enough to investigate and material enough to influence the choice. Include a severe case where useful, but label its purpose rather than assigning an unsupported likelihood.
Make the dashboard useful at handover
Every displayed scenario should have a short explanation of what changed from the base case. Retain the model version and the source dates used. If the inputs change, confirm that the displayed summaries were regenerated; a dashboard image can remain stale even when the underlying workbook has been updated.
Finish with the assumptions that deserve confirmation next. In the fictional example, the delay exposure and storage inclusion matter more than an immaterial formatting difference between offers. A useful dashboard directs attention to those questions and shows how their answers will affect the recommendation.
Bring a live commercial choice and its most uncertain inputs to Zeaclub to discuss a proposed scenario dashboard. The objective is a clear US freight decision supported by visible reversal points, coherent linked assumptions and human judgment, rather than a confident-looking base case that conceals how easily the ranking can change.
Sources
- GAO: Cost Estimating and Assessment Guide, checked October 24, 2026; sensitivity-analysis scope only, within the shared source allocation.
- Microsoft: Introduction to What-If Analysis, checked October 24, 2026; input-and-result analysis capability only.
Related articles
- 0995: US Voyage Estimate Audit: Reproduce the Number Before Approving
- 0434: US Tanker Dashboards: Show What Could Change the Preferred Proposal
- 0980: US Bunker Sensitivity Matrix: Find the Price That Reverses a Voyage


