View the step-by-step solution to:

Question

I am struggling to find my error. Can you please help?

alt="D7DBCC69-9EB4-42D4-80CA-5AA643B2A2B0.png" />208338F6-95DF-4ED6-BC6F-54039007115F.png085134CC-035B-4CE6-9EE6-B466661A810F.png

085134CC-035B-4CE6-9EE6-B466661A810F.png

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

208338F6-95DF-4ED6-BC6F-54039007115F.png

Safari File Edit View History Bookmarks Window Help
92% : Mon 3:50 PM
Q DE
DO . < >
uta.instructure.com
C
+
= 2198-NURS-5341-401 > Assignments > Module 3: Staffing Module Assignment (Excel Exercise)>
enshots
2019 Fall
Account
Submission Details
Grade: 84/ 100
Home
Show Rubric
nshots
Announcements
Dashboard
Module 3: Staffing Module Assignment (Excel Exercise)
Syllabus
Re-submit Assignment
9
Kerri Kincade submitted Oct 8 at 11:31am
Courses
Modules
Number or
Correct
WILLTCITOTS
ng '18
Assignments
Module 3 staffing assignment.xisx 19 KB
Required
ester
Positions
Groups
Grades
view longer
description
Discussions
Preview of Module 3 staffing assignment.xlsx
Calendar
Collaborations
21 to >20.9 pts
Page
> of 8
Staffing Pattern
20.9 to >0 pts
5/21 pts
Semester
<
3
view longer
Correct
with Errors
EP
Google Drive
description
nbox
Office 365
Calculating
12 to > 11.9 pts
11.9 to >0 pts
12 / 12 pts
My Media
NHPPD
Correct
with Errors
Studio
Variable, and
?
Media Gallery
Fixed Hours
Help
Course
TOTAL 14 15
15
view longer
Evaluations
15
Calculating the number of required positions: 4 points
description
UTA Libraries
Insert formulae to calculate the number of required po
STAFF
W
Determining
12 to > 11.9 pts
11.9 to >0 pts
12 / 12 pts
NM
Paid NHPPD
Correct
with Errors
CNS
view longer
RN
description
K
OCT 1
14
O
. ...
W

D7DBCC69-9EB4-42D4-80CA-5AA643B2A2B0.png

Page
<
3
> of 8
O
ZOOM
+
T
S
TOTAL 14 15 15
15
Calculating the number of required positions: 4 points
15 15 14 103 20.6 24.3
Insert formulae to calculate the number of required positions (whole numbers)
STAFF
s
SHIFTS
WORKED PAID
NM
ETC..
ETC.
CNS
RN
LVN
3.8
4.48
NA
4.2
4.96
US
4.8
5.66
4.2
4.96
TOTAL
19
Putting it all Together
22.06
Staffing Pattern: 21 points
Complete the information for the following staffing pattern, by inserting formulae in appropriate cells. Assume:
Hours/shift:
Theresa Mont
PWR:
1.15
Pt. Days:
incorrect
STAFF
S
220 for one-week period
M
w
S
SHIFTS WORKED
PAID
FTEs*
NM
FTEs
CNS
RN
LVN
8.4
9.66
NA
3.8
4.37
US
10.4
11.96
TOTAL
2.8
3.22
Calculation of NHPPD, Variable, and Fixed hours for staffing pattern above: 12 points
137
27.4
31.21
Insert formulae in D105, D107, and D109 to:
Calculate NHPPD:
Calculate Variable Hours:
4.98
Calculate Fixed Hours:

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes