The hospital is opening a new dermatological and orthopedic department. And the CFO needs to know...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The hospital is opening a new dermatological and orthopedic department. And the CFO needs to know how much to charge for those services. Use an Excel spreadsheet to determine the breakeven and profit points. Since the CEO would like to learn more about calculating breakeven points, please show your work. 1. Assume that the managers of the hospital are setting the price on a new dermatology service. Here are the relevant data estimates: Varible cost per visit Annual direct fixed cost $ 7.00 $350,000.00 Annual overhead allocation $ 49,000.00 Expected annual utilization 9100 a. What per-visit price must be set for the service to break even? To earn an annual profit of $100,000. b. Repeat part A but assume that the variable cost per visit is $10. c. Return to the data given in the problem. Again, repeat part A, but assume that direct fixed costs are $1,000,000. 2. The Orthopedic Department offers many services to the clinic's patients. The three most common, along with cost and utilization data, are as follows: Service Variable Cost Annual Direct per Service Fixed Costs Annual Visits Basic examination $ 5.00 $ 60,000.00 5000 Advance examination $ 7.00 $ 35,000.00 3500 Therapy session $ 10.00 $ 50,000.00 1500 a. What is the fee schedule for these services, assuming that the goal is to cover only variable and direct fixed costs? b. Assume that the Orthopedic Department is allocated $100,000 in total overhead by the clinic, and the department director has allocated $50,000 of this amount to the three services listed earlier. What is the fee schedule, assuming that these overhead costs must be covered in addition to the variable and direct fixed costs? (To answer this question, assume that the allocation of the $50,000 in overhead costs to each of the three services is made on the basis of the number of visits.) c. Assume that these three services must make a combined profit of $25,000. Now, what is the fee schedule? (To answer this question, assume that the profit requirement is allocated to each of the three services in the same way as overhead costs.) The hospital is opening a new dermatological and orthopedic department. And the CFO needs to know how much to charge for those services. Use an Excel spreadsheet to determine the breakeven and profit points. Since the CEO would like to learn more about calculating breakeven points, please show your work. 1. Assume that the managers of the hospital are setting the price on a new dermatology service. Here are the relevant data estimates: Varible cost per visit Annual direct fixed cost $ 7.00 $350,000.00 Annual overhead allocation $ 49,000.00 Expected annual utilization 9100 a. What per-visit price must be set for the service to break even? To earn an annual profit of $100,000. b. Repeat part A but assume that the variable cost per visit is $10. c. Return to the data given in the problem. Again, repeat part A, but assume that direct fixed costs are $1,000,000. 2. The Orthopedic Department offers many services to the clinic's patients. The three most common, along with cost and utilization data, are as follows: Service Variable Cost Annual Direct per Service Fixed Costs Annual Visits Basic examination $ 5.00 $ 60,000.00 5000 Advance examination $ 7.00 $ 35,000.00 3500 Therapy session $ 10.00 $ 50,000.00 1500 a. What is the fee schedule for these services, assuming that the goal is to cover only variable and direct fixed costs? b. Assume that the Orthopedic Department is allocated $100,000 in total overhead by the clinic, and the department director has allocated $50,000 of this amount to the three services listed earlier. What is the fee schedule, assuming that these overhead costs must be covered in addition to the variable and direct fixed costs? (To answer this question, assume that the allocation of the $50,000 in overhead costs to each of the three services is made on the basis of the number of visits.) c. Assume that these three services must make a combined profit of $25,000. Now, what is the fee schedule? (To answer this question, assume that the profit requirement is allocated to each of the three services in the same way as overhead costs.)
Expert Answer:
Related Book For
Intermediate Accounting
ISBN: 978-0132162302
1st edition
Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
A very long insulating cylinder of charge of radius 2.40 cm carries a uniform linear density of 13.0 nC/m. If you put one probe of a voltmeter at the surface, how far from the surface must the other...
-
Match each element with its financial statement by entering the appropriate letter in the space provided. Element ____ 1. Expenses ____ 2. Cash flows from investing activities ____ 3. Assets ____ 4....
-
Find the slope of the line tangent to the following polar curves at the given points. At the points where the curve intersects the origin (when this occurs), find the equation of the tangent line in...
-
In a contract dispute between a US company and a Canadian company, the contract itself referred to provisions of the Uniform Commercial Code. Do these references alone preempt the contract from being...
-
Bar Company has a maximum capacity of 500,000 units per year. Variable manufacturing costs are $25 per unit. Fixed overhead is $900,000 per year. Variable selling and administrative costs are $5 per...
-
Green Scenery Company provides landscape services and operated based on customer order. The company uses normal costing, and the overhead allocation base is direct labour costs. On 1st May, the...
-
Myles Etter and Crystal Santori are partners who share in the income equally and have capital balances of $210,000 and $62,500, respectively. Etter, with the consent of Santori, sells one-third of...
-
Chris, a CPA and formerly a staff accountant for a large public accounting firm, is the new controller for a small construction company that employs 60 people. The company is now facing tough times...
-
The two basic forms of long-term liabilities are: Select one: a. Common shares and preferred shares b. Credit cards and operating lines of credit c. Loans and bonds d. Allowance for doubtful accounts...
-
Aiden has been operating a printing and stationery supply business since November 2010. In April 2023, he agreed to sell his business and the land and buildings on which it is located for a total...
-
Megan, age 40, has the following assets: $20,000 in mutual funds in an RRSP $17,500 in a non-registered 5-year GIC, purchased last year $38,400 in a LIRA $58,490 in an RPP Megan needs $12,000 to...
-
include all the correspondence auditors use with auditee personnel, officers, and third parties to conduct the audit; communication with management and those charged with governance includes the...
-
youll need to evaluate specific account values or financial statement paragraphs. As an analyst, you have access to the Securities and Exchange Commissions (SECs) EDGAR database of XBRL financial...
-
Four professors are running for chair of the Natural Science Division: Professors Darwin (D), Einstein (E), Freud (F), and Hawking (H). The votes of the professors in the natural science division are...
-
How can a promoter avoid personal liability for pre-incorporation contracts?
-
List and explain the three primary advantages of the statement of financial position.
-
In applying the lower of cost or market rule for inventory, what amount do firms typically use as the estimate of market value? Note that the lower of cost or market rule measures inventory in...
-
Certain transactions require a choice about which financial statement is more important the income statement or the balance sheet. Read paragraphs BC1.31 and BC1.32 in the basis for conclusions of...
-
The following accounts and amounts (balances are normal balances) were taken from the records of Prider Manufacturers Ltd at 30 June 2019. Required (a) Prepare a cost of goods manufactured statement...
-
The following data were taken from the records of Manik Manufacturing Ltd for the year ended 30 June 2019. Required (a) Prepare the cost of goods manufactured schedule for the year ended 30 June...
-
The following demonstration problem illustrates the use of the general journal, the four special journals introduced here, and the general ledger with two subsidiary ledgers. Sidney Carton began...
Study smarter with the SolutionInn App