Most companies that conduct scenario analysis create three scenarios: base case, best case, worst case. The scenarios are modelled in Excel. The sensitivity table is produced. The spreadsheet is filed. The company proceeds with the base case.
The exercise answered the question “what could happen?” It did not answer the question that matters: “when we know it is happening, what do we do?”
Scenario analysis without decision triggers is an intellectual exercise. The company has modelled uncertainty without creating a mechanism for responding to it. When the worst case begins to materialise, management has no predefined playbook. It improvises, often too late, because the indicators that should have triggered a response were not being monitored.
From Modelling to Managing
The transformation from scenario analysis to scenario management requires three additional steps after the model is built.
Step 1: Define the indicators
For each scenario, identify the observable indicators that would signal the scenario is materialising.
If the downside scenario assumes demand drops to 80% of plan, the indicator is: actual orders, measured weekly, compared to the plan trajectory. If orders are trending below 85% of plan by Week 8, the downside scenario is materialising.
Step 2: Define the thresholds
For each indicator, set the threshold that triggers management action.
Step 3: Assign ownership
Each trigger has an owner: the individual who monitors the indicator, determines when the threshold is crossed and initiates the predefined action. The owner does not need committee approval for the predefined action, because the approval was given when the trigger framework was designed.
The technology layer
Technology transforms scenario management from a quarterly review exercise into a continuous monitoring system. The indicators are tracked in real time through BI dashboards connected to the ERP, the CRM and the financial planning system. When an indicator approaches its threshold, the system alerts the owner. When the threshold is crossed, the predefined action is initiated.
The monitoring is continuous. The response is immediate. The scenario analysis, originally a static Excel exercise, becomes a living decision system.
In Northrop Management Private Limited’s capital allocation and financial advisory practice, scenario analysis is delivered as a decision infrastructure, not a spreadsheet. The model defines the scenarios. The indicators define what to watch. The thresholds define when to act. The ownership defines who acts. The technology defines how fast.
Ashish Chaudhary, frames the management discipline directly: “Scenario analysis should answer three questions: what changes, when do we know it has changed, and what decision do we make? A company that answers only the first has modelled uncertainty. A company that answers all three has built a decision system. The difference is whether the company responds to the downside in Week 8 or in Month 6. And in most businesses, the financial consequence of 18 weeks of delayed response is larger than the downside itself.”
Questions for the Boardroom
- For our most recent scenario analysis, have we defined the specific indicators that would signal each scenario is materialising?
- Are those indicators being monitored continuously (real-time dashboards) or periodically (quarterly reviews)?
- For each indicator, is there a defined threshold and a predefined management action?
- Does each trigger have a named owner who has authority to initiate the action without waiting for committee approval?
- When was the last time a scenario trigger was actually crossed, and did the organisation respond as the framework prescribed?
Closing Implication
Scenario analysis is not forecasting. It is decision preparation. The company that models three scenarios has imagined three futures. The company that defines indicators, thresholds, owners and actions for each scenario has prepared for three futures. The first company will respond when it recognises, retrospectively, that the scenario has materialised. The second will respond when the indicator crosses the threshold, prospectively, before the full impact arrives.