Map procedure profitability per provider to slot and price

Map procedure profitability per provider to slot and price

A practice that does not map procedure profitability per provider runs its schedule and price list by habit: providers get whatever procedures walk into their day, and the fee schedule is uniform even when provider speed and material costs vary. The result is predictable: high-cost, low-margin procedures get booked into prime slots and low-cost, high-margin work sits in off hours. This guide gives the math to calculate margin-per-procedure and profit-per-minute for each provider, a simple template for a provider×procedure profitability matrix, and three immediate schedule and pricing changes you can implement next week.

What you need from your systems before you start

• Fee schedule and average realized payment per procedure (actual collections, not charges).
• Expected payer adjustments and write-off rates by procedure or payer mix.
• Direct costs per procedure: lab fees, outsourced work, implant components, and materials.
• Provider time per procedure: scheduled chair minutes averaged over last 90 days.
• Staff time costs tied to the appointment (assistant, hygienist, lab tech) as hourly rates.
• Overhead allocation method (hourly overhead cost = monthly overhead / available chair hours).
• Historical claim rework or resubmission time where it affects net collections.

How to calculate margin per procedure for each provider

Turn raw inputs into three operational metrics: net revenue per procedure, direct cost per procedure, and profit per minute. Do these calculations per provider because provider speed and write-off patterns differ.

Step 1 — Net revenue per procedure (use realized collections)

Net revenue = average collected amount for that procedure after payer adjustments and write-offs. Use at least 90 days of data. If collections vary by payer, calculate a weighted average by payer mix for that procedure.

Step 2 — Direct cost per procedure

Direct cost = lab fee + consumables + any component costs tied to the case. Do not include general overhead or allocated staff costs here. For example, a crown might have a lab cost of $150 and consumables of $12 — those are direct costs.

Step 3 — Appointment-time cost (staff + overhead) and profit-per-minute

Appointment-time cost = (provider hourly cost + allocated assistant/tech/hygiene costs + overhead per chair-hour) × appointment minutes / 60. Provider hourly cost can be salary/hour for associates or a target compensation rate for owners. Overhead per chair-hour = monthly overhead ÷ available chair hours that month. Profit-per-minute formula (per provider, per procedure): Profit-per-minute = (Net revenue − Direct cost − Appointment-time cost) ÷ Scheduled minutes for the procedure. Margin-per-procedure = Net revenue − Direct cost − Appointment-time cost (this is the per-procedure dollar profit).

Use scheduled minutes rather than actual minutes for planning so that slotting and capacity assumptions remain consistent.

Build the provider×procedure profitability matrix

Create a table with providers as rows and common procedures as columns. For each cell include three fields: margin-per-procedure (dollars), profit-per-minute (dollars/minute), and scheduled minutes. Sort and color-code cells so it’s obvious which are high, moderate, and low margin for each provider.

1. Export or pull the inputs listed earlier for each provider and procedure for a fixed period (90 days recommended).
2. Calculate the three metrics per cell: net revenue, direct cost, appointment-time cost, and then margin and profit-per-minute.
3. Flag cells where margin-per-procedure is negative, or profit-per-minute is below a low threshold. (Illustrative thresholds: <$0 margin or <$2/min are worth reviewing; mark these as illustrative in your first run.)
4. Identify the top 20% and bottom 20% of procedure cells by profit-per-minute for each provider.

Why profit-per-minute matters more than list price

Two procedures with identical fee schedules can yield very different margin profiles when one takes twice as long or requires an expensive lab. Profit-per-minute converts time and money into a single operational metric you can act on when scheduling and setting prices.

Three concrete changes to improve margin next week

• Reslot prime provider time for high profit-per-minute procedures: Reserve morning prime slots for the provider-procedure cells in the top 20% by profit-per-minute. Move low-margin, long procedures to dedicated half-days or to less expensive chair-hours. This increases daily margin without changing production targets.
• Adjust provider-specific pricing or add a speed/complexity modifier: Where a provider consistently delivers a procedure faster and cleaner (higher profit-per-minute), consider a targeted fee adjustment or an internal pricing modifier to reflect realized value. Conversely, for providers where a procedure runs long and margins are routinely low, set scheduling rules that avoid booking those procedures in peak times.
• Target training and task redistribution to raise profit-per-minute: Focus training on the bottom 20% cells for each provider to reduce chair time or reduce rework. Where possible, move preparatory or administrative steps out of chair time (pre-visit planning, delegated chart work). Track the before/after minutes and margin for 60 days to measure impact.

A fourth operational action: use the matrix to triage open slots by recovery value. When you have last-minute openings, fill them with procedures and providers that maximize profit-per-minute rather than simply filling the schedule. See the workflow in "triage-open-slots-recovery-value-maximize-revenue" for practical steps.

How to operationalize the matrix in daily work

Turn the matrix into rules and reports the team uses every day: - Weekly provider×procedure runbook: publish the matrix and highlight top/bottom 20% cells. - Scheduling rules: block templates and provider permissions so front-desk staff can see which procedures are allowed in which slots. - Morning huddle metrics: include profit-per-minute trends and any slots flagged for immediate rebooking. Use the structure in "daily-morning-huddle-metrics-prioritize-today-s-revenue-tasks" to keep discussion focused.

Start with weekly cadence. After two cycles of adjustments you can move to daily signals for last-minute fills using the methods in "How to Convert Last-Minute Openings into Booked Revenue" (see slug: convert-last-minute-openings-booked-revenue).

What to monitor and when to revisit pricing

Track these KPIs weekly and review monthly: - Average profit-per-minute per provider. - Percentage of procedures in top 20% and bottom 20% buckets. - Chair utilization (hours scheduled / available hours) by provider. - Change in rework or claim re-submission time for affected procedures. If a fee adjustment is considered, re-run the matrix after 30 days of the new price to see whether net revenue and profit-per-minute moved as expected. If collections patterns shift (payer denials, increased write-offs), the matrix will show it quickly and suggest whether further pricing or process changes are needed. For more on triaging claims and expected recovery, see "prioritize-denied-claim-resubmissions-expected-recovery" and "prioritize-denied-claims-expected-recovery-prioritize-appeals".

Common objections and how to answer them

• "But we can’t change provider fees easily." — Start with schedule rules and slot assignments; pricing changes are a second step once you have evidence from the matrix.
• "Our overhead allocation is approximate." — Use the same overhead method consistently so trends are visible even if absolute numbers are estimates.
• "Quality concerns block speed improvements." — Track rework and patient satisfaction alongside profit-per-minute. The goal is higher margin with quality preserved, not speed for its own sake.

Map procedure profitability per provider — summary checklist

1. Pull 90 days of realized collections, direct costs, and scheduled minutes by provider and procedure.
2. Calculate net revenue, direct cost, appointment-time cost, margin-per-procedure, and profit-per-minute.
3. Build a sortable provider×procedure matrix and flag top/bottom 20% cells.
4. Apply the three schedule/pricing changes and monitor weekly KPIs for 60 days.