Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve those questions in the picture on excel sheet Current Month Grayson General Hospital Budget Report - June 2020 Jun20 Year To Date 2020

please solve those questions in the picture on excel sheet
image text in transcribed

Current Month Grayson General Hospital Budget Report - June 2020 Jun20 Year To Date 2020 Annualized Projection 2019 Budget to Actual Inpatient stays Inpatient Revenue Outpatient Procedures Outpatient Revenue Total Reve nue Operating Expenses Inpatient Labor (fixed costs) Inpatient Supplies (variable costs) Total Inpatient Expenses Outpatient Labor (fixed costs) Outpatient Supplies (variable costs) Total Outpatient Expenses Total Operating Expenses Net Income Loss 1,250 S 293,750 $475,000 $137,500 $55,000 $192,500 - 201 250 Budget 2,500 S 250,000 $500,000 S 150,000 $50,000 S 200,000 - 425000 Variance $272,500 250 $43,750 SS16,250 $125,000 -$25,000 S 100,000 -$12,500 S 5,000 -$7,500 Sg2,soo 223 750 % Variance 16.0% 21.8% 25.0% 17.5% 21.1% 10.2% 10.0% -52.6% 17,400 7,500 $825,000 $330,000 - 1 207 soo Budget 15,000 S goo,ooo $300,000 - 2550000 Variance 1,500 $262,500 $750,000 -S 150,000 S 600,000 -S 75,000 $30,000 -$45,000 S 555,000 1 42 soo % Variance 16.0% 218% 25.0% 17.5% 21.1% 10.2% 10.0% -52.6% 34,800 15,000 $660,000 - 2415000 Budget so,ooo 12,000 600,000 - 5100000 Variance % Variance 31,320 13,500 $ sg4,ooo - 2173 soo Budget 28,500 11,400 $570,000 - sooo Variance % Variance 4,800 $525,000 -$300,000 -S 150,000 60,000 -Sgo,ooo 2 685 ooo 16.0% 218% 25.0% 17.5% 21.1% 10.2% 10.0% -52.6% 2,820 2,100 $322,500 $615,000 -$570,000 $45,000 -$225,000 $24,000 -S 201,000 -$156,000 2 671 soo 15.4% 18.4% 11.3% 14.7% -10.0% -13.2% -55.1% 2019 In pnce $525 361.21 2019 out pnce $235 191.00 nt Break Even VC sto SIE .79 40,365 nt Break Even VC sto $44.00 7,775 Review the attached budget report that includes current month, YTD, the annualized YTD projections, and the prior year actuals to use for trending purposes. I-Jse the 2021 worksheet/tab to build a budget for 2021 based on the assumptions listed below. Include the 2020 & 2019 YTD Actual as well. Assumptions: 1) The # of stays or procedures will increase by 5% for both Inpatient days and Outpatient procedures 2) The revenue per stay or procedure will decrease by 1% 3) Both the labor & the supply costs will increase by 2% 4) What is the break even point for both inpatient and outpatient for the projected annualized 2020? For 2021 ?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Introduction to Corporate Finance What Companies Do

Authors: John Graham, Scott Smart

3rd edition

978-1111222284

Students also viewed these Accounting questions