Healthcare cost analysis for finance teams

Healthcare cost analysis compares labor, supplies and overhead with the volume of services a department actually delivered. Calculate cost per unit, then flex the original budget to actual volume so higher activity does not automatically look like poor cost control.

Use department-level financial exports and aggregated service counts. The purpose is to explain operating spending, distinct from evaluating clinical effectiveness or the facility investment decision covered in healthcare cost-benefit analysis.

Define the department, period and unit

Start with one department over one closed accounting period. Specify the completed service unit and which costs belong in the comparison. An imaging procedure count is a different denominator from a rehabilitation visit count; combining both into an undifferentiated service total can conceal a mix change.

Bring the departmental ledger, payroll summary, supplies expense report, approved budget and service activity summary. Keep period, department code and cost category in each summarized export. Separate accruals and allocations from direct expenses so a reviewer can follow the calculation.

CMS describes institutional provider cost reports as containing utilization, costs and charges by cost center, plus financial statement data. That supports organizing finance analysis around defined cost centers and activity, although this internal comparison does not replace a required cost report.

Decide whether the analysis includes corporate allocations, depreciation and employer benefit costs. There is no useful cost-per-unit comparison if those boundaries change between the budget and actual columns. Document exclusions beside the worksheet rather than expecting readers to infer them.

Calculate the starting cost per unit

Cost per service unit = Department expense / Completed service units

An illustrative US imaging department planned 1,000 procedures in September 2026 and completed 1,100. Its budget assumes 1.20 labor hours per procedure at a loaded cost of $50 per hour, supplies of $20 per procedure and fixed overhead of $30,000. Actual labor is 1,300 hours at $55 per hour; actual supplies are $22 per procedure.

These are workbook assumptions, not external benchmarks. The resulting expense table is:

Budget labor is 1,000 × 1.20 × $50 = $60,000. Actual labor is 1,300 × $55 = $71,500. Supplies are 1,000 × $20 = $20,000 in budget and 1,100 × $22 = $24,200 in actual expense.

In a worksheet with budget costs in B2:B4 and actual costs in C2:C4, use:

B5 = SUM(B2:B4)
C5 = SUM(C2:C4)
D2 = C2-B2
B7 = B5/B6
C7 = C5/C6
D7 = C7-B7

Put service volumes in B6 and C6 and fill D2 down through row 6. Round displayed cost per procedure to two decimals; keep the underlying calculations unrounded. The $17,200 increase combines the cost of more procedures with changes in spending behavior.

Flex variable costs to actual activity

A flexible budget recalculates variable costs at actual volume. OpenStax's flexible-budget explanation distinguishes this comparison from holding the original activity assumption constant.

The example treats labor and supplies as variable within the department's existing capacity. Fixed overhead stays at its budgeted total. If staffing coverage is committed regardless of procedure volume, split that component out before using this approach.

For a flexible-budget column E in the first worksheet, the formulas are:

E2 = $C$6*1.20*50
E3 = $C$6*20
E4 = B4
E5 = SUM(E2:E4)
F2 = C2-E2

Fill F2 down through the total row. Positive differences mean expense is above the comparison amount. Keep that sign convention consistent throughout the workbook.

Explain the labor difference without double counting

Actual labor exceeds the flexible budget by $5,500, but the cause is not simply more labor hours. Allowed hours at actual activity are 1,100 × 1.20 = 1,320. Actual hours are 1,300, so resource use is below the allowance.

The finance team should review the rate change with payroll and the department manager. Overtime mix, agency coverage or a changed benefit allocation are questions to investigate, not conclusions established by this table. Use healthcare financial analysis when the review extends beyond department costs to overall financial performance.

Prove the total difference

The activity effect is $118,000 − $110,000 = $8,000. The spending difference is $127,200 − $118,000 = $9,200. Their sum is $17,200, exactly equal to actual cost less the original budget.

Within spending, $5,500 labor + $2,200 supplies + $1,500 overhead also equals $9,200. Tie actual expense of $127,200 to the included ledger accounts and procedure volume to the approved activity summary before assigning actions.

For inventory-related differences, cost flow analysis covers the movement between opening balances, additions and closing balances. This department comparison should use the resulting expense rather than substitute purchasing cash flows.

Where it goes wrong

• Purchases substituted for consumption. A stock build looks like higher treatment cost even when supplies remain unused.
• Fixed costs flexed with volume. Rent or committed coverage is incorrectly assumed to change with each procedure.
• Different procedure mixes ignored. A more resource-intensive mix can move unit cost without a change in efficiency.
• Allocation changes hidden. A revised corporate allocation can look like a department spending failure.
• Unclosed periods compared. Missing payroll or supplies accruals make the apparent saving temporary.

Explain your department export in Covirage

Bring a deidentified workbook with department costs, budget assumptions and aggregated service volumes. Covirage maps the columns, and its tools compute and check the cost differences; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; account creation takes about a minute.

See Covirage cost variance analysis for the supporting workflow.