April 18, 2015

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:

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 ...
econ 2110 - Suppose that we want to test whether the mean selling price of ...
Strategic Management - Using the Bacardi website, develop both EFAS and IFAS ...
excel - You have been tasked with analyzing an extremely large amount of data ...
statistic - 1. Compute descriptive statistics for liberal art colleges and ...