Post acute care analytics: volume, cost and performance

Post acute care analytics compares service volume, cost and capacity across facilities using operational exports with consistent definitions. For a business review, separate calendar-period activity from completed-stay measures, then reconcile both before interpreting the differences.

The useful question is specific: which facility needs an explanation of its spending, available capacity or activity change? A facility comparison can identify that question without making patient recommendations or treating an operational ratio as evidence of care quality.

Define a comparable service before calculating

Post-acute operations include different settings, so choose the service being compared first. This example covers residential skilled nursing operations at an illustrative US provider. It does not combine residential patient days with home health visits or use either as a clinical performance score.

CMS cost reports include facility characteristics, utilization, costs and charges by cost center, and financial statement information. Those categories provide useful context for an internal business review, although a monthly management workbook is not itself a Medicare cost report.

Agree on the facilities, reporting dates, service units and cost centers included. Define whether operating cost includes agency staffing, allocated administration, facility expense and depreciation. Use the same policy for every facility, and retain separate lines for excluded costs so finance can reconcile the scope.

For service questions in a nonclinical support operation, customer care analytics uses different outcome measures. Keep those definitions separate from residential utilization and facility spending.

Bring the exports that answer each question

Use an operational file with facility code, service date and counted patient days, plus an available-bed schedule for the same dates. Obtain a completed-stay summary with facility, discharge period, completed stays and the full counted days attached to those completed stays. Finance supplies operating costs by facility and period.

The review needs aggregate counts and amounts. Prepare the business summary without names, clinical narratives or individual treatment details. Establish consistent treatment of same-day stays, transfers and temporary absences in the source reports before comparing totals.

Each file has a different purpose. The daily activity export supports monthly utilization and cost per day. The completed-stay file supports average length of stay for the discharge cohort. Combining the two without preserving their definitions creates a plausible-looking ratio that answers neither question correctly.

Work the facility comparison from the supplied rows

The following invented business example covers September 2026. Cedar has 30 available beds throughout the 30-day month, giving 900 available bed days; Maple has 50, giving 1,500. All costs are in USD and use the same operating-cost policy.

Average completed-stay length = Full days in completed stays / Completed stays

Occupancy = Calendar-period patient days / Available bed days

Operating cost per patient day = Calendar-period operating cost / Calendar-period patient days

Cedar's completed-stay length is 600 / 40 = 15.0 days. Its occupancy is 720 / 900 = 80.0%, and its cost per patient day is 216,000 / 720 = $300.00. Maple's corresponding calculations are 1,200 / 60 = 20.0 days, 1,350 / 1,500 = 90.0%, and 472,500 / 1,350 = $350.00.

Display days and percentages to one decimal place and unit costs to two decimals. Calculate from unrounded inputs: combined occupancy is 2,070 / 2,400 = 86.25% before rounding, while combined unit cost is 688,500 / 2,070 = $332.61 after rounding.

Prove the totals with the right weights

The combined completed-stay length is 1,800 / 100 = 18.0 days. The simple average, (15.0 + 20.0) / 2 = 17.5 days, gives the smaller Cedar discharge cohort the same weight as Maple and understates the combined result.

For a spreadsheet with the first input table in columns A through F, enter completed-stay length in G2 as =C2/B2, occupancy in H2 as =D2/E2, and cost per patient day in I2 as =F2/D2. Fill through row 3. The weighted checks are:

=SUMPRODUCT(B2:B3,G2:G3)/SUM(B2:B3)
=SUMPRODUCT(E2:E3,H2:H3)/SUM(E2:E3)
=SUMPRODUCT(D2:D3,I2:I3)/SUM(D2:D3)

Microsoft's SUMPRODUCT documentation explains the corresponding-range multiplication used by these Excel checks. They must reproduce the ratios of the original totals when calculated using unrounded cells. Covirage is not affiliated with Microsoft.

Keep separate checks for each source. The available-bed schedule must rebuild 2,400 available bed days, the daily activity export must rebuild 2,070 patient days, and the finance export must rebuild $688,500 of included operating cost. A weighted identity confirms the arithmetic; it does not prove that the source reports are complete.

Reconcile movement and assign the investigation

Use the census movement report as another operational check. In this example, admissions and discharges include the defined facility movements; there are no additional movement categories.

Opening census plus admissions minus discharges must equal closing census: 69 + 100 − 100 = 69. Tie the detailed daily counts to the activity export as well; matching opening and closing census alone does not verify all days between them.

The facility administrator owns the operational explanation, while finance owns cost reconciliation and reporting staff own the counted-day definitions. Maple's longer completed stays and higher cost per day justify investigating service mix, staffing cost and accounting scope. They do not prove inefficiency or justify changing anyone's care.

Use healthcare contribution margin if the next business question concerns revenue less defined costs. Use capacity utilization for the general capacity calculation; neither replaces the facility-specific definitions above.

Where it goes wrong

• Different populations in one ratio. Monthly patient days divided by completed stays are not completed-stay length.
• Unweighted averages. Each measure needs its own denominator: completed stays, available bed days or patient days.
• Different cost scopes. Central allocations at one facility and direct costs alone at another distort the comparison.
• Missing capacity changes. Bed closures or openings change available bed days even when licensed capacity stays constant.
• Clinical conclusions from business totals. Higher occupancy or lower cost does not establish an appropriate clinical decision or care outcome.

Review your own facility exports in Covirage

Upload aggregate facility activity, completed-stay and operating-cost files; Covirage maps the columns, and its tools compute and check the agreed comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for healthcare teams for the supporting business context.