Get documents about "Excellence Submission Template
Description
Excellence Submission Template document sample
Document Sample
Welcome!
Welcome to the Monitoring Staff Turnover Calculator. This easy-to-use template is a mechanism for tracking and
monitoring monthly turnover for CNAs, RNs, and LPN/LVNs. This workbook will also help nursing home staff prepare
entries for submission of turnover data for Goal #1 (Staff Turnover) on the
Advancing Excellence in America's Nursing Homes website:
http://www.NHQualityCampaign.org
This workbook contains ten [10] worksheets to assist you in your turnover calculations
and monitoring. Each worksheet can be accessed by
clicking on the Tab at the bottom of each worksheet.
Worksheet Description
1 Welcome! A table of contents to ease workbook navigation.
2 Instructions A navigation guide to task completion. Print for easy access.
3 Common Qs & As Answers to commonly asked questions. Print for easy access.
4 CNA Calc The CNA Turnover Calculator. Enter data on this worksheet.
5 CNA Trending A trending graph to visually see your impact on Turnover Rates.
6 RN Calc The RN Turnover Calculator. Enter data on this worksheet.
7 RN Trending A trending graph to visually see your impact on Turnover Rates.
8 LPN/LVN Calc The LPN/ LVN Turnover Calculator. Enter data on this worksheet.
9 LPN/LVN Trending A trending graph to visually see your impact on Turnover Rates.
10 Sample Data A completed Calculator sample.
Instructions
Please print this worksheet for easy-to-follow instructions.
Monitoring CNA Staff Turnover [SAMPLE]
CAMPAIGN GOAL #1: Staff Turnover: Nursing homes will take steps to minimize staff
turnover in order to maintain a stable workforce to care for residents.
NOTE: Campaign Goal #1 requires that annual turnover numerators and denominators be entered on campaign website for years 2010 & 2011.
Nursing Home Name: Provider Number (6-digit):
Number of CNA Staff
Step 1:
Number of CNA Staff Average Number
Terminated by the Cumulative Annualized
Month & Year Employed on the First Type in Terminations
Turnover Rate Per the Nursing of CNA Staff
Last Day of Each Turnover Rate
[A] Day of Each Month Month Employed
[B] Home Name and 6-digit Medicare Year-to-Date
Month Year-to-Date Year-to-Date
[C]
January 2010 100 2
Provider Number (if available).
1 2.0% 2 100.0 3.0%
February 2010 103 3 1 2.9% 5 101.5 7.4%
March 2010 95 4 1 4.2% 9 99.3 13.6%
April 2010 97 1 1 1.0% 10 98.8 15.2%
May 2010 102 0 1 0.0% 10 99.4 15.1%
June 2010 103 2 1 1.9% 12 100.0 18.0%
July 2010 99 1 1 1.0% 13 99.9 19.5%
August 2010 103 3 1 2.9% 16 100.3 23.9%
September 2010 0
October 2010 0
November 2010 0
December 2010 0
Total # of Data Collection Months Step 3:
8
Total # of CNA Staff Terminations During the 8 Months of MONTH , NUMBER OF
16 note
2010 Average # of CNA Staff During the 8 Months
Annualized Turnover Rate
100.3
23.9%
STAFF & NUMBER OF
TERMINATIONS for entry into th
Step 2: [Click of Staff website for data entry.]
Enter Numberto go to and Quality Campaign website.
Number of Terminations in yellow
columns . Monthly and annualized
turnover rates will automatically
calculate.
Common Qs & As
Q: What is a termination?
A: An employee departure, either due to firing or quitting, whereby the employee receives a final paycheck.
Q. Where can I find the data to fill out this Calculator?
A. Often, the organization has a separate form that must be completed for each termination. The periodic payroll reports
also may list terminations.
Q: Why does a part-time or per diem Staff termination count equally as a full-time Staff termination?
A: The calculation is measuring turnover of all Nursing Staff regardless of individual employment status.
Q: What about a member of the Nursing Staff who changes his/her job title and stays in the organization;
does this count as a termination if the employee is still a member of the Nursing Staff?
A: No. Do not count this individual as a termination.
Q: What about a member of the Nursing Staff who changes his/her job title and stays in the organization;
does this count as a termination if the employee leaves the Nursing Staff?
A: No. Do not count this individual as a termination.
Q: What if a Nursing Staff member works at two facilities owned by the same corporation and leaves one of the facilities,
but stays at the other?
A: The Staff member would be coded as a termination by the facility from which he/she departed.
Q: What if a Nursing Staff employee cuts his/her hours from full-time to per diem? Does that count as a termination?
A: No. He/She is still employed by the facility.
Q: What about a Nursing Staff employee who goes on unpaid leave?
A: He/She is still employed and would continue to be included in the denominator.
Common Qs & As
Q: What if a Nursing Staff employee leaves via a termination, but then is re-hired 3 weeks later?
A: He/She would count as a termination.
Q: If a home has 30 budgeted Staff positions, but only 25 of the positions are filled, is the number of
Staff 30 or 25?
A: The number of positions is 25.
Q: What about Agency Staff? Do they count in any of the calculations?
A: No. Agency Staff are not employed by the Nursing Home and therefore are not included.
Q: Does the turnover period need to be a calendar year? Must the year start in January?
A: For the purposes of Phase 2 of the Advancing Excellence Campaign, turnover periods are based on a calendar year.
Q: On the 'CNA Calc' or 'RN Calc' or 'LPN LVN Calc,' where do I enter data?
A: Data is entered in yellow cells only.
Q: Why is the Trending Graph not showing any trends?
A: Be sure data values have been entered in the yellow columns.
Achieving Excellence in America's Nursing Homes
Monitoring CNA Staff Turnover
CAMPAIGN GOAL #1: Staff Turnover: Nursing homes will take steps to minimize staff
turnover in order to maintain a stable workforce to care for residents.
NOTE: Campaign Goal #1 requires that monthly turnover data be entered on campaign website.
www.NHQualityCampaign.org
Nursing Home Name: Provider Number (6-digit):
Number of CNA Staff
Number of CNA Staff
Terminated by the
Employed on the First Cumulative Average Number of Annualized
Month & Year Last Day of Each Turnover Rate Per
Day of Each Month Terminations CNA Staff Employed Turnover Rate
Month Month
[Enter this number on Year-to-Date Year-to-Date Year-to-Date
[Enter this number on
the website]
the website]
January 2010
February 2010
March 2010
April 2010
May 2010
June 2010
July 2010
August 2010
September 2010
October 2010
November 2010
December 2010
Total # of Data Collection Months
Total # of CNA Staff Terminations During the Months
2010 Average # of CNA Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
Number of CNA Staff
Number of CNA Staff
Terminated by the
Employed on the First Cumulative Average Number of Annualized
Month & Year Last Day of Each Turnover Rate Per
Day of Each Month Terminations CNA Staff Employed Turnover Rate
Month Month
[Enter this number on Year-to-Date Year-to-Date Year-to-Date
[Enter this number on
the website]
the website]
January 2011
February 2011
March 2011
April 2011
May 2011
June 2011
July 2011
August 2011
September 2011
October 2011
November 2011
December 2011
Total # of Data Collection Months
Total # of CNA Staff Terminations During the Months
2011 Average # of CNA Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
Number of CNA Staff
Number of CNA Staff
Terminated by the
Employed on the First Cumulative Average Number of Annualized
Month & Year Last Day of Each Turnover Rate Per
Day of Each Month Terminations CNA Staff Employed Turnover Rate
Month Month
[Enter this number on Year-to-Date Year-to-Date Year-to-Date
[Enter this number on
the website]
the website]
January 2012
February 2012
March 2012
April 2012
May 2012
June 2012
July 2012
August 2012
September 2012
October 2012
November 2012
December 2012
Total # of Data Collection Months
Total # of CNA Staff Terminations During the Months
2012 Average # of CNA Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
CNA Staff Annualized Turnover Trending
120%
100%
80%
Percent Turnover
2010
60% 2011
2012
40%
20%
0%
J F M A M J J A S O N D
Month
Achieving Excellence in America's Nursing Homes
Monitoring RN Staff Turnover
CAMPAIGN GOAL #1: Staff Turnover: Nursing homes will take steps to minimize staff
turnover in order to maintain a stable workforce to care for residents.
NOTE: Campaign Goal #1 requires that monthly turnover data be entered on campaign website.
www.NHQualityCampaign.org
Nursing Home Name: Provider Number (6-digit):
Number of RN Staff
Number of RN Staff
Terminated by the
Employed on the First Cumulative Average Number of Annualized
Month & Year Last Day of Each Turnover Rate Per
Day of Each Month Terminations RN Staff Employed Turnover Rate
Month Month
[Enter this number on Year-to-Date Year-to-Date Year-to-Date
[Enter this number on
the website]
the website]
January 2010
February 2010
March 2010
April 2010
May 2010
June 2010
July 2010
August 2010
September 2010
October 2010
November 2010
December 2010
Total # of Data Collection Months
Total # of RN Staff Terminations During the Months
2010 Average # of RN Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
Number of RN Staff
Number of RN Staff
Terminated by the
Employed on the First Cumulative Average Number of Annualized
Month & Year Last Day of Each Turnover Rate Per
Day of Each Month Terminations RN Staff Employed Turnover Rate
Month Month
[Enter this number on Year-to-Date Year-to-Date Year-to-Date
[Enter this number on
the website]
the website]
January 2011
February 2011
March 2011
April 2011
May 2011
June 2011
July 2011
August 2011
September 2011
October 2011
November 2011
December 2011
Total # of Data Collection Months
Total # of RN Staff Terminations During the Months
2011 Average # of RN Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
Number of RN Staff
Number of RN Staff
Terminated by the
Employed on the First Cumulative Average Number of Annualized
Month & Year Last Day of Each Turnover Rate Per
Day of Each Month Terminations RN Staff Employed Turnover Rate
Month Month
[Enter this number on Year-to-Date Year-to-Date Year-to-Date
[Enter this number on
the website]
the website]
January 2012
February 2012
March 2012
April 2012
May 2012
June 2012
July 2012
August 2012
September 2012
October 2012
November 2012
December 2012
Total # of Data Collection Months
Total # of RN Staff Terminations During the Months
2012 Average # of RN Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
RN Staff Annualized Turnover Trending
120%
100%
80%
Percent Turnover
2010
60% 2011
2012
40%
20%
0%
J F M A M J J A S O N D
Month
Achieving Excellence in America's Nursing Homes
Monitoring LPN/LVN Staff Turnover
CAMPAIGN GOAL #1: Staff Turnover: Nursing homes will take steps to minimize staff
turnover in order to maintain a stable workforce to care for residents.
NOTE: Campaign Goal #1 requires that monthly turnover data be entered on campaign website.
www.NHQualityCampaign.org
Nursing Home Name: Provider Number (6-digit):
Number of LPN/LVN Number of LPN/LVN
Staff Employed on Staff Terminated by Average Number of
Cumulative Annualized
Month & Year the First Day of Each the Last Day of Each Turnover Rate Per LPN/LVN Staff
Terminations Turnover Rate
Month Month Month Employed
Year-to-Date Year-to-Date
[Enter this number on [Enter this number on Year-to-Date
the website] the website]
January 2010
February 2010
March 2010
April 2010
May 2010
June 2010
July 2010
August 2010
September 2010
October 2010
November 2010
December 2010
Total # of Data Collection Months
Total # of LPN/LVN Staff Terminations During the Months
2010 Average # of LPN/LVN Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
Number of LPN/LVN Number of LPN/LVN
Staff Employed on Staff Terminated by Average Number of
Cumulative Annualized
Month & Year the First Day of Each the Last Day of Each Turnover Rate Per LPN/LVN Staff
Terminations Turnover Rate
Month Month Month Employed
Year-to-Date Year-to-Date
[Enter this number on [Enter this number on Year-to-Date
the website] the website]
January 2011
February 2011
March 2011
April 2011
May 2011
June 2011
July 2011
August 2011
September 2011
October 2011
November 2011
December 2011
Total # of Data Collection Months
Total # of LPN/LVN Staff Terminations During the Months
2011 Average # of LPN/LVN Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
Number of LPN/LVN Number of LPN/LVN
Staff Employed on Staff Terminated by Average Number of
Cumulative Annualized
Month & Year the First Day of Each the Last Day of Each Turnover Rate Per LPN/LVN Staff
Terminations Turnover Rate
Month Month Month Employed
Year-to-Date Year-to-Date
[Enter this number on [Enter this number on Year-to-Date
the website] the website]
January 2012
February 2012
March 2012
April 2012
May 2012
June 2012
July 2012
August 2012
September 2012
October 2012
November 2012
December 2012
Total # of Data Collection Months
Total # of LPN/LVN Staff Terminations During the Months
2012 Average # of LPN/LVN Staff During the Months
Annualized Turnover Rate
[Click to go to website for data entry.]
LPN / LVN Staff Annualized Turnover Trending
120%
100%
80%
Percent Turnover
2010
60% 2011
2012
40%
20%
0%
J F M A M J J A S O N D
Month
Achieving Excellence in America's Nursing Homes
Monitoring CNA Staff Turnover [SAMPLE]
CAMPAIGN GOAL #1: Measure staff turnover and develop action plans to improve staff retention.
NOTE: Campaign Goal #1 requires that monthly turnover data be entered on campaign website.
www.NHQualityCampaign.org
Nursing Home Name: Provider Number (6-digit):
Number of CNA Staff Number of CNA Staff
Employed on the First Terminated by the
Cumulative Average Number of
Month & Year Day of Each Month Last Day of Each Turnover Rate Per
Terminations CNA Staff Employed
[Enter this number on Month Month
Year-to-Date Year-to-Date
the website] [Enter this number on
the website]
January 2010 100 2 2.00% 2 100
February 2010 103 3 2.91% 5 102
March 2010 95 4 4.21% 9 99
April 2010 97 6 6.19% 15 99
May 2010 102 0 0.00% 15 99
June 2010 103 2 1.94% 17 100
July 2010 99 1 1.01% 18 100
August 2010 103 3 2.91% 21 100
September 2010 100 4 4.00% 25 100
October 2010 100 2 2.00% 27 100
November 2010 101 3 2.97% 30 100
December 2010 102 0 0.00% 30 100
Total # of Data Collection Months
Total # of CNA Staff Terminations During the 12 Months
2010 Average # of CNA Staff During the 12 Months
Annualized Turnover Rate
SAMPLE
Excellence in America's Nursing Homes
nitoring CNA Staff Turnover [SAMPLE]
easure staff turnover and develop action plans to improve staff retention.
paign Goal #1 requires that monthly turnover data be entered on campaign website.
www.NHQualityCampaign.org
Provider Number (6-digit):
Annualized
Turnover Rate
Year-to-Date
2%
5%
9%
15%
15%
17%
18%
21%
25%
27%
30%
30%
12
30
100.4
29.9%
SAMPLE
Related docs
