Complete weak spots, write recommendation and risk statements, and name what to carry into the project.
Open the shared workbook and save your class copy with a clear name. This is your guided practice for the project — not open-ended production. You are rehearsing the structure, not inventing a new one.
Download again: unit06-lesson07-student.xlsx| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | PedalFast Dashboard | ||||
| 2 | Select Scenario | Base Case | Monthly Profit | $908 | |
| 3 | Recommended Price | $56 | Volume | 62 | |
| 4 | Break-Even Units | 36 | Risk Note | Demand below 60 bikes lowers the cushion | |
| 5 | |||||
| 6 | Scenario Summary | Price | Volume | Profit | Break-Even |
| 7 | Base Case | $56 | 62 | $908 | 36 |
| 8 | Price Hike | $64 | 50 | $900 | 29 |
| 9 | High Volume | $56 | 70 | $1,180 | 36 |
| 10 | Downside | $48 | 50 | $100 | 47 |
This dashboard shows the standard. Your project dashboard should look just as clear: one recommendation, one risk note, and scenario summary numbers that tie back to supporting sheets.
Complete these four items before class ends. Each one maps directly to a project requirement:
- Finish any incomplete sheet in the rehearsal workbook. If a sheet is partially filled, complete it so the evidence chain is unbroken.
- Check alignment. Confirm that the recommendation on the Dashboard matches the best option in PriceOptions and that the risk note is supported by Feasibility or PriceSensitivity.
- Write two statements in plain language:
Recommendation Statement
"Based on our CVP analysis, we recommend [price/option] because it produces [profit] at [volume], which is [above/below] break-even by [number] units. This is supported by the [sheet name] sheet."
Risk Statement
"Our recommendation is at risk if [specific condition, e.g., volume drops below X]. The [sheet name] sheet shows that under this scenario, profit would fall to [number]."
- Name the three features to carry into Lessons 8-10.Which structures, checks, or communication moves from today's workbook must your team recreate when you get your own business scenario?
Before class ends, be ready to answer:
What stays the same in the project?
- The seven-sheet structure
- The evidence chain logic
- The Definition of Done checklist
- The recommendation + risk statement format
What changes in the project?
- The business scenario and data
- The specific numbers and recommendations
- Less teacher scaffolding — your team owns quality
- Presentation and defense to a panel