Who This Helps
This is for Junior Analysts in the Finance Basics for Operators program. You're looking at a dashboard, see a red arrow, and need to move from 'uh oh' to 'here's why and what we do' before the next stand-up.
Mini Case
Your weekly report shows Contribution Margin dropped from 65% to 58% last week. Revenue was flat at $50,000, but Cost of Goods Sold spiked by $3,500. The old story was 'sales are good, margin is healthy.' The new story needs a root cause. Was it a supplier price hike? A shipping delay fee? A one-time quality write-off? You have 30 minutes to find out.
Do This Now (5 Steps)
- Isolate the Metric: Open your P&L or unit economics report. Don't get distracted by 10 other charts. Focus only on the one KPI that dropped.
- Grab Two Data Points: Write down the number for this week and last week. For our case: 58% now, 65% last week. That's a 7-point drop.
- Trace One Layer Deeper: What direct inputs make up that KPI? For Contribution Margin, it's Revenue and Variable Costs. Revenue was flat, so the variable costs line is your suspect.
- Ask 'What Changed?': Look at the detailed variable costs. Did one line item jump? In our case, a single material cost went up by $3,500. That's your smoking gun.
- Form Your One-Sentence Diagnosis: Instead of 'margin is down,' you now say, 'Margin dropped 7 points because our per-unit cost for Component X increased by 15%.' Boom. You've pinpointed the root cause.
Avoid These Traps
- Rabbit Hole Analysis: Don't start modeling five-year impacts. Your job is diagnosis, not a full forecast. Stay in the recent past.
- Blame Storming: Your goal is to find the what, not the who. Focus on the process or cost driver, not the person.
- Vague Conclusions: 'Higher costs' isn't a diagnosis. 'A 15% price increase from Vendor Y on July 15th' is.
- Ignoring the Obvious: Sometimes the answer is in the first place you look. Check the most volatile cost line first—it's often the culprit. It's like checking if the fridge light is on before calling an electrician.
Your Win by Friday
By Friday, you can ship a clean analysis. You'll replace a vague 'KPI alert' with a specific, one-page note. It will state the metric, the exact root cause (like identifying the weak cost line from your Unit Economics Snapshot mission), and one clear recommendation. Your stakeholder reads it in 60 seconds and knows exactly what to discuss next.