Can you model the future before you commit to it?
Big decisions are bets on an uncertain future. This question reveals whether you can model how a price change, a new market, or a volume swing would play out across best, base, and worst cases, or whether you are still deciding on a single guess and hoping.
“Can you model scenarios and what-if analysis to support strategic decisions?”
What is scenario modelling capability, and why does it matter?
It is the ability to model how a decision would play out under different assumptions, before committing to it. Instead of a single forecast, you build a range: a best case, a base case, and a worst case, and you see how profit moves as volume, price, cost, or mix change. A cost model built with time-driven activity-based costing is what makes this reliable, because it can recompute the true cost and profit of each scenario, not just scale a spreadsheet. Maturity runs from no scenario capability at all, to manual what-if in a spreadsheet, to structured best-base-worst models, to dynamic simulation that actively shapes strategic decisions. The stronger the capability, the less you are betting blind.
A single forecast is a bet you cannot see.
Every strategic decision, a price change, a new channel, an investment, is a bet on assumptions that may not hold. Deciding against a single forecast hides the risk: you cannot see how wrong you can afford to be, or what happens if volume comes in low and cost comes in high at the same time.
Scenario modelling makes the risk visible. By modelling best, base, and worst cases, you see the range of outcomes, the break-even, and the decisions that are robust across all of them. A move that looks good in the base case but ruinous in the worst case is one you want to know about before you commit, not after.
This depends on a cost model that can recompute profit under new assumptions. A spreadsheet that simply scales last year cannot; a time-driven activity-based cost model can, because it holds the real drivers of cost and can flex them scenario by scenario.
From a single guess to a modelled range.
As capability matures, a single forecast gives way to manual what-if, then to structured best-base-worst models, and finally to dynamic simulation that actively shapes strategic decisions.
Can you model what-if?
Question 10 assesses whether you can model scenarios to support strategic decisions. Each level replaces more guesswork with a modelled range of outcomes.
“We decide on a single forecast, with no what-if modelling.”
Decisions rest on one projection, usually an extrapolation of last year. There is no way to test how the outcome changes if assumptions move, so risk is invisible and the downside is discovered only after the decision is made.
- Decisions rest on a single, unquestioned projection
- No way to see the downside before committing
- Risk is discovered after the fact, not before
- Assumptions are implicit and untested
“We can flex a few assumptions by hand in a spreadsheet.”
Some what-if is possible: an analyst changes a number and sees the effect. This is a real improvement, but it is slow, fragile, and limited to one or two variables at a time. Because the underlying model just scales, it does not capture how cost truly behaves as volume or mix change.
- What-if is manual, slow, and easy to break
- Only one or two variables can move at once
- The model scales cost rather than recomputing it
- Results are directional, not reliable
“We model structured scenarios with a proper cost model behind them.”
Scenarios are built deliberately: best, base, and worst, each with coherent assumptions, computed on a cost model that recalculates true profit. Decision-makers see the range, the break-even, and which choices are robust. This is where scenario modelling starts to change decisions rather than just describe them.
- Scenarios are structured and internally coherent
- A real cost model recomputes profit, not a scaled sheet
- The range and break-even are visible to decision-makers
- Modelling now informs the decision, not just reports it
“We run dynamic simulations that actively shape strategic decisions.”
Scenario modelling is continuous and embedded. Decision-makers can flex assumptions live, run many scenarios quickly, and see profit and risk update in real time. Modelling is part of how strategy is set, not a one-off exercise, and the organisation routinely chooses the option that is robust across futures.
- Simulation must rest on a trusted, current cost model
- Speed must not come at the cost of realism
- Skills shift toward interpreting scenarios, not building them
- The temptation to over-model must be balanced with decisiveness
Practical steps, level by level.
Quick Wins
- Take your next big decision and write down its key assumptions explicitly
- Build a simple spreadsheet to flex the one or two that matter most
- Model a downside case, not just the expected one
- Bring the range, not a single number, to the decision table
Structural Improvements
- Connect scenarios to a cost model that recomputes profit, not one that scales
- Build structured best, base, and worst cases with coherent assumptions
- Show the break-even and which choices are robust across the range
- Use the scenarios to actually inform the decision, on the record
World-Class Practices
- Make scenario modelling live, so assumptions can be flexed in the room
- Run many scenarios quickly on a current, trusted cost model
- Embed modelling in planning, not just one-off business cases
- Choose for robustness across futures, and keep the model transparent
Where modelling matters most.
Every business faces uncertainty, but scenario modelling pays back hardest where decisions are large, irreversible, and sensitive to volume or cost.
| Industry | Decision Signal | Key Insight |
|---|---|---|
| Manufacturing | Capacity bets | Capacity and mix decisions are large and hard to reverse; modelling how cost behaves at different volumes is what protects the investment. |
| Distribution & Logistics | Network moves | Adding a depot or a route changes cost to serve non-linearly; scenario models reveal the break-even that a single forecast hides. |
| Professional Services | Pricing and hiring | Decisions on pricing and capacity hinge on utilisation; what-if modelling shows which bets survive a slow quarter. |
Are you deciding on a guess, or a range?
Take the free Profitability Health Check to assess whether you can model scenarios before you commit, and where a single forecast is hiding the risk in your biggest decisions.