Chapter 9
Chapter 9
Cost-Volume-Profit Analysis
Concept Questions
Contribution margin will not change because a change in fixed cost does not
affect contribution margin. Students may note that the break-even point will
decrease.
Contribution margin is the sales price per unit minus all variable production and
selling costs per unit. One might also consider contribution margin to be total
sales minus total variable costs. Contribution margin (ratio) can also be
expressed as a percentage of the sales price.
The break-even point in units is equal to total fixed costs divided by the
contribution margin per unit. The break-even point in sales dollars is equal to the
total fixed costs divided by the contribution margin ratio.
A company can decrease its break-even point by decreasing fixed costs and/or
increasing contribution margin (i.e., increasing sales price or decreasing variable
costs).
As a company nears the break-even point and its income is close to zero, the
operating leverage will increase dramatically. Accordingly, increases in sales will
result in large percentage increases in income.
Brief Exercises
1. (LO 1—Contribution margin)
a. contribution margin
b. net income
c. gross profit
d. increase
e. contribution margin ratio
f. variable costs
g. decrease, fixed costs
2. (LO2—What-if analysis)
Thus, the new net operating income will be Rs.15,00,000 after the owner’s
changes are made.
BE (units) =
BE (units) =
=
= 100,000
5. (LO5—Operating leverage)
Operating leverage = 2
Increasing the sales price by 40 percent (to ₹2,450) without changing variable
costs increases contribution margin to ₹1,400 (₹2,450 – ₹1,050) from ₹700
(₹1,750– ₹1,050). If the contribution margin per unit doubles, sales can decline
by half before net income is affected.
This problem can be solved using contribution margin ratio or operating leverage.
Walker’s contribution margin ratio is 40 percent (₹1,20,00,000/₹3,00,00,000). If
sales increase by 5 percent or ₹15,00,000, contribution margin will increase by
₹6,00,000. All other things being equal, this would increase income by
₹6,00,000. However, advertising (a fixed cost) increases by ₹5,00,000 so the net
change in income is only ₹1,00,000.
A.
Operating leverage =
Operating leverage =
x = ₹1,750
The company must sell an additional 1,000 logs if fixed costs increase by
₹6,00,000. With a contribution margin of ₹600 per log, each additional unit sold
will increase income by ₹600. Consequently, if fixed costs increase by
₹6,00,000, sales must increase by 1,000 logs (₹6,00,000/600 CM per unit).
Students may also want to calculate the old and new break-even points to solve
this problem. The old break-even point is 9,000 logs (₹54,00,000/₹600) and the
new break-even point is 10,000 units (₹60,00,000/₹600).
12 (LO 3—Break-even analysis: Multi-product environment)
Calculating the break-even point with multiple products requires first calculating
the weighted average contribution margin:
BE (units) =
BE (units) =
Calculating the break-even point with multiple products requires first calculating
the weighted average contribution margin:
Green Compost
Selling price ₹800.00 ₹600.00
Variable costs (500.00) (400.00)
Contribution margin ₹ 300.00 ₹ 200.00
Weight 0.5 0.5
Weighted-average CM per unit ₹ 150.00 ₹ 100.00
BE (units) =
Check:
Sales (₹1,500 9,500) ₹ 1,42,50,000
Variable costs (₹500 9,500) 47,50,000
Contribution margin ₹ 95,00,000
Fixed costs (75,00,000)
Before-tax profit ₹ 20,00,000
Income tax (40% ₹20,00,000) (8,00,000)
Net income ₹ 12,00,000
=
= 32,000
Problems
A. The weighted-average contribution margin per unit is ₹130 per unit (see
below). If fixed costs are ₹1,30,00,000, the break-even point will be
100,000 total units.
BE (units) =
BE (units) =
B.
Citronella DEET Mean Green
Weight 0.2 0.4 0.4
Total units 100,000 100,000 100,000
Total units to be sold 20,000 40,000 40,000
C. One way to reduce the break-even point is to sell more Citronella. Since it
has the highest contribution margin per unit, increasing its sales will
increase the overall weighted average contribution margin. Of course,
reducing fixed and variable costs or increasing the sales price of the
products would also decrease the break-even point.
A.
BE (units) =
BE (units) =
* Calculation of CM per ton:
Sales ₹25,00,00,000
Less: Variable costs
DM (7,50,00,000)
VOH (1,00,00,000)
VS&A (25,00,000)
CM ₹16,25,00,000
÷ units ÷ 25,000
CM per ton ₹ 6,500
B. If the direct material costs for plastic frames is reduced by ₹500, the CM
for plastic frames increases to ₹1,500. Assuming the same sales mix as in
part A, the new weighted-average CM is ₹1,875. Consequently, the break-
even point is reduced to 33,000 units (₹6,18,75,000/₹1,875).
C. Changing the sales mix to 35 percent plastic frames and 65 percent metal
frames changes the weighted-average CM per unit to ₹1,650.00. The new
break-even point would be 34,000 frames (₹5,61,00,000 fixed
costs/₹1,650.00 weighted-average CM per unit).
19. (LO1, 2, and 3—Decision focus: Basic CVP and break-even analysis)
Sales – VC – FC = Income
If sales = (10,000 units sales price),
Variable costs = Rs.25,00,000 (10,000 units Rs250 per unit),
Fixed costs = Rs.15,00,000 (10,000 units Rs.150 per unit), and
Net operating income = Rs.15,00,000 (Rs. 50,00,000 30%), then
B. Assuming a sales price of Rs.550 per unit, we find that the CM is Rs.300
per unit. If total fixed costs remain at Rs.15,00,000, the break-even point is
5,000 units (Rs.15,00,000/Rs.300).
A.
BE (units) =
BE (units) =
B.
Sales volume (units) to reach target profit =
Schedule Showing New Selling Price in the Forthcoming Year Maintaining the Current
Contribution Margin Ratio
Variable cost per unit Rs. Rs.
Material (Rs. 120 1.075) 129.00
Labor (Rs.30 1.03) 33.00
Variable overhead (Rs.12 1.05) 12.60
--------- 174.60
Selling price per unit (174.60/0.60) 291.00
Contribution per unit (Rs.291-Rs.174.60) 116.40
Schedule Showing the Number of Units to be Sold in the Forthcoming Year to Maintain
Profit at the Current Year Level
Rs.
Current Year Profit 220,000
Add: Fixed cost (Rs.1, 400,000 1.03) 1, 442,000
--------------
Required amount of total contribution 1, 662,000
Number of units to be sold (Rs. 1, 662,000/ Rs.116.40) 17,422
Product A B
Contribution per unit (Rs.) 1 2
Proportion of sales quantity (%) 2/3 1/3
Proportionate contribution per unit 2/3 2/3
Composite contribution per unit = Rs.4/3
Overall break-even point =
=
= 150,000 units
Product-wise break-up of overall break-even quantity:
Product A = 150,000 units*2/3 = 100,000 units
Product B = 150,000 units*1/3 = 50,000 units
Product P E
Selling price per unit (Rs.) 10 12
Deduct: Variable cost per unit (Rs.) 5 10
Contribution per unit (Rs.) 5 2
Schedule Showing Annual Break-Even Units for each of the PTO’s Plants
Mumbai Plant Pune Plant
Selling price per unit (Rs.) 150.00 150.00
Deduct:
Variable manufacturing cost per unit (Rs.) 72.00 88.00
Commission per unit (Rs) 7.50 7.50
Variable general and administrative expenses per unit (Rs) 6.50 6.50
-------- ---------
Contribution per unit (Rs.) 64.00 48.00
Fixed cost (Rs) (see working note) 4,704,000 2,265,600
Annual break-even (units) Fixed cost/ Contribution per unit 73,500 47,200
Working Note:
Total fixed cost based on a normal year of 240 working days
Mumbai Plant Pune Plant
Production rate per day (units) 400 320
Number of days 240 240
Total production (units) in 240 days 96,000 76,800
Fixed manufacturing cost per unit (Rs.) 30 15
Total fixed manufacturing cost (Rs.) 2,880,000 1,152,000
Add: Fixed general and administrative expenses (Rs.)
(96,000*19; 76,800*14) 1,824,000 1,113,600
Total Fixed cost (Rs.) 4,704,000 2,265,600
Operating Income Statement (with each plant producing 96,000 units)
Mumbai Plant Pune Plant
Normal capacity (units) [400units*240 days; 320units*240 days] 96,000 76,800
Full capacity (units) [400 units*300 days; 320 units*300 days] 120,000 96,000
Sales Revenue (96,000 units @Rs.150 each) 14,400,000 14,400,000
Deduct:
Variable manufacturing cost [96000 units*Rs.72;
96,000 units * (Rs.88+Rs.8)] 6,912,000 9,216,000
Commission (Rs.) [96,000 units*Rs.7.50] 720,000 720,000
Variable general and administrative expenses [96,000
units *Rs.6.50] 624,000 624000
Contribution margin (Rs.) 6,144,000 3,840,000
Deduct: Fixed cost (Rs.) 4,704,000 2,265,600
Operating income (Rs.) 1,440,000 1,574,400
Total operating income of both the plants= Rs.1, 440, 000+Rs.1, 574, 400
= Rs. 3,014,400
Note: It is assumed that the increase in the variable cost applies to all the units produced.
Under the optimum production plant the capacity of the Mumbai plant will be utilized fully as it
has a lower variable cost compared to the Pune Plant. The Mumbai plant will, therefore, produce
120,000 units and the Pune plant will produce 72,000 units
A.
BE (Rs.) =
BE (Rs.) =
BE (Rs.) = Rs.10,00,00,000
BE (units)
B.
Face
Daily Wash Mud Mask Cleanser
Weight 0.4 0.2 0.4
Total units 31,250 31,250 31,250
Total units to be sold 12,500 6,250 12,500
C. One way to reduce the break-even point is to sell more Mud Mask.
Because it has the highest contribution margin per unit, increasing its
sales will increase the overall weighted-average contribution margin.
Of course, reducing fixed and variable costs or increasing the sales price
of the products would also decrease the break-even point.
28. Break-even point (in units)= 60% of sales units = 21,600 units
Break-even point (in sales value) = 21,600 x `.300 = `64,80,000
(iii) Optimal Profit- best mix for proposed increase of 4,000 (8,000) units
30.
`
Revenue per trip 8,000
Less: Variable Cost
Train fare 3,400
Meals per child 600
Craft materials 1,200
Total Variable Cost 5,200
Contribution per child 2,800
At 250 Students
BEP= 250 +1,560/2,800 = 250.56. Hence the minimum students will be 251
At251 Students
Cases
B. With a selling price of Rs.10,000, the Morey Division must sell 40,000
units to reach its target profit objective:
C.
Moore, Inc.
Income Statement (Pro Forma)
A. Given the break-even point of 100 jets and the contribution margin per jet
of Rs.500 million (Rs.8750 million sales price less Rs.8,250 million cost),
the fixed costs must have been Rs.50 billion.
FC = Rs.50,00,00,00,000
Then: Variable costs per jet + Needed CM = Sales price per jet
D. Over the years, the companies have made Rs.66 billion of income on
sales of the jet.