Hospital Intelligence Brief
How to Combine Market Data With Financial and Operational Evidence
Market data show where demand is. Financial and operational data show whether the hospital can meet it profitably. Decisions need all three.
Short answer
To combine market data with financial and operational evidence, estimate market demand and share from public data, translate expected volume into revenue and cost using internal payer and cost data, check capacity and staffing against that volume, and run scenarios. A decision is supported only when demand, economics and operations agree.[1][2][3]
Why do decisions need all three kinds of evidence?
Hospitals often make decisions on one kind of evidence. A market study shows strong demand, so a service is added without testing the economics. A financial model shows a positive margin, so a line is expanded without checking staffing. An operational plan is sound, but the market is too small. Each failure is common and avoidable. Combining the evidence forces the question each source cannot answer alone.
What does the market evidence provide?
Market evidence sizes demand, share and flow. It defines the area, using constructs such as the Dartmouth Atlas hospital service areas and referral regions,[3] counts utilization by area residents from all-payer discharge data such as HCUP and New York’s SPARCS public files,[1][2] and estimates the hospital’s share, leakage and competitors. It also reveals trends such as age mix and care-setting shifts.
Its output is a range of expected volume for the hospital under stated assumptions: for example, 300 to 500 additional cases a year within three years.
What does the financial evidence add?
Financial evidence converts volume into money. Use internal data to estimate net revenue per case by payer, based on contracts and Medicare rates; direct variable cost per case; step-fixed costs such as staffing blocks; capital; and overhead treatment. Public data cannot supply these, as explained in the article on public data and profitability. Medicare, for example, pays by diagnosis-related group using prospectively set base rates adjusted by wage index and other factors, so revenue per case is known only after applying the hospital’s own wage index and add-ons.[4]
Output: contribution per case, break-even volume and the cumulative cash requirement under each scenario.
What does the operational evidence add?
Operational evidence tests whether the hospital can deliver the volume with the quality, access and safety patients and regulators expect. It covers staffing availability and cost, beds and procedure rooms, equipment, scheduling and turnaround, supply chain and information systems. Often the binding constraint is people: if the plan needs two more anesthesiologists and none can be recruited, the volume will not materialize.
Output: a capacity plan showing when each constraint binds and what it costs to relax it.
How do you combine them?
Build a single model with three linked parts. The market part gives the volume range. The financial part converts volume into contribution. The operational part sets the maximum volume deliverable and the cost of reaching it. Then run at least three scenarios: base, downside (lower share, slower ramp, worse payer mix) and upside. Show the decision in terms of expected contribution, worst-case loss, break-even timing and the conditions that would trigger a stop or a pivot.
An invented example: market data suggest 400 recapturable cases; financial data show contribution of $3,500 per case at the expected payer mix and $1.2 million in annual step-fixed costs; operations show that a single operating room team can handle 350 cases a year. Break-even volume is 343 cases, just under capacity. The decision is marginal: a modest share shortfall eliminates profit, and a second team would be needed beyond 350 cases. The numbers are illustrative only. The interactive example below shows such a model.
Frequently asked questions
How do you combine market and financial analysis for a hospital decision?
Estimate demand and share from market data, convert volume to contribution using internal payer and cost data, test capacity and staffing, and run scenarios.
What is break-even volume?
The annual case volume at which contribution covers the step-fixed costs of the service.
Why isn’t market data enough?
It shows demand but not whether the economics or operations support serving it.
What public data support market analysis?
HCUP, SPARCS public files and the Dartmouth Atlas geography.[1][2][3]
How many scenarios should be run?
At least a base, downside and upside case.
What to do next
- Define the decision and the volume range from market data.
- Convert volume to contribution using internal payer and cost data.
- Test capacity and staffing limits.
- Run base, downside and upside scenarios and set review triggers.
Optional · interactive example
See it in an interactive example.
Hospital Market Explorer: a market dashboard comparing a five-hospital market by service category, an outmigration capture scenario, evidence-linked answers from APIS, and a sample brief, all on synthetic data.
The experience below uses a synthetic five-hospital market built to look like public discharge data. It is not New York data, or data for any real market, and every figure is illustrative. The counts are discharges, not dollars.
- Select Orthopedics. Write down what finance and operations would each need to say before you acted on the share loss.
- Ask APIS what additional information would help validate your reading.
- Generate the brief and use its “what this data cannot establish” list as the financial and operational question list.
Explore Your Hospital’s Opportunities
Two Pillars can help hospital leadership investigate market, financial, operational and strategic questions using relevant organizational data, public information and a structured assessment process. A good first step is a market scan that uses public discharge data to show where your service area’s patients go and which gaps are worth a closer look.
Sources
- Agency for Healthcare Research and Quality, HCUP-US Overview (Healthcare Cost and Utilization Project). Accessed October 2026.
- New York State Department of Health, Hospital Inpatient Discharges (SPARCS De-Identified): 2024. Accessed October 2026.
- Dartmouth Atlas of Health Care, Glossary. Accessed October 2026.
- Centers for Medicare & Medicaid Services, Acute Inpatient PPS. Accessed October 2026.
Sources checked October 2026. This guide is general information for healthcare leaders and is not legal, financial, clinical or compliance advice. Figures and rules are cited to the sources below and may have changed since they were accessed, so confirm anything you rely on against the current source. Two Pillars & Co is independent of the organizations cited. See our editorial policy.
