Premium Essay

Breakeven Analysis Casestudy

In: Business and Management

Submitted By naturalgurl
Words 1084
Pages 5
3/26/09

Case 4

Better Care Clinic
(Breakeven Analysis)
Fairbanks Memorial Hospital, an acute care hospital with 300 beds and 160 staff physicians, is one of 75 hospitals owned and operated by Health
Services of America, a for-profit, publicly owned company. Although there are two other acute care hospitals serving the same general population, Fairbanks historically has been highly profitable because of its well-appointed facilities, fine medical staff, and reputation for quality care. In addition to inpatient services, Fairbanks operates an emergency room within the hospital complex and a stand-alone walk-in clinic, the Better Care Clinic, located about two miles from the hospital.
Todd Greene, Fairbanks’s chief executive officer (CEO), is concerned about
Better Care Clinic’s financial performance. 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. Todd wonders whether Fairbanks 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 more visits—up to 60 per day. Todd has asked Jane Adams, Fairbanks’s chief financial officer, to look into the whole matter of the walk-in clinic. In their meeting, Todd stated that he visualizes two potential outcomes for the clinic: (1) the clinic could be closed or (2) the clinic could continue to operate as is.
As a starting point for the analysis, Jane has collected the most recent historical financial and operating data for the clinic, which are summarized in Table 1. In assessing the historical data, Jane noted that one competing clinic had recently (December 2008) closed its doors. Furthermore, a…...

Similar Documents

Premium Essay

Casestudy

...transparency in the entire process. EProcurement will be utilised by all GoAP departments including, Local Bodies and Municipal Corporations along with their vendors. Co-operative sectors, public sectors and other State governments can also use this solution. Advantages of E-Procurement that can be derived EProcurement can be of enormous value to companies of all types, and particularly to manufacturing companies. EProcurement provides numerous benefits to companies that employ this strategy, including the reduction of costs, the elimination of paperwork, as well as reduced manual labour and errors. EProcurement, when fully implemented in all departments, can also lead to a total visibility of spend, which leads to the ability to conduct spend analysis and to manage spend as well. When conducting eProcurement, it is possible to obtain items from a catalogue of approved items, making the procurement process very streamlined and efficient. When conducting eProcurement, time is saved such that staff can work on high value transactions, and can concentrate on strategic sourcing and on improving supplier relationships. In short, eProcurement can be of enormous benefit to an organization. An enormous benefit of eProcurement is the ability to allocate indirect materials from a catalogue or from a purchase requisition to a shopping basket. We can then see all account information and at the same time transfer the same information directly to the supplier. The ultimate goal of an......

Words: 1089 - Pages: 5

Premium Essay

Casestudy

...External Factor Analysis Summary on Coca-Cola Richard Lee Columbia Southern University The Coca-Cola Corporation provides consumers over five hundred brands and is the world's largest beverage company. The company has its headquarters in Atlanta. The organization conducts operations in over two hundred countries. This is the reason they have the largest beverage distribution and average 1.6 billion served daily (The Coca Cola Company, 2012). Coke was declared the world’s most valuable brand in 2011. Coke is also the leading company in the production of non-alcoholic beverages (Interbrand, 2011). The various variables which are to be taken into consideration in this analysis include political economic, social and economic factors, technology and SWOT data (Strategic Management Insight, 2013). See Table 1 for weighted factors of identified threats and opportunities. Political factors Political factors plays part in ensuring some effect on the production and selling behavior of the company. Political factors, however have a neutral effect on the coke industry. This is because environmental protection laws have been put forward by the government which, ensuring the company does not pollute the environment during their production. Coca Cola Company, however adjusted the protection......

Words: 746 - Pages: 3

Premium Essay

Breakeven Analysis

...Hospital, just recently bought the city’s largest primary care group practice and plans to acquire more. The new primary care practice will bring in referrals to Baptist Hospital while taking away possible volume from Columbia. In order to calculate the profitability of the other two options decided by the CEO, HSA's financial consulting team performed a break even analysis along with profit-loss statements based off of the historical financial data. Data Collection Primarily, the financial consulting team gathered information from the historical financial statements supplied by Brent Williams and Columbia Memorial Hospital. These financial statements included data from 2009 and January and February of 2010(See Table 1).This data was found to be useful in determining recommendations to Mike Reynolds, CEO, and Brent Williams. To perform the breakeven analysis, the average total data from the historical financial statements was used. (See Table 2) Data Analysis Gathering the average historical financial data from 2009 and part of 2010, the financial consultants were able to complete the break even analysis. The average number of visits during 2009 as well as the average number of visits for January and February 2010 were used to calculate an average monthly volume for the rest of 2010. Together, the projected average monthly volume, with the net revenue and fixed costs were used to evaluate a per visit revenue amount. The fixed costs of the clinic......

Words: 1125 - Pages: 5

Premium Essay

Casestudy

...Building Data Science Teams The Skills, Tools, and Perspectives Behind Great Data Science Groups DJ Patil THE SIMPLEST WAY TO BRING MapReduce and SQL www.asterdata.com Optimized in One Database Appliance Everyone knows data is the new black. The Aster MapReduce Analytics Portfolio enables customers to quickly make use of their data for actionable insights, analysis and product innovation. - Jonathan Goldman, Director of Analytics, Teradata Aster (and former Principal Data Scientist at LinkedIn) Learn More www.Asterdata.com/MapReduce Change the world with data. We’ll show you how. strataconf.com Sep 25 – 27, 2013 Boston, MA Oct 28 – 30, 2013 New York, NY Nov 11 – 13, 2013 London, England ©2013 O’Reilly Media, Inc. O’Reilly logo is a registered trademark of O’Reilly Media, Inc. 13110 Building Data Science Teams DJ Patil Beijing • Cambridge • Farnham • Köln • Sebastopol • Tokyo Building Data Science Teams by DJ Patil Copyright © 2011 O’Reilly Media. All rights reserved. Printed in the United States of America. Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472. O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles (http://my.safaribookson line.com). For more information, contact our corporate/institutional sales department: (800) 998-9938 or corporate@oreilly.com. Editor: Mike Loukides Printing......

Words: 8024 - Pages: 33

Premium Essay

Casestudy

...issue is ATLAM need to change their current system from traditional to the information technology (IT) facilities. This is not about technology change but it's also about a change in work processes, culture and habits. ATLAM has two option of the new upgrading system but they should choose the best one whether PETRA'S group wide SAP system or ACCPAC an accounting package. According to the discussion between Mr. Zulkifli and teams for the new system upgrade, most of them prefer PETRA'S group wide SAP system. The suggestion from Mr. Zulkifli is to propose for a cost benefit before making decision by perform feasibility analysis to determine if ATLAM should implement SAP. Solution: The feasibility analysis by Assuming that depreciation is at 34% for six years, internal rate of return at 25% with a discount rate of 10%, compute the following as part of the analysis: initial investment, after-tax cash flows for Years 1 through 6, payback period, net present value and internal rate of return. | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Initial Investment | 5,000,000 | | | | | | | | | | | | | | | Sales Revenue | | 0 | 0 | 0 | 0 | 0 | 0 | Operating Costs: | | | | | | | | Average SAP license cost | | 0 | 150,000 | 200,000 | 225,000 | 250,000 | 250,000 | Cost to convert olddata to new data | | 100,000 | 160,000 | 180,000 | 560,000 | 600,000 | 640,000 | Costs of overheads | | 300,000 | 420,000 | 490,000 | 560,000 |......

Words: 1779 - Pages: 8

Premium Essay

Columbia Memorial Hospital Breakeven Analysis

...50 x 1,230) = $4,305 Total Contribution Margin: ($56.50 x 1,230) = $69,495 Total Fixed Costs: (7,000 x 12) = $84,000 Profit: ($14,505) B. Projected Profit Charging $130.00 Per Patient Total Revenue: (1,230 x $130) = $159,900 Total Variable Costs: ($3.50 x 1,230) = $4,305 Total Contribution Margin: ($56.50 x 1,230) = $155,595 Total Fixed Costs: (7,000 x 12) = $84,000 Profit: $71,595 C. Projected Profit Charging $200.00 Per Patient Total Revenue: (1,230 x $200) = $246,000 Total Variable Costs: ($3.50 x 1,230) = $4,305 Total Contribution Margin: ($56.50 x 1,230) = $241.695 Total Fixed Costs: (7,000 x 12) = $84,000 Profit: $157,695 Breakeven Analysis CFO Williams determined that a breakeven analysis would be useful to determine which scenario is most prudent. A breakeven analysis estimates the amount of some variable, such as volume, price or variable cost rate, needed to break even.[2] CFO Williams also sought answers to four questions posted by CEO Reynolds: 1) What is the projected profitability of the walk-in clinic for the entire year if volume continues at its current level? 2) How many additional visits per day would be required to break even without the new marketing program? 3) How many additional visits per day would be required to break even assuming that the new marketing program is undertaken? 4) How many additional daily visits would the new program have to bring in to make it......

Words: 2009 - Pages: 9

Premium Essay

Casestudy

...AFF3431 Performance Measurement and Control Case study Analysis ------------------------------------------------- ------------------------------------------------- From your reading of the case describe the issue(s) or problem(s) which should be the focus of your case analysis. ------------------------------------------------- All of the physician groups would need to earn a surplus on the basis of the revenue generated from their outpatient visits only. Problem: BMA has never tried billed for their time before; therefore they are not even sure this time if they are using the right approach. The overhead budget is not completely certain. Identify any principles, theoretical framework or relevant theories that can be applied to the case. Line – item budgeting Responsibility centre What is the qualitative evidence that is relevant to the issue(s) or problem(s) identified above? BMA has never tried time billing before. Dr King commented: this method is pretty daunting and it is not something that Gordon has done before therefore they are both struggling a little. The overhead budget is not completely certain as the figures totally depend on the formulas from Coos Bay’s cost allocation system. Physician’s base salary would based on his or her expected revenue, what if he or she deliberately set the salary up to an unachievable amount. All inpatient revenue from both hospital and physician billings would be retained by the hospital, and only a portion of...

Words: 421 - Pages: 2

Premium Essay

Casestudy

...1950s and early 1960s until millennium approached of Web-based analytical applications; the Decision support system (DSS) has been used in many different ways (Alter 1980, Power, 2002). Turban (1995) defines it as "an interactive, flexible, and adaptable computerbased information system, especially developed for supporting the solution of a nonstructured management problem for improved decision making. It utilizes data, provides an easy-to-use interface, and allows for the decision maker's own insights." For Little (1970), a DSS is a "model-based set of procedures for processing data and judgments to assist a manager in his decision-making." Moore and Chang (1980) define DSS as extendible systems capable of supporting ad hoc data analysis and decision modeling, oriented toward future planning, and used at irregular, unplanned intervals. importance of DSS to assist in high-level decision-making, assist academic advising staff, improve the quality and timeliness of marketing decisions, and medical diagnosis process; and current issues of DSS where decision-making as the most important activities for human beings, Clinical Decision Support Systems (CDSSs), several types of DSS usage and deployment, and Social decision support system (SDSS) . In contrast, Keen (1980) claims that it is impossible to all give the a precise of definition the DSS. 1. Introduction Information Systems (IS) play a vital role in the decision-making process. IS are tools and instruments...

Words: 1600 - Pages: 7

Premium Essay

Breakeven

...For Case 3-1: answer questions 1 - 5. 1. Breakeven Volume Analysis Varible costs Medical Supplies: $493,806 Purchased Laboratory Services: $24,476 Water Usage: $20,896 Total Variable Costs: $539,178 Number of treatments: 5,736 Total Variable Cost / Number of treatments $539,178 / 5,736 = 94 Px = a + bx $250x = $510,870 + 94x $156x = $510,870 ($156x = $510,870)/$156 = 3274.81 3274.81 treatments per year 7 nurses -1 $35,000/7 = $5,000 bi-monthly / 2 = $2,500 monthly ($2,500 monthly)12 = $30,000 per year 7 techs -1 $30,680/7 = $4382.86 bi-monthly(2 Employees)/ 2 = $4382.86 monthly ($4382.86 monthly)12 = $52,594.29 per year $30,000 per year + $52,594.29 per year = $82,594.29 per year total payroll last year = $436,800 $436,800 - $82,594.29 = $354,205,71 projected payroll with 3 less employees $354,205.71/$436,800 = 81.1% of previous years payroll expenses Assumptions: Medical Supplies: $493,806 Purchased Laboratory Services: $24,476 Water Usage: $20,896 Are variable expensed and Depreciation is a fixed expense 2. Fair Share of Overhead: @ 50% Capasity 120 Treatments per week / 2 = 60 Treatments per week (60 Treatments per week)(52 weeks in a year) = 3120 Treatments per year @ 50% Capacity Treatments per year @ 50% Capacity / Number of treatments last year: 5,736 = 3,120/5,736 = 54.4% Fixed Overhead; Depreciation, Operation of Plant, Housekeeping $4,778 + $4,281 + $3,411 = $12,470 Variable per treatment: Laundry and......

Words: 288 - Pages: 2

Premium Essay

Breakeven Analysis

...Beta company sells blouses in Washington, USA. Blouses are imported from Pakistan and are sold to customers in Washington at a profit. Salespersons are paid basic salary plus a decent commission on sales made by them. Sales and expense data is given below: Selling price per blouse $80.00 Variable expenses per blouse: Invoice cost $36.00 Sales commission $14.00 Total $50.00 Annual fixed expenses: Rent $160,000 Marketing  $300,000 Salaries  $140,000 Total $600,000 1. Compute the number of units to be sold to break-even. 2. Prepare a CVP graph (break-even chart) and show the break-even point on the 3. If the manage is paid a commission of $6 blouse (in addition to the salesperson’s commission), what will be the effect on company’s break-even point? 4. As an alternative to (3) above, company is thinking to pay $6 commission to manager on each blouse sold in excess of break-even point. What will be the effect of these changes on the net operating income or loss of the Beta company if 23,500 blouses are sold in a year? 5. Refer to the original data. What will be the break-even point of the company if commission is entirely eliminated and salaries are increased by $214,000? Should the company make this change? (1) Calculation of break-even point: Fixed expenses / Contribution margin per unit $600,000 / $30 20,000 units 20,000 units × $80 = $1,600,000 (2) CVP graph or break-even......

Words: 458 - Pages: 2

Premium Essay

Breakeven

...------------------------------------------------- Breakeven Analysis of Zomato Submitted to: Submitted by: Prof. Atmanand Jyoti (15PGHR03) Lovish (15PGHR23) Vikas (15PGHR50) Rohit (15PGHR52) Zachariah (15PGHR53) Sophiya (15PGHR58) Acknowledgement We wish to express our sincere thanks and gratitude to Prof. Atmanand for providing us an opportunity to undertake this project under his guidance. The completion of this project would not have been possible without his timely advice and dedicated support. The guidance provided by him is immensely valuable. We are very thankful to him for his prompt inspiration, suggestions and patience while helping us. Table Of Content * About the Company * Funding * Revenue......

Words: 3232 - Pages: 13

Premium Essay

Casestudy

...Keywords: Working Capital Management, Cash Conversion Cycle, Net Trade Cycle, Average Collection Period, Average Payment Period, Manufacturing Sector, Fixed Effect Model. International Research Journal of Finance and Economics - Issue 47 (2010) 152 1. Introduction Manufacturing is the second largest sector of the economy of Pakistan after agriculture sector and it accounts for 19.1% of GDP. It grew by 8.4 percent during 2007 as against 10 percent last year. In the manufacturing sector, large scale manufacturing plays a vital role and accounts for approximately 70 percent of overall manufacturing (Government of Pakistan, 2006-07). As an important sector in the overall economic growth, manufacturing sector requires in depth analysis at industry as well as firm level. The sector is dominated by textile, oil and gas, cement and automobile sectors in terms of assets size and credit allocation. Working capital management efficiency is vital especially for manufacturing firms, where a major part of assets is composed of current assets (Horne and Wachowitz, 2000). It directly affects the profitability and liquidity of firms (Raheman and Nasr, 2007). The profitability liquidity tradeoff is important because if working capital management is not given due considerations then the firms are likely to fail and face bankruptcy (Kargar and Bluementhal, 1994). The significance of working capital management efficiency is irrefutable (Filbeck and Krueger, 2005). Working......

Words: 7443 - Pages: 30

Premium Essay

Breakeven Analysis

...Taco Restaurant Breakeven Analysis November 29, 2015 _ Scenario The problem states that the average order price at a local taco restaurant in Lynchburg, VA is $7.00 per order. The variable costs including food and paper products are $3.00 per order. The fixed costs are $5,600 a month (building lease, electricity, and labor). Breakeven Formula Analysis At this rate, the restaurant requires at least 1,400 orders a month to reach the breakeven point. However, as the problem states, the restaurant is barely making 1,000 orders per month. This means that the restaurant may not last long at this rate and measures must be taken to increase sales and decrease expenses. _ Marketing Plan The obvious solution is to increase the orders per month from 1,000 to 1,400. However, because of factors such as competition, this may be difficult to do in a short period of time. I suggest increasing the average order price to $8 by slightly raising prices, and offering customers discounts for purchasing more food with a lower variable cost (i.e nachos, fries, or anything that doesn't cost much to make). A pricing constraint to consider would be the price that customers are willing to pay for your food may not be extremely high depending on the quality of the restaurant. Then, it would be advantageous to decrease the variable costs to $2.50 by purchasing certain food items in bulk if possible. Next, it......

Words: 318 - Pages: 2

Premium Essay

Casestudy

...revenue was declining, the cost of sales should not have much change and even have changes, it will just be low increment such as affected by the government policy in setting the price of fuel (APM formula). However, in this case, the increasing of cost of sales may be high possibility attributed by the dishonest staffs in misuse the business money to buy the petrol and sold it to third party privately for personal gain. Thus, the revenue was kept declining and cost of sales was increasing. If this was real, then we can explain the missing petrol in the stock balance report. 5. 5. Horizontal Analysis Item/Year 2004 2005 2006 2007 2008 Sales 100% 105% 94.50% 75.60% 71.82% Cogs 100% 105% 103.95% 85.05% 86.18% Gross Profit 100% 105% 56.70% 37.80% 14.36% Common-size (horizontal) analysis took place to compare the performance of the company from year 2004 to 2008. Common-size analysis expresses comparisons in percentages. Thus, it makes the comparison more preferable and meaningful than absolute amount. By using year 2004 as the selected base year, the performance of the company was getting worse since years 2006. Gross profit decreased approximately 43% in 2006, 62% in 2007 and 86% in 2008 (compare with year 2004). The main concern is on the changes in the percentage of cost of sales. Cost of sales increased slightly in year 2006 despite the gross profit slash 43% (in comparison with the base year, 2004). In addition, the gross profit for year 2007 was only 37.8% compare with...

Words: 5968 - Pages: 24

Free Essay

Casestudy

...goods industry that is headquartered in Conshohocken, Pennsylvania. Satori Group demonstrated how Snyder's could implement its proCube software to gather better sales and marketing data and, therefore, make better business decisions. ProCube would automate Snyder's budgeting processes, creating accurate forecasting facilities, improving financial reporting techniques, and refining Snyder's product marketing analysis so that Snyder's could evaluate the viability of each of its individual brands and products. Such analytical power was just what Snyder's would need to compete with Rold Gold, which is backed by the corporate powerhouses of Frito-Lay and PepsiCo. What Snyder's found so appealing about proCube was the ease with which it could be integrated with the company's existing information systems. ProCube enables Snyder's department heads to continue using Microsoft Excel spreadsheets to collect sales and returns data. These data are collected in a large data repository, where they are consolidated and organized before being used by proCube reporting software for analysis. The proCube software also uses manufacturing data from Snyder's enterprise system. Snyder's financial department now spends a couple of days preparing those same monthly, quarterly, and yearly statements that used to devour weeks' worth of productivity. This is only the first step in what Snyder's hopes is a chain of improvements that will result in new growth. The next step is to add new levels of......

Words: 1592 - Pages: 7