...AS REVISION SUMMARY BREAK – EVEN • DEFINITION • USES OF B/E • BASIC CALCULATIONS • CONTRIBUTION • CALCULATING B/E POINT • B/E CHARTS • B/E ANALYSIS & EVALUATION • EXAMINERS TIPS NAME: ______________________________ TUTOR GROUP: _____________________ BREAK-EVEN ANALYSIS DEFINITION: - The level of output at which business sales provide just enough revenue to cover all the costs of production. - At the B/E level of output, a business has made NO PROFIT. WHY USE BREAK – EVEN ANALYSIS? 1. To help a business decide how much it needs to produce and sell to make a profit 2. Break – even can illustrate the impact of changes in levels of production on the profitability of a business 3. Break – even analysis can help support an application for a loan at the bank. 4. Break – even analysis can be used to compare the profitability of a range of products. BASIC CALCULATION: Examples: a) A furniture shop makes one type of chair that costs £80. At this price the shop is just breaking even. They are considering increasing the price of the chair to £96. Q1 what % has the price increased? ___________________________________________________________ Q2 what profit would the furniture shop make if sold 150 chairs? ___________________________________________________________ ___________________________________________________________ CONTRIBUTION Contribution is the most important factor when calculating B/E It...
Words: 1289 - Pages: 6
...14/05/2014 Mixed Costs Total Mixed Cost VC Per Unit (Slope) Purpose of Mixed Cost Analysis To predict cost at an activity level with no historical record: Total mixed cost line can be expressed as: 2N Y Total Utility Cost Fixed Cost (Intercept) Level of Activity If your fixed monthly utility charge is $40, your variable cost is $0.03 per kilowatt hour, can you predict the utility of next month when you plan to use 2,000 kilowatt hours? Y = a + bX Variable Cost per KW Fixed Monthly Utility Charge Y = $40 + ($0.03 × 2,000) Y = $100 X Activity (Kilowatt Hours) A mixed cost has both fixed and variable components. Total cost CHANGES with activity level but NOT IN PROPORTION The High-Low Method 1. Find the data with highest & lowest activity level 2. Compare high vs low point data to get the slope, b, unit VC 3. Use either high or low point data to get a, total fixed cost Assume the following hours of maintenance work and the total maintenance costs for six months. Y = a + bX • From Algebra, if we know any two points on a line, we can determine its slope. 2. Break-Even Analysis (J. Smith ~ Taxi Driver) Break Even Point is the point at which costs and sales are equal CM = fixed costs. Fixed costs (FC) Insurance Car payment Interest Dispatcher fees Variable costs (VC) Gas Maintenance & repairs neither gain nor loss $ (principal or amortization) Value of Costs or Revenue Step 2, the slope or b is determined by difference...
Words: 1150 - Pages: 5
...❏ BEP Analysis n = number of units/volume B = Breakeven volume TC = Total cost P = Unit (selling) price FC = Fixed cost VC = Variable cost; TFC = Total Fixed Cost TVC = Variable Cost/Unit Revenue/period = n P TC/period = n VC + FC Profit/Loss = Revenue - TC = n P - (n VC + FC) = n (P - VC) - FC At BEP, Profit = 0 ==> 0 = n (P - VC) - FC or n = FC P - VCChapter 5: Revenue and Cost Analysis 10/19/98 6 ❍ P - VC is called contribution margin (CM), ❖ The difference between selling price and variable costs. It is the portion of the selling price that contributes to paying off the fixed cost (after covering VC). ❖ When the total contribution margin is exactly equal to total fixed costs, sales are at the Break-Even Point. The contribution of each unit sold beyond BEP is the increment of profit. ❍ At n = B the sum of contributions from units equals the total fixed cost. The contribution of each unit sld beyond n = B is an increment of profit. ❍ Example 5-1: If VC is 60% of sales; with unit price at $10/each and FC = $40,000. What is the total sales? Sales @ BEP = a (Sales @ the BEP) + TFC X = .60(X) + $40,000 X = $100,000 To find break-even in units: $100,000/$10.00 = 10,000 or BEP in units = TFC/(Price-VC per unit) $40,000/($10.00-$6.00) = 10,000 ❍ Example 5-2: A small coal mine can produce a max of 100,000 tons per month. The coal sells for $30.00 per ton and the contribution contribution is around 75%. TFC per month is $1,850,000. How many tons of...
Words: 412 - Pages: 2
...Break-Even Analysis Kelly Rosales FIN/200 September 6, 2013 Albert Schweigert Break-Even Analysis 13. Healthy Foods, Inc., sells 50-pound bags of grapes to the military for $10 a bag. The fixed costs of this operation are $80,000, while the variable costs of the grapes are $.10 per pound. A. What is the break-even point in bags? BE=Fixed costsContribution margin=Fixed costsPrice-Variable cost per unit=FCP-VC BE=$80,000$10-($.10×50)=$80,000$5=16,000 B. Calculate the profit or loss on 12,000 bags and on 25,000 bags. C. What is the degree of operating leverage at 20,000 bags and at 25,000 bags? DOL=Q (P-VC)Q P-VC-FC Q represents beginning units sold (all calculations should be done at this level). P can be found by dividing total revenue by units sold. VC can be found by dividing total variable costs by units sold. DOL 20,000 bags=20,000 $10-$520,000 $10-$5-$80,000=$100,000$20,000=5.0x DOL 25,000 bags=25,000 $10-$525,000 $10-$5-$80,000=$125,000$45,000=2.78x Why does the degree of operating leverage change as the quantity sold increases? The closer the degree of operating leverage is calculated to the corporation’s break-even point, the higher the number will be because a large ratio increase in the income of operation (Block, Hirt, & Danielsen, 2009). The degree of operating leverage changes as the quantity sold increases because degree of operating leverage measures the percentage adjustment in operating income as a result of a percentage change...
Words: 438 - Pages: 2
...The Basic Profit Equation: Cost-Volume-Profit analysis (CVP) relates the firm’s cost structure to sales volume and profitability. A formula that facilitates CVP analysis can be easily derived as follows: Profit = Sales – Expenses Profit = Sales – (Variable Costs + Fixed Costs) Profit + Fixed Costs = Sales – Variable Costs Profit + Fixed Costs = Units Sold x (Unit Sales Price – Unit Variable Cost) This formula is henceforth called the Basic Profit Equation and is abbreviated: P + FC = Q x (SP – VC) Contribution margin is defined as Sales – Variable Costs The unit contribution margin is defined as Unit Sales Price – Unit Variable Cost Typically, the Basic Profit Equation is used to solve one equation in one unknown, where the unknown can be any of the elements of the equation. For example, given an understanding of the firm’s cost structure and an estimate of sales volume for the coming period, the equation predicts profits for the period. As another example, given the firm’s cost structure, the equation indicates the required sales volume Q to achieve a targeted level of profits P. If targeted profits are zero, the equation simplifies to Q = FC ÷ Unit Contribution Margin Q = FC ÷ Unit Contribution Margin In this case, Q indicates the required sales volume to break even, and the exercise is called breakeven analysis. Target Costing: A relatively recent innovation in product planning and design is called target...
Words: 791 - Pages: 4
...(429) | (405) | (536) | Total Variable Cost | (4755) | (4537) | (6106) | Total Contribution Margin | 3828 | 3565 | 4605 | Contribution Margin Per Unit | .7167 | .6706 | .6677 | Fixed Cost | 2003 | 2004 | 2006 | Salaries | 2021 | 2081 | 3215 | Advertising | 254 | 250 | 257 | Administrative Exp | 418 | 425 | 435 | Rent | 420 | 420 | 840 | Depreciation | 84 | 84 | 142 | Misc. | 53 | 93 | 122 | Total | 3250 | 3353 | 5011 | Breakeven analysis: For this part of the case study we used the following formulas to get Breakeven in units and Breakeven sales. The calculations can be found below and are in thousands of dollars. * Breakeven # of tickets = total FC / (selling price per ticket - VC per ticket) * Breakeven in sales dollars = [total FC / (selling price per ticket - VC per ticket)] * (selling price per ticket) or total FC/ CM ratio * Margin of Safety = Expected Sales - Breakeven in Sales Dollars Results | 2003 | 2004 | 2006 | Break even # units | 4,535 | 5,000 | 7473 | Break even sales dollars | 7,323.994 | 7,606.797 | 11,495.82 | Margin of Safety | 1259 | 495.2 | (1259) | Calculations 2003 Breakeven Units: FC (3250) / CM (.71672) = 4,534.546 Breakeven sales: Total FC (3250) / CM ratio (.44375) = $7,323.944 Margin of Safety: Sales (8,583) - Breakeven Sales (7,323.994) = 1259 2004 Breakeven Units: FC (3353) / CM (.6706) = 5000 Breakeven sales dollars: Total FC (3353)...
Words: 1507 - Pages: 7
...1) Variable expenses in relation to Revenue Hours are Power, Wages of Hourly Personnel, Corporate services, and Sales Promotions. Variable Expenses | January | February | March | Power | $1546 | $1485 | $1697 | Hourly Personnel | $7896 | $7584 | $8664 | Corporate Services | $15,424 | $15,359 | $15,236 | Sales Promotions | $7,909 | $7,039 | $8,083 | TOTAL VC | $32,775 | $31,467 | $33,680 | FixedExpenses | January | February | March | Space Costs | $9,240 | $9,240 | $9,240 | Equipment Costs | $126,580 | $126,580 | $126,580 | Salaries | $53,800 | $53,800 | 53,800 | TOTAL FC | $189,620 | $189,620 | $189,620 | 2) Cost per Revenue Hour for Variable Expenses: Revenue Hours> | January329 | February316 | March361 | Power | $1546 | $1485 | $1697 | Cost/Revenue Hr. | $4.70/hr. | $4.70/hr. | $4.70/hr. | Hourly Personnel | $7896 | $7584 | $8664 | Cost/Revenue Hr. | $24/hr. | $24/hr. | $24/hr. | Corporate Services | $15,424 | $15,359 | $15,236 | Cost/Revenue Hr. | $46.88 | $48.60 | $42.20 | Sales Promotions | $7,909 | $7,039 | $8,083 | Cost/Revenue Hr. | $24.04/hr. | $22.28/hr. | $22.39/hr. | 3) Contribution margin income statement for Salem Data Services Assumption: Intra company usage=205 hours; Commercial usage for March=138 hours Revenue Hours Intra company: 205 Commercial: 138 Total Revenue Hours: 343 Salem Data Services Income Statement | | Revenues | | Intra company...
Words: 928 - Pages: 4
...MKT500: Breakeven – Determining Your Costs Companies have a variety of costs with which they grapple. To keep things simple, we will look at Variable Costs (VC) and Fixed Costs (FC). The combination of VC and FC = TOTAL Costs. In effect, VC + FC = TC. What's a Fixed Cost (FC)? Fixed costs (FC) are costs that do NOT vary as your sales volume increases or decreases. Whether you sell one widget or 50,000 widgets, these are known costs that your company will have to pay regardless of volume of widgets sold. Fixed Costs (FC): These might include fixed staff salaries, lease/rent, debt service, insurance -- in effect, any KNOWN cost that will remain constant, e.g., your insurance premium for 12 months is $12,000… or $1,000 for each and every month. Whether you sell many widgets or sell nothing, you still have to pay that monthly insurance premium, monthly lease/rent, salaries! Variable Costs (VC): These increase linearly as your sales increase or decrease. Some examples of Variable Costs (VC) that companies have include raw materials and thus the cost of goods sold, sales commissions, shipping charges, delivery charges, hourly salaries and overtime, costs of direct materials or supplies and direct labor. Thus, an increase in widgets manufactured might necessitate more plastic moldings, more gizmos, possible overtime, more electricity to run the equipment that is used to manufacture the widgets, etc. Each additional widget manufactured increases your overall...
Words: 982 - Pages: 4
...King Abdul Aziz University Engineering Management Executive Program IEEM 680 Financial Analysis & Economics for Engineers Prof. Seraj Abed Team members: 1. Fahad Alsobhi 1401722 2. Meshal Alserehi 1401734 3. Anas Shata 1401749 Problem 3-17 Assume the following data for Cable Corporation and Multimedia | | | Cable Corporation | MM Inc | | Net income | $ 30,000 | $ 100,000 | | Sales | 300,000 | 2,000,000 | | Total assets | 400,000 | 900,000 | | Total debt | 150,000 | 450,000 | | Stockholders' equity | 250,000 | 450,000 | | a. Compute return on stockholders' equity for both firms using ratio 3a. Which firm has the higher return? | Cable Corp. | Multi-Media.INC | Return on Equity=Net IncomStockholder Equity | 30,000250000=12% | 100,000450,000=22.2% | b. Compute the following additional ratios for both firms. Net income/Sales Net income/Total assets Sales/Total assets Debt/Total assets | | Cable Corporation | Multi-Media.INC | Net IncomSales | 30,000300,000=10% | 100,0002,000,000=5% | Net IncomTotal Asset | 30,000400,000=7.5% | 100,000900,000=11.1% | SalesTotal Asset | 300,000400,000=75% | 2000,000900,000=222.2 | DeptTotal Asset | 150,000400,000=37.5% | 450,000900,000=50% | C: The equity for multimedia is higher than the cable company. We see that the profit is higher in the cable company by 5%. Problem 3-21: Jim Short's company makes clothing for schools...
Words: 3438 - Pages: 14
...Table of Content Executive Summary 1 Background 2 Analysis 3 Recommendations 4 Appendix A- Summary of Computer Utilization 5 Appendix B- Summary Results of Operations, First Quarter 2004 6 Appendix C- Variable and Fixed Cost in respect to revenue hours 7 Appendix D- Breakdown of Variable Cost per Hour Usage 8 Appendix E- Contribution Margin Income Statement, March 2004 9 Appendix F- Contribution Margin Ratios 11 Appendix G- Break-even Analysis 12 Appendix H- “What if” Analysis 13 Executive Summary Since 2001, Salem Data Services has been operating at a net loss. After review the reports from first quarter 2004, it has become apparent that action will be necessary. Through our examination of the first quarter 2004 reports, we have concluded three key areas to focus on. These include utilization of computer usage hours, how the results of the operations have been unprofitable, and how sales promotions are not tied to current levels of work. Our analysis begins with careful inspection of the variable and fixed costs of Salem Data Services. It is clear the variable costs equaling $32,640, do not contribute enough to covering the total fixed costs of $189,620. The other focus of the analysis lies in the re-evaluating the usage hours available for Commercial Sales. Currently the level of Commercial Sales is under utilized. Available hours need to be maximized to eliminate the current loss and begin to show growth and profit. We have included data...
Words: 2617 - Pages: 11
...Budgeted Amount | 13,063 | Per Unit | Budgeted Amount | Sales | $815 | 8,279,000 | | $814 | 8,117,000 | | $816 | 10,656,000 | VC | $468 | (4,750,000) | | $467 | (4,654,000) | | $467 | (6,106,000) | CM | $347 | 3,529,000 | | $347 | 3,463,000 | | $349 | 4,550,000 | FC | | $(3,230,000) | | | $(3,333,000) | | | $(4,921,000) | NI | | $299,000 | | | $130,000 | | | $(371,000) | Break-even point in units and dollars | | 2008 | 2009 | 2011 | Break-even point (Unit) | 3,230,000/347=9,308 | 3,333,000/347=9,605 | 4,921,000/349=14,100 | Break-even point (Dollar) | 9,308*815=$7,586,020 | 9,605*814=$7,818,470 | 14,100*816=$11,505,600 | Break-even point (Unit)= Fixed cost/Contribution Margin per unit Break-even point (Dollar)= Break-even point (Unit) x Sales per unit Margin of safety (%)= (Budgeted sales – Break-even sales)/Budgeted sales Margin of safety (%) | | 2008 | 2009 | 2011 | Margin of safety (%) | (8,279,000-7,586,020)/8,279,000= 8.4% | (8,117,000-7,818,470)/ 8,117,000= 3.7% | (10,656,000-11,505,600)/10,656,000= -8.0% | Index 2. New Income statement (Contribution Margin) | | 2008 | | | 2009 | | | 2011 | | 13,800 | Per Unit | Budgeted Amount | 13,800 | Per Unit | Budgeted Amount | 13,800 | Per Unit | Budgeted Amount | Sales | $774 | 10,681,200 | | $773 | 10,667,400 | | $775 | 10,695,000 | VC | $468 | (6,458,400) | | $467 | (6,444,600) | | $467 | (6,444,600) | CM | $306 | 4,222,800 | | $301 | 4,222,800 | | $308...
Words: 1147 - Pages: 5
...Table of Contents Page 1. Background …………………………………………………………………. 1 2. Company Description ……………………………………………………….. 1 3. Strategic Focus and Plan…………………………………………………….. 1 • Mission Statement……………………………………………………... 1 • Goals…………………………………………………………………… 2 4. Competitive Advantage ……………………………………………………… 2 5. Situational Analysis ………………………………………………………….. 3 • SWOT Analysis…………………………………………………………. 3 • Environmental Forces…………………………………………………… 3 • Consumer Analysis……………………………………………………… 4 6. Market product Grid ………………………………………………………… 5 • Service Offering………………………………………………………... 6 • Service Strategy………………………………………………………… 6 7. Break-Even Point …………………………………………………………….. 6 8. Marketing Program ………………………………………………………….. 10 • Promotion Strategy…………………………………………………….. 10 • Promotion Schedule……………………………………………………. 11 • Promotion Strategy (cont.)……………………………………………… 12 9. Implementation Phase …………………………………………………………. 13 10. Executive Summary ……………………………………………………………. 14 11. Bibliography …………………………………………………………………….. 16 Company Description Kids “R” Us Babysitting Service is a new and local child care service located in Harlingen, TX. After performing a brief survey to the local families in Harlingen, their main concern was trustworthy and reliable child care in the evening hours at their home. Reva Leanna Rodriguez, founder of Kids “R” Us Babysitting Service, knew this was exactly what the families of Harlingen needed. Kids “R” Us offers local babysitting services for...
Words: 3272 - Pages: 14
...Royalties | ($0.35) | Recording Artists' Royalties | ($1.00) | Contribution per CD unit | $6.40 | B. Break-Even volume in CD units Fixed Cost: | | | | | | Advertising | $275,000 | | Break-Even in Units | | Overhead | $250,000 | | $525,000 | = 82031.25 | units | Total | $525,000 | | $6.40 | | | | | | | | | Contribution per CD Unit | $6.40 | | | | | Break-Even Volume in Dollars Break-Even (Units) * Selling Price | 82.031.25 * $ 9.00 = | $738,281.25 | C. Net profit if 1 million CDs are sold $ 9.00 * $1,000,000 | $9,000,000 | $ 6.40 * $1,000,000 | ($6,400,000) | Fixed Cost | ($525,000) | Net Profit | $2,075,000 | D. Necessary CD unit volume to achieve a $200,000 profit $525,000 + $200,000 | = 113,281.25 | necessary CD unit volume | 6.40 | | | 2. A. VCI's unit contribution and contribution margin Unit contribution | | X | = 40% | $20 | | | | X = $8 required return | | | | Variable Costs per Unit | Reproduction | $4.00 | Labels and packaging | $0.50 | Royalties | $0.50 | Required Return | $8.00 | Total | $13.00 | | | Unit Contribution = Selling Price - Variable Cost | $20 - $13 | = $7.00 | | | Contribution Margin = | Selling Price - VC | | Selling Price | | | $20-$13 | = 35% | $20 | | B. Break-even in Units and Dollars BE units = Fixed Costs/ (Selling Price – Variable Cost) FIXED COSTS | | ...
Words: 1980 - Pages: 8
...FORMULAS CHAPTERS 12, 14, 15 AND 16. CH 12 BREAK EVEN ANALYSIS Sales price EBIT = 0 = units X per unit Break-even level of units variable cost - units X sold per unit total fixed + sold cost total fixed cost = sales price variable cost per unit − per unit Total fixed cost S* = F/ [1 – (VC / S)] Break-even level of revenues = variable cost 1revenues Degree of operating leverage DOLs = Q (P – V) / [Q (P – V) – F] DOLs = revenue before fixed cost / EBIT = S – VC / [S - VC – F] Degree of financial leverage DFLEBIT = EBIT / (EBIT - I) Degree of combined leverage DCLS = (DOLS) X (DFLEBIT) EBIT – EPS indifference point: EPS: Stock plan (EBIT – I)(1 – t) – P / Ss = EPS: Bond plan (EBIT – I)(1 – t) – P / Sb EBIT = [Ib – Is (Sb / Ss ] / [ 1 - (Sb / Ss) ] 14 SHORT-TERM FINANCIAL PLANNING CURRENT ASSETS AS A PERCENTAGE OF SALES = Current assets / sales Projected current assets = projected sales X (current assets / sales) Projected addition net income cash dividends X 1 − = projected sales X to retained earnings sales net income Discretionary financing = projected total assets – projected liabilities – projected owner’s equity needed (DFN) predicted change predicted change − DFN = in total assets predicted change − in spontaneous liabilities in retained earnings External financing needs (EFN) EFN = predicted change in total assets – change in retained earnings ...
Words: 532 - Pages: 3
...10/24/2011 WHAT IS A FEASIBILITY STUDY • A feasibility study is defined as an evaluation or analysis of the potential FEASIBILITY STUDY impact of a proposed project or program. It is conducted to assist decision‐ makers in determining whether or not to implement a particular project or p g program. • The study is based on extensive research on both the current practices & the proposed project & its impact on the current practice of the enterprise. • The feasibility study will contain wide‐ranging of data related to financial & operational impact & will include advantages & disadvantages of both the current situation & the proposed plan. • The feasibility study is conducted during the deliberation phase of the business development cycle prior to commencement of a formal Business business development cycle prior to commencement of a formal Business Plan. It is an analytical tool that includes recommendations & limitations, which are utilized to assist the decision‐makers when determining if the Business Concept is viable (Drucker 1985; Hoagland & Williamson 2000; Thompson 2003c; Thompson 2003a). Mahfuzul Hoque Ph D Mahfuzul Hoque Ph. D Professor , Faculty of Business Studies, Department of Accounting & Information Systems, University of Dhaka. October 24, 2011 • • • DMH‐ Project Management 1 THE IMPORTANCE OF A BUSINESS FEASIBILITY STUDY It is estimated that only one in fifty business ideas are actually ...
Words: 4286 - Pages: 18