CostVolumeProfit Relationships

1
Cost-Volume-Profit Relationships
2
The Basics of Cost-Volume-Profit (CVP) Analysis
Contribution Margin (CM) is the amount remaining
from sales revenue after variable expenses have
been deducted.
3
The Basics of Cost-Volume-Profit (CVP) Analysis
SQ -VQ (S-V)Q -F OI
Contribution Margin (CM) is the amount remaining
from sales revenue after variable expenses have
been deducted.
4
An identityI True by definitiondentity (true by
definition)
A model implicit assumptions about the Behavior
of costs and revenues
SQ -VQ (S-V)Q -F OI
Identity SQ VQ F OI Model
OI SQ VQ -F
5
Breakeven chartOI SQ VQ - F
500Q-300Q-80,000
Dollars
Units
6
Profit-volume chartOI (S-V)Q -F
OI
Slope 200
Q400
Dollars
Q
80,000
OI 200Q 80,000
Units
7
Contribution Margin Ratio

• The contribution margin ratio isTotal
  contribution margin/Total sales
• For Wind Bicycle Co. the ratio is

8
Contribution Margin Ratio

• Or, in terms of units, the contribution margin
  ratio isFor Wind Bicycle Co. the ratio is

9

• Applications of profit-volume analysis
• 1. Breakeven point, units of output sales
  dollars
• Margin of safety
• Target profits, before tax
• Target profits, after tax
• Target return on sales (ROS)
• Operating leverage
• Comparisons of cost structures
• Absorption costing profits
• Breakeven with absorption costing
• Target profits with absorption costing
• CPV with multiple products
• Opportunity costs of scarce resources

10
The Breakeven Point

• The breakeven point may be computed in terms of
  either units sold or sales dollars.

11
The Breakeven Point

• The breakeven point may be computed in terms of
  either units sold or sales dollars.

Q 80,000 / 200 Q 400 units
12
The Breakeven Point

• The breakeven point may be computed in terms of
  either units sold or sales dollars.

Q 80,000 / 200 Q 400 units
Break-even point in total sales dollars
Fixed expenses CM ratio

13
The Breakeven Point

• The breakeven point may be computed in terms of
  either units sold or sales dollars.

Q 80,000 / 200 Q 400 units
Break-even point in total sales dollars
Fixed expenses CM ratio

SQ 80,000 / .40 SQ 200,000
14
Target Profit Analysis, before tax

• Suppose Wind Co. wants to know how many bikes
  must be sold to earn a pre-tax profit of
  100,000.
• We can use our CVP formula to determine the sales
  volume needed to achieve a target profit figure.

OI 200Q - 80,000 Q (80,000 OI) / 200
Q (80,000 100,000) / 200 Q 900u
15
Target Profit Analysis, after tax

• Suppose Wind Co. wants to know how many bikes
  must be sold to earn an after-tax profit of
  90,000. The income tax rate is 40.
• We must first convert the after tax profit to
  before tax profit, as follows
• OI(BT) OI(AT) / (1 T)
• 90,000 / (1 - .4)
• 150,000

16
Target Profit Analysis, after tax

• Suppose Wind Co. wants to know how many bikes
  must be sold to earn an after-tax profit of
  90,000. The income tax rate is 40.
• We must first convert the after tax profit to
  before tax profit, as follows
• OI(BT) OI(AT) / (1 T)
• 90,000 / (1 - .4)
• 150,000

OI 200Q - 80,000 Q (80,000 OI) / 200
Q (80,000 150,000) / 200 Q 1,150u
17
Target Return on Sales (ROS)

• Suppose Wind Co. wants to know the sales level
  at which profits will equal fifteen percent of
  sales.
• OI CM(SQ) F

18
Target Return on Sales (ROS)

• Suppose Wind Co. wants to know the sales level
  at which profits will equal fifteen percent of
  sales.
• OI CM(SQ) F
• ROS(SQ) CM(SQ) F

19
Target Return on Sales (ROS)

• Suppose Wind Co. wants to know the sales level
  at which profits will equal fifteen percent of
  sales.
• OI CM(SQ) F
• ROS(SQ) CM(SQ) F
• SQ F / (CM - ROS)

20
Target Return on Sales (ROS)

• Suppose Wind Co. wants to know the sales level
  at which profits will equal fifteen percent of
  sales.
• OI CM(SQ) F
• ROS(SQ) CM(SQ) F
• SQ F / (CM - ROS)
• 80,000 / (.40 - .15)

21
Target Return on Sales (ROS)

• Suppose Wind Co. wants to know the sales level
  at which profits will equal fifteen percent of
  sales.
• OI CM(SQ) F
• ROS(SQ) CM(SQ) F
• SQ F / (CM - ROS)
• 80,000 / (.40 - .15)
• 320,000 (or 640 units)

22
The Margin of Safety

• Excess of budgeted (or actual) sales over the
  break-even volume of sales. The amount by which
  sales can drop before losses begin to be incurred.

Margin of safety Total sales - Break-even
sales
The margin of safety can be expressed as 20 of
sales.(250,000 - 200,000) / 250,000
23
Operating Leverage

• A measure of how sensitive net operating income
  is to percentage changes in sales.
• With high leverage, a small percentage increase
  in sales can produce a much larger percentage
  increase in net operating income.

24
Operating Leverage
100,000 20,000
5
25
Operating Leverage

• With a operating leverage of 5, if Wind increases
  its sales by 10, net operating income would
  increase by 50.

Heres the verification!
26
Operating Leverage
10 increase in sales from 250,000 to 275,000 .
. .
. . . results in a 50 increase in income from
20,000 to 30,000.
27
Note that for Wind Bicycle the margin of safety
is 20 and operating leverage is 5.
Operating leverage is the reciprocal of the
margin of safety. Explain why this relation
exists.
28
Comparisons of alternative cost structures
Assume that Wind Company may replace its existing
equipment with a more capital intense technology.
The new equipment would result in a reduction of
variable costs per unit from 300 to 250, and
would increase annual fixed costs from 80,000 to
120,000. Question At what level of output
would the new technology result In higher profits
for Wind?
29
Comparisons of alternative cost structures
Assume that Wind Company may replace its existing
equipment with a more capital intense technology.
The new equipment would result in a reduction of
variable costs per unit from 300 to 250, and
would increase annual fixed costs from 80,000 to
120,000. Question At what level of output
would the new technology result in higher
profits for Wind? Current cost structure TC
80,000 300Q Alternative cost structure TC
120,000 250Q Difference in costs 40,000 -
50Q Output level with equal total costs 800
units
30
Comparisons of alternative cost structures
Assume that Wind Company may replace its existing
equipment with a more capital intense technology.
The new equipment would result in a reduction of
variable costs per unit from 300 to 250, and
would increase annual fixed costs from 80,000 to
120,000. Question At what level of output
would the new technology result in higher
profits for Wind? Current cost structure TC
80,000 300Q Alternative cost structure TC
120,000 250Q Difference in costs 40,000 -
50Q Output level with equal total costs 800
units Question At 800 units, which cost
structure has the higher Operating leverage?
Explain.
31
CPV Analysis with Absorption Costing Let QM
units produced Let QS units sold Let FM/QM
fixed manufacturing cost per unit Let FSfixed
selling and administrative costs OI (S V
FM/QM) QS - FS
32
CPV Analysis with Absorption Costing Let QM
units produced Let QS units sold Let FM/QM
fixed manufacturing cost per unit Let FSfixed
selling and administrative costs OI (S V
FM/QM) QS - FS OI (S V) QS FM (QS/QM) -
FS
33
CPV Analysis with Absorption Costing Let QM
units produced Let QS units sold Let FM/QM
fixed manufacturing cost per unit Let FSfixed
selling and administrative costs OI (S V
FM/QM) QS - FS OI (S V) QS FM (QS/QM) -
FS Note If QM QS, then OI is the same
using either variable or absorption costs.
34
Consider the original data for the Wind
Company. Using variable costing, the firms
breakeven point is 400 units. Assume instead
that the firm uses absorption costing in
measuring operating income. The firm intends to
manufacture 500 units in the coming period. In
addition, assume that Winds total fixed costs of
80,000 consists of 50,000 fixed manufacturing
costs, and 30,000 fixed selling and
administrative costs. Question What is the
firms absorption cost profit equation?
35
Consider the original data for the Wind
Company. Using variable costing, the firms
breakeven point is 400 units. Assume instead
that the firm uses absorption costing in
measuring operating income. The firm intends to
manufacture 500 units in the coming period. In
addition, assume that Winds total fixed costs of
80,000 consists of 50,000 fixed manufacturing
costs, and 30,000 fixed selling and
administrative costs. Question What is the
firms absorption cost profit equation? OI (S
V FM/QM) QS - FS (500-300-50,000/500)QS
30,000
36
Question If the firm produces 500 units and
sells 400 units, what will be the resulting
operating income?
37
Question If the firm produces 500 units and
sells 400 units, what will be the resulting
operating income? OI (S V FM/QM) QS - FS
(500-300-50,000/500)QS 30,000
(500-300-50,000/500)400 30,000 10,000
38
Question If the firm produces 500 units and
sells 400 units, what will be the resulting
operating income? OI (S V FM/QM) QS - FS
(500-300-50,000/500)QS 30,000
(500-300-50,000/500)400 30,000
10,000 Question If the firm produces 500
units, what will be the breakeven point using
absorption costing?
39
Question If the firm produces 500 units and
sells 400 units, what will be the resulting
operating income? OI (S V FM/QM) QS - FS
(500-300-50,000/500)QS 30,000
(500-300-50,000/500)400 30,000
10,000 Question If the firm produces 500
units, what will be the breakeven point using
absorption costing? OI (S V FM/QM) QS -
FS O (500-300-50,000/500)QS 30,000 QS
30,000 / (500-300-100) QS 300 units
40
Assumptions of CVP Analysis

• Selling price is constant.
• Costs are linear.
• In multi-product companies, the sales mix is
  constant.
• In manufacturing companies, inventories do not
  change (units produced units sold). Otherwise,
• the equations must incorporate the impact of
  absorption costing.

41
The Concept of Sales Mix

• Sales mix is the relative proportions in which a
  companys products are sold.
• Different products have different selling prices,
  cost structures, and contribution margins.
• Lets assume Wind sells bikes and carts and see
  how we deal with break-even analysis.

42
Multi-product break-even analysis

• Wind Bicycle Co. provides the following
  information

265,000 550,000
48.2 (rounded)
43
Multi-product break-even analysis
Note that the dollar amount of sales
must maintain the existing sales mix
proportions (45 bikes and 55 carts).At any
other sales mix, the breakeven sales amount would
differ.
44
CPV Graph, Multi-Product Firm
CM.55
CM.40
45
Extending CVP Analysis

• Multi-product firms must make
• product mix decisions that earn the best total
  contribution
• margin for the firm. To
• accomplish this objective, we need to focus on
  the contribution margin earned by each unit of
  scarce input.

46
Decisions Involving Limited Resources

• Firms often face the problem of deciding how
  limited resources are going to be used.
• Usually, fixed costs are not affected by this
  decision, so management can focus on maximizing
  total contribution margin.
• Lets look at an example.

47
Limited Resources

• Martin, Inc. produces two products and selected
  data is shown below

48
Limited Resources

• Martin, Inc. produces two products and selected
  data is shown below

Question What is Martins profit-volume equation?
49
Limited Resources

• The lathe is the scarce resource because there is
  excess capacity on other machines. The lathe is
  being used at 100 of its capacity.
• The lathe capacity is 2,400 minutes per week.
• Should Martin focus its efforts
• on Webs or Highs?

50
Limited Resources

• Lets calculate the contribution margin per unit
  of the scarce resource, the lathe.

51
Limited Resources

• Lets calculate the contribution margin per unit
  of the scarce resource, the lathe.

52
Limited Resources

• Lets calculate the contribution margin per unit
  of the scarce resource, the lathe.

Highs should be emphasized. It is the more
valuable use of the scarce resource the lathe,
yielding a contribution margin of 30 per minute
as opposed to 24 per minute for the Webs.
53
Limited Resources
If there are no other considerations, the best
plan would be to produce to meet current demand
for Highs. If demand is sufficient, Martin would
produce a total of 4,800 Highs, and earn a total
contribution margin of 72,000 (4,800 x 15).
What would be the value to Martin of an
additional 90 minutes of lathe time?
54
Suppose that the maximum demand for highs
is 4,000 units. What mix of webs and highs
would be best for Martin? In this case,What
would be the benefit to Martin if the demand for
highs could be expanded to 4,500 units?
55
Limited Resources
Assume in addition that material used in the
manufacture of both products is in short supply.
Each unit of Webs requires 2 pounds and each unit
of Highs requires 4 pounds of material. The total
available material is 7,200 pounds per week.
Question If there was unlimited lathe
capacity, what product mix would be optimal for
Martin? What is the value to Martin of an
additional 150 pounds of material?
56
Limited Resources
Assume in addition that material used in the
manufacture of both products is in short supply.
Each unit of Webs requires 2 pounds and each unit
of Highs requires 4 pounds of material. The total
available material is 7,200 pounds per week.
Question If there was unlimited lathe
capacity, what product mix would be optimal for
Martin? What is the value to Martin of an
additional 150 pounds of material? Question If
the lathe time and the material are both scarce,
what product mix would be optimal? In this case,
what is the value to Martin of an additional 150
pounds of material?
57
Extending CVP Analysis

• Multi-product profit-volume analysis with changes
  in product mix is an application of Linear
  Programming. This
• decision tool begins with the
• profit volume equation, and
• deals with capacity limitations.

58
The End