Blog · Board and management reporting · Healthcare
Business intelligence in healthcare compares aggregate operating costs and activity across facilities. Work a facility example, reconcile the source totals, and separate cost changes from changes in activity.
Business intelligence in the healthcare industry helps operating leaders compare aggregate facility costs and activity on a consistent basis. It shows where spending changed, whether activity moved with it, and which differences need investigation before a manager changes a budget or capacity plan.
A useful question is: which comparable facilities account for the change in operating cost per completed visit? It requires cost and activity together. A facility can spend more while its cost per visit falls, or stay within budget while activity declines.
The CMS cost-report overview describes reports containing utilization, costs and charges by cost center, and financial statement information. That distinction matters for internal reporting too: activity, cost, and billed amounts answer different questions.
Use approved facility summaries containing aggregate operating information. No patient records, names, encounter identifiers, or clinical details are needed for this comparison. The business question concerns spending and completed activity, and the files should match that scope.
Finance owns the account definitions, accruals, and allocations. Facility operations owns the activity count and explains changes in hours, services, and capacity use. For broader context, see AI analytics for healthcare; this article stays with the arithmetic of operating comparisons.
For this analysis, include labor, purchased supplies and services, and allocated facility overhead. Document the treatment of depreciation, lease expense, and central support before comparing periods. Keep the same scope in the budget and actuals.
Cost is not the amount billed. AHRQ distinguishes hospital charges from resource costs: charges are billed amounts, while costs reflect expenses such as wages, supplies, and utilities. For a company operating-cost comparison, start with the approved expense summary rather than replacing expenses with charges.
Choose an activity unit that the facilities count consistently. The example below uses completed outpatient visits at facilities offering a comparable service mix. Scheduled appointments, canceled visits, and completed visits must not be mixed in one denominator.
Cost per completed visit = Included operating costs / Completed visits
Cost variance = Actual operating costs − Planned operating costs
A higher cost per visit identifies a change to explain. It does not show clinical quality, the appropriateness of care, or the cost of treating a particular person. Separate comparisons by service group when the mix makes a combined rate misleading.
Consider a fictional US outpatient group reporting the same closed month across comparable facilities. The first table provides its approved plan, aggregate completed visits, and actual expense categories. All costs are USD.
| Facility | Plan visits | Actual visits | Plan costs (USD) | Actual labor (USD) | Actual supplies and services (USD) | Actual overhead (USD) |
|---|---|---|---|---|---|---|
| Midtown | 6,000 | 6,600 | 720,000 | 500,000 | 180,000 | 100,000 |
| Riverside | 4,000 | 3,600 | 480,000 | 310,000 | 100,000 | 70,000 |
| Lakeside | 5,000 | 5,000 | 600,000 | 380,000 | 140,000 | 100,000 |
| Total | 15,000 | 15,200 | 1,800,000 | 1,190,000 | 420,000 | 270,000 |
Add the actual expense categories, then divide each facility's planned and actual costs by their corresponding visit counts:
| Facility | Actual costs (USD) | Cost variance (USD) | Plan cost per visit (USD) | Actual cost per visit (USD) |
|---|---|---|---|---|
| Midtown | 780,000 | 60,000 | 120.00 | 118.18 |
| Riverside | 480,000 | 0 | 120.00 | 133.33 |
| Lakeside | 620,000 | 20,000 | 120.00 | 124.00 |
| Total | 1,880,000 | 80,000 | 120.00 | 123.68 |
Midtown's cost is above plan, but it handled more visits and its cost per visit is lower. Riverside meets its cost budget, yet fewer visits spread the same expense over less activity. Lakeside has unchanged activity and higher costs, making its spending categories the immediate question.
The total rate is 1,880,000 / 15,200 = $123.68, rounded to cents. Compare that with the planned rate of 1,800,000 / 15,000 = $120.00. Total cost is $80,000 above plan while visits are 200 above plan; neither fact alone explains the facility differences.
The ratio must use total expenses divided by total visits. Averaging the displayed facility rates would give each location equal weight regardless of its activity. Business intelligence charts covers how to present comparisons once these measures are settled.
The expense categories must satisfy this identity:
1,190,000 + 420,000 + 270,000 = 1,880,000
780,000 + 480,000 + 620,000 = 1,880,000
Match that amount to the ledger control total for the included facilities and accounts. Match the visit total to the aggregate activity report. Confirm that both files use the same period and facility boundaries, and retain any unresolved facility codes as exceptions.
Check allocations separately. The overhead charged to facilities must equal the included overhead pool, without also retaining the same central expenses in the total. Late invoices and payroll accruals require consistent treatment across facilities.
A simple Riverside variation illustrates the denominator effect: hold its cost at $480,000 and change completed visits from 3,600 to the planned 4,000. Its rate becomes 480,000 / 4,000 = $120.00. That explains how volume affects the ratio; it is not a forecast that every additional visit has no incremental cost.
Finance should ask Lakeside's owner which expense categories changed and whether timing explains them. Riverside's operating manager should examine the activity shortfall and available capacity. Midtown's manager should confirm that its lower rate reflects a comparable service mix and complete expenses.
Document the action, owner, and evidence needed before changing spending. A facility summary can point to contract costs, staffing patterns, or unused capacity; it cannot establish the cause without follow-up. Keep healthcare BI tool selection separate from the measure definitions, and consult automated business intelligence when considering a repeatable monthly review.
Bring a sample of your own approved aggregate expense and activity summaries in a file; Covirage maps the columns, and its tools compute the rates and check the totals. The external AI model explains the comparisons with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your facility summary.
See Covirage for healthcare for supporting context.
Healthcare operating teams use it to compare facility costs, activity, and performance against plan. Aggregate finance and activity summaries can show where spending changed or capacity needs review. These operating measures do not establish clinical quality or determine individual care.
Divide the included operating costs for a facility and period by completed visits for that same scope and period. Define both inputs first. A combined rate uses total included costs divided by total visits, rather than an average of facility rates.
Only when the activity units and included services are sufficiently comparable. Differences in service mix, staffing requirements, operating hours, and shared-cost allocation can explain different rates. Use the measure to identify a question for investigation rather than declare one facility inefficient.
Start with a facility-level expense summary, an approved budget, and aggregate completed-activity counts. Include the period, facility code, cost categories, and activity definition. Use approved summaries without patient records, individual identifiers, or clinical details.