Basil & Co: Profits Down Despite Flat Revenue

Consulting
medium45 min0 submissions
Flipkart
Scenario

Basil & Co is a quick service restaurants business in India. The CEO has asked for help understanding a sharp fall in profitability.

Revenue moved from ₹656 Cr to ₹676 Cr over the past year, while operating margin fell from 15% to 12% — a drop of 3 percentage points and roughly ₹17 Cr of operating profit.

What the finance team has established so far:

  • Sales volume changed by -4%
  • Average realised price changed by -1%
  • Input costs per unit rose 11%
  • Fixed overhead rose 13%

The COO believes the problem is "the sales team discounting too aggressively". The Head of Sales believes it is "procurement failing to control input costs". The CEO wants an evidence-based answer, not an argument.

Supporting data

drivers

volume change pct
-4
fixed overhead change pct
13
realised price change pct
-1
input cost per unit change pct
11

profit bridge

revenue last year cr
656
revenue this year cr
676
operating margin last pct
15
operating margin this pct
12
Your task

Diagnose the profit decline and recommend a response. Provide:

  1. Analysis — structure the problem and isolate what actually drove the margin fall.
  2. Risks — what your recommendation depends on.
  3. Recommendation — prioritised actions with expected impact.

Show the arithmetic behind your conclusion.

Ready to move forward? Up next: Vantage Analytics: Trial-to-paid conversion Dropped 23%Next question
How you'll be graded

100 points, 60% to pass.

  • root cause25
  • recommendation25
  • problem structuring25
  • quantitative analysis25
Hint
Reveal suggested structure

Profit = (Price × Volume) − (Variable cost × Volume) − Fixed cost

  1. Decompose the change: how much of the margin fall is price, how much volume, how much unit cost, how much overhead?
  2. Size each driver before forming a hypothesis.
  3. Test the two stakeholder claims against the numbers.
  4. Prioritise by size of impact and speed of fix.