Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each line item (a-p), list the dollar amount of the variance on that line, then describe which detail line items on that statement changed
- For each line item (a-p), list the dollar amount of the variance on that line, then describe which detail line items on that statement changed to cause the variance (for example, which of the revenue line items from the detailed statement was the main source of the variance in total operating revenues)? What does this mean? (Hint: use the descriptions in the text to help you with this part). You had a similar assignment in Unit 1. Comparing how well you did in this analysis with the results you achieved in Unit 1 should demonstrate how much you have learned in this module. I did the first one for you, as an example
- Increased $552K, due to $150K increase in patient services revenue and $400K increase in premium revenue, meaning- both related to income from patient care services, possibly related to increased # of patients. Here is the example complete this Excel schedule showing Statement of Operations and Balance Sheet totals for the last two years. Use a formula (given) to calculate the Variance. Format your cells with commas and no decimal points (these dollars are in thousands).
From Statement of Operations (Exhibit 3.2) | 2017 | 2016 | Variance (2017 minus 2016) | ||
REVENUES | |||||
a | Patient Service Revenues | 8,402 | 8,119 | ||
b | Less: Contractual allowances | ||||
c | Less: Charity Care allowances | ||||
d | Less: Bad Debt allowances | 600,000 | 500,000 | ||
e | Net Patient Service Revenues | 8,402 | 8,119 | ||
f | Premium Revenue | 400.00 | - | ||
g | Other Revenue | 440 | 447 | ||
h | Total Operating Revenue | ||||
EXPENSES | |||||
i | Salaries, wages and benefits | 4,980 | 4,278 | ||
j | Supplies, drugs, purchased services | 3,080 | 2,956 | ||
k | Depreciation and amortization | 471 | 443 | ||
l | Interest | 113 | 109 | ||
m | Total Operating Expenses | ||||
n | Total Operating Income | ||||
o | Non Operating Income: Investment Income | $95 | $85 | ||
p | Excess of Revenues over Expenses | ||||
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