Summarize key takeaways and preview connections to upcoming lessons
You came into this lesson with a business mystery: how could Sarah earn more and keep less? You leave with the answer — and the tools to make sure it doesn't happen again.
🔍 Problem Diagnosis
You identified why Sarah's profit was shrinking despite growing revenue: cost-plus pricing can't adapt to business growth or competitive pressure.
🧮 Mathematical Foundation
You mastered the key distinction — markup is profit as a percentage of cost; margin is profit as a percentage of revenue. Same profit, entirely different numbers. Investors speak margin.
📊 Cost Structure Mapping
You sorted TechStart's real expenses into fixed and variable buckets and watched the break-even point respond live on the CVP chart.
⚙️ Advanced Analysis
You used Goal Seek, Data Tables, and sensitivity analysis to generate strategic pricing recommendations — the same tools professional consultants use with clients.
The markup vs. margin foundation you've built today is exactly what you'll need for Unit 6's culminating challenge: developing a data-driven pricing strategy and defending it in a Town Hall debate in front of real business stakeholders.
- • Day 3: Build comprehensive CVP models with automated Excel
- • Days 6–7: Master Goal Seek and Data Tables for what-if analysis
- • Day 8: Develop and refine your pricing recommendation
- • Day 10: Present and defend your strategy to business professionals