Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Review the attached monthly budget report from General Hospital. Identify the line items that are variances from the budget, use the rates per UOS to
Review the attached monthly budget report from General Hospital. Identify the line items that are variances from the budget, use the rates per UOS to help analyze and mark whether the line item was F-favorable or U-unfavorable, analyze the reason/s for the variance and write up a variance report for your boss including some ideas of what you could do to get back to budget. Review both the current month and the Year to Date in your evaluations. Use the SBAR method for writing up your variance and recommendations to get back to budget.
General Hospital-Sample Budget Report | ||||||||||
Monthly Revenue and Expense Report | Respiratory Therapy-31677200 | |||||||||
For the Month Ended March 31, 2015 | Year to Date - March 31, 2015 | |||||||||
Mar-15 | Mar-15 | Mar-15 | Mar-15 | Mar-15 | Mar-15 | Mar-15 | Mar-15 | |||
Account Description | Actual | Budget | Variance | Variance % | Actual | Budget | Variance | Variance % | ||
Revenue | ||||||||||
Inpatient Revenue | 2,088,635 | 1,555,433 | 533,202 | 34.3% | 5,749,533 | 4,666,299 | 1,083,234 | 23.2% | ||
Outpatient Revenue | 117,077 | 123,212 | -6,135 | -5.0% | 365,542 | 369,636 | -4,094 | -1.1% | ||
Total Revenues | 2,205,712 | 1,678,645 | 527,067 | 31.4% | 6,115,075 | 5,035,935 | 1,079,140 | 21.4% | ||
Volume | ||||||||||
Inpatient Volume (UOS) | 10,443 | 7,777 | 2,666 | 34.3% | 28,748 | 23,331 | 5,416 | 23.2% | ||
Outpatient Volume (UOS) | 520 | 548 | -27 | -5.0% | 1,625 | 1,643 | -18 | -1.1% | ||
Total Volume | 10,964 | 8,325 | 2,639 | 31.7% | 30,372 | 24,974 | 5,398 | 21.6% | ||
Direct Expenses | ||||||||||
Salaries and Wages | 539,977 | 376,898 | 163,079 | 43.3% | 1,495,821 | 1,130,694 | 365,127 | 32.3% | ||
Employee Benefits | 119,796 | 99,615 | 20,181 | 20.3% | 331,854 | 298,845 | 33,009 | 11.0% | ||
Contract Labor (Agency) | 66,664 | 8,333 | 58,331 | 700.0% | 149,994 | 24,999 | 124,995 | 500.0% | ||
Medications | 112,569 | 95,086 | 17,483 | 18.4% | 337,707 | 285,258 | 52,449 | 18.4% | ||
Medical Supplies | 185,949 | 173,849 | 12,100 | 7.0% | 557,847 | 521,547 | 36,300 | 7.0% | ||
Other Supplies | 1,516 | 2,070 | -554 | -26.8% | 4,548 | 6,210 | -1,662 | -26.8% | ||
Utilities | 79 | 48 | 31 | 64.6% | 237 | 144 | 93 | 64.6% | ||
Maintenance and Repairs | 965 | 4,685 | -3,720 | -79.4% | 2,895 | 14,055 | -11,160 | -79.4% | ||
Purchased Services | 14,751 | 17,747 | -2,996 | -16.9% | 44,253 | 53,241 | -8,988 | -16.9% | ||
Lease and Rental | 3,391 | 5,529 | -2,138 | -38.7% | 10,173 | 16,587 | -6,414 | -38.7% | ||
Other Expenses | 863 | 2,398 | -1,535 | -64.0% | 2,589 | 7,194 | -4,605 | -64.0% | ||
Total Direct Expenses | 1,046,520 | 786,258 | 260,262 | 33.1% | 2,937,918 | 2,358,774 | 579,144 | 24.6% | ||
Allocated Expenses | ||||||||||
Facility, Medical Ed, Billing, etc. (Allocated Expenses) | 557,204 | 504,932 | 52,272 | 10.4% | 1,671,612 | 1,514,796 | 156,816 | 10.4% | ||
Total Operating Expenses | 1,603,724 | 1,291,190 | 312,534 | 24.2% | 4,609,530 | 3,873,570 | 735,960 | 19.0% | ||
Total Income From Operations | 601,988 | 387,455 | 214,533 | 55.4% | 1,505,545 | 1,162,365 | 343,180 | 29.5% | ||
Labor Breakdown | ||||||||||
Total Paid FTEs (Productive plus PTO) | 71 | 56 | 15 | 26.2% | 65 | 56 | 9 | 16.5% | ||
Total Worked FTEs (Productive Only) | 68 | 49 | 19 | 38.0% | 60 | 49 | 11 | 21.6% | ||
Total Paid Hours | 12,608 | 9,990 | 2,618 | 26.2% | 34,928 | 29,969 | 4,959 | 16.5% | ||
Total Worked Hours (Productive Only) | 12,060 | 8,741 | 3,319 | 38.0% | 31,891 | 26,223 | 5,668 | 21.6% | ||
Total Worked FTE Breakdown (Productive Only) | ||||||||||
FTEs-Managers/Supervisors | 3 | 3 | 0 | 0.0% | 3 | 3 | 0 | 0.0% | ||
FTEs-Technical/Specialist | 59 | 51 | 8 | 15.7% | 50 | 44 | 6 | 13.6% | ||
FTEs-Clerical/Other | 1 | 1 | 0 | 0.0% | 1 | 1 | 0 | 0.0% | ||
FTEs-Agency | 8 | 1 | 7 | 700.0% | 6 | 1 | 5 | 500.0% | ||
Total Worked FTEs (Productive Only) | 71 | 56 | 15 | 26.8% | 60 | 49 | 11 | 22.4% | ||
Productivity Breakdown | Actual | Target | Variance | Variance % | Actual | Target | Variance | Variance % | ||
Actual Hours Worked (Productive Hours) | 12,060 | 11,512 | 548.18 | 4.8% | 31,891 | 26,223 | 5,668 | 21.6% | ||
Productivity for Worked Hours (Hours Worked/UOS) | 1.1 | 1.05 | 0.05 | 95.5% | 1.05 | 1.05 | 0 | 100.0% | ||
Assumptions | ||||||||||
Inpatient Revenue per UOS | $200 | |||||||||
Outpatient Revenue per UOS | $225 | |||||||||
Productivity Target (Productive Hours Worked per UOS) | 1.05 | |||||||||
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