Post a New Question

Excel

posted by .

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?

  • Excel -

    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.

  • Excel -

    What is the formula to figure out these two problems?

  • Accounting -

    I am trying to figure out which formula to use for this problem. For this one: (1-CO)F + NI /
    = (CHxP1) +(FPxPE)-(1-CO)
    my answer 66164 doesn't make sense.

    For:
    FixedCost/Price per case-Variablecost, my anser of $26,000 doesnt make sense either bcs that is the original # pt days Can you offer any advice?

  • Excel -

    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

First Name
School Subject
Your Answer

Similar Questions

  1. 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 …
  2. 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 …
  3. 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.
  4. 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 …
  5. 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 …
  6. 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 …
  7. 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 …
  8. 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.?
  9. 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: …
  10. 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 …

More Similar Questions

Post a New Question