Cost–Volume–Profit Analysis - Pearson

3y ago
37 Views
2 Downloads
545.04 KB
40 Pages
Last View : 23d ago
Last Download : 3m ago
Upload by : Mara Blakely
Transcription

Cost–Volume–Profit Analysis3How “The Biggest Rock Show Ever”Turned a Big Profit1and Asia, the rock band U2 performed on animposing 164-foot-high stage that resembled aspaceship, complete with a massive video screenand footbridges leading to ringed catwalks. U2used three separate stages—each one costingnearly 40 million. Additional expenses for the tourwere 750,000 daily. As a result, the tour’s suc-Kevin Dietsch/UPI/NewscomOn its recent tour across North America, Europe,cess depended not only on the quality of each night’sconcert but also on recouping its tremendous fixed costs—costs that didLearning Objectivesnot change with the number of fans in the audience.To cover its high fixed costs and make a profit, U2 needed to sell alot of tickets. To maximize the tour’s revenue, tickets were sold for as littleas 30, and a unique in-the-round stage configuration boosted stadiumcapacities by roughly 20%. The plan worked. U2 shattered attendancerecords in most of the venues it played. By the end of the tour, the bandplayed to more than 7 million fans, racking up almost 736 million in ticketand merchandise sales and went into the history books as the biggesttour ever. As you read this chapter, you will begin to understand how andwhy U2 made the decision to lower prices.1. Identify the essential elements ofcost–volume–profit analysis andcalculate the breakeven point(BEP).2. Apply the CVP model to calculatea target operating profit beforeinterest and tax.3. Distinguish among contribution,gross, operating, and net incomemargins, and apply the CVP modelto calculate target net income.Businesses that have high fixed costs have to pay particular attentionto the “what-ifs” behind decisions because making the wrong choicescan be disastrous. Examples of well-known companies that have highfixed costs are American Airlines and General Motors. When companieshave high fixed costs, they need significant revenues just to break even.In the airline industry, for example, companies’ fixed costs are so high thatthe profits most airlines make come from the last two to five passengerswho board each flight! Consequently, when revenues at American Airlinesdropped, it was forced to declare bankruptcy. In this chapter, you will seehow cost–volume–profit (CVP) analysis helps managers minimize such4. Apply the CVP model in decisionmaking and explain how sensitivityanalysis can help managers bothidentify and manage risk.5. Analyze the implications ofuncertainty on decision models.6. Interpret the results of CVPanalysis in complex strategic,multi-product, and multiple costdriver situations.risks.1Sources: Edna Gundersen. 2009. U2 turns 360 stadium into attendance-shattering sellouts. USA Today,October 4; Ray Waddell. 2011. U2’s “360” tour gross: 736,137,344! Billboard, July 29.M03 HORN8443 07 SE C03.indd 57579/18/14 12:33 PM

58 CHAPTER 3 COST–VOLUME–PROFIT ANALYSISCost–volume–profit (CVP) analysis is a model to analyze the behaviour of net incomein response to changes in total revenue, total costs, or both. In reality, businesses operate in a complex environment; a model reduces that complexity by using simplifyingassumptions to focus on only the relevant relationships. The most important elements ina model affect one another in a predictable way. In this chapter, when we determine thebreakeven point (BEP), we include all business function costs in the value chain, not justthose of production. The breakeven point (BEP) is the point at which total revenue minustotal business function costs is 0.Essentials of CVP Analysis LO 1Identify the essential elementsof cost–volume–profit analysisand calculate the breakevenpoint (BEP).The CVP model depends on understanding the effects of cost behaviour on profit, andidentifies only the relevant relationships. The following assumptions identify relevantinformation required to complete a CVP analysis: Changes in the sales volume and production (or purchase) volume are identical (purchase volume would apply to a merchandiser). The ending balances in all inventoriesare zero. Everything purchased is used in production; everything produced is sold. Fora merchandiser, the sales volume of finished goods purchased for resale is identical tothe sales volume sold. All costs are classified as either fixed (FC) or variable (VC). All mixed costs arebroken into their respective fixed and variable components. The fixed costs includeboth manufacturing and non-manufacturing fixed costs. The total variable costsinclude both manufacturing and non-manufacturing variable costs. All cost behaviour is linear (a straight line) within the relevant volume range. The sales price per unit, variable costs per unit, and total fixed costs and sales (orproduction) volume are known. The MIS provides all of this information. Either the product sold or the product mix remains constant, although the volume changes. All revenue and costs can be calculated and compared without considering the timevalue of money.We know that total revenue is the product of total sales volume or quantity (Q) ofunits sold multiplied by the price per unit. We also know that total variable cost is theproduct of total Q units produced multiplied by the cost per unit, and together with fixedcosts (constant cost regardless of production volume) comprise total costs. Based on thesimplifying assumption that Q sold Q produced, the relationship among relevant elements of the CVP model upon which the BEP can be calculated is:Operating income (Unit sales price * Q) - (Unit variable cost * Q) - (Fixed costs)(1)At break even, operating income is zero. So for the break even point, we can rearrangeequation (1) above to be:(Unit sales price * Q) (Unit variable cost * Q) (Fixed costs)CVP Analysis: An ExampleDecision FrameworkWe will begin by looking at an example based on known information about operatingincome (net income before interest and taxes). Then we will determine the required combination of sales volume and unit sales price to break even. In the CVP analysis, only onefactor, sales volume (Q), changes.Example: Wei Shao is considering selling Do-All Software, a home-office software package, at a computer convention in Vancouver. Wei knows she canpurchase this software from a computer software wholesaler at 120 perpackage, with the privilege of returning all unsold packages and receiving afull 120 refund per package. She also knows that she must pay ComputerM03 HORN8443 07 SE C03.indd 589/15/14 4:45 PM

ESSENTIALS OF CVP ANALYSIS 59Conventions, Inc. 2,000 for the booth rental at the convention. She will incurno other costs. Should she rent a booth?Wei faces an uncertain future as she analyzes the information she has at hand. Adecision framework can be applied in this situation:1. Identify the problem and uncertainties. Wei has to resolve two important uncertainties—the unit sales price she can charge and the number of packages (Q) she can sell at that price.2. Obtain information. Wei obtains the relevant information on the variable and fixedcosts to attend the conference and purchase the software. She uses her own information on sales volume and her previous experience at a similar convention in Seattlefour months ago. Wei also gathers published industry information. She realizes thatcustomers may purchase their software from competitors and wants to match hervolume and purchase price to customer demand.3. Predict the future. Wei predicts that she can charge 200 for Do-All Software. She isconfident of the straight line or linear relationship between volume, price, and totalrevenue within her relevant range of 30 to 60 units. However, Wei remains uncertain.Have there been important changes in customer demand over the last four months?Her regular sales in the last couple of months have been lower than she expected. Isshe too optimistic or biased in her predictions?4. Make decisions by choosing among alternatives. Wei will use the CVP relationship tohelp her decide among alternatives available for pricing and quantity sold.5. Implement the decision, evaluate performance, and learn. If Wei attends the conventionthen she will know her outcome or actual profit. This is important feedback to comparewith her predicted profit. Wei can learn from this comparison how to make better decisions in the future.Cost–Volume–Profit AnalysisWei knows that the booth-rental cost of 2,000 is a fixed cost because it must be paideven if she sells nothing. Wei’s variable cost per Do-All Software package is 120 forquantities between 30 and 60 packages. Wei sorts her data into classifications of revenueand total variable cost, then tests two volumes of sales shown in a spreadsheet:Wei Sells 5 PackagesRevenueTotal variable costContribution margin 1,000 ( 200 per package 5 packages)600 ( 120 per package 5 packages) 400Wei Sells 40 Packages 8,000 ( 200 per package 40 packages)4,800 ( 120 per package 40 packages) 3,200The only numbers that change from selling different quantities are total revenues andtotal variable costs. The difference between total revenues and total variable costs is calledthe contribution margin. That is:Revenue - Total variable cost Contribution marginWhat is the breakeven price (BEP) in sales volume Q, where operating income 0?Wei does not yet know her predicted operating income, nor does she know what her minimum Q must be to cover her costs. By including the fixed cost of 2,000 in her analysis,Wei can calculate how operating income changes as Q changes. If she sells only 5 packages, then she will suffer an operating loss of 1,600 ( 400 2,000) and operatingincome 0. If she sells 40 packages then she will enjoy a positive operating income of 1,200 ( 3,200 2,000) and operating income 0.Wei Sells 5 PackagesRevenueTotal variable cost 1,000 ( 200 per package 5 packages) 8,000 ( 200 per package 40 packages)600 ( 120 per package 5 packages)Contribution margin 400Fixed costOperating incomeM03 HORN8443 07 SE C03.indd 59Wei sells 40 Packages2,000 (1,600)4,800 ( 120 per package 40 packages) 3,2002,000 1,2009/15/14 4:45 PM

60 CHAPTER 3 COST–VOLUME–PROFIT ANALYSISBut rather than simply using trial and error, Wei can use the CVP modelQ sold Q purchased for saleIf Wei assumes that operating income 0, she can easily calculate the sales volumeQ at which she will break even: 0 Q * (Unit price - Unit variable cost) - Fixed cost(2)Based on the information she has, Wei can substitute the financial values and complete her calculation as follows: 0 Q * ( 200 - 120) - 2,000 0 Q * ( 80) - 2,000 2,000 80Q 2,000 Q 8025 QContribution margin per unit is the difference between selling price and variable costper unit. In the Do-All Software example, contribution margin per unit is 80 per unit( 200 price per unit 120 variable cost per unit). Simplifying her model further: 0 Q * Contribution margin per unit - Fixed cost(3)When the unit sales price is 200, Wei knows that each unit sold covers the variable costof 120 per unit and provides 80 ( 200 120) that can be used to cover her fixedcost of 2,000. By substituting the known amounts into the formula, Wei can calculatethe BEP of 25 units ( 2000 80): 0 Q * ( 80) - 2,000 2,000 80Q 2,000 Q 8025 QExhibit 3-1 shows the result of calculating the BEP in two formats. On the right is thefamiliar financial statement of comprehensive income format. On the left is a contribution statement of comprehensive income, which groups costs as either variable or fixedaccording to their behaviour. The format of the report does not affect the dollar value ofthe operating income, since the revenue and total costs are identical. What has changed isthe classification system used to report the results.Expressing CVP RelationshipsTo make good decisions using CVP analysis, we must understand these relationshipsand the structure of the contribution statement of comprehensive income in Exhibit 3-1.Exhibit 3-1 ContributionStatement Comparedto Financial StatementFormatQuantity Purchased and Sold 25Contribution FormatRevenue ( 200 25)Financial Statement of Comprehensive Income Format 5,000 5,000 Total variable cost ( 120 25)3,000 Total cost of sales (COS)3,000Total contribution margin2,000Gross margin2,000 Fixed costs (always a total)Operating incomeM03 HORN8443 07 SE C03.indd 60Revenue ( 200 25)2,000 0 Total period costOperating income2,000 09/15/14 4:45 PM

ESSENTIALS OF CVP ANALYSIS 61ABCD16RevenuesVariable costsContribution marginFixed costs7Operating income45FGExhibit 3-2 ContributionStatement ofComprehensive Incomefor Different Quantities ofDo-All Software PackagesSoldHNumber of Packages Sold23E0152540 200 per package 0 200 1,000 5,000 8,0000600 3,000 4,800120120 per package80 per package080400 2,000 3,2002,0002,0002,000 2,0002,0002,0000 1,200 (2,000) (1,920) (1,600) There are three related ways (we will call them methods) to think more deeply aboutand model CVP relationships:1. The equation method2. The contribution margin method3. The graph methodThe equation method and the contribution margin method are most useful whenmanagers want to determine operating income at a few specific levels of sales (for example, in Exhibit 3-2, there are 1, 5, 25, and 40 units sold). The graph method helps managers visualize the relationship between units sold and operating income over a wide rangeof quantities of units sold. As we shall see later in the chapter, different methods are usefulfor different decisions.Equation MethodEach column in Exhibit 3-2 is expressed as an equation.Revenues - Variable costs - Fixed costs Operating incomeHow are revenues in each column calculated?Revenues Selling price (SP) * Quantity of units sold (Q)How are variable costs in each column calculated?Variable costs Variable cost per unit (VCU) * Quantity of units sold (Q)So,caSelling Quantity ofVariable cost Quantity ofFixedOperating*b - a*bd priceunits soldper unitunits soldcostsincome(4)Equation 4 becomes the basis for calculating operating income for different quantities ofunits sold. For example, if you go to cell F7 in Exhibit 3-2, the calculation of operatingincome when Wei sells 5 packages is( 200 * 5) - ( 120 * 5) - 2,000 1,000 - 600 - 2,000 - 1,600Contribution Margin MethodRearranging equation 4,caSelling Variable costQuantity ofFixedOperatingb * abd priceper unitunits soldcostsincomeaContribution margin Quantity ofFixedOperating*b per unitunits soldcostsincome(5)In our Do-All Software example, contribution margin per unit is 80 ( 200 - 120),so when Wei sells 5 packages,Operating income ( 80 * 5) - 2,000 - 1,600M03 HORN8443 07 SE C03.indd 619/15/14 4:45 PM

62 CHAPTER 3 COST–VOLUME–PROFIT ANALYSISEquation 5 expresses the basic idea we described earlier—each unit sold helps Weirecover 80 (in contribution margin) of the 2,000 in fixed costs.The calculation for the contribution margin method can also be rearranged to showthe breakeven point (BEP) in relation to fixed costs and the contribution margin per unit.BEP Total fixed costsContribution margin per unitGraph MethodIn the graph method, we represent total costs and total revenues graphically. Each isshown as a line on a graph. Exhibit 3-3 illustrates the graph method for Do-All Softwaresales. Because we have assumed that total costs and total revenues behave in a linearfashion, we need only two points to plot the line representing each of them.1. Total costs line. The total costs line is the sum of fixed costs and variable costs. Fixedcosts are 2,000 for all quantities of units sold within the relevant range. To plot thetotal costs line, use as one point the 2,000 fixed costs at zero units sold (point A)because variable costs are 0 when no units are sold. Select a second point by choosingany other convenient output level (say, 40 units sold) and determine the corresponding total costs. Total variable costs at this output level are 4,800 ( 40 units * 120per unit). Remember, fixed costs are 2,000 at all quantities of units sold within therelevant range, so total costs at 40 units sold equal 6,800 ( 2,000 4,800),which is point B in Exhibit 3-3. The total costs line is the straight line from point Athrough point B.2. Total revenues line. One convenient starting point is 0 revenues at 0 units sold, whichis point C in Exhibit 3-3. Select a second point by choosing any other convenient outputlevel and determining the corresponding total revenues. At 40 units sold, total revenuesare 8,000 ( 200 per unit * 40 units), which is point D in Exhibit 3-3. The totalrevenues line is the straight line from point C through point D.Profit or loss at any sales level can be determined by the vertical distance betweenthe two lines at that level in Exhibit 3-3. For quantities fewer than 25 units sold, totalcosts exceed total revenues, and the purple area indicates operating losses. For quantities greater than 25 units sold, total revenues exceed total costs, and the blue-green areaindicates operating incomes. At 25 units sold, total revenues equal total costs. Wei willbreak even by selling 25 packages.Exhibit 3-3 Cost–Volume–Profit Graph forDo-All Software ngincome ostsline*4,000Breakevenpoint 25 units2,000 AFixedcostsOperatingloss areaC1020253040x50Units Sold*Slope of the total costs line is the variable cost per unit 120**Slope of the total revenues line is the selling price 200M03 HORN8443 07 SE C03.indd 629/15/14 4:45 PM

USING CVP TO CALCULATE A TARGET OPERATING INCOME 63Contribution Margin Percentage:Breakeven Point in RevenueInstead of expressing contribution margin as a dollar amount per unit, we can alsoexpress it as a percentage. Contribution margin percentage (also called contribution margin ratio) equals the contribution margin per unit divided by the selling price per unit:Contribution margin percentage 80 0.40, or 40, 200The contribution margin percentage tells us how many pennies per 1.00 of revenuecontribute to paying fixed costs. For example, a contribution margin percentage of 40%means for each 1.00 a customer pays for Do-All Software, 0.40 contributes to payingfixed cost.The contribution margin percentage enables us to solve for values with partial data.For example, how do you calculate the breakeven point in revenue when you do notknow the sales price per unit? The solution is shown below: 2,000BreakevenFixed costs 5,000 Contribution margin ,0.40revenueProof: 5,000 200 25 unitsFrom previous calculations, we know the BEP in units is 25.Using CVP to Calculate a Target OperatingIncomeThe breakeven point (BEP) can be calculated as either the minimum sales quantity or theminimum revenue required to avoid a loss. However, the point of for-profit business isto earn a profit, not to break even. The CVP model can also be used to calculate a targetoperating income.Let’s go back to the example of Wei Shao and Do-All Software. Wei can apply hermodel to determine what her quantity purchased and sold must be to make a positiveoperating income. Instead of setting Operating income 0, it is set to equal a non-zeroamount. The method of calculating this target quantity is identical to the method alreadydescribed. Wei selects 1,500 as her target operating income. LO 2Apply the CVP model to calculate a target operating profitbefore interest and tax. 1,500 Q * (Unit sales price - Unit variable cost) - Fixed costQ * ( 200 - 120) - 2,000 1,500 80 * Q 2,000 1,500Q 3,500 , 80 per unit 43.75 unitsAlternatively, Wei knows the contribution margin per unit and can calculate the Qrequired to achieve a target operating income of 1,500 by starting at the second line ofthe solution, treating the target operating income as if it were a fixed cost. This is exactlywhat we have done when adding the 1,500 to the 2,000 to obtain 3,500. Th

58 CHAPTER 3 COST–VOLUME–PROFIT ANALYSIS Cost–volume–profit (CVP) analysis is a model to analyze the behaviour of net income in response to changes in total revenue, total costs, or both.

Related Documents:

Cost-Volume-Profit Analysis Overview This chapter explains a planning tool called cost-volume-profit (CVP) analysis. CVP analysis examines the behavior of total revenues, total costs, and operating income (profit) as changes occur in the units sold, the selling price, the variable cost

11.1 ECONOMIC COST AND PROFIT 11.1 ECONOMIC COST AND PROFIT Figure 11.1 shows two views of cost and profit. Economists measure cost as the sum of explicit costs and implicit costs, which equals opportunity cost. 11.1 ECONOMIC COST AND PROFIT Normal profit is an implicit cost. Accountants measure cost as explicit costs and accounting depreciation.

Pearson Education LTD. Pearson Education Australia PTY, Limited. Pearson Education Singapore, Pte. Ltd. Pearson Education North Asia, Ltd. Pearson Education Canada, Ltd. Pearson Educación de Mexico, S.A. de C.V. Pearson Education—Japan Pearson Education Malaysia, Pte. Ltd. The Libra

Pearson Education LTD. Pearson Education Australia PTY, Limited. Pearson Education Singapore, Pte. Ltd. Pearson Education North Asia, Ltd. Pearson Education Canada, Ltd. Pearson Educatión de Mexico, S.A. de C.V. Pearson Education—Japan Pearson Education Malaysia, Pte. Ltd. Library of Co

TOI: Target operating income 3-1 Define cost–volume–profit analysis. Cost-volume-profit (CVP) analysis examines the behavior of total revenues, total costs, and operating income as changes occur in the units sold, selling price, variable cost per unit, or fixed costs of a product. 3-2 Describe

Pearson (UK) 80 Strand, London WC2R 0RL, UK T 44 (0)20 7010 2000 F 44 (0)20 7010 6060 firstname.lastname@pearson.com www.pearson.com Pearson (US) 1330 Avenue of the Americas, New York City, NY 10019, USA T 1 212 641 2400 F 1 212 641 2500 firstname.lastname@pearson-inc.com www.pearson.com Pearson Education One Lake Street, Upper Saddle River,

Practical Guide to SAP . 1.3 Evolution of profit center accounting 17 1.4 Summary 20 2 Master data in PCA 21 2.1 Profit center 21 2.2 The dummy profit center 30 2.3 Profit center standard hierarchy 31 2.4 Profit center group 34 2.5 Revenue/cost elements and accounts 37 2.6 Account groups 38 2.7 Statistical key figures 39 2.8 Profit center assignment 43 2.9 Summary 55 3 Planning in classic .

Ratio 104 121 143 165 195 231 273 319 377 473 559 649 731 841 1003 1247 1479 1849 2065 2537 3045 3481 4437 5133 6177 7569 50 Hz 60 Hz 13.9 12.0 10.1 8.79 7.44 6.28 5.31 4.55 3.85 3.07 2.59 2.23 1.98 1.72 1.45 1.16 0.98 0.754 0.702 0.572 0.476 0.417 0.327 0.282 0.235 0.192