Lesson ProgressPhase 5 of 6
Phase 5Assessment
Assessment: Build the Scenario-Switch Dashboard
Technical check plus recommendation memo using workbook evidence
Phase 5: Audit and Explain
Technical Check and Method Recommendation
Prove you can audit the selector chain and defend a recommendation using KPI evidence from your workbook.
Part A: Technical Comprehension Check
Scenario Switch and KPI Logic
Answer to show selector, lookup, and interpretation accuracy.
1. Which formula pattern best selects COGS for the currently selected scenario and method?
2. Why is SelectedKey built as Scenario + "|" + Method?
3. Which turnover formula is correct for this workbook?
4. What should happen to Days on Hand when turnover increases, assuming the period length is fixed?
5. What is the first trust check before discussing a recommendation?
0 of 5 questions answered
Part B: Recommendation Memo
Write 4-6 sentences recommending one scenario+method pair for Sarah's investor meeting.
Memo Structure
- Claim: Name your selected scenario and method.
- Evidence: Cite exact COGS, ending inventory, and one KPI from your workbook.
- Comparison: Compare against at least one alternative method.
- Risk: State one limitation of your chosen method.
- Decision fit: Explain why this choice matches the investor question.
Strong memo checklist:
- Uses exact workbook numbers.
- References one trust check result.
- Connects method choice to turnover and days-on-hand impact.