Excellence Submission Template

Document Sample
Excellence Submission Template Powered By Docstoc
					                                                                 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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:2/3/2011
language:English
pages:13
Description: Excellence Submission Template document sample