Clinic cost simulator: from aggregate P&L to margin per service and payer mix
In ambulatory clinics and medical groups across the US, UK and Canada — dental, specialty, imaging, dialysis, rehab, med-spa — most directors operate with an aggregate income statement that shows revenue, supply cost and payroll, but without decomposing margin by service, provider and payer type. The classic result: the clinic grows in revenue but net margin erodes, because profitable services silently subsidize services running below break-even.
A serious cost simulator integrates three operational frameworks on one screen:
Contribution margin per service = Price − Direct variable costs Break-even point (services/month) = Monthly fixed costs / Average contribution margin Payer mix contribution = Σ (volume × effective rate × collection probability) by payer type
Fixed vs variable cost structure
First distinction: separate fixed costs (rent, leased equipment, base salary of permanent administrative and technical staff, licenses, insurance, EHR) from direct variable costs (supplies per procedure, professional fees when billed per service, regulated waste disposal, clinical laundry, proportional sterilization). A dental clinic in the US typically runs 55% fixed / 45% variable; diagnostic imaging can hit 70% fixed because of equipment leasing; a med-spa paying clinicians per service can drop fixed to 35%.
Worked example — specialty clinic with 12 exam rooms
Mid-size multispecialty clinic in a US Sun Belt metro with 12 exam rooms and four procedure rooms, monthly revenue of $1.2M, monthly fixed cost of $620K and variable cost averaging 32% of revenue. Contribution margin = $1.2M − ($1.2M × 0.32) = $816K. Break-even = $620K / 0.68 = $912K monthly. Running 24% above break-even, seemingly healthy.
Decomposing by service exposes three silent subsidies: clinical nutrition runs 18% over break-even, cardiology 42% over, but a low-volume spirometry service runs 12% below break-even, absorbing a monthly hidden subsidy of $26K from the rest of the center. Three commercial insurance contracts pay 35% below cash rate with actual collection of 74% at 90 days — an effective rate that turns those patients into margin dilution in the payer mix. The simulator surfaces what the aggregate P&L obscures.
Payer mix: Medicare, Medicaid, commercial, direct pay
In US ambulatory, payer mix defines profitability. Medicare and Medicaid rates sit 25-45% below commercial contracts with collection rates of 85-95% at 30-60 days. Commercial insurers pay 85-100% of cash rate but with denials, pre-authorizations and coinsurance that complicate cash flow. Direct-pay cash patients pay full rate but typically represent 15-35% of volume. Without decomposing margin by payer type, the clinic cannot renegotiate contracts, repackage service bundles or shift mix to defend operating margin.
Capitation vs fee-for-service vs DRG
Fee-for-service pays per billed service — dominant model in US commercial. Capitation pays a fixed per-member-per-month amount regardless of utilization — common in Medicare Advantage risk arrangements. DRG (Diagnosis-Related Group) pays a fixed amount per admission diagnosis and shifts overuse risk to the provider — Medicare inpatient standard. Each model demands different cost accounting: FFS prioritizes per-service margin; capitation prioritizes utilization management; DRG prioritizes supply control and LOS. The simulator models all three and evaluates the impact of a partial FFS→capitation migration in a major contract.
Reimbursement rate and denials
Contracted rate with payers is rarely the effective collected rate. Denials (rejections for ICD-10 coding, missing documentation, authorization, coinsurance) reduce recovery 8-20% per AHA RCM benchmarks. Clinics with mature coding and submission processes hold denials below 5% with 60-75% recovery on appeal. Clinics with weak RCM lose 15-20% of theoretical revenue without noticing because the admin report doesn't surface it at granularity. A simulator that integrates denial rate and appeal-recovery probability computes a weighted effective rate that completely changes the read on per-contract profitability.
Installed vs utilized capacity
An exam room with 22 operating days per month × 8 hours × 2 visits per hour = 352 potential slots. If the room books 240 and attends 200, real utilized capacity is 57%. The room's fixed costs (rent, depreciation, permanent staff) spread across 200 patients, inflating unit cost 75% above the optimal base. Best-in-class clinics aligned to MGMA (Medical Group Management Association) benchmarks run utilized capacity above 78%. The simulator surfaces the installed-vs-utilized gap per exam room and translates that gap into recoverable margin without CapEx.
Differentiation from the accounting P&L
The accounting P&L reports aggregate monthly numbers. It does not decompose margin by service, does not cross contract against volume and effective rate, does not translate an unbooked exam-room hour into lost contribution dollars, and does not simulate the impact of a rate adjustment or payer-mix shift before rollout. The simulator closes that gap and produces decisions with quantitative evidence: which service to expand, which to renegotiate, which to discontinue, which contract is worth the paper and which needs a hard reset with the insurer.
For the physician-owner, the practice administrator and the CFO, the tool turns a dozen scattered spreadsheets into a consolidated view of real profitability that the leadership committee can act on in the same session — without waiting for the quarterly report from the outside accountant or scoping a six-month engagement with a healthcare operations consultancy.
Worked example — general practice clinic with 12 physicians and $MXN 8M monthly revenue
Consider a multispecialty clinic in Mexico City with 12 physicians (6 general practitioners, 3 specialists on retainer, 3 part-time), generating MXN 8,000,000 monthly (approximately $400,000 USD). Fixed costs: rent MXN 480,000 (6%), base payroll for administrative and nursing staff MXN 1,600,000 (20%), EHR and billing platform MXN 96,000, insurance and licenses MXN 120,000, utilities MXN 240,000. Total fixed: MXN 2,536,000 (31.7% of revenue). Variable costs: physician fees (per-service model averaging 35% of each professional service billed), medical supplies 8%, regulated waste disposal 1.5%. Effective contribution margin = 100% - 35% physician fees - 8% supplies - 1.5% waste = 55.5%. Break-even = MXN 2,536,000 / 0.555 = MXN 4,570,270 per month — well below the MXN 8M actual revenue, leaving a 43% cushion. But this aggregate view hides two services operating below break-even at their current volume and pricing, subsiding the rest.
EHR and telemedicine cost-benefit in 2026
Electronic Health Record adoption in Mexico reached 48% of private clinics in 2024 (CENETEC estimate), versus 96% in US physician practices (ONC 2024 Health IT Report). The cost of a clinic-grade EHR (Doctoralia Pro, Nuvita, Medicarechile, or international platforms like Athenahealth for US-billing clinics) runs MXN 3,000-12,000/month per physician, with ROI from three measurable levers: reduced no-show via automated reminders (30-50% reduction), faster insurance claim submission (denial cycle from 45 to 14 days), and 15-20% administrative time recovered per provider. Telemedicine integration adds $20-60 USD per teleconsult in ARPU without consuming physical exam-room capacity — a near-pure margin add on existing patient relationships. The simulator separates in-person from teleconsult contribution margins and projects the EBITDA impact of a telemedicine ramp at defined weekly volume targets.
Claim denial rate and its hidden revenue impact
For clinics billing commercial insurance or IMSS complementary, denial rate is the metric that most consistently destroys theoretical revenue without appearing explicitly in the income statement. AHA RCM benchmarks for US ambulatory: 8-20% of claims submitted receive an initial denial. In Mexico's mixed billing environment (IMSS, Axa Salud, BUPA Mexico, Metlife, direct pay), denial occurs through different mechanisms — incorrect coding, expired insurance card, missing pre-authorization — but the impact is the same: revenue captured in accounts receivable that may never convert to cash without active follow-up. A clinic with MXN 8M monthly billing and a 14% denial rate is generating a theoretical receivable of MXN 1.12M/month that it will actually collect at 55% after appeals, netting MXN 616,000 in real cash — not the full MXN 1.12M the billing system shows.
Scaling to a second location: the cost structure inflection
Opening a second location does not double revenue and does not halve per-patient fixed cost — it creates a J-curve of 8-18 months of elevated opex before the new site reaches utilization break-even. The fixed costs of a second location (new lease, build-out amortization, minimum staff before patient volume justifies it) are committed from day one; revenue ramps over 12-24 months. The simulator models the cash requirement, break-even month and incremental EBITDA for a second-location decision using current clinic cost structure as the base — a materially different analysis than the informal 'if we do the same revenue with two clinics we earn double' logic most physician-owners apply.
Common mistakes in clinic cost management
- Ignoring claim denial rate in the revenue model. A 15% denial rate on insurance billing reduces effective revenue 6-9% below what the billing system shows.
- Under-pricing the concierge or direct-pay tier. Concierge services can carry 60-75% contribution margin — far above the 55% average — but are chronically under-priced at clinics that use insurance reimbursement rates as their reference.
- Treating physician compensation as fixed when it is partially variable. Clinics that pay specialists a fixed retainer regardless of consultations absorb demand risk on the physician fee; per-service or hybrid models transfer part of that risk to the physician.
- No utilization report by exam room. An under-utilized exam room at 45% capacity bears the same rent as one at 85%. Identifying low-utilization rooms and converting them to high-demand specialties or telemedicine suites is pure margin recovery.