Exercise 5-1: Total Per Unit
Exercise 5-1: Total Per Unit
Exercise 5-1: Total Per Unit
Exercise 5-1
1. We need two points for both cost line and the revenue line.
2. The revenue line passes through origin and say at 2000 units, the revenue = 2000*36 = $
72,000.
3. The total cost line has a y-axis intercept = the fixed cost = $12,000. The second point
(cost) for say 2000 units = 12000+2000*24 = $ 60,000
CVP Graph
$80,000
$60,000
Dollars
$40,000
$20,000
$0
0 500 1,000 1,500 2,000
Volume in Units
Total Expense Total Sales Revenue
2. The break-even point = point of intersection of total sales revenue and the total expense lines.
This occurs at sales of 1,000 units.
Exercise 5-3
Profit Graph
$5,000
$0
-$5,000
Profit
-$10,000
-$15,000
-$20,000
0 500 1,000 1,500 2,000 2,500 3,000 3,500 4,000
Sales Volume in Units
2.
Change in total sales $1,500
× CM ratio 20%
= Estimated change in net operating income $ 300
Exercise 5-5
1. The following table shows the effect of the proposed change in monthly advertising budget:
Current
Sales
Sales $225,000
Variable expenses 135,000
Contribution margin 90,000
Fixed expenses 75,000
Net operating income $ 15,000
2. The $3 increase in variable expenses will cause the unit contribution margin to decrease from
$30 to $27 with the following impact on net operating income:
1. The equation method yields the break-even point in unit sales, Q, as follows:
2. The equation method can be used to compute the break-even point in sales dollars as follows:
𝑢𝑛𝑖𝑡 𝐶𝑀 2
Contribution margin ratio = = 𝑈𝑛𝑖𝑡 𝑠𝑒𝑙𝑙𝑖𝑛𝑔 𝑝𝑟𝑖𝑐𝑒 = 8 = 0.25
3. The formula method gives an answer that is identical to the equation method for the break-
even point in unit sales:
𝐹𝑖𝑥𝑒𝑑 𝐶𝑜𝑠𝑡 5500
Unit sales to break even = 𝑈𝑛𝑖𝑡 𝑐𝑜𝑛𝑡𝑟𝑖𝑏𝑢𝑡𝑖𝑜𝑛 𝑚𝑎𝑟𝑔𝑖𝑛 = $2 = 2750 baskets
4. The formula method also gives an answer that is identical to the equation method for the
break-even point in dollar sales:
𝐹𝑖𝑥𝑒𝑑 𝑒𝑥𝑝𝑒𝑛𝑠𝑒𝑠 5500
Dollar sales to break even = 𝐶𝑀 𝑟𝑎𝑡𝑖𝑜 = 0.25 = $ 22,000
Exercise 5-8
1. To compute the margin of safety, we must first compute the break-even unit sales.
2. The effect of 10% increase in sales net operating income, is computed as follows
3. To construct the required income statement, we must first determine the relative sales mix for
the two products:
2. The contribution margin at the break-even point is $150,000 because at that point it must
equal the fixed expenses.
𝑡𝑎𝑟𝑔𝑒𝑡 𝑝𝑟𝑜𝑓𝑖𝑡+𝐹𝑖𝑥𝑒𝑑 𝑒𝑥𝑝𝑒𝑛𝑠𝑒𝑠 18000+150000
3. Units sold to attain target profit = = = 14,000 units
𝑈𝑛𝑖𝑡 𝑐𝑜𝑛𝑡𝑟𝑖𝑏𝑢𝑡𝑖𝑜𝑛 𝑚𝑎𝑟𝑔𝑖𝑛 12
Total Unit
Sales (14,000 units × $40 per unit) $560,000 $40
Variable expenses (14,000 units × $28 per unit) 392,000 28
Contribution margin (14,000 units × $12 per unit) 168,000 $12
Fixed expenses 150,000
Net operating income $ 18,000
2. An increase in variable expenses as a percentage of the selling price would result in a higher
break-even point. If variable expenses increase as a percentage of sales, then the contribution
margin will decrease as a percentage of sales.
3.
Present: Proposed:
8,000 Lanterns 10,000 Lanterns*
Total Per Unit Total Per Unit
Sales $720,000 $90 $810,000 $81
Variable expenses 504,000 63 630,000 63
Contribution margin 216,000 $27 180,000 $18
Fixed expenses 135,000 135,000
Net operating income $ 81,000 $ 45,000
The fixed expenses of the Extravaganza total $8,000; therefore, the break-even point is
𝐹𝑖𝑥𝑒𝑑 𝑒𝑥𝑝𝑒𝑛𝑠𝑒𝑠 8000
Units sold to break even= 𝑈𝑛𝑖𝑡 𝑐𝑜𝑛𝑡𝑟𝑖𝑏𝑢𝑡𝑖𝑜𝑛 𝑚𝑎𝑟𝑔𝑖𝑛 = = 400 persons
20
1.
Model A100 Model B900 Total Company
Amount % Amount % Amount %
Sales 700,000 100 300,000 100 1,000,000 100
Variable expenses 280,000 40 90,000 30 370,000 37
Contribution margin
$420,000 60 $210,000 70 630,000 63
Fixed expenses 598,500
Net operating
income 31,500
3. Additional contribution margin from the additional sales = $50,000 × 63% CM ratio =
$31,500
Exercise 5-15
1.
Sales (30,000 doors) $1,800,000 $60
Variable expenses 1,260,000 42
Contribution margin 540,000 $18
Fixed expenses 450,000
Net operating income $ 90,000
𝐶𝑜𝑛𝑡𝑟𝑖𝑏𝑢𝑡𝑖𝑜𝑛 𝑚𝑎𝑟𝑔𝑖𝑛 540,000
Degree of operating leverage = 𝑁𝑒𝑡 𝑜𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝑖𝑛𝑐𝑜𝑚𝑒 = =6
90,000
2. a. Sales of 37,500 doors represent an increase of 7,500 doors, or 25%, over present sales of
30,000 doors. Because the degree of operating leverage is 6, net operating income should
increase by 6 times as much, or by 150% (6 × 25%).
b. Expected total dollar net operating income for the next year is:
2.
a.
Contribution margin = selling price – variable expenses = 60 – 36 = $ 24
𝐹𝑖𝑥𝑒𝑑 𝑐𝑜𝑠𝑡 360,000
Breakeven units = 𝑐𝑜𝑛𝑡𝑟𝑖𝑏𝑢𝑡𝑖𝑜𝑛 𝑚𝑎𝑟𝑔𝑖𝑛 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 24 = 15,000 units
In sales dollars: 15,000 units × $60 per unit = $900,000
b.
𝑇𝑎𝑟𝑔𝑒𝑡 𝑝𝑟𝑜𝑓𝑖𝑡+ 𝐹𝑖𝑥𝑒𝑑 𝑐𝑜𝑠𝑡 90,000 + 360,000
Breakeven units = 𝑐𝑜𝑛𝑡𝑟𝑖𝑏𝑢𝑡𝑖𝑜𝑛 𝑚𝑎𝑟𝑔𝑖𝑛 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = = 18,750 units
24
In sales dollars: 18,750 units × $60 per unit = $1,125,000
a. Case #1 Case #2
Number of units sold 9,000 14,000
Sales $270,000 $30 $350,000 $25
Variable expenses 162,000 18 140,000 10
Contribution margin 108,000 $12 210,000 $15
Fixed expenses 90,000 170,000
Net operating income $ 18,000 $ 40,000
Case #3 Case #4
Number of units sold 20,000 5,000
Sales $400,000 $20 $160,000 $32
Variable expenses 280,000 14 90,000 18
Contribution margin 120,000 $6 70,000 $14
Fixed expenses 85,000 82,000
Net operating income $ 35,000 $(12,000)
b. Case #1 Case #2
Sales $450,000 100 $200,000 100
Variable expenses 270,000 60 130,000 65
Contribution margin 180,000 40 70,000 35
Fixed expenses 115,000 60,000
Net operating income $ 65,000 $ 10,000
Case #3 Case #4
Sales $700,000 100 $300,000 100
Variable expenses 140,000 20 90,000 30
Contribution margin 560,000 80 210,000 70
Fixed expenses 470,000 225,000
Net operating income $ 90,000 $(15,000)