Premium Essay

Breakeven

In: Other Topics

Submitted By peter88
Words 288
Pages 2
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 Linens, Dietary, Physician Salaries, Medical Supplies, Pharmacy, Social Services, Intern and Resident Services
$1,782 + $9471 + $65,477 + $279 + $1,827 + $50,878 + $10,425 = $140,139
$140,139(.544) = $76,235.62…...

Similar Documents

Premium Essay

Hallstead Jewelers Case Study

...Hallstead Jewelers Case Study Amanda Dutcher October 6, 2011 1) Fixed Costs=Salaries+Advertising+Administrative Expenses+Rent+Depreciation+Miscellaneous expenses Breakeven=Fixed Costs/Contribution Margin 2003-3230000/377.03=8,566.96 units 2004-3333000/357.68=9,318.39 units 2006-4921000/352.52=13,959.49 units Breakeven$=Breakeven Units*Unit Price 2003-8566.96*845=$7,239,079.12 2004-9318.39*812=$7,566,532.68 2006-13959.49*819=$11,432,822.31 Margin of Safety=Sales-Breakeven Sales 2003=8583000-7239079.12=1343920.88=15.66% 2004=8102000-7566532.68=535467.32=6.61% 2006=10711000-11432822.31=-721822.31=6.74% The breakeven point increases from year to year because of the increases in fixed costs. Because these costs are increasing, the company needs to produce and sell more units in order to cover them. The margin of safety decreases from year to year for the same reason. The change from 2003 to 2004 for breakeven units and the margin of safety were not nearly as significant as the change in 2006. This change in fixed costs is because they moved to a new, larger location causing them to increase dramatically. This caused for not only an increase in rent, but also most likely an increase in the amount of employees. This major increase in fixed costs is what caused the major change in both the breakeven point and the margin of safety. 2) New Price=$737.10 New Sales Volume=14,0000 Sales=$10,319,400 $10,319,400-10,711,000=$-391,600 The decrease in price also......

Words: 634 - Pages: 3

Premium Essay

Hallstead Jwelers Case Study

...Hallstead Jewelers (Case Study1) Accounting 2301 Managerial Accounting Professor May Spring 2013 By: Madhur Mittal, Ishaq Rehman, Ying Wang and Bohan Li Question 1 Breakeven is a point at which a company covers all its costs and its profit is zero. After reviewing Hallstead Jewelers Income Statement, operational statistics, and table 2 and 3, for fiscal years 2003, 2004, and 2006, we can see a slight change in the breakeven unit and dollar amounts between the fiscal year of 2003 when compared to 2004. At the same time we also examine a major change when comparing the breakeven points of the fiscal year 2004 to 2006. This can be seen in Tables 1, 2, and 3. Hallstead Jewelers | Income Statement | For the years 2003, 2004, and 2006 (In thousands) |   | 2003 | 2004 | 2006 | Total Sales | $8,583 | $8,102 | $10,711 | Variable Costs |   |   |   | Cost of Goods Sold | $4,326 | $4,132 | $5,570 | Commissions | $429 | $405 | $536 | Total Variable Costs | $4,755 | $4,537 | $6,106 | Contribution Margin | $3,828 | $3,565 | $4,605 |   |   |   |   | Fixed Costs |   |   |   | Salaries | $2,021 | $2,081 | $3,215 | Advertising | $254 | $250 | $257 | Administrative Expenses | $418 | $425 | $435 | Rent | $400 | $400 | $750 | Depreciation | $84 | $84 | $142 | Miscellaneous Expenses | $53 | $93 | $122 | Total Fixed Costs | $3,230...

Words: 2015 - Pages: 9

Premium Essay

Fixed Variable and Breakeven Points

...Fixed Variable and Break Even points David Anderson HSM/260 July 14, 2013 Melvin Green Fixed Variable and Break Even points Fixed Costs, Variable Costs, and Break-Even Point Part 1 During the sixth month of the fiscal year, the program director of the Westchester Home-Delivered Meals program decides to again recalculate fixed costs, variable costs, and the Break-Even Point using the high to low method. Included here are the number of meals served and the total costs of the program for each of the first six months: Month Meals Served Total Costs July (3,500) $20,500 August (4,000) $22,600 September (4,200) $23,350 October (4,600) $24,500 November (4,700) $25,000 December (4,900) $26,000 Recalculate fixed costs, variable costs, and the BEP. What are the variable costs? What are the fixed costs? How many meals will the WHDM program need to provide during the fiscal year to reach the BEP? How much profit will the program earn if it completes its 45,000-meal contract with the City of Westchester? Meals: High-Low=   Cost: High-Low=   The variable cost per meal:   The variable cost for the low month:   Fixed cost:   (Monthly BEP) (Fiscal-year BEP) WHDM program profit analysis = meal contract Break Even Point (BEP) =   1,008 Revenue 1,008 Meals at   Total Cost Per meal   Total Profit = Exercise 10.2 It has been two years since the New River Community Council (NRCC) started its newsletter dealing with state and community...

Words: 353 - Pages: 2

Premium Essay

Breakeven Analysis

...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 included the salaries and wages as well as the building lease. The clinic also incurred variable costs such as physician fees,......

Words: 1125 - Pages: 5

Premium Essay

Enrollment

...cost per unit $20, and fixed cost per unit is $3. When this company operates above the breakeven point, the sale of one more unit will increase net income by $7. Answer: False Difficulty: 2 Objective: 3 Terms to Learn: contribution income statement The sale of one more unit will increase net income by $10, ($30 – $20 = $10). 15. A company with sales of $100,000, variable costs of $70,000, and fixed costs of $50,000 will reach its breakeven point if sales are increased by $20,000. Answer: False Difficulty: 2 Objective: 3 Terms to Learn: breakeven point (BEP) $50,000 / 0.30 = $166,667 of total sales are needed to break even. 16. Breakeven point is not a good planning tool since the goal of business is to make a profit. Answer: False Difficulty: 2 Objective: 3 Terms to Learn: breakeven point (BEP) Breakeven point is an important planning tool that helps managers determine volume of sales/production needed to be profitable. 17. Breakeven point is that quantity of output where total revenues equal total costs. Answer: True Difficulty: 1 Objective: 3 Terms to Learn: breakeven point (BEP) 18. In the graph method of CVP analysis, the breakeven point is the quantity of units sold for which the total revenues line crosses the X-axis. Answer: True Difficulty: 1 Objective: 3 Terms to Learn: breakeven point (BEP) 19. A profit-volume graph shows the impact on operating income from......

Words: 13946 - Pages: 56

Premium Essay

Hallstead Jewelers

...The breakeven point in units and in sales dollars has increased each year from 2003 to 2006 (with the renovation year of 2005 having been skipped). From 2003 to 2004, breakeven increased by 10.28% in units and 4.58% in dollars. These increases occurred because, while variable costs decreased by 4.58%, average ticket (unit) price decreased by 5.16%, meaning Hallstead was getting a lower contribution margin per ticket/unit. Fixed costs also slightly increased from 2003 to 2004, which in turn contributing to increasing breakeven point. Breakeven increased drastically from 2004 to 2006, increasing by 50.07% in units and 52.93% in dollars. The biggest reason for this is the massive increase in fixed costs. Particularly salaries, which increased by $1.134 million from 2004 to 2006 (54% increase from 2004 to 2006) and rent, which doubled from 2004 to 2006, increasing by $420,000. In this case, margin of safety indicates how much sales did Hallstead actually make above breakeven level, instead of using a budgeted or expected sales value. For 2003, if Hallstead’s sales were 15.09% lower, they would have been at exactly breakeven sales level. Margin of safety decreased significantly from 2003 to 2004, because Hallstead’s sales decreased while its breakeven point increased. Margin of safety continued to drastically decrease from 2004 to 2006 and was actually negative in 2006, meaning they needed to make 8.82% more in sales to have reached breakeven. This occurred because, even though......

Words: 854 - Pages: 4

Premium Essay

Columbia Memorial Hospital Breakeven Analysis

...($3.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

Case 7-20

...considering our breakeven point. Therefore I’m made this report to underline the importance of a good projected income statement. I’ve stated the problem analyses and the consequences of this error. Also I’ve placed my recommendations in this report. As you can see in appendix 1, there’s a big difference in our projected income statement and our income statement based on our actual sales. The deviation of our sold products is different than stated in our projected income statement. Instead of the sales deviation of 48% Sinks, 20% Mirrors and 32% Vanities. Our actual sales deviation of this month is 32% Sinks, 40% Mirrors and 28% Vanities. Because there are differences in the contribution margins of the three products, this has lead to a lower total contribution margin than stated in the projected income statement. Nevertheless we’ve reached our sales of $500,000 we didn’t reach our projected operating income of $36,400. Unfortunately we’ve made a operating loss of $8,600. This is due to the fact that our projected income statement was not accurate enough regarding our total contribution margin. Instead of our projected contribution margin of 52% our real total contribution margin is 43%. I recommend that because of this difference, we also have to change our breakeven point in total sales dollars. As you can see in appendix 1, our breakeven point in total sales shouldn’t be $430,000 but instead of that it should be $520,000. The difference between the two breakeven......

Words: 1321 - Pages: 6

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

Business Apple

...Breakeven for Microsoft and Apple The main purpose for this communication is to address the breakeven for Microsoft and Apple when they develop a new computer operating system. It will also expound on the various challenges that this breakeven rise for Apple, how Apple can overcome these challenges and the sources of Apple’s competitive advantage. Additionally, this memo will address how Apple’s financial performance compares to its rivals, what a DuPont formula analysis explains and challenges that Apple faces moving forward. It will also discuss the moves that Apple should consider moving forward. Subsequently, it will also discuss the stock performance of Apple and how Apple’s retail strategy supports its overall approach to competitive strategy. Lastly, this memo will articulate how important Steve Jobs was to Apple’s future. Breakeven for Microsoft when they develop a new computer operating system The breakeven for Microsoft when they develop a new computer operating system mostly depends on the product being developed since each on them varies. However, Microsoft has ensured that it maintains a breakeven of about 50% for most of its new computer operating system that ensures that Microsoft can cover its expenses prior for it attaining a profit. Microsoft also sets the breakeven quantity in terms of quantity, and the number of months it has to sell so that it can recoup the expenses incurred while developing the new operating system. For example, it had to sell......

Words: 929 - Pages: 4

Free Essay

Breakeven

...1. Analyze Aquarius with respect to the five contextual variables.   How would you describe the environment, goals, culture, size, and technology for Aquarius? According to the case, the environment of Aquarius Advertising Agency is not very stable, which is mainly because other agency specialists avoiding the Account Executives. The goals of Aquarius Advertising Agency are to be creative, imaginative, resourceful but yet unique and to please their customers, and do it better than any other companies can and possibly gain more customers. Today, the culture is changed every day, so the turnover that Aquarius has experienced is a fact of the fast-changing trend; researchers must find better ways to present thoughts that customers would like to accept. The technology is mainly non-routine, because of the emphasis on originality and art. 2. Design a new organization structure that takes into consideration the contextual variables in the case and the information flows. As I see it, the mixture form of structure would be one specific possibility, with account executives reporting to customer group vice-presidents, and most functional departments such as research, media, merchandising, copy department and art department reporting to each of the account executives. The functional heads that would still report directly to the president would probably be legal counsel, finance, and personnel. The structure matches the uncertainty of the environment, and would enable the......

Words: 412 - 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

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

Breakeven Analysis Casestudy

...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...

Words: 1084 - Pages: 5

Premium Essay

Case Study 2 Acct 505

...fare x 100 Fixed operating cost per month $3,150,000 Breakeven point in passengers 35,000 Breakeven point in passengers = Fixed operating cost per month / Contribution Margin per passenger Breakeven point in revenue $5,600,000 Breakeven point in revenue = Fixed operating cost per month / Contribution Margin ratio B: Breakeven point in passengers per month 35,000 Number of seats per passenger train car 90 Total train car needed 388.89 Total Cars Needed = Breakeven point in passengers per month / Number of seats per passenger train car At Average load factor (percentage of seats filled) 70% Break-even point in number of passenger train cars per month 556 Break-even point in number of passenger train cars per month = Total train cars needed / Load factor C: Average full passenger fare $190 Less: Average variable cost per passenger $(70) Contribution Margin per passenger $120 Contribution Margin = Per Passenger fare - Variable cost per passenger Contribution Margin ratio 63.16% Contribution Margin Ratio = Contribution Margin Per Passenger / Average full passenger fare x 100 Fixed operating cost per month $3,150,000 Breakeven point in passengers 26,250 Breakeven point in passengers = Fixed operating cost per month / Contribution Margin per passenger Number of seats per passenger train car 90 Total train car needed 291.67 Total Cars Needed = Breakeven point in passengers per month / Number of seats per......

Words: 960 - Pages: 4

Martech CLIP | Knowing Brother Episode 72 | Babydolls