Cost Volume Profit Analysis - CVP Exmaples
Cost Volume Profit Analysis - CVP Exmaples
Cost Volume Profit Analysis - CVP Exmaples
Example No.1:
Total Per unit
Explaination of change in activity affect Contribution Margin & Net Operating Income:
On Sale of 1 Speaker:
Total Per unit
Sales manager feels that by increase in $10,000 fixed cost i.e, advertising budget,
then the sale will increase by $30,000 to a total 520 units. Should the advertising
budget increase,
OR
Increase in sales 30,000
Contribution Margin ratio 40%
OR
OR
Concept No.3: (Change in Fixed Cost, Sales Price and Sales Volume):
Assumption:
Management consider to cut the selling price by $20 per speaker,
increases fixed cost by $15,000 in advertising budget per month,
these changes increases the sales by 50% i.e. 600 speakers.
Should this changes incorporated:
OR
Proof: Present Expected
Concept No.4: (Change in Variable Cost, Fixed Cost and Sales Volume):
Assumption:
Management decided to pay $15 per speaker commission to
Sales person and stop payment of $6,000 fixed amount of
salaries, this change will increase the monthly sales by 15%
i.e. to 400 speakers to 460 speakers per month.
Should this changes incorporated:
OR
40%
ution margin
Percentage
Percentage
Changes
38,000
(30,000)
8,000
(15,000)
(7,000)
Changes
15,000
(15,900)
(900)
6,000
5,100
Break even Analysis:
Margin of Safety:
Margin of safety is the excess of budgeted (or actual) sales over the break even sales.
BEP provided the line below which company suffered loss. Higher the margin of safety, the
lower the risk of not breaking even.
c) In a single product firm, the margin of safety can also be expressed in terms of
number of units.
Margin of Safety (in units) = Margin of Safety (in amount)
Sales price per unit
Or
Margin of Safety (in units) = Actual units sold - BEP (in units)
Example:
### MOS = $100,000 - $87,500 $ 12,500
### MOS (%) = $ 12,500 12.5%
$100,000
Operating Leverage:
It is a measure of how sensitive net operating income is to percentage changes in sales.
It means that if operating leverage is high then the small percentage change can produce
large increasein net income and vice versa.
Farm A Farm B
10%
Sales 100,000 110,000 100,000
Less: Variable cost (60,000) (66,000) (30,000)
Changes in Percentage 40
Farm A Farm B
12%
Sales 100,000 88,000 100,000
Less: Variable cost (60,000) (52,800) (30,000)
77,000
(60,000)
17,000
7,000
7,000
10,000
70
Farm B
12%
88,000
(26,400)
61,600
(60,000)
1,600
(8,400)
(8,400)
10,000
(84)
Review Problem
Total Per unit Percentage
of Sales
Sales 1,200,000 60 100%
Less: Variable cost (900,000) (45)
Required:
1 Compute Company's C. M ratio and Variable expense ratio.
2 Compute the company's break even point (in units) and (in dollars), by equation method.
3 Assume that sales increase by $400,000 next year. If cost behaviour pattern remain constant,
by how much will the company net operating income increase? Use the C.M. ratio to
determine your answer.
4 Refer to the original data. Assume that next year management wants the company
earn a min. profit of $ 90,000. How much units will have to be sold to meet
this target profit figure?
5 Refer, to the original data, Compute the company's margin of safety (in dollar)
and (in percentage)
6
a Compute the company degree of operating leverage at the present level of sale
b Assume that through a more intense effort by the sales staff the company sale increase
by 8% next year. By what percentage would you expect ner operating income increases?
Use the operating leverage concept.
7 In an effort to increase the sales and profit, management is considering the use of
a higher quality speaker. The higher quality speaker would increase the variable cost
by $3 per unit, but management could eliminate one quality inspector who is paid a
salary of #30,000 per year. The sales manager estimate that the higher quality speaker
would increase annual sales by atleast 20%.
b) Compute the company's new breakeven point in both units and dollar of sales.
Use C.M method.
e company
ny sale increase
ncome increases?
the use of
variable cost
ho is paid a
quality speaker
rcentage basis.
r of sales.
Req (I) ContributionMargin Ratio and Variable cost ratio:
Req (III) Impact on Net Operating Income on changes in Sales, by C.M. ratio:
Calculation of changes in net income, with the changes in sales, without I/S
Increase in Sales 400,000
C.M. ratio 25%
= Amount of Sales
Sales price per unit
Req (VI)
a) Degree of Operating Leverage
DOL = 300,000
60,000
DOL = 5 times.
DOL = 5 times
Changes in Percentage 40
Req (VII)
a) Changes in Variable Cost, Sales and Fixed Cost:
c) Yes, the proposed changes will incorporate because from these changes company
earn $18,000 more than Present level.
300,000 25
1,200,000
15 25
60
900,000 75
1,200,000
, by C.M. ratio:
100,000
1,320,000 22,000 units
60
tual) sales
help of DOL
Rate Percent
60 100
(48) (80)
12 20
1,050,000
17,500
hanges company