Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Look at the PRIOR YEAR-TO-DATE section: 1.If I look at the Total Surgery row , I can see that I am down 10.4% or 361

image text in transcribed

Look at the PRIOR YEAR-TO-DATE section:

1.If I look at the Total Surgery row, I can see that I am down 10.4% or 361 cases compared to last year.The variance that indicate a negative indicator is in red font.I would want to look into why I am loosing volume.If I have market research data, I would ask if the entire volume in the community is down.If so, by what percent.If the market in the area is stable, you would conclude that you are losing market share.

Now look at the PROJECTED YEAR-TO-DATE section:

1.If I look at ALOS (Average Length of Stay) row, I can see that I am projected to be at an average of 3.83 days, and I am running at 3.85.Would you assume that we are doing well?The answer is "no".We are close, but in a big organization, every .1 variance in length of stay can equate to a $500,000 in revenue!!This is because if you assume that all patients are paid a flat amount for their stay, as Medicare does for the lives that they cover, every day is more cost to you, and you do not get paid any more money.

You can see that there is a lot of information that can be obtained from a dashboard.Please refer to the dashboard, and answer the following questions:

Look at the PROJECTED MONTH END section:

1.Looking at total revenue, is Local Hospital beating budget?By what percent?

2.In many cases, hospitals are paid the same amount for a patient if they are in the hospital for 3 days or 4 days, because they are paid by the diagnosis.

With that information, would you say that Local Hospital is doing a good job with ALOS (average length of stay)? Why?

Look at the PRIOR YEAR-MONTH END section:

1.From a total revenue perspective, is Local Hospital doing better or worse than last year? By what percent?

Look at the TOP HALF OF THE DASHBOARD:

1.Are OP Surgery Cases above or below budget on a projected year to date basis? By what percent?

2.Have OP Surgery Cases grown in volume over last year?By what percent?

3.Are ED visits projected to be above budget for the month?Are they projected to be above budget for the year?

4.Imagine that there is another hospital within one mile of Local Hospital. Market data has shown that the annual number of ED visits in the community is unchanged.When you look at the prior year to date ED visits, would you say that Local Hospital is gaining market share or losing it?Why would you say that?

5.If you knew that surgical volume in the community was constant to last year, would you say that Local Hospital is gaining or losing market share?

6.Looking at total revenue, would you say that Local Hospital has a better projected month end, compared to budget, than have had related to the rest of the year?Why would you say that?

Using the 4 GRAPHS ON THE BOTTOM HALF OF THE PAGE:

1.What is the one area that you would focus your attention on improving?

image text in transcribed
Local Hospital Daily Operations Dashboard Admissions - 11/11 19 Obs Patients - 11/11 Daily Operations Dashboard Projections as of : 11/11/2020 all $'s in 000's Projected Month End Prior Year-Month End Projected Year-to-Date Prior Year-to-Date Var Fav/ 96 Fav/ Growth/ Growth/ Var Fav/ 96 Fav/ Growth/ Growth/ VOLUME: Actual Budget (Unf) (Unf) Actual (Decline) (Decline) Actual Budget (Unf) (Unf) Actual (Decline) (Decline) Discharges 471 461 10 2.296 477 1.396) 5,349 5,320 29 0.5%% 5,436 (87 (1.696) Patient Days 1,849 1,740 109 5.39% 1,822 27 1.59% 20,580 20,352 228 1.1% 20,377 203 1.0%% ALOS 3.93 3.77 (0.16) (4.296) 3.82 (0.11) (2.996) 3.85 3.83 (0.02) (0.596) 3.75 (0.10) (2.796) Observation Days 233 159 74 46.5%% 232 1 0.496 3,394 2,344 1,050 44.89% 2,611 783 30.0%% Adj Discharges 945 907 38 4.296 894 51 5.796 10,850 10,297 553 5.496 10,756 94 0.9%% IP Surgery Cases 100 122 (22) (18.096) 110 (10) (9.196) 1,162 1,353 (191) (14.196) 1,274 (112) (8.896) OF Surgery Cases 175 235 (60) (25.596) 185 (10) (5.496) 1,948 2,253 (305) (13.56) 2,197 (249 (11.396) Total Surgery 275 357 (82) (23.096) 295 (20) (6.896) 3,110 3,606 (13.896) 3,471 (361 [10.496) ED - Visits 3,200 3,035 165 5.496 3,198 2 0.196 33,682 34,112 (430) (1.396) 37,841 (4,159) (11.06) IP Revenue $18,006 $15,857 $2,149 13.696 $16,706 51,300 7.89% $196,784 $183,886 $12,898 7.09% $181,147 $15,638 8.69% OF Revenue $18,107 $15,309 $2,797 18.396 $14,559 $3,548 24.496 $200,048 $169,407 $30,641 18.19% $173,702 $26,346 15.29% Total Revenue $36,112 $31,166 $4,946 15.9%% $31,264 $4,848 15.596 $396,833 $353,293 $43,539 12.356 $354,849 $41,984 11.896 Hospital Specific Stats Projected Month End Discharges / Adj Discharges Surgery Cases ED Visits Gross Revenue 1,200 300 3,500 246 1000 250 3250 20% 18.3% 800 200 3000 1696 13.6% 12% 600 150 2750 8% 400 100 2500 496 200 50 2250 Decharges Adj Died ages PSunERY OPSurgery ED-VSE IP Revenue OP Revenue Budget 451 Budget 235 3,085 46 Achel 471 915 Actuel 100 175 3,200 896

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

Criminal Law Directions

Authors: Nicola Monaghan

7th Edition

0192855379, 978-0192855374

More Books

Students also viewed these Law questions

Question

14. Now reconcile what you answered to problem 15 with problem 13.

Answered: 1 week ago