Lesson ProgressPhase 3 of 6
Phase 3Guided Practice
Guided Practice: Project Rehearsal: Shared Workbook, Evidence Chain, and Quality Standard
Trace the recommendation from Dashboard back to CostSetup using guided audit routines.
🛠️ Phase 3: Guided Practice
Trace the Recommendation Back to Evidence
A strong project workbook is not just a dashboard. It is a chain of evidence. In guided practice, trace the recommendation from the final dashboard all the way back to the cost totals and analysis sheets.
- Check the fixed and variable totals on CostSetup.
- Use those totals to interpret PriceOptions and Feasibility.
- Use TargetProfit, PriceSensitivity, and ProfitMatrix to test the recommendation.
- Confirm that the Dashboard says the same thing as the supporting sheets.
Preview 1 - Cost Setup and Assumptions
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | CostSetup | Project Assumptions | Value | ||
| 2 | Service van lease | 520 | Fixed | Fixed Costs Total | 1200 |
| 3 | Business insurance | 160 | Fixed | Variable Cost per Unit | 22 |
| 4 | Replacement parts kit | 10 | Variable | Monthly Capacity | 80 |
| 5 | Travel fuel | 4 | Variable | Target Profit | 850 |
| 6 | Payment processing | 2 | Variable | Base Price | 56 |
| 7 | |||||
| 8 | |||||
| 9 | |||||
| 10 |
Preview 2 - What the Final Dashboard Should Reveal
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Dashboard | |||
| 2 | Recommended Option | Commuter Care | ||
| 3 | Recommended Price | $56 | Forecast Units | 62 |
| 4 | Projected Profit | $908 | Break-Even Units | 36 |
| 5 | Risk Note | Demand below 60 bikes reduces the cushion quickly. | ||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 |
Guided Audit Routine
- Ask: What does the dashboard recommend?
- Find the exact numbers that support it.
- Name one sheet that proves the upside and one sheet that reveals the risk.
- Circle anything that looks confusing, hidden, or unsupported.
Turn and Talk
- If the dashboard says “Commuter Care,” which earlier sheet should convince you that choice is reasonable?
- What would make the dashboard recommendation feel untrustworthy?
- What part of this structure should every group copy into the project?