Business Context

You’re the analytics lead at a multi-specialty outpatient healthcare provider operating 35 clinics across 6 states, with ~2.5M patient visits/year. The business has grown quickly through acquisitions and now offers multiple service lines (Primary Care, Orthopedics, Imaging, Physical Therapy, Behavioral Health, and Telehealth). Revenue is a mix of fee-for-service and value-based contracts, and margins are under pressure due to rising labor costs and payer mix shifts.

At the last board meeting, the CFO reported that company-wide EBITDA margin fell from 14% to 9% YoY, despite total revenue growing +18%. The CEO believes “some departments are subsidizing others,” but the current reporting is inconsistent: some costs are booked centrally, some at clinics, and some at service lines. Department heads are disputing the numbers, claiming shared costs (call center, scheduling, IT, rent, clinical supervisors) are being allocated unfairly.

You are asked to design a repeatable profitability analysis framework by department (e.g., clinic operations, call center, billing, corporate) and by service line (e.g., Imaging, PT, Ortho) that can be used for monthly business reviews and pricing decisions.

Metric Scenario

Stakeholders want answers to:

• Which service lines are truly profitable after allocating shared costs?
• Which departments are cost centers vs value drivers (e.g., billing improving collections)?
• What changed YoY: volume, price, payer mix, clinician productivity, denials, or cost inflation?
• What actions should be taken: renegotiate payer rates, adjust staffing, change scheduling rules, close/expand clinics, or shift marketing spend?

You have 10 business days to deliver a recommendation that will influence next quarter’s operating plan and potentially a $20M cost reduction program.

Data Available

Requirements (What you must produce)

1. Define a primary profitability KPI that works at both department and service-line levels (and explain why it’s the right KPI for this business).
2. Specify cost and revenue attribution rules:
   • Direct vs indirect costs
   • Shared services allocation (call center, rent, IT, corporate)
   • Provider compensation allocation across service lines
   • How to treat value-based contract revenue and quality bonuses
3. Provide a metric decomposition that isolates the drivers of profitability changes (volume, price/allowed rate, payer mix, denials/collections, labor productivity, fixed cost absorption).
4. Propose benchmarks/targets for “healthy” profitability by service line and what ranges would trigger intervention.
5. Recommend 3–5 actions you would take if your analysis finds (a) Imaging is high margin but capacity constrained, (b) PT is low margin with high no-shows, and (c) Billing costs rose while denial rates also increased.
6. List guardrail metrics you would monitor to ensure profitability improvements don’t harm patient access, clinical quality, or long-term retention.

Constraints:

• The CFO requires allocations to be auditable and stable month-to-month (no “black box” models).
• Department heads will challenge assumptions; you must justify trade-offs (simplicity vs precision).
• You must support drill-down by clinic, payer, provider, and CPT category.