I need help with this case study.
Please see exhibit 6.1 and 6.2 in attachments
The excel spreadsheet is also attached
Background of case:
Columbia Memorial hospital an acute care hospital with 300 beds and 160 staff drs is one of 75 hospitals owned and operated by health Services of America, a for-profit, publicly owned company. Although two other acute care hospitals serve the same population, Columbia historically has been highly profitable because of its well-appointed facilities, fine medical staff, and reputation for quality care and the amount of individual attention it gives to patients. In addition to the standard range of inpatient and outpatient services, Columbia operate an emergency department within the hospital complex and a stand-alone walk in clinic located across the street from the area’s major shopping mall, about two miles from the hospital.
Patients, who need immediate care for injuries or illness, be it a nail gun puncture or a sore throat are increasingly turning to walk in clinics (urgent care centers). These clinics aim to fill the gap between the growing shortage of primary care physicians and already crowded (and expensive) emergency departments. Walk in clinics are staffed by Drs, offer wait times as little as a few minutes, and charge $60 to $200, depending on the procedure. Furthermore, no appointments are necessary and evening and weekend hours are frequently available. Finally, many offer discounts to the uninsured, and for those with coverage, copayments are typically much less than for emergency department visits. Currently 8,000 of these clinics exist around the country, including about 1200 affiliated with hospitals.
Mike Reynolds, Columbia’s chief executive officer (CEO) is concerned about the clinics overall financial soundness. About ten years ago, all three area hospitals jumped onto the walk-in-clinic bandwagon and within a short time, there were five such clinics scattered around the city. Now only three are left and none of them appears to be a big money maker. Mike wonders if Columbia should continue to operate its clinic or close it down. The clinic is currently handling a patient load of 45 visits per day, but it has the physical capacity to handle many more visits-up to 85 a day. Mikes decision has been complicated by the fact that Rose Daniels, Columbia’s marketing director, has been pushing to embark on a new marketing program for the clinic. She believes that an expanded marketing effort aimed at local business would bring in the number of new patients needed to make the clinic a financial winner.
Mike has asked Brent Williams, Columbia’s chief financial offer, to look into the whole matter of the walk-in clinic. In their meeting, Mike stated that he visualizes three potential outcomes for the clinic: 1. The clinic could be closed. 2.) The clinic could continue to operate as is-that is, without expanding its marketing program or 3.) the clinic could continue to operate, but with the expanded marketing effort. As starting point for the analysis, Brent has collected the most recent historical financial and operating data for the clinic, which are summarized in exhibit 6.1. In assessing the historical data, Brent noted that one competing clinic had recently closed its doors. Furthermore, a review of several years of financial data revealed that the Columbia clinic does not have a pronounced seasonal utilization pattern.
Next Brent met several times with the clinic’s director. The primary purpose of the meetings was to estimate the additional costs that would have to be borne if clinic volume rose above the current January/February average level of 45 visits per day. Any incremental usage would require additional expenditures for administrative and medical supplies, estimated to be $3.00 per patient visit for medical supplies, such as tongue blades and rubber gloves, and $.50 per patient visit for administrative supplies, such as file folders and clinical record sheets.
Because of the relatively low volume level, the clinic has purposely been staffed at the bare minimum. In fact, some clinic employees have started to grumble about not being able to do their jobs as well because of overwork. Thus, any increase in the number of patient visits would require immediate administrative and medical staff increases. Furthermore, as the number of visits increase, the clinic would have to hire additional staff members. The incremental costs associated with increased volume are summarized in Exhibit 6.2
In addition, Brent learned that the building is leased on a long-term basis. Columbia could cancel the lease, but the lease contract calls for a cancellation penalty of three months’ rent ($37,500) at the current lease rate. Brent was startled to read in the newspaper that Baptist Hospital, Columbia’s major competitor, had just brought the city’s largest primary care group practice, and Baptist’s CEO said that more group practice acquisitions are planned. Brent wondered whether Baptist’s actions would influence the decision regarding the clinics fate.
Finally, Brent met with Rose (Columbia’s marketing director) to learn more about the proposed expansion of the clinic’s marketing program. The primary focus of the new marketing program would be on occupational health service (OHS). OHS involves providing medical care to local businesses, including physical examinations for managers and employees; treatment of illnesses that occur during work hours; and treatment of work-related injuries, especially those covered by Workers’ Comp. Although some of the clinic’s current business is OHS related, Rose believes that a strong marketing effort, coupled with specialized OHS record keeping, could bring additional patients to the clinic. The proposed marketing expansion requires a marketing assistant who will run the clinic’s OHS program. Additionally, the new marketing program would incur costs for newspaper, radio, TV, and Internet ads as well as for brochures and handouts. The incremental costs associated with the new marketing program are also summarized in exhibit 6.2.
With a blank spread sheet on the screen, Brent began to construct a model that would provide the information needed to help the board make a rational, informed decision. At first Brent planned to conduct a standard capital budgeting analysis that focused on the profitability of the clinic as measured by net present value or internal rate of return. Then he realized that the expanded marketing program requires no capital investment. He also realized that no valid data are available on the incremental increase in visits that would be generated either by an increasing population base or by the expanded marketing program.
Finally he remembered that mike requested that the analysis consider the inherent profitability of the clinic without the expanded marketing program.
In addition, Brent wonders if the clinic could inflate its way to profitability; that is, if volume remained at its current level, could the clinic be expected to become profitable in, say five years, solely because of inflationary increases in revenues? Finally Brent is concerned about whether or not the analysis gave the clinic full credit for its financial contributions to the hospital. Brent does not want to change the spreadsheet at this late date, but he does want to make sure that any additional financial value is at least considered qualitatively. Overall Brent must consider all relevant factors- both quantitative and qualitative-and come up with a recommendation regarding the future of the clinic.
Why Work with Us
Top Quality and Well-Researched Papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional and Experienced Academic Writers
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Money-Back-Guarantee
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & Confidential
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.