Excel
posted by Varney .
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
FixedPrice 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 breakeven 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?

What kind of HELP do you need? You need to be specific when asking questions here.
If all you do is post your entire assignment, nothing will happen since no one here will do your work for you. But if you are specific about what you don't understand about the assignment or exactly what help you need, someone might be able to assist you. 
What is the formula to figure out these two problems?

I am trying to figure out which formula to use for this problem. For this one: (1CO)F + NI /
= (CHxP1) +(FPxPE)(1CO)
my answer 66164 doesn't make sense.
For:
FixedCost/Price per caseVariablecost, my anser of $26,000 doesnt make sense either bcs that is the original # pt days Can you offer any advice? 
If volume goes up 10 percent to 28,600 patient days and payer mix is unchanged, what will net income be?
Respond to this Question
Similar Questions

global strategic management
Research Chevron Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables are to be submitted in … 
college
Research the Bacardi website. Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables are to be … 
Strategic Management
Using the Bacardi website, develop both EFAS and IFAS table using an excel file. Also including both environmental and internal scanning process and what factors you consider and why will typed in MS word file. 
Global Strategic Management
Research the Abercrombie and Fitch website. Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables … 
Business/ Strategic Management
If you don't mind if you could give me TWO PRICES one for 1.) full assignment Deliverable Length:Tables count for 2 pgs and 4 pages in MS Word format Due Date: 6/18/2010 latest 6/19/2010 Research the British Petroleum website. Using … 
accounting
Assignment 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. A dermatology … 
Business
Research the Goldman Sachs website. Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables are … 
statistic
1. Compute descriptive statistics for liberal art colleges and research universities in the Excel file colleges and universities. Compare the two types of colleges . what can you conclude.? 
econ 2110
Suppose that we want to test whether the mean selling price of houses with is the same as the mean selling price of houses without a garage. We collect two samples and obtain the following information: Houses with garage Sample size: … 
excel
You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two thousand records of data. Explain …