I need help with completing a excel spread sheet for ex. 9.7

pnzvyyrj855
timer Asked: Jun 6th, 2016

Question Description

I have to complete the highlighted boxes for the 3 locations. I struggle with anything math related and could really use the help. 

Unformatted Attachment Preview

Solutions toProblem Set #4 EX9.1: a- What are Multi-productivity ratios for these years? Assumptions: (1) Each test represents an equal amount of output (2) Quality is constant Measurement Year 1 Year 2 880 883 Price ($) 5,583 6,312 Volume 75,000 77,000 Labor ($) 2,750 2,900 Materials ($) 6,500 6,700 Overhead ($) Year 1 Year 2 Year 3 886 6,129 80,000 3,100 7,000 Year 3 EX9.1: b- Conclusions about the productivity trend for the procedure: Solutions toProblem Set #4 EX9.4: Calculate the case-mix index for the following hospitals (Indexes marked with *) Patient classification Low level care Medium level care High level care Extreme care Average Direct care hours 3 6 9 12 Hospital 1 0.5 0.35 0.1 0.05 H1 Case Mix Index* Hospital 2 0.35 0.4 0.15 0.1 H2 Case Mix Index* Hospital 3 0.3 0.3 0.22 0.18 H3 Case Mix Index* Hospital 4 0.2 0.25 0.3 0.25 H4 Case Mix Index* EX 9.7 Annual Visits Annual Paid Hours (Work Hours) Step One -Calculate Case Mix & Adjusted visits Patient Classification (CPT) Initial visit Low-level care Medium-level care High-level care Direct Care Hours Weight (DC hrs/Avg DC Hours) Economic Equivalencies (Given Assumptions) Skill Mix Distribution Location 1 (Given) Case-mix Adjusted Visits Step Two - Calculate Adjusted Work Hours Specialists ($110/hr) General Practitioners ($85/hr) Nurse Practitioners ($45/hr) Annual Hours Worked (paid) Adjusted Work Hours Step Three - Calculate Total Salary Expense Skill Mix Distribution Location 1 Salary per Hour (Given) Specialists ($110/hr) General Practitioners ($85/hr) Nurse Practitioners ($45/hr) Annual Hours Worked (paid) Total Salary Expense Step Four - Calculate Hours of Direct Care for each location Patient Classification Initial visit Low-level care Medium-level care High-level care Hours of Direct Care Direct Care Hours Location 1 Distribution Ratios: a.Work hours/visits b.Adjusted work hours/visits c.Work hours/adjusted visits d.Adjusted work hours/adjusted visits e.Total salary expense/visits f. Total salary expense/adjusted visits g.Percent of hours in direct patient care h.Percent of adjusted work hours in direct patient care* i.Total salary expense/hours of direct patient care* j: *Use these measures for the final comparison among the three sites, and discuss potential problems at each s Location 1 135,000 115000 Location 1 Distribution Location 2 94,000 112000 Case Mix Index Location 1 Skill Mix Adjusted Hours Distribution Location 1 Location 2 (Given) Labor Cost (Location 1) Skill Mix Distribution Location 2 (Given) Location 3 101000 125000 Location 2 Distribution Case Mix Index Location 2 Location 3 Distribution Adjusted Hours Location 2 Skill Mix Distribution Location 3 (Given) Adjusted Hours Location 3 Labor Cost (Location 2) Skill Mix Distribution Location 3 (Given) Labor Cost (Location 3) Hours in Direct Care Location 1 Location 1 Location 2 Distribution Hours in Direct Care Location 2 Location 2 Location 3 Distribution Hours in Direct Care Location 3 Location 3 scuss potential problems at each site or overall for the company. What are your recommendations to correct them? Case Mix Index Location 3 to correct them?
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors