Unit 6 • Lesson 40.8h
Scenario Comparison & Sensitivity Reasoning
Before building automated Excel tools, students must understand how to compare scenarios manually. This builds intuition for what Goal Seek and Data Tables will automate in Lesson 05.
What You'll Learn
- ▶Compare multiple pricing scenarios using CVP reasoning
- ▶Analyze how changes in price, volume, and costs affect profitability
- ▶Defend a pricing recommendation using contribution margin analysis
- ▶Identify which variables matter most in pricing decisions
Key Concepts
Scenario comparison using contribution margin
Sensitivity reasoning: which inputs shift break-even most
Trade-offs between pricing strategies
+1 more concepts
Lesson Phases
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Hook
Compare two pricing paths and see which one actually works.
Introduction
Build structured comparison tables to analyze multiple scenarios.
Guided Practice
Add a meaningful complication: competitor response and market constraints.
Independent Practice
Compare scenarios algorithmically with varied numbers and automatic checking.
Assessment
Exit ticket on scenario comparison and sensitivity reasoning.
Closing
Reflect on the best path forward and preview Goal Seek automation.
How You'll Learn
Concrete scenario analysis with TechStart data
Structured comparison tables showing price/volume/cost trade-offs
Manual calculation practice before Excel automation