Why this chapter matters
Leaders need to understand best case, expected case, and risk case before committing resources.
What you will learn
- Use Goal Seek to solve for required input values.
- Build one-variable and two-variable data tables for sensitivity checks.
- Compare scenarios with clear assumptions and output deltas.
Lessons in this chapter
- Goal Seek basicsBack-solve a target metric by changing one driver.
- Sensitivity tablesEvaluate output changes across parameter ranges.
- Scenario managerStore and compare assumption sets for planning discussions. Read the full guide →
- Decision framingPresent assumptions and confidence limits clearly.
Study task
Find the required sales volume to hit a quarterly profit target, then test sensitivity to price and cost changes.
Chapter checkpoint
When is Goal Seek not enough for planning?
Goal Seek handles one changing input at a time, so multi-input tradeoffs need data tables or scenario comparisons.