Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Calculation_of_turnover

VIEWS: 90 PAGES: 13

									                                                                 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.

                                                         1
                                               Step : Type in the Nursing
Nursing Home Name:                           Home Name and 6-digit Medicare                                 Provider Number (6-digit):
                                              Provider Number (if available).
                                                          Number of CNA Staff
                               Number of CNA Staff                                                                                 Average Number
                                                           Terminated by the                                   Cumulative                                  Annualized
      Month & Year             Employed on the First                                    Turnover Rate Per                            of CNA Staff
                                                            Last Day of Each                                   Terminations                               Turnover Rate
          [A]                   Day of Each Month                                            Month                                    Employed
                                                                  Month                                        Year-to-Date                               Year-to-Date
                                        [B]                                                                                          Year-to-Date
                                                                   [C]

      January 2010                        100                  2                    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  3
                                                                                                                Step : Print worksheet or make
                                                                                                                                    98.8                     15.2%
        May 2010                          102                  0                    1          0.0%                 10              99.4
                                                                                                                   note of MONTH , NUMBER OF                 15.1%
        June 2010                         103                  2                    1          1.9%                                 100.0
                                                                                                                    12 STAFF & NUMBER OF                     18.0%
         July 2010                         99                  1                    1          1.0%                 13              99.9
                                                                                                                 TERMINATIONS for entry into the             19.5%
       August 2010             Step 2     : Enter Number of Staff and
                                          103                  3                    1          2.9%                Quality Campaign website.
                                                                                                                    16              100.3                    23.9%
     September 2010              Number of Terminations in yellow                   0
      October 2010              columns . Monthly and annualized                    0
                                 turnover rates will automatically
     November 2010                                                                  0
                                            calculate.
     December 2010                                                                  0

                                                                                                                Total # of Data Collection Months               8
                                                                                            Total # of CNA Staff Terminations During the 8 Months              16

    2010                                                                                              Average # of CNA Staff During the 8 Months

                                                                                                              Annualized Turnover Rate
                                                                                                                                                              100.3

                                                                                                                                                            23.9%
                                                                                 [Click to go to website for data entry.]


                                                                                        Step   4
                                                                                               : Click the web link to open the
                                                                                         NH Quality Campaign website to enter
                                                                                        MONTH, NUMBER OF STAFF & NUMBER OF
                                                                                                    TERMINATIONS.
                                                           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
                               Employed on the       Terminated by the
                                                                                                                Cumulative        Average Number of       Annualized
         Month & Year          First Day of Each      Last Day of Each             Turnover Rate Per
                                                                                                                Terminations      CNA Staff Employed     Turnover Rate
                                      Month                 Month                       Month
                                                                                                                Year-to-Date         Year-to-Date        Year-to-Date
                             [Enter this number on [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
                               Employed on the       Terminated by the
                                                                                                                Cumulative        Average Number of       Annualized
         Month & Year          First Day of Each      Last Day of Each             Turnover Rate Per
                                                                                                                Terminations      CNA Staff Employed     Turnover Rate
                                      Month                 Month                       Month
                                                                                                                Year-to-Date         Year-to-Date        Year-to-Date
                             [Enter this number on [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
                               Employed on the       Terminated by the
                                                                                                                Cumulative        Average Number of       Annualized
         Month & Year          First Day of Each      Last Day of Each             Turnover Rate Per
                                                                                                                Terminations      CNA Staff Employed     Turnover Rate
                                      Month                 Month                       Month
                                                                                                                Year-to-Date         Year-to-Date        Year-to-Date
                             [Enter this number on [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
                               Employed on the       Terminated by the
                                                                                                                Cumulative        Average Number of         Annualized
         Month & Year          First Day of Each      Last Day of Each             Turnover Rate Per
                                                                                                                Terminations       RN Staff Employed       Turnover Rate
                                      Month                 Month                       Month
                                                                                                                Year-to-Date         Year-to-Date          Year-to-Date
                             [Enter this number on [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
                               Employed on the       Terminated by the
                                                                                                                Cumulative        Average Number of         Annualized
         Month & Year          First Day of Each      Last Day of Each             Turnover Rate Per
                                                                                                                Terminations       RN Staff Employed       Turnover Rate
                                      Month                 Month                       Month
                                                                                                                Year-to-Date         Year-to-Date          Year-to-Date
                             [Enter this number on [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
                               Employed on the       Terminated by the
                                                                                                                Cumulative        Average Number of         Annualized
         Month & Year          First Day of Each      Last Day of Each             Turnover Rate Per
                                                                                                                Terminations       RN Staff Employed       Turnover Rate
                                      Month                 Month                       Month
                                                                                                                Year-to-Date         Year-to-Date          Year-to-Date
                             [Enter this number on [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       Terminated by the
                                                                                                                    Cumulative        Average Number of
         Month & Year              First Day of Each      Last Day of Each             Turnover Rate Per
                                                                                                                    Terminations      CNA Staff Employed
                                          Month                 Month                       Month
                                                                                                                    Year-to-Date         Year-to-Date
                                 [Enter this number on [Enter this number on
                                      the website]          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

								
To top