What's included
- Month-by-month FTE gap projected six months out, by unit
- Cumulative travel-nurse premium of the unfilled gap
- Per-unit budgeted vs filled FTEs, attrition and retirements
- Forecast dashboard with two charts
- Compatible with Excel 2016+ and Google Sheets
planning
Nursing Vacancy & FTE Forecasting Workbook
See the staffing hole before it opens. For each unit, enter budgeted versus filled FTEs, the trailing departure rate, the retirement-age headcount, and expected monthly hires, and the workbook projects your month-by-month FTE gap over the next six months and the cumulative travel-nurse premium of leaving it unfilled. A forecast dashboard shows current vacancy, the projected six-month gap, the cumulative premium, and the monthly net change, with two charts. Every figure is computed from your own inputs. Pairs with the NursingWorkforce app.
No subscription. Download once, use forever.
Instant digital download · all sales final. Refund policy
What's included
- Month-by-month FTE gap projected six months out, by unit
- Cumulative travel-nurse premium of the unfilled gap
- Per-unit budgeted vs filled FTEs, attrition and retirements
- Forecast dashboard with two charts
- Compatible with Excel 2016+ and Google Sheets
Want this automatically? NursingWorkforce tracks turnover, vacancies, and retention for you.
Live BLS nurse-wage benchmarking, turnover dashboards, and vacancy forecasting — no spreadsheet maintenance required.
Join the Waitlist →More templates
Nurse Retention Action Plan Workbook
Build a unit-level nurse-retention plan you can actually track — and benchmark your turnover against the cited NSI figure.
RN Turnover Tracker
Track nurse departures by unit, see your rolling 12-month turnover, and benchmark it against the cited NSI figure.
Travel Nurse Cost vs. Staff Retention ROI Calculator
Build the board-ready financial case for a nurse-retention program — in your own numbers.
Nursing Staffing Ratio Planning Template
Map your unit nurse-to-patient ratios against the cited state mandate and your internal targets — and flag the gaps.