Prescriptive Analytics & Decision Trees

Chapter 8
Sensitivity, Scenario and Robust Decision Analysis

Graduate Program in Business Analytics
Prescriptive Analytics & Decision Trees   •   Graduate

Sensitivity, Scenario and Robust Decision Analysis

Introduction

A prescriptive analytics recommendation is never better than the assumptions, data, and model that support it. A solution that is optimal for one forecast of demand, cost, or capacity may become unattractive when conditions change. Sensitivity, scenario, and robust decision analysis provide a disciplined way to examine this problem before a decision is implemented.

These methods answer different questions. Sensitivity analysis asks how much the recommendation changes when one or more input parameters vary. Scenario analysis examines coherent combinations of changes, such as a recession, supply disruption, or rapid growth. Uncertainty analysis represents unknown future conditions probabilistically or through distributions. Robust decision analysis seeks choices that perform acceptably across a range of plausible futures rather than optimizing only one estimated future.

The distinction is strategically important. A decision maker may accept a small reduction in expected profit if it substantially reduces exposure to severe downside outcomes. Conversely, a solution that appears robust may be unnecessarily conservative if its performance is measured without considering probabilities, reversibility, or the value of information.

Learning Objectives

By the end of this chapter, you should be able to:

  1. Distinguish sensitivity, scenario, risk, uncertainty, and ambiguity.
  2. Conduct one-way, two-way, and multi-parameter sensitivity analysis.
  3. Calculate break-even values and interpret switching points.
  4. Construct and evaluate coherent scenarios.
  5. Formulate robust and chance-constrained optimization models.
  6. Assess trade-offs among expected value, variability, downside risk, and resilience.
  7. Communicate model dependence, limitations, and governance implications.

1. A Decision Model as a Function of Assumptions

Let a decision be represented by vector [[M:x]], parameters by [[M:θ]], and objective value by [[M:f(x;θ)]]. A prescriptive model solves:

x*(θ) = argmaxx ∈ X(θ) f(x;θ)

Here, [[M:X(θ)]] is the feasible set, which may itself depend on parameters such as capacity, budgets, or regulatory limits. Sensitivity analysis studies the effect of changing [[M:θ]] on both the objective value and the selected decision [[M:x*]]. This distinction matters: a parameter may have a large effect on profit while leaving the recommended decision unchanged, or it may cause a small profit change but trigger a completely different operating plan.

A useful decomposition is:

  • Data uncertainty: the true value is unknown, but a probability distribution may be defensible.
  • Parameter uncertainty: model coefficients, such as demand elasticity or failure rates, are estimated rather than known.
  • Model uncertainty: competing model structures could plausibly represent the process.
  • Ambiguity: probabilities themselves are disputed or unavailable.
  • Decision uncertainty: implementation, behavioral responses, or managerial execution may differ from the model.

A model should report not only its best solution but also the conditions under which that solution remains preferable.

2. Sensitivity Analysis

2.1 One-way sensitivity analysis

One-way sensitivity analysis changes one input while holding others constant. Suppose profit from a product is:

Π(q) = (p − c)q − F

where [[M:Π]] is profit in currency units, [[M:p]] is unit price, [[M:c]] is variable cost per unit, [[M:q]] is quantity sold, and [[M:F]] is fixed cost. The formula assumes a single product, constant unit price and variable cost, and no quantity-dependent constraints.

If demand is fixed at 10,000 units, price is 80, variable cost is 50, and fixed cost is 200,000, then:

Π = (80 − 50)(10,000) − 200,000 = 100,000

If variable cost increases to 58:

Π = (80 − 58)(10,000) − 200,000 = 20,000

The recommendation to produce may remain feasible, but its economic attractiveness is much weaker. One-way analysis is easy to explain, but it can be misleading when inputs are correlated. For example, a recession may reduce both price and quantity; changing only one of them may understate downside exposure.

2.2 Percentage sensitivity and elasticities

A local measure of objective sensitivity to parameter [[M:θ]] is the elasticity:

EΠ,θ = (∂Π/∂θ)(θ/Π)

It approximates the percentage change in profit associated with a one-percent change in [[M:θ]], provided the function is differentiable and the change is sufficiently small. Elasticities are dimensionless and therefore useful for comparing parameters measured in different units. They become unstable when [[M:Π]] is close to zero and do not adequately describe discontinuities or regime changes.

For the profit function, sensitivity to price is:

∂Π/∂p = q

and sensitivity to variable cost is:

∂Π/∂c = −q

The units are currency per unit of the relevant parameter. These derivatives describe local effects, not necessarily large changes.

2.3 Two-way and multi-way analysis

Two-way sensitivity analysis varies two parameters simultaneously and displays the resulting objective value or decision. A common example varies demand and unit margin. Multi-way analysis can use a grid, Monte Carlo simulation, tornado chart, or global sensitivity method such as variance-based decomposition.

For an optimization model, record at least four outputs:

  1. objective value;
  2. selected decision variables;
  3. binding constraints and slack values;
  4. feasibility status.

A solution can appear stable in objective value while a constraint becomes nearly binding, creating operational fragility.

2.4 Switching points

A switching point is a parameter value at which two alternatives have equal value. Suppose technology A has value:

VA = 120,000 − 4D

and technology B has value:

VB = 80,000 − 2D

where [[M:D]] is annual demand in units and values are currency units. Set the alternatives equal:

120,000 − 4D = 80,000 − 2D

Therefore, [[M:D = 20,000]]. Below 20,000 units, B has the greater value because its lower fixed advantage is offset by lower demand-related cost; above 20,000 units, A is preferred. The switching point is more informative than saying simply that A is “optimal,” because it identifies the boundary at which the recommendation changes.

2.5 Break-even analysis

For the single-product profit model, the operating break-even quantity is the quantity at which profit equals zero:

qBE = F/(p − c), p > c

The denominator is the contribution margin per unit. With [[M:F = 200,000]], [[M:p = 80]], and [[M:c = 50]],

qBE = 200,000/(80 − 50) = 6,667 units approximately

The formula assumes constant price and cost, no taxes or financing effects, and a positive contribution margin. If [[M:p ≤ c]], no finite positive sales volume covers fixed cost under these assumptions.

Break-even analysis can also compare alternatives. If an investment costs 300,000 and creates annual savings of 75,000, its simple payback period is:

T = Investment/Annual savings = 300,000/75,000 = 4 years

Payback ignores the time value of money and cash flows after recovery; it should not replace discounted cash-flow analysis when those factors matter.

3. Scenario Analysis

Sensitivity analysis usually varies parameters mechanically. Scenario analysis changes a set of assumptions that form a coherent narrative. Typical scenarios include base case, high-growth case, recession, supply disruption, regulatory change, and technology failure.

A scenario should specify:

  • the external conditions;
  • the parameter values or distributions implied by those conditions;
  • the decisions available;
  • the time horizon;
  • the indicators used to judge performance;
  • the actions that would trigger a response.

Scenarios should not be confused with forecasts. A forecast estimates what is most likely; a scenario explores what could plausibly occur. Scenario probabilities may be assigned when evidence supports them, but probability-free scenarios are often preferable when ambiguity is substantial.

Expected value and risk measures

If alternative [[M:a]] produces outcome [[M:Y_{as}]] in scenario [[M:s]], with probability [[M:p_s]], its expected value is:

E[Ya] = ∑s=1S psYas, ∑s=1Sps = 1

The variance is:

Var(Ya) = ∑s=1S ps[Yas − E(Ya)]²

The standard deviation is [[M:σ_a = √Var(Y_a)]], measured in the same units as the outcome. Expected value is appropriate for a risk-neutral decision maker with reliable probabilities and repeatable opportunities. It is insufficient when losses are asymmetric, probabilities are unreliable, or the organization has binding liquidity and service constraints.

A downside measure is expected shortfall. If [[M:L]] is a loss and [[M:α]] is a confidence level, expected shortfall at level [[M:α]] is the average loss in the worst [[M:(1−α)]] fraction of cases. Unlike a single worst-case value, it reflects the severity of the tail, although it requires a defensible distribution or scenario set.

4. Robust Decision Analysis

Robustness means acceptable performance across specified plausible conditions. It does not necessarily mean optimality in every condition. A robust decision may sacrifice some best-case performance to avoid catastrophic failure.

4.1 Minimax and regret criteria

For uncertain states without trusted probabilities, a conservative criterion maximizes the worst outcome:

maxa ∈ A mins ∈ S Yas

This is the maximin criterion. It is appropriate when downside protection is dominant but can be excessively conservative.

Regret compares each outcome with the best decision available in that state:

Ras = maxa' ∈ AYa's − Yas

The minimax-regret decision is:

mina ∈ A maxs ∈ S Ras

Regret is measured in outcome units and focuses on the cost of being wrong rather than the absolute outcome.

4.2 Robust optimization

A generic robust optimization problem is:

maxx minθ ∈ U f(x;θ)

where [[M:U]] is an uncertainty set. The set might be an interval, polyhedron, ellipsoid, or empirically calibrated collection of scenarios. The choice of [[M:U]] is a substantive modeling decision. An excessively broad set can produce a uselessly conservative plan; an excessively narrow set creates false confidence.

For uncertain linear constraints, a robust formulation requires feasibility for every parameter realization in [[M:U]]:

A(θ)x ≤ b for all θ ∈ U

This is called a robust counterpart when transformed into a tractable deterministic or conic program. The transformation depends on the uncertainty set and must not be assumed automatically.

4.3 Chance constraints

A chance constraint requires a constraint to hold with a specified probability:

P[g(x,ξ) ≤ 0] ≥ 1 − α

Here, [[M:ξ]] is a random vector, [[M:α]] is the permitted violation probability, and [[M:1−α]] is the service or reliability level. For a normally distributed demand [[M:D ∼ N(μ,σ²)]], a capacity decision [[M:C]] satisfying [[M:P(D ≤ C) ≥ 1−α]] can be written as:

C ≥ μ + z1−ασ

where [[M:z_{1−α}]] is the standard normal quantile. At 95% reliability, [[M:z_{0.95} ≈ 1.645]]. If expected demand is 10,000 units and standard deviation is 1,500, then:

C ≥ 10,000 + 1.645(1,500) = 12,467.5

Thus capacity should be at least approximately 12,468 units, assuming normality, a reliable estimate of [[M:σ]], and a one-period interpretation. If demand is skewed, bounded, seasonal, or dependent across locations, the normal approximation may be inappropriate.

Chance constraints manage probabilistic service requirements, but they do not automatically control the size of a violation when failure occurs. They also rely on probabilities that may be uncertain. Distributionally robust chance constraints address this by requiring performance across a family of plausible distributions rather than one distribution.

5. Worked Application: Regional Distribution Capacity

Background

The following is an illustrative case. A retailer must choose capacity for a regional fulfillment center for the next planning year. Demand is uncertain, and excess capacity is costly. Short capacity causes expedited shipping, lost sales, and reputational damage.

Problem

Three capacity choices are available:

OptionCapacityFixed annual costShortfall cost per unitExcess-capacity cost per unit
Small10,000180,000428
Medium12,000245,000428
Large15,000355,000428

Demand scenarios are 9,000, 11,000, 13,000, and 15,000 units. For capacity [[M:C]] and demand [[M:D]], annual cost is:

Cost(C,D) = F(C) + 42 max(D−C,0) + 8 max(C−D,0)

The [[M:max]] function ensures that only shortfall or excess is charged, not both. Costs are assumed linear, and capacity is available for the full year.

Scenario evaluation

CapacityCost at 9,000Cost at 11,000Cost at 13,000Cost at 15,000
Small188,000222,000306,000390,000
Medium269,000261,000303,000387,000
Large403,000387,000371,000355,000

If the four scenarios are assigned equal probabilities, expected costs are 276,500 for Small, 305,000 for Medium, and 379,000 for Large. On expected cost alone, Small is preferred. However, Small has the highest cost in the two high-demand scenarios and exposes the retailer to severe service risk.

The maximum costs are 390,000, 387,000, and 403,000, respectively. Under a minimax-cost criterion, Medium is preferred because it has the lowest worst-case cost. If management instead requires at least 95% capacity coverage and demand is modeled as normal with mean 11,500 and standard deviation 1,800, required capacity is:

C ≥ 11,500 + 1.645(1,800) = 14,461

The Large option is the only listed capacity satisfying that requirement. The recommendations differ because the criteria differ: expected cost, worst-case cost, and service reliability are not interchangeable.

Governance interpretation

Before implementation, analysts should validate the scenario probabilities, test demand correlation with promotions, model temporary outsourcing, and estimate whether capacity can be expanded. A staged contract or flexible third-party capacity may dominate all three fixed alternatives by creating an option to respond after demand information improves.

6. Value of Information and Real Options

Sensitivity analysis may reveal that a recommendation changes near a plausible parameter boundary. In such a case, better information may have economic value. The expected value of perfect information is:

EVPI = E[maxa Ya] − maxa E[Ya]

The first term represents choosing the best action after the state is known; the second represents choosing before the state is known. EVPI is an upper bound on what an organization should pay for perfect information. The value of sample information is lower because a real study is imperfect.

Managerial flexibility can also create option value. Examples include modular capacity, postponable procurement, cancellation clauses, pilot launches, and reversible technology investments. A static optimization model may undervalue these choices because it assumes that the initial decision cannot be revised.

7. Implementation Workflow and Best Practices

A defensible analysis follows a transparent workflow:

  1. Define the decision and outcome. Specify objectives, constraints, time horizon, and units.
  2. Identify influential assumptions. Use domain expertise, derivatives, historical validation, or screening methods.
  3. Separate controllable decisions from uncertain parameters. Do not vary decisions as if they were data.
  4. Construct plausible ranges. Document sources, confidence, and dependencies.
  5. Run local sensitivity analysis. Identify thresholds, binding constraints, and nonlinearities.
  6. Build coherent scenarios. Ensure that parameter combinations are internally consistent.
  7. Compare criteria. Report expected value, dispersion, downside exposure, regret, and service metrics where relevant.
  8. Test robustness. Use uncertainty sets, stress tests, distributional alternatives, or out-of-sample simulation.
  9. Identify monitoring indicators. Link leading indicators to predefined response actions.
  10. Communicate limitations. State what the model does not represent and which assumptions drive the recommendation.

Reproducibility is essential. Version-control input data, scenario definitions, code, solver settings, and decision outputs. A sensitivity report should make it possible for an independent reviewer to reproduce the result.

8. Limitations, Ethics, and Governance

Robust analysis can create an illusion of objectivity. Uncertainty sets are often selected by analysts or executives and may encode hidden risk preferences. A “worst case” may be physically impossible, while a plausible but unmodeled event may be omitted entirely.

Data quality also affects equity. If a service allocation model uses historical demand that reflects unequal access, optimizing expected outcomes may reinforce that inequality. Scenario analysis should therefore examine impacts across relevant customer or population groups, not only aggregate profit.

Chance constraints require careful governance when violations affect safety, health, privacy, or legal rights. A 95% service level may be unacceptable for a critical medical supply, and averaging risk across individuals may conceal concentrated harm. Decision makers should document who bears downside risk, establish escalation thresholds, and obtain appropriate legal, compliance, and subject-matter review.

AI-assisted forecasting and optimization can accelerate scenario generation, but generated scenarios must be audited for plausibility, data leakage, bias, and correlated errors. Human review remains necessary when model outputs influence high-consequence decisions.

9. Contemporary Developments

Modern decision systems increasingly combine:

  • distributionally robust optimization, which protects against misspecified probability distributions;
  • Bayesian decision analysis, which updates parameter beliefs as evidence arrives;
  • conformal and probabilistic forecasting, which provide calibrated predictive intervals under stated conditions;
  • simulation-based optimization for nonlinear and discrete systems;
  • digital twins for testing operational policies before deployment;
  • adaptive policies that map observed signals to future actions rather than selecting one fixed plan.

These approaches do not eliminate uncertainty. They improve the explicit representation of assumptions, feedback, and adaptation. Their value depends on validation, calibration, computational tractability, and managerial interpretability.

Chapter Summary

Sensitivity analysis examines how outcomes and recommendations respond to changes in assumptions. One-way analysis is transparent but may ignore interactions; multi-way and global methods reveal nonlinearities and correlated effects. Break-even and switching-point calculations identify the boundaries at which decisions change.

Scenario analysis evaluates coherent possible futures and should be distinguished from forecasting. Expected value is useful when probabilities are credible and decision opportunities are repeatable, while variance, downside measures, and regret reveal risks that averages conceal. Robust optimization protects performance across an uncertainty set, minimax criteria emphasize worst outcomes, and chance constraints impose probabilistic reliability requirements.

A high-quality prescriptive analysis reports the recommendation, its sensitivity, the assumptions that drive it, the consequences of failure, and the monitoring or adaptation plan. Governance must address model uncertainty, distributional effects, accountability, and the ethical allocation of risk.

Key Terms

Sensitivity analysis: Examination of how outputs change when model inputs vary.

Scenario analysis: Evaluation of coherent combinations of assumptions describing possible futures.

Uncertainty: Lack of complete knowledge about parameters, states, or model structure.

Ambiguity: Uncertainty about the appropriate probabilities or model representation.

Parameter uncertainty: Uncertainty in estimated model coefficients or inputs.

Model uncertainty: Uncertainty about the structure or assumptions of a model.

Elasticity: Dimensionless local measure of percentage output response to percentage input change.

Switching point: Input value at which two alternatives have equal value.

Break-even quantity: Activity level at which revenue or contribution exactly covers fixed cost.

Scenario probability: Assigned likelihood of a specified scenario.

Expected value: Probability-weighted average outcome.

Variance: Probability-weighted squared dispersion around an expected value.

Expected shortfall: Average loss beyond a specified tail quantile.

Regret: Loss relative to the best decision that could have been chosen after the state was known.

Maximin: Criterion that selects the alternative with the best worst-case outcome.

Robust optimization: Optimization designed to remain feasible or effective across an uncertainty set.

Chance constraint: Constraint required to hold with at least a specified probability.

Uncertainty set: Defined collection of parameter values considered plausible.

Value of information: Improvement available from obtaining information before deciding.

Distributionally robust optimization: Optimization that protects against a family of plausible probability distributions.

Review Questions

Short Answer Questions

  1. What is the difference between sensitivity analysis and scenario analysis?
  2. Why can a recommendation be stable in objective value but unstable in decision variables?
  3. Define a switching point and explain its managerial value.
  4. What assumptions are required for the normal chance-constraint capacity formula?
  5. Why might expected value be inadequate for a high-consequence decision?

Long Answer Questions

  1. Explain the distinctions among data uncertainty, parameter uncertainty, model uncertainty, and ambiguity. Give a business example of each.
  2. Compare maximin, minimax regret, expected value, and chance-constrained decision criteria.
  3. Develop a sensitivity-analysis plan for a capital investment whose demand, price, and operating cost are uncertain.
  4. Discuss how real options and staged decisions can improve a robust decision.
  5. Evaluate the ethical and governance risks of using AI-generated scenarios in resource allocation.

Analytical / Application Questions

  1. A product has price 90, variable cost 54, and fixed cost 360,000. Calculate the break-even quantity. Then calculate the quantity if variable cost rises to 60, and interpret the change.
  2. Demand is normally distributed with mean 20,000 and standard deviation 2,400. Calculate capacity required for 99% coverage using [[M:z_{0.99} = 2.326]]. State the assumptions and discuss one reason the result might be unreliable.
  3. Construct a two-alternative, three-scenario decision table with probabilities, calculate expected value and maximum regret, and explain why the preferred alternative could differ under the two criteria.

Multiple Choice Questions with Answers

Question 1

Which question is most directly addressed by sensitivity analysis?

A. What coherent future narratives are plausible?

B. How does the recommendation change when an input varies?

C. Who is legally responsible for a decision?

D. What is the historical average of an outcome?

Correct Answer: B. How does the recommendation change when an input varies?

Question 2

For Π(q) = (p − c)q − F, which condition is required for a finite positive break-even quantity?

A. p = c

B. p < c

C. p > c

D. F = 0 only

Correct Answer: C. p > c

Question 3

A switching point is the value at which:

A. A constraint becomes infeasible for every alternative

B. Two alternatives have equal value

C. Expected value equals variance

D. A probability becomes zero

Correct Answer: B. Two alternatives have equal value

Question 4

Which criterion selects the alternative with the best worst-case outcome?

A. Maximin

B. Expected value

C. Minimax regret

D. Mean-variance efficiency

Correct Answer: A. Maximin

Question 5

If an alternative has outcomes 100 and 40 with equal probabilities, its expected value is:

A. 40

B. 60

C. 70

D. 140

Correct Answer: C. 70

Question 6

In a chance constraint P[g(x,ξ) ≤ 0] ≥ 1 − α, α represents:

A. The required reliability level

B. The permitted violation probability

C. The expected objective value

D. The standard deviation of ξ

Correct Answer: B. The permitted violation probability

Question 7

If demand has mean 10,000 and standard deviation 1,500, capacity for 95% coverage under the stated normal assumption is approximately:

A. 10,247

B. 11,500

C. 12,468

D. 15,000

Correct Answer: C. 12,468

Question 8

Which statement best distinguishes a scenario from a forecast?

A. A scenario must always be more probable than a forecast

B. A scenario explores a plausible future and need not be the most likely

C. A forecast cannot use quantitative data

D. A scenario contains only one changing parameter

Correct Answer: B. A scenario explores a plausible future and need not be the most likely

Question 9

Expected value of perfect information is calculated as:

A. Worst outcome minus best outcome

B. Expected value with prior knowledge minus best current expected value

C. Variance divided by mean

D. Fixed cost divided by contribution margin

Correct Answer: B. Expected value with prior knowledge minus best current expected value

Question 10

Which is a principal risk of an excessively broad uncertainty set in robust optimization?

A. The model becomes more optimistic automatically

B. The solution may become unnecessarily conservative

C. Probabilities become perfectly calibrated

D. All constraints disappear

Correct Answer: B. The solution may become unnecessarily conservative

Prescriptive Analytics & Decision Trees
Chapter 8 of 15