Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose you are a member of the senior leadership team for this hospital. Based on the elements of contribution margin presented for each service, which

Suppose you are a member of the senior leadership team for this hospital. Based on the elements of contribution margin presented for each service, which service line(s) would you recommend? Why would you choose the particular service(s)? What would you estimate as the incremental impact for 10% growth in your chosen service line? Incremental impact = (incremental revenue incremental variable cost)

image text in transcribed

Service Line Report - Monthly INPATIENT CASES Cardiology General Medical General Surgery # Cases 411 369 538 Net Revenue $ 2,521,485 $ 1,607,364 $ $ 4,646,706 $ Avg. Net per Case . $ 6,135 5 4,356 s 8,637 S Neurology 125 526,875 $ 4,215 S Orthopedic 236 2,105,828 $ 8,923 $ Pulmonary 453 2,648,691 $ 5,847 $ Tota! 2,132 14,056,949 6,593 DIRECT - Variable Costs Staffing Supplies Avg. Variable Cost/Case Contribution Margin Avg Contribution/Case $ $ $ 1,039,745 $ 586,908 $ 3,957.79 $ 905,942 $ 332,100 $ 3,355.13 $ 1,545,597 $ 1,263,224 $ 5,220.86 $ 1,837,885 $ 3,416.14 $ 293,227 $ 100,000 $ 3,145.82 $ 133,648 $ 1,069.18 S 364,714 $ 1,227,200 $ 6,745.40 $ 513,914 $ 2,177.60 $ 1,159,425 $ 345,639 $ 3,322.44 $ 5,308,650 3,855,071 4,298.18 $ $ 894,832 $ 2,177.21 $ 369,322 $ 1,000.87 S 1,143,627 $ 2,524.56 $ 4,893,228 2,295.14 DIRECT - Fixed Costs Avg Personnel Other Fixed Expenses Avg. Direct Fixed Cost/Case . $ $ $ 120,000 $ 578,330 $ 1,699.10 $ 80,000 $ 519,231 $ 1,623.93 $ 150,000 $ 757,036 $ 1,685.94 $ 110,000 $ 175,891 $ 2,287.13 $ 140,000 $ 332,083 $ 2,000.35 $ 130,000 $ 637,430 $ 1,694.11 $ 730,000$ 342 3,000,000 $1,407 1,749.53 INDIRECT - Fixed Costs (Overhead) Administration & HR Building Depreciation $ 167,932 11,000 11,066 151,949 15,000 232,417 25,000 55,596 9,000 Allocated Costs 850,000 by variable FTES) 100,000 (by square footage) 54,843 21,000 187,262 19,000 Total Cost Avg Total Cost/Case $ $ 2,503,915 $ 6,092.25 $ 2,004,222 $ 5,431.50 $ 3,973,274 $ 7,385.27 S 743,715 $ 5,949.72 s 2,139,840 $ 9,067.12 S 2,478,756 $ 5,471.87 S 13,843,721 6,493.30 Net Income Avg Net Income/Case $ $ 17,570 $ 42.75 $ (396,858) $ (1,075.50) $ 673,432 $ 1,251.73 $ (216,840) $ (1,734.72) $ (34,012) $ (144.12) $ 169,935 $ 375.13 $ 213,228 100.01 23.06 159,768 Variable Costs average wk hours/patient day total hours hourly rate - direct variable staff FTES - direct variable benefit factor supply cost per 24 31,565 27 15.18 18 28,561 26 13.73 29 43,686 29 21.00 22 10,450 23 5.02 28 10,308 29 4.96 21 35,198 27 16.92 76.81 1.22 1,808 $ 1,428 $ 900 $ 2,348 $ 800 $ 5,200 $ 763 $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Facilities Managers Reference Management Planning Building Audits Estimating

Authors: Harvey H. Kaiser

1st Edition

0876291426, 978-0876291429

More Books

Students also viewed these Accounting questions

Question

The nature and importance of the global marketplace.

Answered: 1 week ago