Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Patton - Fuller Community Hospital Nursing Statistics Jan Feb Mar Apr May Jun Number of Patients per day 428 428 396 339 293 242 Cost

image text in transcribedimage text in transcribedimage text in transcribed
Patton - Fuller Community Hospital Nursing Statistics Jan Feb Mar Apr May Jun Number of Patients per day 428 428 396 339 293 242 Cost of nurse per hour w/benefits 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 Cost of nurse per 24hour day 720.00 $ 720.00 720.00 $ 720.00 $ 720.00 S 720.00 Number of nurses per patient based on 5 patients per nurse or a "5 to 1" nursing ratio 0.2 Number of nurses per day 85.6 85.6 79.3 67.8 58.7 48.4 Nursing cost per day 61,648 $ 61,626 $ 57,071 $ 48,821 $ 42,233 S 34,840 Nursing cost per month 1,911,078 $ 1,725,532 $ 1,769,190 $ 1,464,623 $ 1,309,221 $ 1,045,194 Simulation: Effect of a $1 per hour raise for all nurses Cost of nurse per hour w/benefits 31.00 $ 31.00 $ 31.00 $ 31.00 $ 31.00 $ 31.00 744.00 $ 744.00 $ 744.00 $ 744.00 $ 744.00 S 744.00 Number of nurses per patient based on a ratio of 5 patients per nurse or a "5 to 1" nursing ratio 0.2 Number of nurses per day 85.6 85.6 79.3 67.8 58.7 48.4 Nursing cost per day 63,703 $ 63,680 $ 58,973 $ 50,448 $ $ 36,001 Nursing cost per month 1,974,781 $ 1,783,050 $ 1,828,163 $ 1,513,444 $ 1,352,862 $ 1,080,034 Increase in cost per month due to a $1 raise per nursing hour $ 63,702.62 $ 57,517.73 $ 58,973.00 $ 48,820.77 $ 43,640.71 $ 34,839.80 Simulation: Effect of changing to a "4 to 1" nursing ratio Number of nurses per day 0.25 107.0 107.0 99.1 84.8 73.3 60.5 Nursing cost per day (Nursing ratio of "4 to 1" and an hourly rate of $30 ) 77,060 $ 77,033 $ 71,338 $ 61,026 $ 52,791 $ 43,550 Nursing cost per month 2,388,848 $ 2,156,915 $ 2,211,487 $ 1,830,779 $ 1,636,527 S 1,306,493 Increase in cost per month due to a change in nursing ratio from 5 to 1 down to 4 to 1 S 477,770 $ 431,383 $ 442,297 $ 366,156 $ 327,305 $ 261,299Patton - Fuller Community Hospital Nursing Statistics Jul Aug Sep Oct Nov Dec Total Number of Patients per day 235 346 373 374 447 423 Cost of nurse per hour w/benefits 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 Cost of nurse per 24hour day 720.00 720.00 720.00 720.00 $ 720.00 S 720.00 Number of nurses per patient based on 5 patients per nurse or a "5 to 1" nursing ratio 0.2 Number of nurses per day 47.1 69.2 74.5 74.9 89.5 84.6 Nursing cost per day 33,884 49,811 53,672 53,919 64,413 60.910 Nursing cost per month 1,050,392 1,544,143 1,610,150 1,671,479 1,932,388 1,888,210 Simulation: Effect of a $1 per hour raise for all nurses Cost of nurse per hour w/benefits 31.00 $ 31.00 31.00 $ 31.00 $ 31.00 $ 31.00 744.00 744.00 $ 744.00 $ 744.00 $ 744.00 S 744.00 Number of nurses per patient based on a ratio of 5 patients per nurse or a *5 to 1" nursing ratio 0.2 Number of nurses per day 47.1 69.2 74.5 74.9 39.5 84.6 Nursing cost per day 35,013 $ 51,471 $ 55,461 $ 55,716 $ 66,560 S 62,940 Nursing cost per month 1,085,405 $ 1,595,615 $ 1,663,822 $ 1,727,195 $ 1,996,801 $ 1,951, 150 Increase in cost per month due to a $1 raise per nursing hour $ 35,013.05 $ 51,471.44 $ 53,671.66 $ 55,715.97 $ 64,412.93 $ 62,940.33 $ 630,720.01 Simulation: Effect of changing to a "4 to 1" nursing ratio Number of nurses per day 0.25 58.8 86.5 93.2 93.6 111.8 105.7 Nursing cost per day (Nursing ratio of "4 to 1" and an hourly rate of $30 ) 42,354 $ 62,264 $ 67,090 $ 67,398 $ 80,516 $ 76,137 Nursing cost per month 1,312,989 $ 1,930,179 $ 2,012,687 $ 2,089,349 $ 2,415,485 $ 2,360,262 Increase in cost per month due to a change in nursing ratio from 5 to 1 down to 4 to 1 $ 262,598 $ 386,036 $ 402,537 $ 417,870 $ 483,097 $ 472,052 $ 4,730,400Answer 2010 for $1 Budgeted Answer 2009 9% Change per for 4:1 Hour (Proj) From Nurse Raise 2009 Ratio for Projection Nurses 220,752 1% 223,591 227,690 ad benefits

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel Applications For Accounting Principles

Authors: Gaylord SmithBruce Walz

4th Edition

1133388027, 9781133388029

More Books

Students also viewed these Accounting questions

Question

4 What is specific in constructivist approach to group coaching?

Answered: 1 week ago

Question

1. To generate a discussion on the concept of roles

Answered: 1 week ago