Calculating Employee Turnover

W
Description

Calculating Employee Turnover document sample

Document Sample
scope of work template
							        dcc0221d-fa96-4fb7-b9f9-2c1c5ad8df51.xls                                               Enter Information ONLY IN the SHADED Cells. All others will be calculated automatically.


     Facility Name-                                                                                                       Date Completed-



Turnover Rate                                                            Period Being Studied-
                   To calculate OVERALL FACILITY Turnover Rate, indicate the total number of
                  ALL Employees / ALL Departments on the last day of each month to be studied.
JAN-                   FEB-                MAR-            APR-             MAY-               JUNE-
JULY-                  AUG-                SEPT-           OCT-             NOV-               DEC-                             OVERALL FACILITY
Total of monthly #s above-                                     0                                                              TURNOVER STATISTICS
Average # of Employees-                                    #DIV/0!
Total # of ALL Terminations (for same period)
OVERALL Turnover Rate- (# Term/Ave. # of Employees)        #DIV/0!
                            To calculate RN Turnover Rate, indicate the total number of
                                  RNs on the last day of each month to be studied.
JAN-                   FEB-                  MAR-             APR-              MAY-             JUNE-
JULY-                  AUG-                  SEPT-            OCT-              NOV-             DEC-
Total of monthly #s above-                                       0
                                                                                                                                RN Turnover Statistics
Average # of RNs-                                             #DIV/0!
Total # of RN Terminations (for same period)
RN Turnover Rate- (# RNs Term/Ave. # of RNs on payroll)       #DIV/0!
                           To calculate LPN Turnover Rate, indicate the total number of
                                 LPNs on the last day of each month to be studied.
JAN-                   FEB-                  MAR-             APR-              MAY-             JUNE-
JULY-                  AUG-                  SEPT-            OCT-              NOV-             DEC-
Total of monthly #s above-                                       0
                                                                                                                               LPN Turnover Statistics
Average # of LPNs-                                            #DIV/0!
Total # of LPN Terminations (for same period)
LPN Turnover Rate- (# LPNs Term/Ave. # of LPNs on payroll)    #DIV/0!




        Turnover Rates                                                                1 of 3
        dcc0221d-fa96-4fb7-b9f9-2c1c5ad8df51.xls                                                   Enter Information ONLY IN the SHADED Cells. All others will be calculated automatically.


     Facility Name-                                                                                                           Date Completed-



Turnover Rate                                                               Period Being Studied-
                       To calculate OVERALL FACILITY Turnover Rate, indicate the total number of
                              To calculate CNA Turnover Rate, indicate the total number of
                      ALL Employees / ALL Departments on the last day of each month to be studied.
                                    CNAs on the last day of each month to be studied.
JAN-                   FEB-                 MAR-                APR-               MAY-              JUNE-
JULY-                  AUG-                 SEPT-               OCT-               NOV-              DEC-                           OVERALL FACILITY
                                                                                                                                  CNA Turnover Statistics
Total of monthly #s above-                                         0                                                              TURNOVER STATISTICS
Average # of CNAs-                                              #DIV/0!
Total # of CNA Terminations (for same period)
CNA Turnover Rate- (# CNAs Term/Ave. # of CNAs on payroll)      #DIV/0!
         These statistics reflect an automatic calculation of the statistics entered in the 3 categories above.
                                                   (RN, LPN & CNA)
JAN-              0      FEB-           0    MAR-         0     APR-          0     MAY-         0     JUNE-        0             Nursing Staff Combined
JULY-             0      AUG-           0    SEPT-        0     OCT-          0     NOV-         0     DEC-         0
Total of monthly #s above-                                          0
                                                                                                                                  (RNs, LPNs and CNAs)
Average # of All Nursing Staff-                                    0.00                                                             Turnover Statistics
Total # of All Nursing Staff Terminations (for same period)         0
All Nursing Staff Turnover Rate-                                 #DIV/0!
                These statistics reflect an automatic calculation based on the statistics entered above.
                             ("Overall Facility Statistics" minus "Nursing Staff Combined")
JAN-              0      FEB-            0     MAR-          0    APR-        0    MAY-         0    JUNE-          0
JULY-             0      AUG-            0     SEPT-         0    OCT-        0    NOV-         0    DEC-           0                    All Other Staff
Total of monthly #s above-                                           0                                                                 Turnover Statistics
Average # of All Other Staff-                                       0.00
Total # of All Other Staff Terminations (for same period)            0
All Other Staff Turnover Rate-                                    #DIV/0!




        Turnover Rates                                                                    2 of 3
         dcc0221d-fa96-4fb7-b9f9-2c1c5ad8df51.xls                                                        Enter Information ONLY IN the SHADED Cells. All others will be calculated automatically.


      Facility Name-                                                                                                                Date Completed-



Turnover Rate                                                                    Period Being Studied-
              To calculate OVERALL FACILITY Turnover Rate, indicate the total number of
                                                    The "calculators" below may be used to customize and help analyze turnover statistics. The "User-Defined" nature allows you to
    User-Defined Turnover Calculatorsthe last daystatistics by such specifics as individual department, unit, or even specific job description.
             ALL Employees / ALL Departments on     isolate
                                                            of each month to be studied.

                                                                                                                                            OVERALL FACILITY
To calculate Turnover Rate, indicate the total number of identified staff on the last day of each month to be studied. The data        TURNOVER STATISTICS
                                                                                                                                     Enter the description of the specific group below.
                entered should ONLY be specific to the group of employees identified for this isolated table.
JAN-                    FEB-                      MAR-             APR-                 MAY-                JUNE-
JULY-                   AUG-                      SEPT-            OCT-                 NOV-                DEC-
Total of monthly #s above-                                            0
Average # of identified staff-                                     #DIV/0!
Total # of Terminations (for same period)
Turnover Rate- (# Term/Ave. # of identified staff on payroll)       #DIV/0!


To calculate Turnover Rate, indicate the total number of identified staff on the last day of each month to be studied. The data
                                                                                                                                     Enter the description of the specific group below.
                entered should ONLY be specific to the group of employees identified for this isolated table.
JAN-                    FEB-                      MAR-             APR-                 MAY-                JUNE-
JULY-                   AUG-                      SEPT-            OCT-                 NOV-                DEC-
Total of monthly #s above-                                            0
Average # of identified staff-                                     #DIV/0!
Total # of Terminations (for same period)
Turnover Rate- (# Term/Ave. # of identified staff on payroll)       #DIV/0!


To calculate Turnover Rate, indicate the total number of identified staff on the last day of each month to be studied. The data
                                                                                                                                     Enter the description of the specific group below.
                entered should ONLY be specific to the group of employees identified for this isolated table.
JAN-                    FEB-                      MAR-             APR-                 MAY-                JUNE-
JULY-                   AUG-                      SEPT-            OCT-                 NOV-                DEC-
Total of monthly #s above-                                            0
Average # of identified staff-                                     #DIV/0!
Total # of Terminations (for same period)
Turnover Rate- (# Term/Ave. # of identified staff on payroll)       #DIV/0!



         Turnover Rates                                                                        3 of 3

						
Related docs