Answered step by step
Verified Expert Solution
Link Copied!

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

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

Students also viewed these Accounting questions