Examples for Class updated

xlsx

School

Humber College *

*We aren’t endorsed by this school

Course

3001

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by SargentBook16495

Completed Table Measurements Unit A Unit B Annual Patient Days 14,000 10,000 given in the question Annual Hours Worked 210,000 180,000 given in the question Distribution of Hours by Provider Type Unit A Unit B PSW 0% 25% given in the question RPN 0% 30% given in the question RN 100% 45% given in the question Hours by provider type Unit A Unit B PSW 0 45,000 calculate RPN 0 54,000 calculate RN 210,000 81,000 calculate Total 210,000 180,000 calculate Weights PSW 0.5 0.5 given in the question RPN 0.8 0.8 given in the question RN 1.0 1.0 given in the question Adjusted inputs Unit A Unit B PSW 0 22,500 calculate RPN 0 43,200 calculate RN 210,000 81,000 calculate Adjusted worked hours 210,000 146,700 calculate Adjusted Hours per Patient Day 15.0 14.7 calculate

Student Table Measurements Unit A Unit B Annual Patient Days 14,000 10,000 given in the question Annual Hours Worked 210,000 180,000 given in the question Distribution of Hours by Provider Type Unit A Unit B PSW 0% 25% given in the question RPN 0% 30% given in the question RN 100% 45% given in the question Hours by provider type Unit A Unit B PSW 0 45,000 calculate RPN 0 54,000 calculate RN 210,000 81,000 calculate Total 210,000 180,000 calculate Weights PSW 0.5 0.5 given in the question RPN 0.8 0.8 given in the question RN 1.0 1.0 given in the question Adjusted inputs Unit A Unit B PSW 0 22,500 calculate RPN 0 43,200 calculate RN 210,000 81,000 calculate Adjusted worked hours 210,000 146,700 calculate Adjusted Hours per Patient Day 15.0 14.7 calculate

Example 4 Measurements Suburban Downtown Annual Visits 135,000 97,000 given in the question Annual Paid hours 115,000 112,000 given in the question Distribution of Hours by Provider Type Suburban Downtown Specialists 50% 30% given in the question General practitioners 30% 50% given in the question Nurse practitioners 20% 20% given in the question Hours by provider type Suburban Downtown Specialists 57,500 33,600 Calculate General practitioners 34,500 56,000 Calculate Nurse practitioners 23,000 22,400 Calculate Total 115,000 112,000 Calculate Cost per hour Specialists $110 $110 given in the question General practitioners $85 $85 given in the question Nurse practitioners $45 $45 given in the question Adjusted Labour Cost Suburban Downtown Specialists $6,325,000 $3,696,000 calculate General practitioners $2,932,500 $4,760,000 calculate Nurse practitioners $1,035,000 $1,008,000 calculate Adjusted labour cost $10,292,500 $9,464,000 calculate Labour cost per Visit $76 $98 calculate

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Student Table Measurements Suburban Downtown Annual Visits 135,000 97,000 given in the question Annual Paid hours 115,000 112,000 given in the question Distribution of Hours by Provider Type Suburban Downtown Specialists 50% 30% given in the question General practitioners 30% 50% given in the question Nurse practitioners 20% 20% given in the question Hours by provider type Suburban Downtown Specialists 57,500 33,600 Calculate General practitioners 34,500 56,000 Calculate Nurse practitioners 23,000 22,400 Calculate Total 115,000 112,000 Calculate Cost per hour Specialists $110 $110 given in the question General practitioners $85 $85 given in the question Nurse practitioners $45 $45 given in the question Adjusted Labour Cost Suburban Downtown Specialists $6,325,000 $3,696,000 calculate General practitioners $2,932,500 $4,760,000 calculate Nurse practitioners $1,035,000 $1,008,000 calculate Adjusted labour cost $10,292,500 $9,464,000 calculate Labour cost per Visit $76 $98 calculate

Completed Table Student Table Activity in patient days Hospital A Hospital B Activity in patient days Hip Replacement 2,000 8,000 given in the question Hip Replacement Renal Failure 8,000 2,000 given in the question Renal Failure Total 10,000 10,000 given in the question Total Service intensity Service intensity Hip Replacement 3 3 given in the question Hip Replacement Renal Failure 7 7 given in the question Renal Failure Average 5 5 Calculate Average Service intensity weights Service intensity weights Hip Replacement 0.6 0.6 Calculate Hip Replacement Renal Failure 1.4 1.4 Calculate Renal Failure Average 1.0 1.0 Calculate Average Hospital A Hospital B Hip Replacement 1,200 4,800 Calculate Hip Replacement Renal Failure 11,200 2,800 Calculate Renal Failure Total 12,400 7,600 Calculate Total Nursing hours per day Nursing hours per day Nursing hours per day Nursing hours per day Weighted adjusted patient days Weighted adjusted patient days

Hospital A Hospital B 2,000 8,000 given in the question 8,000 2,000 given in the question 10,000 10,000 given in the question 3 3 given in the question 7 7 given in the question 5 5 Calculate 0.6 0.6 Calculate 1.4 1.4 Calculate 1.0 1.0 Calculate Hospital A Hospital B 1,200 4,800 Calculate 11,200 2,800 Calculate 12,400 7,600 Calculate Nursing hours per day Nursing hours per day Nursing hours per day Nursing hours per day

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Completed Table Measurements Unit A Unit B Annual Patient Days 14,000 10,000 given in the Annual Hours Worked 210,000 180,000 given in the Unit A Unit B Tonsillectomy 0.5 0.5 given in the Hip replacement 1.5 1.5 given in the Stroke 4 4 given in the Heart transplant 6 6 given in the Average 3 3 Calculate Patient Mix Unit A Unit B Tonsillectomy 15% 15% given in the Hip replacement 25% 30% given in the Stroke 35% 40% given in the Heart transplant 25% 15% given in the Total 100% 100% given in the Weights Unit A Unit B Tonsillectomy 0.17 0.17 Calculate Hip replacement 0.50 0.50 Calculate Stroke 1.33 1.33 Calculate Heart transplant 2.00 2.00 Calculate Unit A Unit B CMI 1.12 1.01 Calculate Weighted Days Unit A Unit B Tonsillectomy 350 250 Hip replacement 1,750 1,500 Stroke 6,533 5,333 Heart transplant 7,000 3,000 Total Weighted Days 15,633 10,083 Total Days 14,000 10,000 CMI 1.12 1.01 Case Mix Group (care hours per day) this is the distribution of each unit's total patient days by patient type (can also express this in percentages) this measures the service intensity of each patient type to the average of all patient types. Eg. type 4 has a weight of 2.0 because it has 6 hours per day compared to the average of 3 hours.

Student Table Measurements Unit A Unit B e question Annual Patient Days 14,000 10,000 given in the question e question Annual Hours Worked 210,000 180,000 given in the question Unit A Unit B e question Tonsillectomy 0.5 0.5 given in the question e question Hip replacement 1.5 1.5 given in the question e question Stroke 4 4 given in the question e question Heart transplant 6 6 given in the question Average 3 3 Calculate Service Mix Unit A Unit B e question Tonsillectomy 15% 15% given in the question e question Hip replacement 25% 30% given in the question e question Stroke 35% 40% given in the question e question Heart transplant 25% 15% given in the question e question Total 100% 100% given in the question Weights Unit A Unit B Tonsillectomy 0.17 0.17 Calculate Hip replacement 0.50 0.50 Calculate Stroke 1.33 1.33 Calculate Heart transplant 2.00 2.00 Calculate Unit A Unit B CMI Calculate Weighted Days Unit A Unit B Tonsillectomy 350 250 Hip replacement 1,750 1,500 Stroke 6,533 5,333 Heart transplant 7,000 3,000 Total Weighted Days 15,633 10,083 Total Days 14,000 10,000 CMI 1.12 1.01 Patient Acuity Level (care hours per day)