Assignment 4 Productivity Workbook

xlsx

School

Humber College *

*We aren’t endorsed by this school

Course

3001

Subject

Economics

Date

Feb 20, 2024

Type

xlsx

Pages

9

Uploaded by SargentBook16495

Report
Assignment 4 Instructions Complete all your work in this Excel file You can add new work sheets Submit your assignment by the start of next week's class Submit your assignment via Blackboard Put your answers in the yellow cells do not touch any green cell
Solutions toProblem Set #4 Diagnostic Imaging Centre: Prices, activities, and costs Measure Year 1 Year 2 Year 3 Price ($) 883 886 880 Volume 6,277 6,102 5,553 Labor ($) 77,000 80,000 75,000 Materials ($) 2,900 3,100 2,750 Overhead ($) 6,700 7,000 6,500 1.1 Calculate the multifactor productivity ratios for each year Year 1 Year 2 Year 3 64.00 60.00 58.00 do not touch points 3 3 3 1.2 Conclusions about the productivity trend for the centre the productivity decreased over the years Do not touch points 1 Multiproductivity Ratios = [(Price*Volume)/(Labor + Materials + Overhead)]
Question 2 Measurement Year 1 Year 2 Year 3 Year 4 Price ($) $150 $140 $147 $145 Volume 17,557 16,387 18,555 19,336 Labor ($) $325,000 $275,000 $318,000 $307,000 Materials ($) $7,000 $6,750 $7,100 $7,250 Overhead ($) $28,000 $24,500 $28,600 $26,700 2.1 Calculate the Multifactor productivity ratios Year 1 Year 2 Year 3 Year 4 Multifactor Productivity Ratio 7.32 7.49 7.71 8.22 do not touch points 3 3 3 3 Q2.2: What do you observe about the clincs's productivity trend? The productivity increased over the years Do not touch points 1 The table below shows 4 years of cost and activity data for a paediatric asthma clinic. The centre does only one type of visit: wellness checks on children with asthma. Price is the revenue per visit that the clinic receives Volume is the number of visits they did in each year
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
Question 3 Q3.1 Multifactor productivity Year 1 Year 2 Year 3 Year 4 Patient Visits 6,926 7,438 6,656 7,607 Reimbursement per Visit $30 $29 $30 $30 Labor Costs $76,598 $53,738 $49,215 $63,684 Overhead Costs $67,023 $47,021 $43,063 $55,724 Materials Costs $47,874 $33,587 $30,759 $39,803 Year 1 Year 2 Year 3 Year 4 Multi-Factor Productivity 1.07 1.59 1.63 1.42 do not touch points 3 3 3 3 The table below shows 4 years of cost and activity data for a rehabilitation clinic. The centre does only one type of rehabilitation: rehabilitation following hip replacement surgery Reimbursement is the revenue per visit that the clinic receives
Question 4 Department Measurements General Surgery Neurosurgery Total Worked Hours 14,813 16,442 21,252 Surgical Cases 225 80 145 Resource Intensity Weights (weighted cases) 338 256 326 Reimbursement per Case $30.87 $51.60 $48.88 Overhead Costs $179,000 $194,000 $149,000 Materials Costs $292,000 $380,000 $234,000 Skill Mix Distribution by Labour Type Skill Mix Skill Mix Skill Mix Registered Nurse 0.61 0.42 0.42 Registered Practical Nurse 0.26 0.36 0.36 Personal Support Worker 0.13 0.22 0.22 4.1 Calculate the Case Mix Index for each surgical department General Surgery Neurosurgery Case Mix Index: weighted cases / cases 1.5 3.2 2.25 do not touch points 1 1 1 4.2 Calculate the total wage expense for each surgical department General Surgery Neurosurgery Registered Nurse hours 9,036 6,906 8,926 Registered Practical Nurse hours 3,851 5,919 7,651 Personal Support Worker hours 1,926 3,617 4,675 Registered Nurse cost $260,687 $199,228 $257,510 Registered Practical Nurse cost $67,784 $104,177 $134,653 Personal Support Worker cost $22,723 $42,683 $55,170 Total Labour Cost $351,194 $346,088 $447,333 do not touch points 2 2 2 4.3 Calculate the Total cost per weighted case for each surgical department General Surgery Neurosurgery Orthopaedic Surgery Orthopaedic Surgery Orthopaedic Surgery Orthopaedic Surgery The table below shows annual data for three surgical departments. The Director of the surgical program woul department. Total worked hours are the sum of all hours of labour by all provider types for the year Surgical cases are the number of surgeries in the year
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
Total Cost $822,194 $920,088 $830,333 Weighted cases 338 256 326 Cost per weighted case $2,436 $3,594 $2,545 do not touch points 2 2 2 Revenues 6945.75 4128 7087.6 0.0084478236417 0.0044865290433 0.0085358489058
Hourly wage $28.85 $17.60 $11.80 ld like to compare the productivity of each
mbursement * cases
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