Login|Contact Us
Question and Answer

Homework

Ask a Homework Question, Get an Answer ASAP!

  • Ask A Question
  • Browse Answers
  • Meet The Experts
  • How JustAnswer Works

Determine the revenue variance from Arcadia Hospitals 2005

 

Customer Question

Determine the revenue variance from Arcadia Hospital’s 2005 budget.
• Address the following: Is the variance positive or negative? Which is desirable, a positive or
negative variance? Why? What do you think are some of the possible causes for this variance?
How would you adjust Arcadia Hospital’s 2006 budget in light of your variance analysis? Explain
your answer. Please I need this no later than 7 pm on Thursday 3/26/09.

 



Already Tried:
Resource: Ch. 8 of Financial Management - Text:McLean, R.A. (2003). Financial management in health care organizations (2nd ed.). Clifton Park, NY: Delmar Learning.

Submitted: 1548 days and 18 hours ago.
Category: Homework
Value: $25
Status: CLOSED
Picture
Expert:  Bill Smith replied1546 days and 8 hours ago.

In order to calculate the variance, please provide the revenue figures.

Customer replied1546 days and 8 hours ago.

Arcadia Hospital
Income Statement
YTD Dec 31, 2005
(Dollars in Millions)
Operating Revenues2005% of revBudgetOver/(Under)
Patient revenues500 550
less:Allowance for doubtful accounts13 14
equalsNet patient revenues488 536
Other Income:
Investments75 60
Misc5 0
Total Operating Revenue568 100.00%596
Operating expenses:
Wages200 35.24%180
Taxes & Benefits75 13.22%70
Temporary/Contract Labor5 0.88%0
Medical/surgical supplies25 4.41%30
Other misc supplies5 0.88%5
Dues/subscriptions3 0.53%3
Transcription expense10 1.76%15
Leases & rentals50 8.81%45
Malpractice Insurance75 13.22%70
Other Insurance30 5.29%32
Professional Fees20 3.52%20
Utilities15 2.64%10
Maintenance & Repairs15 2.64%10
Depreciation/Amortization7 1.23%7
Interest Expense1 0.18%1
Total Operating Expenses536 94.45%498
Net Income32 5.55%98

 

 

These are approaches to valuation:

Rules of thumb: (twice annual revenues) = $1136 million

2) Adjusted book value: (owner's equity) = $7900 million

3) Discounted cash flow:

Cash flow amount

 

Capitalization rate

 

Value

$655 million (assume same as 2006!)

6%

$10,917

8%

$8,187

10%

$6,550

12%

$5,458

 

 

Although there are many ratios in use, some of the key ratios are formulated and described below:

  • Current ratio= (current assets/current liabilities)
  • Quick ratio= ((current assets-inventory)/current liabilities)

These two ratios are short-term liquidity ratios. They are calculated to ascertain how well a business is in paying its current liabilities, in case it has to in an emergency situation.

 

If you need anything else, please let me know. Thank you! Customer/p>

Accepted Answer

Picture
Expert:  Bill Smith replied1546 days and 7 hours ago.

 

Determine the revenue variance from Arcadia Hospital's 2005 budget.

 

Is the variance positive or negative?

 

Looking only at revenue:

Patient Revenue for '05 = 500 while budget = 550, this means that patient revenue is under budget. Since the focus is on revenue and not costs, under budget is unfavorable, meaning that there was less actual revenue than expected when the budget was created.

 

Net patient revenue is under budget by 49, unfavorable, less incoming revenue than planned with the budget.

 

Total Operating Revenue: under budget by 29, unfavorable, less incoming revenue than planned with the budget.

 

Which is desirable, a positive or negative variance?

When focusing on revenue, it is favorable to be over budget, more actual revenue than planned with the budget. Under budget, would indicate less revenue than budgeted which is unfavorable.

 

When focusing on costs, it is favorable to be under budget, less actual costs than originally budgeted. It is unfavorable to be over budget, more actual costs than budgeted.

 

Why? What do you think are some of the possible causes for this variance?

Some possibilities for the revenue shortage could be too much competition from other hospitals, more advertising from other hospitals, and poor level of care from this hospital. Another possibility is low prices.

 

How would you adjust Arcadia Hospital's 2006 budget in light of your variance analysis?

If the hospital does not expect to take action to increase revenue, then the plan for future years may need to be lowered if they expect diminished revenue streams going forward.

 

 

Expert TypeGraduate Student
Category: Homework
Pos. Feedback: 100.0 %
Accepts: 12
Answered: 3/26/2009

Experience: Certifications in all MS Applications, MBA

Ask this Expert a Question >
Customer replied1545 days and 8 hours ago.

Bill,

 

Thank you so very much for your help. I have also posted another question. Could you take the time to see if you could help me with it? It is a final finance project. I will wait for your response.

 

Customer/p>

Picture
Expert:  Bill Smith replied1545 days and 7 hours ago.

I'm not seeing your new question. To appear on my list of possible questions it needs to be under the homework experts category. Please accept the completed question.

Customer replied1544 days and 21 hours ago.

Bill,

 

I will repost my other assignment. I will also add an additional $10.00 to the $65.00 already posted for to pay for this reply. I will post my assignment to the financial expert with your name on it.

 

Thank you,

 

Customer/p>

Picture
Expert:  Bill Smith replied1544 days and 20 hours ago.

THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
If you've already paid for this answer, simply Login.

Customer replied1544 days and 19 hours ago.

Justanswer has given this assignment to Mohammad Ali. I don't know how to change this once it has been accepted by someone else. I will however, post to the homework expert requesting your name to pay you for your time here. I hope that is adequate.

 

Thank you,

 

Customer/p>

 
Tweet

6 Tutors are Online Right Now

Ask Your Question Now
Ask A Tutor
Type Your Homework Question Here...
characters left:

Top Homework Experts

See More Tutors

In The News

Nbc
Washington Post
New York Times
Cnn
Learn More

How It Works

  • Ask an Expert
  • Get a Professional Answer
  • Ask Followup Questions
  • 100% Satisfaction Guarantee
Learn More

Ask a Tutor

Get a Professional Answer. 100% Satisfaction Guaranteed.
125 Tutors are Online Now
Type Your Homework Question Here...
characters left:
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
Truste
Contact Us | Terms of Service | Privacy & Security | About Us | Our Network
© 2003-2013 JustAnswer LLC
  • Pearl.com
  • JustAnswer UK
  • JustAnswer Germany
  • JustAnswer Spanish
  • JustAnswer Japan