We Offer Paper Writing Services on all Disciplines

Make an Order Now and we will be Glad to Help

Order Now



Ask an expert to help you with your homework

We are ready to assist you anytime.

Order Now

appropriate hours and shifts

Sheet1

Assignment 1 Available Actual
Student Answer Sheet: Complete each section as indicated. Points Points
When creating formulae, feel free to place “constant” numbers in separate cells (e.g. in the first section, you may wish to put 8, 40, and 80 in H7, H8, H9 to use the cell identifier in your formulae.)
Calculating Hours and Shifts: 10 points
Insert formulae to calculate appropriate hours and shifts
FTEs ONE WEEK HOURS ONE WEEK SHIFTS ONE PAY PERIOD HOURS ONE PAY PERIOD SHIFTS
0.2 8 1 16 2
0.4 2
0.6 2
0.8 2
1 2
2 2
Calculating Worked FTEs: 5 points
Insert formulae to calculate missing shifts and FTEs. Format FTE to 1 decimal
STAFF S M T W T F S SHIFTS FTEs
NM 0 1 1 1 1 1 0 5 1.0
RN 5 6 6 6 6 6 5 1
LVN 4 3 3 3 3 3 4 1
NA 4 4 4 4 4 4 4 1
US 1 1 1 1 1 1 1 1
TOTAL 14 15 15 15 15 15 14 1
Calculating NHPPD: 2.5 points:
Insert formula in C29 to calculate NHPPD; format to 2 decimal places
Unit 3A
# 8 hr. shifts 98
# Pt. Days 61
NHPPD: 2.5
Calculating Caregiver (Variable) Hours: 2.5 points
Insert formula in C38 to calculate caregiver hours; format to 2 decimal places
Unit 3A Caregiver hours
RN Shifts 54
LVN Shifts 14
NA Shifts 13
Pt. Days 61
Caregiver Hours: 2.5
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 5
CNS 5
US 7
Pt. Days 61
Fixed Hours: 2.5
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 decimals
Number of non-worked 8-hour shifts per year:
Sick leave = 12 shifts per year 12
Vacation 10
Holiday 6
Training 3
Misc. 3
Total Shifts 2.5
Total Non-worked Hours 2.5
Calculating Paid FTEs: 7.5 points
Insert formulae to calculate Paid FTEs using PWR of : 1.18 where appropriate; format for 1 decimal
STAFF S M T W T F S SHIFTS WORKED FTEs PAID FTEs*
NM 0 1 1 1 1 1 0 5 1.0 0 2
RN 5 6 6 6 6 6 5 40 8.0 0 0.75
LVN 4 3 3 3 3 3 4 23 4.6 0 0.75
NA 4 4 4 4 4 4 4 28 5.6 0 0.75
US 1 1 1 1 1 1 1 7 1.4 0 0.75
TOTAL 14 15 15 15 15 15 14 103 20.6 0 2.5
Calculating the number of required positions: 4 points
Insert formulae to calculate the number of required positions (whole numbers)
STAFF S M T W T F S SHIFTS WORKED FTEs PAID FTEs POSITIONS (given: NM, CNS, RN)
NM 0 1 1 1 1 1 0 5 1 1 1
CNS 0 1 1 1 1 1 0 5 1 1 1
RN 2 3 3 3 3 3 2 19 3.8 4.48 4
LVN 3 3 3 3 3 3 3 21 4.2 4.96 1
NA 2 4 4 4 4 4 2 24 4.8 5.66 1
US 3 3 3 3 3 3 3 21 4.2 4.96 1
TOTAL 10 15 15 15 15 15 10 95 19 22.06 1
Putting it all Together
Staffing Pattern: 21 points
Complete the information for the following staffing pattern, by inserting formulae in appropriate cells. Assume:
Hours/shift: 8
PWR: 1.15
Pt. Days: 220 for one-week period
STAFF S M T W T F S SHIFTS WORKED PAID FTEs POSITIONS
FTEs*
NM 0 1 1 1 1 1 0 1.5
CNS 0 1 1 1 1 1 0 1.5
RN 6 6 6 6 6 6 6 3.5
LVN 2 3 3 3 3 3 2 3.5
NA 6 8 8 8 8 8 6 3.5
US 2 2 2 2 2 2 2 3.5
TOTAL 4
Calculation of NHPPD, Variable, and Fixed hours for staffing pattern above: 12 points
Insert formulae in D105, D107, and D109 to:
Calculate NHPPD: 4
Calculate Variable Hours: 4
Calculate Fixed Hours: 4
Determining Paid NHPPD: 12 points
Given the following data, insert formulae in cells I114, I115, and I116
PWR= 1.12
What is the Paid NHPPD with a Worked NHPPD of: 15 4
What are the Paid Caregiver Hours with Worked Caregiver Hours of: 7.25 4
What are the Paid Fixed Hours* with Worked Fixed Hours of: 1.6 4
*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:
Standard Adj. Acuity
Patient Volume 12500 12500
NHPPD 6.62 6.62
Acuity Level (in RVU) 0 3
A. How many FTEs are needed to care for this patient volume (in column labeled Standard)? 5
B. What is the difference between the number of FTE needed for the actual volume, when acuity is taken into consideration? 11
Total Points 100 0

&P

Sheet2

Sheet3

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Get started

How it works

Place an order

Select the paper type, page limit, discipline, and format, and then set the deadline. Specify your paper instructions and attach the additional materials.

Track the progress

Check the finished parts of the paper and ask for amendments if necessary. Use the online chat for quick communication with the writer

Receive a paper

Release the payment when you are fully satisfied with the work. Leave feedback to share your experience with our writer.

Why our online essay writing service?

All types of paper writing help

Whether you need an essay, research paper, or dissertation, We have you covered. Our writers can create any kind of academic writing. Also, we can rewrite and edit your papers.

24/7 support

If you have questions about our service or need additional details to make a request, our friendly customer support will get your issues resolved.

On time delivery

Punctuality is our second name. Your order will be delivered strictly within the deadline. If you have an urgent order, we can do it! Our writers will need at least three hours to complete it.

Let us cover any of your writing needs!

Academic Paper Writing Service

Our best writers will gladly help you with:

Coursework / Homework

  • Homework Assignment
  • Engineering Assignment
  • Statistics Assignment
  • Biology Assignment
  • Nursing Assignment
  • Chemistry Assignment

Paperwork

  • Essay
  • Term Paper
  • Research Paper
  • Thesis / Dissertation
  • Research Proposal
  • Editing and proofreading

Others

  • Multiple Choice Questions
  • Short Answer Questions
  • Word Problems
  • Programming Assignment
  • Article Writing
  • Mathematics Calculations