Nursing Workforce Analytics: The Complete Guide for Mid-Size Facilities

The Resignation Letter You Didn't See Coming

The call came on a Tuesday morning. A charge nurse on your med-surg unit — five years in, a de-facto team anchor — submitted her resignation. Effective in two weeks. You knew she'd had some frustrations, but nothing that felt urgent. No formal complaint, no exit conversations, no early-warning signal in any report you could pull.

What followed was familiar: an emergency call to staffing, a search for float-pool coverage, a conversation with the unit manager about mandatory overtime, and eventually a travel-nurse contract that showed up as a line item no one planned for in the quarterly board review.

The departure cost time, margin, and morale. What it did not produce was data — at least not in any form that would help you see the next one coming.

That is the problem nursing workforce analytics is designed to solve. Not as a prediction machine, but as a continuous measurement system: one that translates the movement of nursing staff — departures, vacancies, wages, risk signals — into monitored, trackable metrics rather than surprises that surface at the resignation letter stage.

This guide explains what nursing workforce analytics actually measures, how each component works, and how a mid-size facility of 50–300 beds can build a functional system around the metrics that matter most. By the end, you will have a clear framework for turning reactive retention into a measured, monitored discipline.

What Nursing Workforce Analytics Actually Measures

Nursing workforce analytics is the practice of collecting, structuring, and interpreting quantitative data about a nursing workforce — turnover, vacancy, wages, staffing ratios, and leading indicators of flight risk — so that nurse leaders can act on patterns rather than react to events.

The term is sometimes conflated with scheduling or staffing optimization. Those are related disciplines, but they are not the same thing. A scheduling tool answers the question "who is on shift this weekend?" Workforce analytics answers the questions that precede and outlast any single schedule: "What is our 12-month RN turnover rate on the night-shift telemetry team? How does our LPN/LVN wage compare to the regional median? Which unit is most likely to have a vacancy six months from now?"

For most mid-size facilities, these questions are answered — if at all — through a combination of spreadsheets, HR system exports, and institutional memory. That approach works when the roster is small and stable. It becomes genuinely difficult to sustain once you are tracking 80 or 150 or 250 nursing FTEs across multiple units and role types. Data entry accumulates, formulas break, and the lag between a pattern emerging and someone recognizing it stretches from weeks to months.

A structured nursing workforce analytics approach replaces that lag with a continuous signal.

The Five Pillars of a Nursing Workforce Analytics System

A functional system for mid-size facilities rests on five connected components. Each one is independently useful; together, they form a picture of retention health that no single report can provide.

1. Rolling 12-Month Turnover Rate

The most widely used benchmark in nursing workforce planning is the annual RN turnover rate. The 2026 NSI National Health Care Retention & RN Staffing Report found a national staff RN turnover rate of 17.6% in 2025, up 1.2 percentage points from 16.4% in 2024, reversing the prior year's decline (NSI 2026, via Becker's Hospital Review, 2026).

What makes this figure useful as a benchmark is the denominator: it is calculated as a rolling 12-month rate, meaning it counts the total departures over the trailing 12 months divided by the average FTE headcount over that same period. That rolling structure means the rate updates continuously as each new month rolls in and the oldest month drops off.

For a detailed walkthrough of the calculation, see our guide to calculating your nurse turnover rate and the companion piece on rolling 12-month turnover rate mechanics.

Two things are worth noting about the national figure. First, the range is wide: the NSI 2026 data shows RN turnover running from 5.6% to 40.0% by hospital bed count (NSI 2026, via Becker's, 2026). A single national average obscures enormous facility-level variation. Second, the rate has moved meaningfully year over year — down 2.4 points from 2023 to 2024, then back up 1.2 points from 2024 to 2025. Treating the benchmark as a fixed target rather than a moving one understates the actual challenge.

A good analytics system tracks the rolling rate at three levels of granularity: facility-wide, by unit, and by role (RN separately from LPN/LVN, and both separately from nursing assistants). The facility-wide rate is the board-level headline. The unit and role breakdowns are where the operational signal lives.

2. Cost-of-Departure Modeling

Turnover has a quantifiable cost per departure, and knowing that cost changes how nurse leaders and CFOs talk about retention investments.

The 2026 NSI report estimates the average cost of a single RN departure at $60,090 (down slightly from $61,110 the prior year; NSI 2026, via Becker's, 2026). That figure aggregates recruitment advertising, agency and overtime coverage during the vacancy, onboarding and orientation time, and the productivity ramp for a new hire.

At the facility level, the cumulative effect is significant: the same NSI 2026 data puts total annual RN-turnover loss per hospital at $4.2M–$6.2M, with an average of $5.19M (NSI 2026, via Becker's, 2026). Or, framed incrementally: each percentage-point rise in RN turnover costs the average hospital approximately $295,000 per year (NSI 2026, via Becker's, 2026).

A worked example illustrates how this plays out at a mid-size facility. Take a 150-bed hospital with 120 nursing RN FTEs and a current rolling 12-month turnover rate of 18%:

• Annualized departures: 120 FTEs × 18% = 21.6 departures/year
• Modeled annual cost: 21.6 × $60,090 (NSI 2026) = ≈$1.30M/year
• Cost of each additional percentage point: 1.2 FTEs × $60,090 ≈ $72,000

This is a model built on NSI inputs with round illustrative numbers — verify against your own headcount and actual departure data. The point is that even at facility sizes well below the national hospital average, the cost-of-departure arithmetic produces numbers that belong in a budget conversation, not just an HR report.

For a full breakdown of what drives departure costs and how to model them for your own facility, see our guide to the cost of nurse turnover. The nurse turnover resource hub collects additional departure-cost research and calculation tools.

3. BLS OES Wage Benchmarking

Pay is not the only driver of RN turnover — but it is one of the most legible, and it is one of the few signals a nurse leader can act on directly.

The Bureau of Labor Statistics Occupational Employment and Wage Statistics (OEWS) program publishes annual wage data by occupation and geography. For workforce analytics purposes, the most relevant figures are for:

• Registered Nurses (SOC 29-1141): national median annual wage of $93,600 (BLS May 2024); 10th percentile below $66,030; 90th percentile above $135,320 (BLS Occupational Outlook Handbook, May 2024).
• Licensed Practical and Vocational Nurses (SOC 29-2061): national median annual wage of $62,340 (BLS May 2024; $29.97/hr); 10th percentile below $47,960; 90th percentile above $80,510 (BLS OOH, May 2024).

The national median is a starting point. What matters for retention is how your facility's internal pay bands compare to the wages BLS reports for your state and metropolitan statistical area — because nurses compare offers regionally, not nationally.

When an internal pay band sits materially below the regional BLS median, staff in that band face wage signals from the external market every time a recruiter reaches out. The gap between what a nurse is paid and what comparable roles pay nearby is a measurable, monitorable flight-risk indicator — one that most spreadsheet-based systems miss entirely because the external benchmark is never imported alongside the internal pay data.

For a detailed guide to reading and applying BLS OES data to nursing pay decisions, see the BLS nurse wage benchmarking guide. The nurse wage benchmarking resource hub covers state-level variation, including markets like California where BLS May 2024 OEWS data shows an RN annual mean of approximately $148,330 — substantially above the national figure (BLS OEWS May 2024, via Sunbelt Staffing analysis, May 2024). For facilities in high-wage markets, the national median benchmark is particularly insufficient.

The relationship between wage gaps and departure risk is covered in the companion piece on nurse wage gaps and flight risk.

4. Retention Risk Scoring

Turnover rate tells you what has already happened. A retention risk score is an attempt to surface what is likely to happen — to identify which units or role cohorts are accumulating the conditions that precede departures, before the resignation letters arrive.

A transparent, formula-based risk score combines inputs that individually correlate with departure likelihood: current turnover rate relative to benchmark, vacancy rate and time-to-fill duration, wage-gap flags from BLS benchmarking, ratio of overtime and agency hours to total hours, and recent departure clustering (multiple departures in a short window on the same unit). Each input is weighted and rolled into a composite score per unit.

The key word is transparent. A score that produces a number without explaining the inputs is difficult to act on. A score that shows its work — "this unit's elevated risk is driven primarily by a wage gap on night-shift RNs and a vacancy that has been open for 64 days" — gives the nurse manager or CNO a specific problem to address.

The NSI 2026 data provides context for why the vacancy dimension of that score matters: the average time-to-fill for an experienced RN was 78 days (Recruitment Difficulty Index, NSI 2026, via Kahuna Workforce, 2026), and the national RN vacancy rate in 2025 was 8.6%, with 43 unfilled RN FTEs on average per hospital and 33.1% of hospitals carrying a vacancy rate of 10% or higher (NSI 2026, via Becker's, 2026). A unit with a vacancy open significantly longer than 78 days, or a facility with vacancy above the 10% threshold, is carrying a structural strain that belongs in the risk calculation.

A full explanation of how retention risk scores are constructed and interpreted is in the nurse retention risk score explained.

5. Six-Month Vacancy Forecasting

Vacancy forecasting answers a forward-looking question: given current turnover patterns, anticipated retirements, and known departures, what does this facility's staffing position look like six months from now?

The utility of a six-month window is that it is long enough to allow a meaningful response — a hiring campaign, a compensation review, a float-pool expansion — but short enough that the forecast is grounded in real trend data rather than speculative projection.

The forecast is built on three inputs: the rolling departure rate by unit and role, any known planned departures (retirements, announced leaves, known contract end dates), and the facility's historical time-to-fill. The output is a per-unit vacancy projection for each of the next six months, flagged when the projection crosses a threshold that would require agency or overtime coverage to maintain safe staffing levels.

Demand context from BLS is relevant here: RN employment is projected to grow 5% from 2024 to 2034, generating approximately 189,100 annual job openings nationally (BLS OOH, 2024–2034 projection). LPN/LVN employment is projected to grow 3% over the same period, producing roughly 54,400 annual openings (BLS OOH). The competitive recruiting environment those projections imply makes the six-month lead time more valuable, not less — a facility that identifies a looming vacancy shortage in April has better options than one that identifies it in September.

For a detailed walkthrough of vacancy forecasting methodology, see six-month vacancy forecasting for nursing.

Why Mid-Size Facilities Need This More Than Large Systems

It is tempting to assume that workforce analytics is an enterprise problem — something for 500-bed academic medical centers with dedicated analytics teams. The reality is roughly the opposite.

Large systems have resources: dedicated HRIS staff, enterprise workforce-management platforms, and reporting teams that can build and maintain custom dashboards. The challenge at scale is complexity; the infrastructure is there.

Mid-size facilities — 50–300 beds, 80–350 nursing FTEs, often community hospitals or regional health systems — typically lack the dedicated analytics infrastructure but face the same fundamental workforce dynamics. Turnover rates in this range are not systematically lower than at larger facilities. The NSI 2026 data's 5.6%–40.0% range by bed count suggests considerable variability at smaller size tiers (NSI 2026, via Becker's, 2026). The absence of a dedicated analytics team does not reduce the scale of the problem; it concentrates the burden on the CNO, Director of Nursing, or nurse manager who is already managing clinical operations.

The spreadsheet — the default tool at this size — works as a ledger. It records what you enter. It does not connect your internal pay bands to the BLS regional median. It does not flag when a unit's turnover rate has drifted above the NSI benchmark. It does not update the rolling rate automatically as months roll forward. And critically, it does not hold a risk score that would have surfaced the charge nurse's situation three months before the resignation letter arrived.

The SNF, LTC, and home-health segment adds a further layer of urgency. AHCA survey data from 2024 found that 94% of nursing homes found recruiting difficult and 90% had raised wages in the prior six months (AHCA 2024 State of the Sector Report, March 2024). 46% of SNFs were limiting admissions and 20% had closed entire units by 2024 (PMC, 2026). Workforce analytics does not solve a recruiting shortage, but it gives operators in those markets the lead time and data specificity to direct limited retention resources where they are most likely to prevent a departure.

For SNF and LTC-specific workforce planning considerations, see skilled nursing facility workforce planning.

The Shortage Context: What Workforce Analytics Can and Cannot Do

Understanding the national supply-side context helps calibrate what workforce analytics is designed to accomplish.

HRSA's nursing workforce projections indicate a national FTE RN shortage of approximately 78,610 in 2025, narrowing to 63,720 by 2030 (HRSA Nursing Workforce Projections Factsheet, November 2022). More recent HRSA projections extend the horizon, suggesting an 8% RN shortage by 2028, narrowing to approximately 3% — roughly 108,960 FTE — by 2038, with a persistent 11% shortage in nonmetro areas through 2038 (HRSA Nurse Workforce Projections 2023–2038 Factsheet, 2024).

A separate dimension of supply risk is the planned-departure wave. The 2022 NCSBN National Nursing Workforce Study found that 610,388 RNs — nearly one in five — intend to leave the workforce by 2027, and of those, approximately 200,000 are under age 40 (NCSBN, 2023). That figure includes retirements but also voluntary career changes that are harder to predict from traditional demographic data alone.

These are national supply figures. Workforce analytics does not expand the supply of available nurses. What it does is give a facility's leadership the clearest possible picture of demand on the other side of that equation — their own departures, vacancies, wage competitiveness, and risk accumulation — so that retention effort and compensation investment can be targeted precisely rather than distributed broadly.

The distinction matters because retention resources are finite. A CNO managing 200 FTEs across four units cannot implement a retention initiative on all four units simultaneously with equal intensity. A risk score that identifies the unit where conditions are most acute makes those resources go further.

The broader picture for nurse leaders on how to approach retention strategy is collected in the CNO retention playbook.

Nursing Workforce Analytics and the Role of Occupational Data

One dimension of workforce analytics that is underutilized at most mid-size facilities is occupational-level data: structured, validated descriptions of what each role requires in terms of skills, knowledge, work activities, and job complexity.

O*NET, maintained by the U.S. Department of Labor, provides full occupational profiles for Registered Nurses (O*NET-SOC 29-1141.00) and Licensed Practical and Vocational Nurses (29-2061.00), including skills, knowledge domains, work context, and Job Zone classifications. These profiles are joinable to BLS OES wage data by SOC code, enabling a combined view of what a role requires and what the market pays for it.

Occupational data sourced from O*NET, licensed under CC BY 4.0. O*NET® is a trademark of the U.S. Department of Labor, Employment and Training Administration. onetcenter.org

In a workforce analytics context, occupational profiles serve two practical functions. First, they provide a standardized role taxonomy that supports consistent FTE tracking across units and facilities — important when an organization uses different local titles for roles that map to the same SOC code. Second, the skills and knowledge framework in an O*NET profile can inform onboarding completeness assessments and identify where a new hire's profile differs from the occupational standard — a leading indicator of time-to-productivity and early-tenure departure risk.

What a Nursing Workforce Analytics System Looks Like in Practice

Abstractly, a nursing workforce analytics system is a set of calculations and benchmarks. Concretely, it is a set of questions a CNO or Director of Nursing can answer without opening a spreadsheet:

• What is our rolling 12-month RN turnover rate on the night-shift med-surg team, and how does it compare to the NSI national rate of 17.6%?
• Which of our units has the highest retention risk score this month, and what inputs are driving it?
• What is our current RN vacancy rate, and which vacancies have been open longer than the 78-day NSI benchmark?
• How do our RN and LPN/LVN pay bands compare to the BLS May 2024 median and 25th percentile for our metro area?
• If our current departure rate holds, what will our telemetry unit's staffing position look like in four months?

The value of having those answers continuously available — updated as data flows in rather than assembled manually at month-end — is not primarily analytical. It is operational. The nurse manager who can see that their unit's risk score has moved up two points this month, driven by a wage gap and an overtime rate that has risen 15%, has something to act on before it becomes a resignation letter.

For a structured comparison of analytics tools and approaches at different price points and capability levels, see nursing workforce software comparison.

The Data Infrastructure Behind Nursing Workforce Analytics

Running a nursing workforce analytics system requires four categories of data, all of which most mid-size facilities already hold — the challenge is structuring and connecting them.

1. Headcount and roster data. A current list of nursing FTEs by unit, role (SOC code), hire date, and employment status (full-time, part-time, PRN, agency/travel). This is the denominator in every turnover and vacancy calculation. It needs to be updated at minimum monthly; ideally, it reflects real-time changes.

2. Departure records. A log of every departure — date, unit, role, departure type (voluntary resignation, involuntary, retirement, internal transfer). Departure type matters for turnover rate interpretation: most analytics frameworks count only voluntary and involuntary departures against the turnover rate, not internal transfers, which are a different workforce signal.

3. Internal wage data. Current pay rates for each nursing FTE by role, unit, and shift differential. Pay-band data at the role level is sufficient for wage-gap benchmarking; individual-level wage data enables more precise gap identification.

4. External wage benchmarks. BLS OES wage data for the relevant SOC codes (29-1141 for RN, 29-2061 for LPN/LVN) at the state level and, for Professional-tier analytics, the metropolitan statistical area level. These benchmarks are updated annually with each BLS OEWS release; the current figures use the May 2024 release.

With those four inputs in place, the five pillars described above — turnover rate, cost modeling, wage benchmarking, risk scoring, and vacancy forecasting — can all be calculated and maintained. The infrastructure is not exotic; most of the data already exists in an HRIS, payroll system, or HR spreadsheet. The work is connecting it into a structure that updates continuously rather than requiring monthly manual assembly.

Getting Started: A Practical Sequence for Mid-Size Facilities

If you are building a nursing workforce analytics capability from the current state — primarily spreadsheets and monthly HR exports — the following sequence reduces setup friction:

Step 1: Establish a clean headcount baseline. Start with a single, authoritative roster of all nursing FTEs: name (or ID), unit, role, SOC code, hire date, FTE status, and current pay band. This is the foundation everything else builds on. Resolve any discrepancies between your HR system and your scheduling system before adding any analytics layer.

Step 2: Calculate your current rolling 12-month turnover rate. Pull departures for the past 13 months (to compute average headcount), categorize them by type, and calculate the rate using the standard formula: (voluntary + involuntary departures ÷ average FTE headcount) × 100. Do this at the facility level, then break it down by unit and role. Compare to the NSI 2026 national benchmark of 17.6% (2025 data). The calculate nurse turnover rate guide walks through this calculation step by step.

Step 3: Import your current pay bands and compare to BLS. Pull the BLS May 2024 median, 25th percentile, and 10th percentile for SOC 29-1141 (RN) and 29-2061 (LPN/LVN) at your state level. Map your current internal pay bands against those percentiles. Flag any cohort sitting at or below the 25th percentile — this is the group with the clearest externally visible wage signal.

Step 4: Identify your current vacancies and time-to-fill. Count open nursing requisitions by unit and role, and record the number of days each has been open. Compare against the 78-day NSI benchmark (NSI 2026, via Kahuna Workforce, 2026). Vacancies significantly above that threshold carry compounding cost and coverage strain.

Step 5: Build a simple risk flag per unit. Even before a formal risk score, you can create a three-column flag: turnover rate (above/at/below NSI benchmark), wage gap (at or below 25th percentile BLS for any role cohort), and vacancy strain (any vacancy open >78 days). A unit with two or three flags active is a retention priority.

Step 6: Establish a monitoring cadence. Workforce analytics loses most of its value if it is produced quarterly and reviewed in isolation. A monthly review cadence — rolling rate updated, vacancies audited, risk flags refreshed — transforms the output from a retrospective report into an early-warning system.

From Spreadsheet to Dashboard: The Analytics Maturity Continuum

Mid-size facilities exist at different points on a maturity continuum for nursing workforce analytics:

Level 1 — Reactive tracking. Turnover is calculated once or twice a year, usually after a period of notable departures. No benchmark comparison. No wage gap analysis. Vacancy tracking is informal.

Level 2 — Monthly reporting. Rolling 12-month rate calculated monthly. Departures logged by type. Some BLS wage comparison, usually at the national level only. Vacancy count maintained. Risk identification is informal and based on manager observation.

Level 3 — Benchmarked monitoring. Rolling rate tracked by unit and role, compared to NSI benchmarks. BLS wage comparison at state or metro level, with pay-band gap flags. Vacancy tracked with time-to-fill. Risk scoring applied per unit on a transparent formula. Monthly review cadence.

Level 4 — Forecasting and action logging. All of Level 3, plus a six-month vacancy forecast, a retention action log tracking what was done in response to risk flags, and a travel-nurse-cost-versus-staff-retention ROI model to surface the cost case for retention investment. This is the level at which workforce analytics shifts from measurement to management.

Most 50–300-bed facilities today operate at Level 1 or Level 2. Moving to Level 3 is achievable with existing data, a structured calculation framework, and a consistent monthly review. Moving to Level 4 requires either significant manual process investment or tooling designed for the purpose.

The Business Case: What Nursing Workforce Analytics Is Worth

The ROI case for nursing workforce analytics is grounded in the departure-cost arithmetic.

At $60,090 per RN departure (NSI 2026, via Becker's, 2026) and a national average hospital turnover loss of $5.19M annually (NSI 2026), even a modest reduction in departures produces a measurable financial return. The NSI 2026 estimate that each percentage point of RN turnover costs the average hospital $295,000/year provides a framework for evaluating retention investments: a compensation adjustment, a scheduling change, or a targeted retention initiative that prevents 2–3 departures per year covers itself many times over.

The travel-nurse dimension adds further urgency. NSI 2026 data documents travel-nurse rates as high as $160/hour (NSI 2026, via Kahuna Workforce, 2026). Agency coverage during open vacancies is substantially more expensive than employed-staff coverage — and the decision to extend or reduce agency reliance is best made with visibility into whether a vacancy can realistically be filled in the near term or whether it will remain open based on current time-to-fill trends.

None of these numbers require a large facility to be meaningful. At a 150-bed community hospital with 120 RN FTEs, preventing two departures per year at $60,090 each represents $120,180 in avoided cost — a figure that materially exceeds the annual cost of a professional-tier workforce analytics tool.

See the full features overview and pricing for Nursing Workforce Planner, or schedule a demo to walk through how these calculations apply to your facility's specific headcount and turnover profile.

Stay Current on Nursing Workforce Data

The NSI report updates annually. BLS OEWS releases each May. HRSA nursing workforce projections are revised periodically. The workforce analytics landscape — benchmarks, vacancy trends, wage movements — shifts meaningfully from year to year, as the 1.2-point rise in national RN turnover from 2024 to 2025 illustrates.

Subscribe to the Nursing Workforce Planner newsletter for a monthly summary of new workforce data, benchmark updates, calculation guides, and practical retention frameworks — delivered directly to your inbox, grounded in sourced data, without the noise.

The nurse turnover resource hub and nurse wage benchmarking resource hub are updated as new data becomes available and serve as the permanent reference points for the figures cited throughout this guide.