Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Current YTD (Jul - Dec) Actuals Current Year's Total Budget Current Year's Variance YTD Estimate Current Total Year's Actuals Next Year's Budget OPERATING REVENUE: Inpatient
Current YTD (Jul - Dec) Actuals | Current Year's Total Budget | Current Year's Variance YTD | Estimate Current Total Year's Actuals | Next Year's Budget | ||
OPERATING REVENUE: | ||||||
Inpatient Revenue | $ 23,123,516 | $ 50,000,000 | $ (1,876,484) | |||
TOTAL PATIENT SERVICES REVENUE | $ 23,123,516 | $ 50,000,000 | $ (1,876,484) | |||
OPERATING EXPENSES | ||||||
Salaries and Wages | $ 12,157,632 | $ 23,000,000 | $ 657,632 | |||
Employee Benefits | $ 3,040,408 | $ 5,750,000 | $ 165,408 | |||
Professional Fees | $ 250,160 | $ 400,000 | $ 50,160 | |||
Supplies | $ 5,883,497 | $ 10,000,000 | $ 883,497 | |||
Purchased Services - Utilities | $ 27,456 | $ 50,000 | $ 2,456 | |||
Purchased Services - Other | $ 23,484 | $ 50,000 | $ (1,516) | |||
Insurance | $ 57,315 | $ 105,000 | $ 4,815 | |||
License and Taxes | $ 21,456 | $ 40,000 | $ 1,456 | |||
Other Direct Expenses | $ 972,157 | $ 1,500,000 | $ 222,157 | |||
TOTAL OPERATING EXPENSES | $ 22,433,565 | $ 40,895,000 | $ 1,986,065 | |||
NET REVENUE OR (EXPENSE) | $ 689,951 | $ 9,105,000 | $ (3,862,549) | |||
Using the data provided in the first three (3) columns, you will be developing an operating budget for the medical-surgical department at the St. Anthony Medical Center for the next fiscal year, as well as estimating the revenue and expenses for the remainder of the current fiscal year. (Assume that next year's revenue will be unchanged from the current year's revenue; however, the department will need to cut operating expenses by 5 percent for next fiscal year.)
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