Question
all $'s in 000's Projected Month End Prior Year-Month End Projected Year-to-Date Prior Year-to-Date VOLUME: Actual Budget Var Fav/ (Unf) % Fav/ (Unf) Actual Growth/
all $'s in 000's | Projected Month End | Prior Year-Month End | Projected Year-to-Date | Prior Year-to-Date | |||||||||||||
VOLUME: | Actual | Budget | Var Fav/ (Unf) | % Fav/ (Unf) | Actual | Growth/ (Decline) | %Growth/ (Decline) | Actual | Budget | Var Fav/ (Unf) | % Fav/ (Unf) | Actual | Growth/ (Decline) | %Growth/ (Decline) | |||
Discharges | 471 | 461 | 10 | 2.2% | 477 | (6) | (1.3%) | 5,349 | 5,320 | 29 | 0.5% | 5,436 | (87) | (1.6%) | |||
Patient Days | 1,849 | 1,740 | 109 | 6.3% | 1,822 | 27 | 1.5% | 20,580 | 20,352 | 228 | 1.1% | 20,377 | 203 | 1.0% | |||
ALOS | 3.93 | 3.77 | (0.16) | (4.2%) | 3.82 | (0.11) | (2.9%) | 3.85 | 3.83 | (0.02) | (0.5%) | 3.75 | (0.10) | (2.7%) | |||
Observation Days | 233 | 159 | 74 | 46.5% | 232 | 1 | 0.4% | 3,394 | 2,344 | 1,050 | 44.8% | 2,611 | 783 | 30.0% | |||
Adj Discharges | 945 | 907 | 38 | 4.2% | 894 | 51 | 5.7% | 10,850 | 10,297 | 553 | 5.4% | 10,756 | 94 | 0.9% | |||
IP Surgery Cases | 100 | 122 | (22) | (18.0%) | 110 | (10) | (9.1%) | 1,162 | 1,353 | (191) | (14.1%) | 1,274 | (112) | (8.8%) | |||
OP Surgery Cases | 175 | 235 | (60) | (25.5%) | 185 | (10) | (5.4%) | 1,948 | 2,253 | (305) | (13.5%) | 2,197 | (249) | (11.3%) | |||
Total Surgery | 275 | 357 | (82) | (23.0%) | 295 | (20) | (6.8%) | 3,110 | 3,606 | (496) | (13.8%) | 3,471 | (361) | (10.4%) | |||
ED - Visits | 3,200 | 3,035 | 165 | 5.4% | 3,198 | 2 | 0.1% | 33,682 | 34,112 | (430) | (1.3%) | 37,841 | (4,159) | (11.0%) | |||
IP Revenue | $18,006 | $15,857 | $2,149 | 13.6% | $16,706 | $1,300 | 7.8% | $196,784 | $183,886 | $12,898 | 7.0% | $181,147 | $15,638 | 8.6% | |||
OP Revenue | $18,107 | $15,309 | $2,797 | 18.3% | $14,559 | $3,548 | 24.4% | $200,048 | $169,407 | $30,641 | 18.1% | $173,702 | $26,346 | 15.2% | |||
Total Revenue | $36,112 | $31,166 | $4,946 | 15.9% | $31,264 | $4,848 | 15.5% | $396,833 | $353,293 | $43,539 | 12.3% | $354,849 | $41,984 | 11.8% |
(prior year to date) 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.
(projected year to date) 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.
(projected month end) Looking at total revenue, is Local Hospital beating budget? By what percent?
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?
(prior year month end) From a total revenue perspective, is Local Hospital doing better or worse than last
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