Medical Center Hospital CEO Thomas Cleverly decided that the not-for-profit hospital needed a new revenue line to help it compete with other hospitals in the area. He envisioned a mobile medical clinic, called “Health Train,” which could travel to different neighborhoods and provide annual physical examinations for a low price. You are an MHA fellow who is assigned to the CEO’s office, and the task of doing the initial planning for this project has fallen on your shoulders. You have been able to gather the following information on the Health Train concept:

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Please provide the answer in excel with the formulas and explain he steps. The are three questions below. The bullets are the information needed to answer and solve the questions.

 

Medical Center Hospital CEO Thomas Cleverly decided that the not-for-profit hospital needed a new revenue line to help it compete with other hospitals in the area. He envisioned a mobile medical clinic, called “Health Train,” which could travel to different neighborhoods and provide annual physical examinations for a low price.

You are an MHA fellow who is assigned to the CEO’s office, and the task of doing the initial planning for this project has fallen on your shoulders. You have been able to gather the following information on the Health Train concept:

  • An appropriate-sized bus can be purchased for $300,000; it would have a ten-year life and a 10 percent salvage value.
  • Equipment for the bus would cost $100,000; it would have a five-year life with no salvage value.
  • A physician to staff the Health Train would require $200,000 per year in salary and benefits. The physician could see one patient every 30 minutes and work 1,400 hours per year.
  • A nurse to assist the physician would cost $60,000 per year in salary and benefits. The nurse also could see one patient every 30 minutes and work 1,400 hours per year. The nurse would weigh patients, check blood pressure, take blood samples, administer electrocardiograms, and perform other tasks as needed.
  • A clerical assistant to handle registration and billing would cost $30,000 per year in salary and benefits.
  • Medical supplies for the physicals would run $5 per patient.
  • Laboratory tests for the physicals would run $20 per patient.
  • Insurance, advertising, fuel, repairs, and other expenses are estimated at $180,000 per year.
  • Cleverly insists that the Health Train contribute a minimum of $20,000 per year of profit.

Questions

1. Develop a cost-based price for a single physical exam in the Health Train.

2. Assume that the “target cost” is the average cost of a physical exam in local physician offices, which is $200. Does the initial plan meet the target cost?

3. If the initial plan does not meet the target cost, what elements could be redesigned to help meet this target?

4. What other factors might affect the decision to proceed with the Health Train?

Expert Solution
steps

Step by step

Solved in 6 steps

Blurred answer
Knowledge Booster
Ethical Decision Making
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education