Cost-Volume-Profit (CVP) Relationship: C O ST
Cost-Volume-Profit (CVP) Relationship: C O ST
Cost-Volume-Profit (CVP) Relationship: C O ST
TS
RELATIONSHIP
T
FI
CO
O
PR
VOLUME
ST
COST-VOLUME-PROFIT
(CVP)
RELATIONSHIP
RELATIONSHIP
IT
OF
PR
VOLUME
By:
A manager can find out the level of sales where the company will
be in a no-profit-no-loss situation with this analysis.
🡪 BREAK-EVEN POINT ANALYSIS
CVP analysis can also explain the no. of units of sales required to
achieve a particular targeted operating income.
🡪 TARGET INCOME
2.
Changes in Sales Changes in Cost and
Volume Revenue
Selling Price
4. Variable Cost per Unit CONSTAN
Fixed Cost T
Relative Sales
5. For Multiple Proportion are
Products constant
Break-even point
CVP
Product Mix Applications Replacement
Advantages Disadvantages
Sales P xx
Less: VC xx
CM xx
Less: FC xx
Operating Income xx
Sales P xx Sales P xx
Less: VC xx Less: COGS xx
CM xx GPM xx
Fixed
Break-even point in units = Cost
CM per
unit
Fixed
Break-even point in sales (peso) = Cost
CM Ratio
(%)
Graphical Presentation
Total
Break-even Revenue
Point
Total
Amou
Cost
nt
Variable Cost
Fixed
Cost
This will tell you the level of sales that you need to achieve to meet
your profit goal.
TARGET INCOME - Formula
EM BEE YEY, Inc., has sales of P750,000 and total variable costs of P450,000. The
company has fixed costs of P300,000. Assuming the company produced and sold
250,000 units during the year, the per unit sales price is P3.00 and the variable cost
per unit is P1.80. Identify the break-even point (BEP) and margin of safety (MOS)
(units & peso sales).
In Peso Per Ratio
Sales 750,000 3.00 100% Unit
VC (450,000)1.80 60%
CM 300,000 1.20 40%
FC (240,000)
Operating Income 60,000
240,000/40% 240,000/P1.20
Using the data from the previous example, what level of sales would be
required if the company wanted P120,000 of income? The P120,000 of
income required is called the targeted income.
240,000+120,000
1.20
Required Sales in units 300,000 units
240,000+120,000
40%
Sales 900,000
VC (540,000)
CM 360,000
FC (240,000)
Operating Income 120,000
CVP Analysis with Multiple Products
For a company with more than one product, sales mix ratio is used.
Different products have different selling prices, cost structures, and
contribution margins. A weighted-average CM must be calculated.
Fixed
Multi-product BEP = Weighted-average
Cost CM per unit
Total Contribution
Weighted-average CM in units = Margin
Total No. of Units
Sold
CVP Analysis with Multiple Products
- Example
Product A Product B Product C TOTAL
Units Sold 5,000 9,000 6,000 20,000
Revenue PHP 1,000,000.00 PHP 6,300,000.00 PHP 4,800,000.00 PHP 12,100,000.00
Weighted-
VC 600,000.00 4,095,000.00 3,360,000.00
average CM per 8,055,000.00
Weighted-
CM per unit 80.00 245.00 240.00 202.25
average CM
CM Ratio 40% 35% Ratio
30% 33%
Expected
Expected Sales
SalesMix
Mixininunits
units 25.00%
25.00% 45.00%
45.00% 30.00%
30.00% 100.00%
100.00%
Expected SalesMix
Expected Sales Mixinin
8.26%
8.26% 52.07%
52.07% 39.67%
39.67% 100.00%
100.00%
revenues
revenues
Degree of operating Leverage
C
Degree of operating Leverage = M
Profi
t
High operating leverage means higher risk of loss when sales decline.