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.

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.

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