Resource Location: https://docs.google.com/spreadsheets/d/1J57KWvXfYZLp8KkBMatAEAemaDPeB7ok/edit?usp=sharing&ouid=108449801722372837681&rtpof=true&sd=true
This Staff Stability Toolkit is an Excel file that contains individual worksheets focused on selected areas related to “staff stability”.
The tool is intended to offer a “snapshot” of your current staffing situation allowing you to collect and analyze areas for detailed and focused areas such as
- Employment Status – The makeup of your current staffing situation as it relates to “full-time”, “part-time” and “per diem” employment status
- Current Staff by Length of Service – Summarizing the current staff into Length of Service classifications across several categories from “< 6 months” through “10 Years or More”
- Vacant Positions – Current vacant positions by FTEs across all departments and shifts
- Turnover Rates – The calculation of turnover rates by “Overall Facility” with the opportunity to drill down by individual departments or groups
- Cost of Turnover – The calculation of “Turnover Replacement Costs” to include recruitment, vacancy costs, and training/orientation costs based on current rate of terminations by position
- Terminations by Length of Service – Collects both the number and percentage of terminations either by “Employee Choice” or “Employer Choice” across several Length of Service categories from “< 6 months” through “10 Years or More”
- Absenteeism – The collection of Call-In Statistics by department and shift for categories to include “timely call-in”, “shift replaced”, “replaced with overtime”, “replaced with agency”, and any “incentives” that were paid for the replacement of the individual call-in. The categories are summarized and graphed by department and shift with the calculation of an overall call-in percentage related to scheduled shifts
- Financial Incentives – The collection and summary of any incentive programs currently in place with an annual cost estimate
It is believed that by collecting and analyzing these focused “costs”, a facility will be better positioned to strategize and plan their approaches to improve and maintain the staffing stability within their individual facility.