Tuesday
September 23, 2014

Homework Help: Excel

Posted by Varney on Sunday, July 25, 2010 at 11:45am.

Please prepare the homework problems in the form of a Word and/or Excel file. Try to use one file to submit your answers, if possible, and include the questions with your answers. You must show your calculations.
1. Your nursing home defines output as a patient day. Its present volume is 26,000 patient days. The average cost per day is $90.00. Present revenues and costs are presented below:
Revenues Amount
Charge Patients (6,000 Patient Days) $750,000
Fixed-Price Patients (20,000 Patient Days) $1,800,000
Total Net Revenues $2,550,000

Costs Amount
Fixed Costs $1,170,000
Variable Costs ($45/PD) $1,170,000
Total ($90/PD) $2,340,000

Net Income $210,000
Using this information, answer the following two questions:
a. What is the break-even in patient days for this nursing home, assuming no profit is required?
b. If volume goes up 10% to 28,600 patient days, and payer mix is unchanged, what will net income be?

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

accounting - Assignment Please prepare the homework problems in the form of a ...
college - Research the Bacardi website. Using your research findings from the ...
global strategic management - Research Chevron Using your research findings from...
Global Strategic Management - Research the Abercrombie and Fitch website. Using ...
Business - Research the Goldman Sachs website. Using your research findings from...
Business/ Strategic Management - If you dont mind if you could give me TWO ...
Strategic Management - Using the Bacardi website, develop both EFAS and IFAS ...
statistic - 1. Compute descriptive statistics for liberal art colleges and ...
Excel, Access, Word - When you link a worksheet and a chart in a business report...
Excel - I have my employee schedule in a excel sheet. It is a weekly schedule ...

Search
Members