9:54 7

. LTE

Done Module 3 staffing assignment...

Calculating Fixed Hours: 2.5 points

Insert formula in C47 to calculate fixed hours; format to 2 decimal places

3A: # of shifts for Nurse Manager, Clin. Spec., & Unit Secretaries

NM

CNS

US

Pt. Days

Fixed Hours:

2.23

Calculating Non-worked Hours: 5 points

Insert formula in B58 to calculate the sum of non-worked shifts;

Then, insert a formula in B59 to calculate the number of non-worked hours; format with 0 decimal

Number of non-worked 8-hour shifts per year:

Sick leave = 12 shifts per year

Vacation

10

Holiday

Training

Misc.

3

Total

34 Shifts

Total

272 Non-worked Hours

Calculating Paid FTEs: 7.5 points

Insert formulae to calculate Paid FTEs using PWR of :

STAFF

1.18 where appropriate; format for 1 decimal

SHIFTS WORKED

FTEs

PAID

NM

FTEs*

RN

1.0

LVN

8.0

NA

US

TOTAL

103

14

6.6

1.7

20.6

24.3

Calculating the number of required positions: 4 points

Insert formulae to calculate the number of required positions (whole numbers)

STAFF

SHIFTS WORKED PAID

FTEs

FTEs

POSITIONS

(given: NM,

NM

CNS, RN)

CNS

RN

LVN

4.48

NA

4.96

US

TOTAL

4.2

3.66

19

4.96

22.06

Putting it all Together

Staffing Pattern: 21 points

Hours/shift:

Complete the information for the following staffing pattern, by inserting formulae in appropriate cells. Assume:

8

PWR:

1.15

Pt. Days:

220 for one-week period

STAFF

SHIFTS WORKED PAID

POSITIONS

NM

FTEs*

FTEs

CNS

RN

LVN

8.4

3.8

9.66

NA

4.37

US

10.4

137

2.8

11.96

TOTAL

27.4

3.22

31.21

Calculation of NHPPD, Variable, and Fixed hours for staffing pattern above: 12 points

Insert formulae in D105, D107, and D109 to:

Calculate NHPPD

4.98

Calculate Variable Hours:

4.11

Calculate Fixed Hours:

0.87

Determining Paid NHPPD: 12 points

PWR-

Given the following data, insert formulae in cells I114, 1115, and 1116

1.12

What is the Paid NHPPD with a Worked NHPPD of:

15

What are the Paid Caregiver Hours with Worked Caregiver Hours of:

16.8

7.25

What are the Paid Fixed Hours* with Worked Fixed Hours of:

1.6

8:12

1.79

*These fixed hours are for staff who are replaced

Effect of Acuity: Part A=5 points: Part B=11 points

Insert formulae into cells J125 and J126 to answer the questions below:

Patient Volume

Standard Adj. Acuity

12500

12500

NHPPD

2080

6.62

6.62

Acuity Level (in RVU)

A. How many FTEs are needed to care for this patient volume (in column labeled Standard)?

39.784

B. What is the difference between the number of FTE needed for the actual volume, when acuity is taken into

consideration?

79.57

Total Points