Accounting
Break Even Point and Contribution Margin Analysis
Break even point and contribution margin analysis, also known as costvolumeprofit (CVP) analysis, helps managers perform many useful analyses. It deals with how profit and costs change with a change in volume. More specifically, it looks at the effects on profits of changes in such factors as variable costs, fixed costs, selling prices, volume, and mix of products sold. By studying the relationships of costs, sales, and net income, management is better able to cope with many planning decisions. Breakeven analysis determines the breakeven sales. Breakeven point—the financial crossover point when revenues exactly match costs—does not show up in corporate earnings reports, but managers find it an extremely useful measurement in a variety of ways.
Through this post, I am going to demonstrate various break even point and contribution margin analysis in details with load of case examples. It’s not merely about break even point and contribution margin formula and calculation, it is also about the concept and the tax effect. Enjoy!
Advertisement
Questions Answered by Breakeven and Contribution Margin Analysis
Breakeven and contribution margin analysis tries to answer these five questions:
 What sales volume is required to break even?
 What sales volume is necessary to earn a desired profit?
 What profit can be expected on a given sales volume?
 How would changes in selling price, variable costs, fixed costs, and output affect profits?
 How would a change in the mix of products sold affect the breakeven and target income volume and profit potential?
Contribution Margin Income Statement
The traditional income statement for external reporting shows the functional classification of costs, that is, manufacturing costs versus nonmanufacturing expenses (or operating expenses). An alternative format of income statement, known as the contribution margin income statement, organizes the costs by behavior rather than by function. It shows the relationship of variable costs and fixed costs a given cost item is associated with, regardless of the functions.
The contribution approach to income determination provides data that are useful for managerial planning and decision making. The statement highlights the concept of contribution margin, which is the difference between sales and variable costs. The traditional format emphasizes the concept of gross margin, which is the difference between sales and cost of goods sold.
These two concepts are independent and have nothing to do with each other. Gross margin is available to cover nonmanufacturing expenses, whereas contribution margin is available to cover fixed costs. A comparison is made between the traditional format and the contribution format below:
Contribution Margin [Concept—Formula—Case Examples]
For accurate breakeven and contribution margin analysis, a distinction must be made between costs as being either variable or fixed. Mixed costs must be separated into their variable and fixed components.
In order to compute the breakeven point and perform various breakeven and contribution margin analyses, note these important concepts:
Contribution Margin (CM). The contribution margin is the excess of sales (S) over the variable costs (VC) of the product or service. It is the amount of money available to cover fixed costs (FC) and to generate profit. Symbolically, CM = S – VC.
Unit CM. The unit CM is the excess of the unit selling price (p) over the unit variable cost (v). Symbolically, unit CM = p – v.
CM Ratio. The CM ratio is the contribution margin as a percentage of sales, that is:
CM ratio = CM/S = [SVC]/s = 1[VC/S]
The CM ratio can also be computed using perunit data:
CM ratio = Unit CM/p = [pv]/p = 1[v/p]
Note: that the CM ratio is 1 minus the variable cost ratio. For example, if variable costs account for 70 percent of the price, the CM ratio is 30 percent.
Example 1
To illustrate the various concepts of CM, consider these data:
From the data listed, CM, unit CM, and the CM ratio are computed as:
CM = S – VC = $37,500$15,000 = $22,500
Unit CM = pv = $25 – $10 = $15
CM Ratio = CM/S= $22,500/$37,500 = 60% 0r Unit CM/p = $15/$25 = 0.6 = $60%
Breakeven Point Analysis
The breakeven point represents the level of sales revenue that equals the total of the variable and fixed costs for a given volume of output at a particular capacity use rate. For example, one might want to ask the breakeven occupancy rate (or vacancy rate) for a hotel or the breakeven load rate for an airliner.
Generally, the lower the breakeven point, the higher the profit and the less the operating risk, other things being equal. The breakeven point also provides nonfinancial managers with insights into profit planning.
Break Even Point can be computed using these formulas:
Breakeven point in units = Fixed Cost/Unit CM
Breakeven point in dollars = Fixed Cost/CM Ratio
Using the same data given in Example 1, where unit CM = $25 – $10 = $15 and CM ratio = 60%, we get:
Breakeven point in units = $15,000/$15 = 1,000 units
Breakeven point in dollars = $15,000/0.6 = $25,000
Or, alternatively:
1,000 units x $25 = $25,000
Determination of Target Income Volume
Besides determining the breakeven point, breakeven and contribution margin analysis determines the sales required to attain a particular income level or target net income.
The formula is:
Target Income Volume = [Fixed Cost + Target Income]/Unit CM
Example 3
Using the same data given in Example 1, assume that Lie Dharma Store wishes to attain a target income of $15,000 before tax.
Then the target income volume would be:
($15,000 + $15,000) / ($25 – $10) = $30,000/$15 = 2,000 units
Impact of Income Taxes
If target income is given on an aftertax basis, the target income volume formula becomes:
Target income volume = [Fixed costs + (Target aftertax income/(1tax rate)]/Unit CM
Example 4
Assume in Example 1 that Lie Dharma Store wants to achieve an aftertax income of $6,000. The tax rate is 40 percent. Then:
Target Income Volume
= [$15,000 + ($6,000/(10.4)]/$15
= [$15,000 + $10,000]/15 = 1,667 units
Margin of Safety
The margin of safety is a measure of difference between the actual sales and the breakeven sales. It is the amount by which sales revenue may drop before losses begin, and is expressed as a percentage of expected sales:
Margin of safety = Breakeven sales / Expected sales
The margin of safety is used as a measure of operating risk. The larger the ratio, the safer the situation since there is less risk of reaching the breakeven point.
Example 5
Assume Lie Dharma Store projects sales of $35,000 with a breakeven sales level of $25,000. The projected margin of safety is:
[$35,000 – $25,000]/$35,000 = $28.57%
Applications of Contribution Margin Analysis and “WhatIf” Analysis
The concepts of contribution margin and the contribution income statement have many applications in profit planning and shortterm decision making. Many “whatif” scenarios can be evaluated using them as planning tools, especially utilizing a spreadsheet program. Some applications are illustrated in Examples 6 to 10 using the same data as in Example 1.
Example 6
Recall from Example 1 that Lie Dharma Store has a CM of 60 percent and fixed costs of $15,000 per period. Assume that the company expects sales to go up by $10,000 for the next period.
How much will income increase?
Using the CM concepts, we can quickly compute the impact of a change in sales on profits. The formula for computing the impact is:
Change in net income = Dollar change in sales x CM ratio
Thus:
Increase in net income = $10,000 x 60% = $6,000
Therefore, the income will go up by $6,000, assuming there is no change in fixed costs.
If we are given a change in unit sales instead of dollars, then the formula becomes:
Change in net income = Change in unit sales x Unit CM
Example 7
Assume that the store expects sales to go up by 400 units.
How much will income increase?
From Example 1, the company’s unit CM is $15. Again, assuming there is no change in fixed costs, the income will increase by $6,000:
400 units x $15 = $6,000
Example 8
What net income is expected on sales of $47,500?
The answer is the difference between the CM and the fixed costs:
CM: $47,500 x 60% = $28,500
Less: Fixed costs = $15,000
Net income = $13,500
Example 9
Lie Dharma Store is considering increasing the advertising budget by $5,000, which would increase sales revenue by $8,000.
Should the advertising budget be increased?
The answer is no, since the increase in the CM is less than the increased cost:
Increase in CM: $8,000 x 60% = $4,800
Increase in advertising = $5,000
Decrease in net income = $(200)
Example 10
Consider the original data. Assume again that Lie Dharma Store is currently selling 1,500 units per period. In an effort to increase sales, management is considering cutting its unit price by $5 and increasing the advertising budget by $1,000. If these two steps are taken, management feels that unit sales will go up by 60 percent.
Should the two steps be taken?
The answer can be obtained by developing comparative income statements in a contribution format:
Sales Mix Analysis
Breakeven and costvolumeprofit analysis requires some additional computations and assumptions when a company produces and sells more than one product. In multiproduct firms, sales mix is an important factor in calculating an overall company breakeven point.
Different selling prices and different variable costs result in different unit CM and CM ratios. As a result, the breakeven points and CVP relationships vary with the relative proportions of the products sold, called the sales mix.
In breakeven and CVP analysis, it is necessary to predetermine the sales mix and then compute a weighted average unit CM. It is also necessary to assume that the sales mix does not change for a specified period.
The breakeven formula for the company as a whole is:
Breakeven sales in units (or in dollars)
= Fixed Costs / Weighted Average Unit CM [or CM Ratio]
Example 11
Assume that Putra, Inc., produces cutlery sets out of highquality wood and steel. The company makes a deluxe cutlery set and a standard set that have these unit CM data:
Deluxe Standard
Selling price $15 $10
Variable cost per unit 12 5
Unit CM $3 $5
Sales mix 60% 40%
(based on sales volume)
Fixed costs $76,000
The weighted average unit CM = ($3)(0.6) + ($5)(0.4) = $3.80. Therefore, the company’s breakeven point in units is:
$76,000/$3.80 = 20,000 units
which is divided in this way:
Deluxe: 20,000 units x 60% = 12,000 units
Standard: 20,000 units x 40% = 8,000 units
20,000 units
Note: An alternative is to build a package containing 3 deluxe models and 2 standard models (3:2 ratio). By defining the product as a package, the multipleproduct problem is converted into a singleproduct one. Then follow the next three steps:
Step 1. Compute the package CM
Deluxe Standard
Selling price $15 $10
Variable cost per unit 12 5
Unit CM $3 $ 5
Sales mix 3 2
Package CM $9 $10
$19 package total
$76,000/$19 per package = 4,000 packages
Step 2. Multiply this number by their respective mix units
Deluxe: 4,000 packages x 3 units = 12,000 units
Economy: 4,000 packages x 2 units = 8,000 units
20,000 units
Example 12
Assume that Dharma, Inc., is a producer of recreational equipment. It expects to produce and sell three types of sleeping bags—the Economy, the Regular, and the Backpacker. Information on the bags follows:
The CM ratio for Dharma, Inc., is $31,000/$100,000 = 31%
Therefore, the breakeven point in dollars is:
$18,600/0.31 = $60,000
which will be split in the mix ratio of 3:6:1 to give us these breakeven points for the individual products:
Economy: $60,000 x 30% = $18,000
Regular: $60,000 x 60% = $36,000
Backpacker: $60,000 x 10% = 6,000
= $60,000
One of the most important assumptions underlying CVP analysis in a multiproduct firm is that the sales mix will not change during the planning period. But if the sales mix changes, the breakeven point will also change.

Accounting9 years ago
Check Payment Issues Letter [Email] Templates

Accounting10 years ago
What is Journal Entry For Foreign Currency Transactions

Accounting9 years ago
How To Calculate And Record Depreciation [of Fixed Asset]

Accounting5 years ago
Accounting for Business Acquisition Using Purchase Method
Monique
May 30, 2010 at 8:18 pm
I used your Website as inofrmation for an assignment and needed to cite it but do not know your first initial. Is Putra your last name? If so, I need the first initial of your name to cite my paper. Could you please furnish me with this info a.s.a.p.? Would really appreciate it. By the way, great reading!!
Victoria
Oct 10, 2012 at 12:01 pm
simple and informative