Business Problem — Financial Performance Analysis¶
Company Context¶
Meridian Manufacturing is a mid-size company selling products across multiple segments, countries, and product lines. Annual revenue is around $100M. The finance team produces monthly board reports manually — pulling data from the ERP, building P&L statements in Excel, and calculating variances by hand. It takes 5 days every month-end and is error-prone.
The problem: The CFO wants three things: (1) automate the monthly P&L so it's ready on day 1, not day 5; (2) understand which products and segments actually drive profit (not just revenue); (3) get early warning when actuals diverge from budget, so course-correction happens mid-quarter, not after.
You've been asked to build the financial analytics layer.
Financial Concepts You'll Use¶
| Term | Definition | Formula |
|---|---|---|
| Revenue | Total sales income | Sum of sales |
| COGS | Cost of Goods Sold | Direct cost of products sold |
| Gross Profit | Revenue minus COGS | Revenue − COGS |
| Gross Margin % | Profitability before overhead | Gross Profit / Revenue |
| Operating Profit | After operating expenses | Gross Profit − OpEx |
| Net Profit | Bottom line | Operating Profit − tax, interest |
| Variance | Actual vs Budget difference | Actual − Budget |
| Variance % | Relative variance | (Actual − Budget) / Budget |
Business Questions to Answer¶
Q1 — P&L and Profitability¶
- What is total revenue, COGS, gross profit, and gross margin?
- How do these trend month over month and year over year?
- Which products/segments have the best and worst margins?
Q2 — Segment and Product Analysis¶
- Which business segment generates the most profit (not just revenue)?
- Which products are high-revenue but low-margin (volume traps)?
- Which countries/regions are most profitable?
Q3 — Budget vs Actual¶
- How do actuals compare to budget by month and segment?
- Where are the biggest unfavourable variances?
- Is the company on track to hit annual targets?
Q4 — Discount and Pricing¶
- How much revenue is given away in discounts?
- Do discounts vary inappropriately by segment?
Q5 — Forecasting¶
- Based on current trends, what's the projected year-end result?
Success Metrics¶
| Metric | Current | Target |
|---|---|---|
| Time to produce monthly P&L | 5 days | < 1 day |
| Reporting errors | Occasional manual errors | Automated, validated |
| Variance visibility | Month-end only | Real-time |
| Margin insight | Revenue-focused | Profit-focused |
Stakeholders¶
| Stakeholder | Cares about |
|---|---|
| CFO | Overall financial health, board reporting |
| FP&A Team | Budget variance, forecasting |
| Segment Leaders | Their P&L and margin |
| CEO | Profit trajectory vs plan |