Multi-Location Nurse Wage-Mix Worksheet

Find the wage-mix gap hiding in your nursing budget.

A Google Sheets template for multi-site healthcare Controllers. Plug in your sites, wage bands, and RN mix. Get the exact swing between what your budget assumed and what payroll will actually cost. Fifteen minutes, one number.

• Google Sheets and .xlsx
• Under 15 minutes to fill in
• No sales call required

‍

Most healthcare budgets model nursing wages in aggregate. Payroll runs at the position level.

That gap is where seven-figure variances hide. It compounds every quarter you don't see it. This worksheet is the fastest way to size it for your own sites, before it shows up in your next close.

1. A permanent RN and a travel RN at the same base rate can cost 40 to 60 percent more once benefits, PTO, and payroll tax stack up. Aggregate budgets can't see that.
2. Agency mix moves week to week. If your budget carries a static blend, you're always the last to know the shape has shifted.
3. Every added site multiplies the wage bands, tax jurisdictions, and benefit tiers your spreadsheet has to hold in its head. Excel runs out of room before you run out of sites.

‍

Preview: Tab 3 · Wage-mix impact

Your budget vs. the mix you're actually running. Illustrative example from the worksheet:

Wage-mix swing: +$742K. Your budget vs. the mix you're actually running.

‍

What you get

One workbook. Five tabs. Fifteen minutes.

Built with the Centage VP of Finance. Every formula validated by an operator. Locked cells on the math tabs so the numbers are inspectable, not editable.

Tab 1 · SETUP

Sites, wage bands, RN mix, benefit tiers, state tax rates. Everything else calculates from here.

Tab 2 · Position model

Per site, per role, per wage tier. Total comp rolled up from FTE and benefit ladder, not a blended average.

Tab 3 · Wage-mix impact

Your budgeted mix vs. the mix you're actually running. The swing number, per site and total.

Tab 4 · Projection

Six months forward if the current mix holds. Sensitivity for a five-point shift in agency or travel share.

Tab 5 · Next steps

Interpretation guide. Under 5% swing, 5 to 15%, above 15%. What each range means for how you plan next.

Yours to keep.

Every formula in the workbook was reviewed by a healthcare-fluent VP of Finance. Works in Google Sheets and Excel. No sales call to unlock the file. If you want to talk about what your swing number means for next year, we're one click away when you're ready.

‍

Download the Worksheet