3 - Cost Volume Profit & Break-Even Point Analysis
3 - Cost Volume Profit & Break-Even Point Analysis
3 - Cost Volume Profit & Break-Even Point Analysis
Prepared by:
Ms. Grace A. Padiernos, CPA, CMA
WARNING
You may not copy, reproduce, distribute,
publish, display, perform, modify, create
derivative works, transmit, or in any way
exploit any such content, nor may you
distribute any part of this content, sell or
offer it for sale, or use such content.
1
10/04/2022
Observe and
Respect the
Republic Act
No. 8293, An
Act Prescribing
the
Intellectual
Property Rights
Law (IPR).
2
10/04/2022
Intellectual Property
Rights of Materials or Resources
Understand that these materials and resources are the property of
the National University - Laguna, copyrighted to the respective
authors of each material or resource. Students shall use these
materials and resources (Example: PowerPoint or PDF files or
recorded videos of lesson, etc.) only for the intended purpose of
learning in this course. To ensure that these materials are not
reproduced, shared, or used outside of the University and for
purposes not consistent with the intent of the course.
3
10/04/2022
4
10/04/2022
Margin (CM)
Contribution Margin (CM) Income Statement with tax
Sales P xxx
10
5
10/04/2022
Problem 1
11
Problem 1
12
6
10/04/2022
Problem 1
13
Problem 1
14
7
10/04/2022
Problem 1
15
Problem 1
16
8
10/04/2022
Problem 1
17
Problem 1
18
9
10/04/2022
Problem 1
19
Problem 1
20
10
10/04/2022
Problem 1
21
Problem 1
22
11
10/04/2022
Problem 1
23
Problem 1
24
12
10/04/2022
Problem 1
25
Problem 1
26
13
10/04/2022
Problem 1
27
Problem 1
28
14
10/04/2022
Problem 1
29
Problem 1
Operating income 3,000 Less: Variable costs (P30 x 150 units) (4,500)
Contribution Margin xxx
Sales per unit = P100
Less: Fixed Costs (xxx)
VC per unit = P30
Operating Income xxx
30
15
10/04/2022
Problem 1
Operating income 3,000 Less: Variable costs (P30 x 150 units) (4,500)
Contribution Margin 10,500
Sales per unit = P100
Less: Fixed Costs (xxx)
VC per unit = P30
Operating Income xxx
31
Problem 1
Operating income 3,000 Less: Variable costs (P30 x 150 units) (4,500)
Contribution Margin 10,500
Sales per unit = P100
Less: Fixed Costs (4,000)
VC per unit = P30
Operating Income xxx
32
16
10/04/2022
Problem 1
Operating income 3,000 Less: Variable costs (P30 x 150 units) (4,500)
Contribution Margin 10,500
Sales per unit = P100
Less: Fixed Costs (4,000)
VC per unit = P30
Operating Income 6,500
33
Problem 1
Operating income 3,000 Less: Variable costs (P30 x 150 units) (4,500)
Contribution Margin 10,500
Sales per unit = P100
Less: Fixed Costs (4,000)
VC per unit = P30
Operating Income 6,500
Increase in OI = 6,500 – 3,000 = 3,500
PROF. GRACE A. PADIERNOS, CPA, CMA
34
17
10/04/2022
Problem 1
35
Problem 1
36
18
10/04/2022
Problem 1
37
Problem 1
Operating income 3,000 Less: Variable costs (P32 x 100 units) (3,200)
Contribution Margin xxx
Sales per unit = P100
Less: Fixed Costs (xxx)
Operating Income xxx
38
19
10/04/2022
Problem 1
Operating income 3,000 Less: Variable costs (P32 x 100 units) (3,200)
Contribution Margin 6,800
Sales per unit = P100
Less: Fixed Costs (xxx)
Operating Income xxx
39
Problem 1
Operating income 3,000 Less: Variable costs (P32 x 100 units) (3,200)
Contribution Margin 6,800
Sales per unit = P100
Less: Fixed Costs (4,000)
Operating Income xxx
40
20
10/04/2022
Problem 1
Operating income 3,000 Less: Variable costs (P32 x 100 units) (3,200)
Contribution Margin 6,800
Sales per unit = P100
Less: Fixed Costs (4,000)
Operating Income 2,800
41
Problem 1
42
21
10/04/2022
Problem 1
43
Problem 1
44
22
10/04/2022
Problem 1
Sales (100 units) P 10,000 e. How many units must be sold to earn the same
profit is sales price if only P 85.
Variable Cost (3,000)
Contribution margin P 7,000 Sales per unit = P85 per unit
Fixed Costs (4,000) VC per unit = P30 per unit (P3,000 / 100 units)
UCM = P55 per unit (P85 – 30)
Operating income 3,000
Units = CM/UCM
Units = P7,000 / P55
Units = 127.27 units
45
46
23
10/04/2022
CVP Graph
Y-axis
Peso Amount
Break-even
X-axis
Units
47
48
24
10/04/2022
49
Profit
equation Operating income = Unit contribution margin x Units – Total fixed cost
50
25
10/04/2022
𝑻𝑭𝑪
BEPu =
𝑼𝑪𝑴
𝑻𝑭𝑪 𝑶𝑰
TPSu =
𝑼𝑪𝑴
51
𝑻𝑭𝑪
BEPSR =
𝑪𝑴𝑹
𝑻𝑭𝑪 𝑶𝑰
TPSSR =
𝑪𝑴𝑹
52
26
10/04/2022
Problem 2
Consider the following:
Selling Price 20
Unit Variable Cost 8
Target net profit 42,000
53
Problem 2
Consider the following:
Selling Price 20
54
27
10/04/2022
55
Problem 2
Consider the following:
Selling Price 20
56
28
10/04/2022
𝑻𝑭𝑪
BEPu =
𝑼𝑪𝑴
𝑷𝟕𝟖,𝟎𝟎𝟎
BEPu =
a. how many unit sales are 𝟏𝟐
required to breakeven?
BEPu = 6,500 units
57
Problem 2
Consider the following:
Selling Price 20
58
29
10/04/2022
59
Problem 2
Consider the following:
Selling Price 20
60
30
10/04/2022
𝑻𝑭𝑪 𝑶𝑰
TPSu =
𝑼𝑪𝑴
𝑷𝟕𝟖,𝟎𝟎𝟎 𝟒𝟐,𝟎𝟎𝟎
b. how many unit sales are
TPSu =
𝟏𝟐
required to earn the target net
profit? TPSu = 10,000 units
61
Problem 2
Consider the following:
Selling Price 20
62
31
10/04/2022
63
Problem 2
Consider the following:
Selling Price 20
64
32
10/04/2022
𝑻𝑭𝑪
BEPSR =
𝑪𝑴𝑹
𝑷𝟕𝟖,𝟎𝟎𝟎
BEPSR =
𝟔𝟎%
c. How much revenues are
needed to breakeven? BEPSR = P130,000
65
Problem 2
Consider the following:
Selling Price 20
66
33
10/04/2022
67
Problem 2
Consider the following:
Selling Price 20
68
34
10/04/2022
𝑻𝑭𝑪 𝑶𝑰
TPSSR =
𝑪𝑴𝑹
𝑷𝟕𝟖,𝟎𝟎𝟎 𝟒𝟐,𝟎𝟎𝟎
TPSSR =
d. How much revenues are 𝟔𝟎%
needed to earn the target net
profit? TPSSR = P200,000
69
Problem 2
Consider the following:
Selling Price 20
70
35
10/04/2022
71
Problem 2
Consider the following:
Selling Price 20
72
36
10/04/2022
𝑻𝑭𝑪 𝑶𝑰
TPSu =
𝑼𝑪𝑴
𝑷𝟕𝟖,𝟎𝟎𝟎 𝟓𝟐,𝟓𝟎𝟎
e. How many units of sales are
TPSu =
𝟏𝟐
required to earn the target net
profit? TPSu = 10,875 units
73
Problem 2
Consider the following:
Selling Price 20
74
37
10/04/2022
75
Problem 2
Consider the following:
Selling Price 20
76
38
10/04/2022
𝑻𝑭𝑪 𝑶𝑰
TPSSR =
𝑪𝑴𝑹
𝑷𝟕𝟖,𝟎𝟎𝟎 𝟓𝟐,𝟓𝟎𝟎
TPSSR =
f. How much revenues are 𝟔𝟎%
needed to earn the target net
profit? TPSSR = P217,500
77
Problem 3
Albatross company has fixed costs of P 90,300. At a sales
volume of P360,000, return on sales of 10%; at a
P600,000 volume, return on sales is 20%.
What is the breakeven volume?
78
39
10/04/2022
• MoS is the difference between actual or budgeted sales and the breakeven point.
• This pertains to the amount that is budgeted or actual sales can fall before it will
result to a loss (A buffer zone).
• These calculations are helpful in risk management.
79
80
40
10/04/2022
Problem 4
Given the following income statement, answer the
following questions:
81
Problem 4
Given the following income statement, answer the
following questions:
82
41
10/04/2022
MoS:
MoS (in peso) = actual or budgeted sales – break-even sales
83
Problem 4
Sales revenue P 400,000
Variable Costs 260,000
CM / SR = CMR
140,000 / 400,000 = 35%
84
42
10/04/2022
85
Problem 4
Given the following income statement, answer the
following questions:
86
43
10/04/2022
MoSR:
𝑴𝒐𝑺 (𝒊𝒏 𝒑𝒆𝒔𝒐)
MoS (in %) =
𝑨𝒄𝒕𝒖𝒂𝒍 𝒐𝒓 𝒃𝒖𝒅𝒈𝒆𝒕𝒆𝒅 𝒔𝒂𝒍𝒆𝒔
87
Problem 4
Sales revenue P 400,000
Variable Costs 260,000
88
44
10/04/2022
𝟏𝟎𝟎,𝟎𝟎𝟎
MoS (in %) =
𝟒𝟎𝟎,𝟎𝟎𝟎
89
Problem 4
Given the following income statement, answer the
following questions:
90
45
10/04/2022
91
Problem 4
Given the following income statement, answer the
following questions:
92
46
10/04/2022
Profit margin
or
Sales margin:
𝑶𝒑𝒆𝒓𝒂𝒕𝒊𝒏𝒈 𝑷𝒓𝒐𝒇𝒊𝒕 𝒐𝒓 𝑵𝒆𝒕 𝒊𝒏𝒄𝒐𝒎𝒆 𝒂𝒇𝒕𝒆𝒓 𝒕𝒂𝒙
PM =
𝑺𝒂𝒍𝒆𝒔
93
Problem 4
Sales revenue P 400,000
Variable Costs 260,000
94
47
10/04/2022
Profit margin
𝑶𝒑𝒆𝒓𝒂𝒕𝒊𝒏𝒈 𝑷𝒓𝒐𝒇𝒊𝒕 𝒐𝒓 𝑵𝒆𝒕 𝒊𝒏𝒄𝒐𝒎𝒆 𝒂𝒇𝒕𝒆𝒓 𝒕𝒂𝒙
PM =
𝑺𝒂𝒍𝒆𝒔
or PM =
𝟑𝟓,𝟎𝟎𝟎
𝟒𝟎𝟎,𝟎𝟎𝟎
95
Problem 4
Given the following income statement, answer the
following questions:
96
48
10/04/2022
CMR: CMR =
𝑪𝒐𝒏𝒕𝒓𝒊𝒃𝒖𝒕𝒊𝒐𝒏 𝑴𝒂𝒓𝒈𝒊𝒏
𝑺𝒂𝒍𝒆𝒔
97
Problem 4
Sales revenue P 400,000
Variable Costs 260,000
98
49
10/04/2022
𝑪𝒐𝒏𝒕𝒓𝒊𝒃𝒖𝒕𝒊𝒐𝒏 𝑴𝒂𝒓𝒈𝒊𝒏
CMR =
𝑺𝒂𝒍𝒆𝒔
𝟏𝟒𝟎,𝟎𝟎𝟎
CMR =
CMR:
𝟒𝟎𝟎,𝟎𝟎𝟎
CMR = 35%
99
Cost Structure
Cost structure is how a company uses a mix of variable costs and fixed costs.
100
50
10/04/2022
101
Problem 6
The following data relate to Guitar Company which sells a single
product.
102
51
10/04/2022
Problem 6
The following data relate to Guitar Company which sells a single
product.
103
Solution:
104
52
10/04/2022
Problem 6
The following data relate to Guitar Company which sells a single
product.
105
Solution:
106
53
10/04/2022
Solution:
107
Problem 6
The following data relate to Guitar Company which sells a single
product.
108
54
10/04/2022
Solution:
109
Problem 6
The following data relate to Guitar Company which sells a single
product.
110
55
10/04/2022
111
Solution:
112
56
10/04/2022
Problem 6
The following data relate to Guitar Company which sells a single
product.
113
114
57
10/04/2022
20,000 units
115
Operating Income 0 0
116
58
10/04/2022
Degree of
Operating Leverage
Operating leverage is the measure of the
degree or the effects of fixed costs have
on changes in operating income where
there is a change in sales. Leverage
magnify the change in sales in the
operating income. If the company have
high fixed costs in its operating cost
structures, the higher the degree of
operating leverage.
117
Formulas:
𝑪𝒐𝒏𝒕𝒓𝒊𝒃𝒖𝒕𝒊𝒐𝒏 𝑴𝒂𝒓𝒈𝒊𝒏
DoL =
𝑶𝒑𝒆𝒓𝒂𝒕𝒊𝒏𝒈 𝑰𝒏𝒄𝒐𝒎𝒆
118
59
10/04/2022
Problem 7
Below is the Income statement for Blender Co. for 2021?
Sales P 400,000
Variable costs (125 000)
Contribution margin P275 000
119
Problem 7
Below is the Income statement for Blender Co. for 2021?
Sales P 400,000
120
60
10/04/2022
𝑪𝒐𝒏𝒕𝒓𝒊𝒃𝒖𝒕𝒊𝒐𝒏 𝑴𝒂𝒓𝒈𝒊𝒏
DoL =
Solution: 𝑶𝒑𝒆𝒓𝒂𝒕𝒊𝒏𝒈 𝑰𝒏𝒄𝒐𝒎𝒆
121
Problem 7
Below is the Income statement for Blender Co. for 2021?
Sales P 400,000
122
61
10/04/2022
𝑪𝒐𝒏𝒕𝒓𝒊𝒃𝒖𝒕𝒊𝒐𝒏 𝑴𝒂𝒓𝒈𝒊𝒏
DoL =
𝑶𝒑𝒆𝒓𝒂𝒕𝒊𝒏𝒈 𝑰𝒏𝒄𝒐𝒎𝒆
𝟐𝟕𝟓,𝟎𝟎𝟎
DoL =
𝟕𝟓,𝟎𝟎𝟎
Solution: DoL = 3.67x
123
Multi-product CVP
Rule:
GIVEN SUPM, USE WAUCM to arrive at BEP(U)
GIVEN SRM, USE WACMR to arrive at BEP(SR)
124
62
10/04/2022
Problem 8
Answer in white board.
The sales unit product mix between products A and B are 1:2. Sales price and variable
costs of the two are as follows:
A B
Sales price P8 P6
Variable cost 2 3
125
Thank you!!!
126
63