Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Look at the PRIOR YEAR-TO-DATE section: If I look at the Total Surgery row , I can see that I am down 10.4% or 361
Look at the PRIOR YEAR-TO-DATE section:
- 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:
- 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.
Local Hospital Daily Operations Dashboard 19 Admissions - 11/11 Obs Patients - 11/11 Daily Operations Dashboard Projections as of : 11/11/2020 Prior Year-to-Date all $'s in 000's Projected Month End Prior Year-Month End Projected Year-to-Date Var Fav/ % Fav/ Growth/ %Growth/ Var Fav/ VOLUME: Actual Budget (Unf) (Unf) Actual (Decline) (Decline) Actual Budget (Unf) Discharges 471 461 10 2.2% 477 (6) (1.3%) 5.349 5.320 29 Patient Davs 1.849 1.740 109 6.3% 1.822 27 1.5% 20.580 20.352 228 ALOS 3.93 3.77 (0.16) (4.2%) 3.82 (10.11) (2.9%) 3.85 3.83 10.02) Observation Days 233 159 74 46.5% 232 1 0.4% 3.394 2.344 1.050 Adi Discharges 945 907 38 4.2% 894 51 5.7% 10.850 10.297 553 IP Surgery Cases 100 122 (22) (18.0%) 110 (10) (9.1%) 1.162 1.353 (191) OP Surgery Cases 175 235 (60) (25.5%) 185 (10) (5.4%) 1.948 2.253 (305) Total Surgery 275 357 (82) (23.0%) 295 (20) (6.8%) 3.110 3.606 (496) ED - Visits 3.200 3.035 165 5.4% 3.198 2 0.1% 33.682 34.112 1430) IP Revenue $18.006 $15.857 $2.149 13.6% $16.706 $1.300 7.8% $196.784 $183.886 $12.898 OP Revenue $18.107 $15.309 $2.797 18.3% $14.559 $3.548 24.4% $200.0481 $169.407 $30.641 Total Revenue $36.112 $31 15.9% $4.848 15.5% 833 43.539 Hospital Specific Stats Projected Month End Discharges / Adj Discharges Surgery Cases ED Visits 1,200 300 3,500 % Fav/ (Unf) 0.5% 1.1% (0.5%) 44.8% 5.4% (14.1%) (13.5%) (13.8% (1.3%) 7.0% 18.1% 12.3% Actual 5.436 20.377 3.75 2.611 10.756 1.274 2.197 3.471 37.841 $181.147 $173.702 849 Growth/ (Decline) (87) 203 10.10) 783 94 (112) (249) (361) (4.159) $15.638 $26.346 $41 %Growth/ (Decline) (1.6%) 1.0% (2.7%) 30.0% 0.9% (8.8%) (11.3%) (10.4%) (11.0%) 8.6% 15.2% 11.8% Gross Revenue 24% 1,000 250 3,250 20% 18.3% 16% 800 200 3,000 13.6% 12% 600 150 2,750 8% 400 100 2500 4% 200 50 2,250 Discharges ED-Visits 0% AdiDischarges 907 IP Surgery 122 OP Surgery 235 IP Revenue OP Revenue Budget 461 3,035 4% Budget Actual Budget Actual Actual 471 945 100 175 3200 8% Local Hospital Daily Operations Dashboard 19 Admissions - 11/11 Obs Patients - 11/11 Daily Operations Dashboard Projections as of : 11/11/2020 Prior Year-to-Date all $'s in 000's Projected Month End Prior Year-Month End Projected Year-to-Date Var Fav/ % Fav/ Growth/ %Growth/ Var Fav/ VOLUME: Actual Budget (Unf) (Unf) Actual (Decline) (Decline) Actual Budget (Unf) Discharges 471 461 10 2.2% 477 (6) (1.3%) 5.349 5.320 29 Patient Davs 1.849 1.740 109 6.3% 1.822 27 1.5% 20.580 20.352 228 ALOS 3.93 3.77 (0.16) (4.2%) 3.82 (10.11) (2.9%) 3.85 3.83 10.02) Observation Days 233 159 74 46.5% 232 1 0.4% 3.394 2.344 1.050 Adi Discharges 945 907 38 4.2% 894 51 5.7% 10.850 10.297 553 IP Surgery Cases 100 122 (22) (18.0%) 110 (10) (9.1%) 1.162 1.353 (191) OP Surgery Cases 175 235 (60) (25.5%) 185 (10) (5.4%) 1.948 2.253 (305) Total Surgery 275 357 (82) (23.0%) 295 (20) (6.8%) 3.110 3.606 (496) ED - Visits 3.200 3.035 165 5.4% 3.198 2 0.1% 33.682 34.112 1430) IP Revenue $18.006 $15.857 $2.149 13.6% $16.706 $1.300 7.8% $196.784 $183.886 $12.898 OP Revenue $18.107 $15.309 $2.797 18.3% $14.559 $3.548 24.4% $200.0481 $169.407 $30.641 Total Revenue $36.112 $31 15.9% $4.848 15.5% 833 43.539 Hospital Specific Stats Projected Month End Discharges / Adj Discharges Surgery Cases ED Visits 1,200 300 3,500 % Fav/ (Unf) 0.5% 1.1% (0.5%) 44.8% 5.4% (14.1%) (13.5%) (13.8% (1.3%) 7.0% 18.1% 12.3% Actual 5.436 20.377 3.75 2.611 10.756 1.274 2.197 3.471 37.841 $181.147 $173.702 849 Growth/ (Decline) (87) 203 10.10) 783 94 (112) (249) (361) (4.159) $15.638 $26.346 $41 %Growth/ (Decline) (1.6%) 1.0% (2.7%) 30.0% 0.9% (8.8%) (11.3%) (10.4%) (11.0%) 8.6% 15.2% 11.8% Gross Revenue 24% 1,000 250 3,250 20% 18.3% 16% 800 200 3,000 13.6% 12% 600 150 2,750 8% 400 100 2500 4% 200 50 2,250 Discharges ED-Visits 0% AdiDischarges 907 IP Surgery 122 OP Surgery 235 IP Revenue OP Revenue Budget 461 3,035 4% Budget Actual Budget Actual Actual 471 945 100 175 3200 8%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started