Blog · Forecast and pipeline · Healthcare
Update healthcare operating forecasts with department volumes, net revenue assumptions and staffing costs. A worked comparison of forecast versions separates volume, reimbursement yield, labor intensity and hourly cost changes.
Rolling forecasting in healthcare updates expected service volumes, net revenue and operating costs as each month closes. Replace the closed period with actuals, extend the horizon and revise the remaining assumptions by department. Compare the same future months across forecast versions so a change in the calendar does not masquerade as a change in performance.
Keep three distinct views: approved budget, issued forecast and actual results. The rolling-forecast glossary explains the generic approach; the healthcare work is choosing service and staffing drivers that reflect each department's operation.
After close, finance should reconcile actual revenue and expense totals to the ledger before updating expectations. Department managers then review activity, staffing and operational constraints. Revenue-cycle staff review net revenue assumptions and adjustments. Finance records the approved assumptions and issues the next version without overwriting the previous one.
Give every forecast row a version date, service month, department, service group, volume unit and reporting basis. If the old version includes a month that has now closed and the new version adds a later month, compare only their overlapping future months when explaining revisions.
Use budget vs forecast for the separate question of accountability to the original budget. An updated expectation should not erase that benchmark.
Start with a department activity export, revenue summary and payroll or staffing-cost export. Aggregate them to department, service group and month. Retain the underlying rows that explain each total; a file for this operating comparison needs no patient identifiers.
Choose units that match the work. Clinic visits, imaging procedures and inpatient days are different measures. Keep them distinct rather than adding them into a hospital-wide volume denominator. When services or payer groups have materially different economics, forecast those groups separately and sum their financial results.
CMS describes provider cost reports as containing utilization data and costs and charges by cost center. That supports the need to keep activity and departmental cost definitions clear; an annual regulatory report does not replace a timely internal monthly export.
Define net revenue per service using finance-approved assumptions, including the adjustments relevant to the organization's reporting basis. Do not substitute the charge-master amount. Reimbursement assumptions also need the correct service and setting: CMS explains that physician-fee payments reflect service resources, setting and geographic adjustments.
For staffing, use the labor hours included in the forecast and a corresponding loaded hourly cost. If hours per service already include coverage or nonproductive time, do not add that allowance again. Keep salaried staffing floors and other fixed costs separate when they cannot reasonably flex with activity.
An illustrative US outpatient provider compares its October 2026 forecast issued on August 31, 2026, with the revised October forecast issued on September 30, 2026. These are hypothetical planning inputs. The net yield includes the assumptions finance wants reflected in expected net revenue; labor cost includes only the staffing costs specified for this comparison.
Put the following columns in A:G of a driver sheet:
| Department | Version | Service volume | Net yield per service (USD) | Labor hours per service | Labor cost per hour (USD) | Service unit |
|---|---|---|---|---|---|---|
| Clinic | Prior | 1,000 | 200 | 1.5 | 40 | Visit |
| Clinic | Updated | 1,100 | 198 | 1.6 | 42 | Visit |
| Imaging | Prior | 600 | 300 | 2.0 | 45 | Procedure |
| Imaging | Updated | 570 | 310 | 2.0 | 45 | Procedure |
Add H for net revenue, I for labor hours, J for labor cost and K for net revenue less labor cost. In Excel, enter this formula in H2 and fill down:
=C2*D2
Enter =C2*E2 in I2, =I2*F2 in J2 and =H2-J2 in K2. Fill each down.
| Department and version | Net revenue (USD) | Labor hours | Labor cost (USD) | Net revenue less labor cost (USD) |
|---|---|---|---|---|
| Clinic, prior | 200,000 | 1,500 | 60,000 | 140,000 |
| Clinic, updated | 217,800 | 1,760 | 73,920 | 143,880 |
| Imaging, prior | 180,000 | 1,200 | 54,000 | 126,000 |
| Imaging, updated | 176,700 | 1,140 | 51,300 | 125,400 |
| Combined prior | 380,000 | 2,700 | 114,000 | 266,000 |
| Combined updated | 394,500 | 2,900 | 125,220 | 269,280 |
The updated clinic result is 1,100 × $198 = $217,800 of net revenue and 1,100 × 1.6 × $42 = $73,920 of labor cost. The final column excludes supplies, occupancy, purchased services and other costs. It is not operating profit.
For the combined prior revenue, use =SUM(H2,H4); for updated revenue, use =SUM(H3,H5). Microsoft documents SUM for adding values or references. Apply the same row selection to labor cost and the final column.
Calculate revenue volume first at the prior yield, then calculate yield at updated volume. Calculate labor volume at prior intensity and cost, intensity at updated volume and prior hourly cost, and hourly cost at updated volume and intensity. This order allocates the interaction effects consistently.
| Revenue change | Clinic (USD) | Imaging (USD) |
|---|---|---|
| Volume: (updated volume − prior volume) × prior yield | 20,000 | -9,000 |
| Yield: updated volume × (updated yield − prior yield) | -2,200 | 5,700 |
| Total revenue change | 17,800 | -3,300 |
| Labor-cost change | Clinic (USD) | Imaging (USD) |
|---|---|---|
| Volume: volume change × prior hours per service × prior hourly cost | 6,000 | -2,700 |
| Intensity: updated volume × change in hours per service × prior hourly cost | 4,400 | 0 |
| Hourly cost: updated volume × updated hours per service × hourly cost change | 3,520 | 0 |
| Total labor-cost change | 13,920 | -2,700 |
For clinic rows 2 and 3 on the driver sheet, calculate the revenue volume effect in a separate cell:
=(C3-C2)*D2
In separate cells, calculate revenue yield with =C3*(D3-D2), labor volume with =(C3-C2)*E2*F2, labor intensity with =C3*(E3-E2)*F2 and hourly cost with =C3*E3*(F3-F2). Repeat with rows 4 and 5 for imaging.
The revenue bridge gives $380,000 + $17,800 − $3,300 = $394,500. Labor cost gives $114,000 + $13,920 − $2,700 = $125,220. Therefore the change in net revenue less labor cost is $14,500 − $11,220 = $3,280, matching $269,280 − $266,000. Dollar outputs are rounded to whole dollars; these inputs produce whole-dollar results.
The clinic's higher activity supports more revenue, but revised labor intensity and hourly cost absorb much of the gain. Managers can examine scheduling, coverage and service mix without treating this financial bridge as a staffing prescription. Healthcare demand forecasting owns the separate task of estimating service demand.
Covirage is not affiliated with Microsoft.
Upload department forecast versions and actuals with consistent service units, periods and cost definitions. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for healthcare for the supporting industry context.
The annual budget preserves the approved benchmark for a fiscal year. A rolling forecast updates the current expectation and extends the planning horizon as periods close. Report both when accountability requires it: changing the expected result does not change the original budget.
Use department-specific service volumes, expected net revenue per service, labor hours per service and labor cost per hour. Add supplies, purchased services and other costs separately. Keep payer and service mix visible where an average rate would otherwise hide an important change.
No. A charge is not the same as expected net revenue for a service. Use assumptions supported by payer arrangements and the organization's reporting policies. If an average net yield changes, identify whether payer mix, service mix, reimbursement terms or adjustments caused the movement.
Yes. Additional services bring additional revenue, but they may also require overtime, agency staffing, supplies or other costs. Compare the incremental revenue and cost assumptions. A favorable revenue movement alone does not establish that the department's overall financial result improved.