question archive A Pediatrics Department became concerned about low morale and productivity of nursing staff after the chair of its General Pediatrics division left the organization due to retirement
Subject:StatisticsPrice:3.87 Bought7
A Pediatrics Department became concerned about low morale and productivity of nursing staff after the chair of its General Pediatrics division left the organization due to retirement. After a nine-month search, the Pediatrics Department was able to hire a specialized pediatrician chair for the General Pediatrics division and would like to evaluate the effect of the new leadership on productivity. Measurements before and after the new leadership took over are displayed in table below.
Measurement |
Before New Leadership |
After New Leadership |
Total Worked Hours |
16,062 |
14,813 |
Patient Visits |
11,826 |
12,113 |
Reimbursement Per Visit($) |
33 |
30.87 |
Overhead Costs($) |
28,546 |
29,831 |
Materials Costs($) |
94,421 |
58,447 |
Skill Mix Distribution |
||
RN($28.85/Hour) |
0.6 |
0.61 |
LPN($17.60/Hour) |
0.21 |
0.26 |
Other ($11.8/Hour) |
0.19 |
0.13 |
Assume That 1 LPN = .6 RN And 1 Other Nursing Staff = 0.4 RN. |
Solve using excel
a) Calculate the total worked hours/unadjusted patient visits before and after the new leadership.
b) Calculate the skill-mix-adjusted hours/unadjusted patient visits Before and After new leadership
c) Calculate the standardized labor costs of care/unadjusted patient visits before and after new leadership.
d) Calculate the multifactor productivity measure before and after new leadership.
Purchased 7 times