health homework

R0r0

Worksheet4-TurnoverRates.xls

Home >English homework help >health homework

INSTRUCTIONS

PLEASE NOTE THAT DATA ENTRY IS ONLY ALLOWED IN THE GRAY AREAS.

Click here to begin Worksheet 4 - Turnover Rates

Turnover Rates

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.

OVERALL FACILITY TURNOVER STATISTICS

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of Employees-

0.00

Total # of ALL Terminations (for same period)

OVERALL Turnover Rate- (# Term/Ave. # of Employees)

0.00%

To calculate RN Turnover Rate, indicate the total number of RNs on the last day of each month to be studied.

RN Turnover Statistics

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of RNs-

0.00

Total # of RN Terminations (for same period)

RN Turnover Rate- (# RNs Term/Ave. # of RNs on payroll)

0.00%

To calculate LPN Turnover Rate, indicate the total number of LPNs on the last day of each month to be studied.

LPN Turnover Statistics

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of LPNs-

0.00

Total # of LPN Terminations (for same period)

LPN Turnover Rate- (# LPNs Term/Ave. # of LPNs on payroll)

0.00%

To calculate CNA Turnover Rate, indicate the total number of CNAs on the last day of each month to be studied.

CNA Turnover Statistics

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of CNAs-

0.00

Total # of CNA Terminations (for same period)

CNA Turnover Rate- (# CNAs Term/Ave. # of CNAs on payroll)

0.00%

These statistics reflect an automatic calculation of the statistics entered in the 3 categories above. (RN, LPN & CNA)

Nursing Staff Combined (RNs, LPNs and CNAs) Turnover Statistics

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of All Nursing Staff-

0.00

Total # of All Nursing Staff Terminations (for same period)

All Nursing Staff Turnover Rate-

0.00%

These statistics reflect an automatic calculation based on the statistics entered above. ("Overall Facility Statistics" minus "Nursing Staff Combined")

All Other Staff Turnover Statistics

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of All Other Staff-

0.00

Total # of All Other Staff Terminations (for same period)

All Other Staff Turnover Rate-

0.00%

User-Defined Turnover Calculators

The "calculators" below may be used to customize and help analyze turnover statistics. The "User-Defined" nature allows you to isolate statistics by such specifics as individual department, unit, or even specific job description.

To calculate Turnover Rate, indicate the total number of identified staff on the last day of each month to be studied. The data entered should ONLY be specific to the group of employees identified for this isolated table.

Enter the description of the specific group below.

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of identified staff-

0.00

Total # of Terminations (for same period)

Turnover Rate- (# Term/Ave. # of identified staff on payroll)

0.00%

Enter the description of the specific group below.

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of identified staff-

0.00

Total # of Terminations (for same period)

Turnover Rate- (# Term/Ave. # of identified staff on payroll)

0.00%

Enter the description of the specific group below.

JAN-

FEB-

MAR-

APR-

MAY-

JUNE-

JULY-

AUG-

SEPT-

OCT-

NOV-

DEC-

Total of monthly #s above-

Average # of identified staff-

0.00

Total # of Terminations (for same period)

Turnover Rate- (# Term/Ave. # of identified staff on payroll)

0.00%

&L&"Arial Narrow,Bold"&12&F&R&"Arial Narrow,Bold Italic"Enter Information ONLY IN the SHADED Cells. All others will be calculated automatically.

&L&8&A&C&"Arial Narrow,Regular"&P of &N

Turnover Rates

Benefit Level

#REF!

Job Codes / Departments

FTE Vacancy Rates

#REF!

Overall Employee Turnover Components