l11 - nobles finman4 ppt 20

Cost-Volume-Profit

Analysis

L 11

Chapter 20

20-1 Copyright 2014 Pearson Education, Inc. Publishing as Prentice Hall

Learning Objectives

1. Determine how changes in

volume affect costs

2. Calculate operating income

using contribution margin and

contribution margin ratio

3. Use cost-volume-profit (CVP)

analysis for profit planning

4. Use CVP analysis to perform

sensitivity analysis


Learning Objectives

5. Use CVP analysis to calculate

margin of safety, operating

leverage, and multiproduct

breakeven points


Learning Objective 1

Determine how

changes in volume

affect costs


Types of costs

Variable costs

Fixed costs

Mixed costs

Copyright 2014 Pearson Education, Inc. Publishing as Prentice Hall 20-5

Variable Costs Batteries in Tablets

Number of

Tablets Produced

Variable Cost

per Tablet

Total

Variable Cost

0 tablets $55 $ 0

25 tablets 55 1,375

50 tablets 55 2,750

75 tablets 55 4,125

100 tablets 55 5,500


Total Variable Costs


Total Fixed Costs


Fixed Costs

Total

Fixed Costs

Number of

Tablets Produced

Fixed Cost

per Tablet

$12,000 25 tablets $480

12,000 50 tablets 240

12,000 75 tablets 160

12,000 100 tablets 120


Characteristics of

Variable and Fixed Costs


Mixed Costs Cell Phone

$100 per month plus $0.10 for each minute of use

Number of

Minutes Used

Total Fixed

Cost

Total Variable

Cost

Total Cost

100 minutes $100 $10 $110

200 minutes 100 20 120

300 minutes 100 30 130

400 minutes 100 40 140

500 minutes 100 50 150


Mixed Costs


Manufacturing Equipment

Maintenance Costs

Number of

Tablets Produced

Total

Maintenance

Cost

1st Quarter 360 tablets $1,720

2nd Quarter 415 tablets 1,830

3rd Quarter 480 tablets 1,960

4th Quarter 240 tablets 1,480


Highest Volume

Lowest Volume

High-Low Method

Step 1

Step 1: Identify the highest and lowest levels of

activity, and calculate the variable cost per unit.

Variable cost per unit = Change in total cost / Change in volume of activity

= (Highest cost Lowest cost) / (Highest volume Lowest volume)


High-Low Method

Step 1

Step 1: Identify the highest and lowest levels of

activity, and calculate the variable cost per unit.

Variable cost per unit = Change in total cost / Change in volume of activity

= (Highest cost Lowest cost) / (Highest volume Lowest volume)

= ($1,960 $1,480) / (480 tablets 240 tablets)

= $480 / 240 tablets

= $2 per tablet


High-Low Method

Step 2

Step 2: Calculate the total fixed cost.

Total fixed cost = Total mixed cost Total variable cost

= Total mixed cost (Variable cost per unit Number of units)


High-Low Method

Step 2

Step 2: Calculate the total fixed cost.

Total fixed cost = Total mixed cost Total variable cost

= Total mixed cost (Variable cost per unit Number of units)

= $1,960 ($2 per tablet 480 tablets)

= $1,960 $960

= $1,000


High-Low Method

Step 3

Step 3: Create and use an equation to show the

behavior of a mixed cost.

Total mixed cost = (Variable cost per unit Number of units) + Total fixed cost


High-Low Method

Step 3

Step 3: Create and use an equation to show the

behavior of a mixed cost.

Total mixed cost = (Variable cost per unit Number of units) + Total fixed cost

Total manufacturing maintenance cost = ($2 per tablet Number of tablets) + $1,000


Estimated manufacturing equipment

maintenance cost at 400 tablets



Estimated manufacturing equipment

maintenance cost at 400 tablets


= ($2 per tablet 400 tablets) + $1,000

= $1,800


Relevant Range


Following is a list of costs for a furniture

manufacturer that specializes in wood tables.

Classify each cost as variable, fixed, or mixed

relative to tables produced and sold.

1. Wood used to build tables






1. Wood used to build tables

Variable






2. Depreciation on saws and other

manufacturing equipment






2. Depreciation on saws and other

manufacturing equipment

Fixed






3. Compensation for sales representatives paid

on a salary plus commission basis






3. Compensation for sales representatives paid

on a salary plus commission basis

Mixed






4. Supervisors salary






4. Supervisors salary

Fixed






5. Wages of production workers






5. Wages of production workers

Variable



Calculate operating

income using

contribution margin

and contribution

margin ratio


Contribution Margin

If Smart Touch Learning sells 200 tablets for $500

each that incur variable costs of $275 each, then

the contribution margin is:

Contribution margin = Net sales revenue Variable costs


Contribution Margin



the contribution margin is:

Contribution margin = Net sales revenue Variable costs

= ($500 per tablet 200 tablets) ($275 per tablet 200 tablets)

= $100,000 $55,000

= $45,000


Unit Contribution Margin



the unit contribution margin is:

Unit contribution margin = Net sales revenue per unit Variable costs per unit


Unit Contribution Margin



the unit contribution margin is:

Unit contribution margin = Net sales revenue per unit Variable costs per unit

= $500 per tablet $275 per tablet

= $225 per tablet


Contribution Margin Ratio



the contribution margin ratio is:

Contribution margin ratio = Contribution margin / Net sales revenue


Contribution Margin Ratio



the contribution margin ratio is:

Contribution margin ratio = Contribution margin / Net sales revenue

= $45,000 / $100,000

= 45%

= $225 per tablet / $500 per tablet

= 45%


Traditional Income

Statement Format

Net sales revenue

Cost of goods sold

= Gross profit

Selling and administrative expenses

= Operating income


Period costs (some variable, some fixed)

Product cost (some variable, some fixed)

Contribution Margin

Income Statement Format

Net sales revenue

Variable costs

= Contribution margin

Fixed Costs

= Operating income


Some product, some period

Some product, some period

A furniture manufacturer specializes in wood

tables. The tables sell for $100 and incur $40 in

variable costs. The company has $6,000 in fixed

costs per month.

6. Prepare a contribution margin income statement

for one month if the company sells 200 tables.

7. What is the total contribution margin for the month

when the company sells 200 tables?


6. Sales revenue (200 tables $100 per table) $ 20,000

Variable costs (200 tables $40 per table) 8,000

Contribution margin (200 tables $60 per table) 12,000

Fixed costs 6,000

Operating income $ 6,000

7. Contribution margin = $12,000





costs per month.

8. What is the unit contribution margin?

9. What is the contribution margin ratio?





costs per month.


Unit contribution margin = $100 per table $40 per table = $60 per table






costs per month.


Unit contribution margin = $100 per table $40 per table = $60 per table


Contribution margin ratio = $60 per table / $100 per table = 60%



Use cost-volume-profit

(CVP) analysis for

profit planning


Cost-Volume-Profit Analysis

Assumes the Following:

The price per unit does not change as volume changes.

Managers can classify each cost as variable, fixed, or mixed.

The only factor that affects total costs is change in volume, which increases variable and mixed

costs.

Fixed costs do not change.

There are no changes in inventory levels.


Target ProfitThree Approaches

Equation approach

Contribution margin approach

Contribution margin ratio approach


Equation Approach

Net sales revenue Total costs = Operating income


Equation Approach

Net sales revenue Total costs = Operating income

Net sales revenue Variable costs Fixed costs = Operating income


Equation Approach

Smart Touch Learning sells tablets for $500 each, variable costs are $275 each, and fixed costs are $12,000 per month. If the company desires to earn $6,000 in profits each month, how many tablets must it sell?

Net sales revenue Variable costs Fixed costs = Target profit


Equation Approach



($500 per unit Units sold) ($275 per unit Units sold) - $12,000 = $ 6,000

[($500 $275 per unit) Units sold] - $12,000 = $ 6,000

$225 per unit Units sold = $12,000 + $6,000

$225 per unit Units sold = $18,000

Units sold = $18,000 / $225 per unit

Units sold = 80 units


Equation Approach Check Your Calculation



Equation Approach Check Your Calculation


($500 per unit 80 units) ($275 per unit 80 units) $12,000 = $6,000

$40,000 -- $22,000 $12,000 = $6,000


Contribution Margin Approach


Required sales in units = Fixed costs + Target profit

Contribution margin per unit






= $12,000 + $6,000

$225 per unit

= 80 units


Contribution Margin ApproachCheck Your Calculation

Net sales revenue

Variable costs

= Contribution margin

Fixed costs

= Operating income


Contribution Margin ApproachCheck Your Calculation

Net sales revenue ($500 per unit 80 units) $ 40,000

Variable costs ($275 per unit 80 units) 22,000

= Contribution margin ($225 per unit 80 units) 18,000

Fixed costs 12,000

= Operating income $ 6,000


Contribution Margin Ratio Approach


Required sales in dollars = Fixed costs + Target profit

Contribution margin ratio






= $12,000 + $6,000

45%

= $40,000


Breakeven Point Calculations

for Smart Touch Learning



for Smart Touch Learning Exhibit 21-6 Breakeven Point Calculations for Smart Touch Learning

Equation approach

Net sales revenue Variable costs Fixed Costs = Target Profit

($500 per unit Units sold) ($275 per unit Units sold) $12,000 = $ 0

[($500$275 per unit) Units sold] $12,000 = $ 0

$225 per unit Units sold = $ 12,000

Units sold = $ 12,000/$225 per unit

Units sold = 54 units*



*Actual result of 53.3333 rounded up to the next full unit as it is not possible to sell partial tablets.




Equation approach








Required sales in units = Fixed Costs + Target profit


= $12,000 + $0

$225 per unit

= 54 units*






Equation approach








Required sales in units = Fixed Costs + Target profit


= $12,000 + $0

$225 per unit

= 54 units*


Required sales in dollars = Fixed Costs + Target profit


= $12,000 + $0

45%

= $26,667**


**Actual result of $26,666.6667 rounded up to next full dollar.


Cost-Volume-Profit Graph




variable costs. The company has $6,000 in

fixed costs per month. The company desires to

earn an operating profit of $12,000 per month.


10. Calculate the required sales in units to earn the

target profit using the equation method.



target profit using the equation method.


($100 per unit Units sold) ($40 per unit Units sold) $6,000 = $12,000

[($100 $40 per unit) Units sold] $6,000 = $12,000

$60 per unit Units sold = $ 6,000 + $12,000

$60 per unit Units sold = $18,000

Units sold = $18,000 / $60 per unit

Units sold = 300 units



target profit using the contribution margin

method.



target profit using the contribution margin

method.

Required sales in units = Fixed costs + Target profit Contribution margin per unit

= $6,000 + $12,000

$100 per unit $40 per unit

= 300 units


12. Calculate the required sales in dollars to earn

the target profit using the contribution margin

ratio method.


12. Calculate the required sales in dollars to earn

the target profit using the contribution margin

ratio method.

Contribution margin ratio = $60 per table / $100 per table = 60%



= $6,000 + $12,000

60%

= $30,000


13. Calculate the required sales in units to

breakeven using the contribution margin

method.


13. Calculate the required sales in units to

breakeven using the contribution margin

method.



= $6,000 + $0


= 100 units



Use CVP analysis to

perform sensitivity

analysis


Change in the Selling PriceContribution Margin Approach

Smart Touch Learning believes it must cut the selling price to $475 per tablet. Variable costs remain at $275 per tablet. Fixed costs stay at $12,000. How many tablets must be sold to break even?




Change in the Selling PriceContribution Margin Approach

Smart Touch Learning believes it must cut the selling price to $475 per tablet. Variable costs remain at $275 per tablet. Fixed costs stay at $12,000. How many tablets must be sold to break even?



= $12,000 + $0


= 60 units Copyright 2014 Pearson Education, Inc. Publishing as Prentice Hall 20-78

Change in the Variable CostsContribution Margin Approach

Smart Touch Learnings selling price remains at $500 per tablet. Variable costs increase to $285 per tablet. Fixed costs stay at $12,000. How many tablets must be sold to break even?




Change in the Variable CostsContribution Margin Approach

Smart Touch Learnings selling price remains at $500 per tablet. Variable costs increase to $285 per tablet. Fixed costs stay at $12,000. How many tablets must be sold to break even?



= $12,000 + $0


= 56 units*

* Rounded up to next full unit


Change in the Fixed CostsContribution Margin Approach

Smart Touch Learnings selling price remains at $500 per tablet. Variable costs stay at $275 per tablet. Fixed costs increase to $15,000. How many tablets must be sold to break even?




Change in the Fixed CostsContribution Margin Approach

Smart Touch Learnings selling price remains at $500 per tablet. Variable costs stay at $275 per tablet. Fixed costs increase to $15,000. How many tablets must be sold to break even?



= $15,000 + $0


= 67 units*

* Rounded up to the next full unit


Effects of Changes in Selling Price,

Variable Costs, and Fixed Costs

Exhibit 20-8 Effects of Changes in Selling Price, Variable Costs,

and Fixed Costs

Cause Effect Result

Change Contribution Margin per Unit Breakeven point

Selling price per unit increases Increases Decreases

Selling price per unit decreases Decreases Increases

Variable cost per unit increases Decreases Increases

Variable cost per unit decreases Increases Decreases

Total fixed cost increases No effect Increases

Total fixed cost decreases No effect Decreases





fixed costs per month. Calculate the breakeven

point in units under each independent

scenario.


14. Variable costs increase by $10 per unit.


14. Variable costs increase by $10 per unit.

Variable cost = $40 + $10 = $50

Contribution margin per unit = $100 $50 = $50



= $6,000 + $0

$50 per unit

= 120 units


15. Fixed costs decrease by $600.


15. Fixed costs decrease by $600.

Fixed costs = $6,000 $600 = $5,400




= $5,400 + $0

$60 per unit

= 90 units


16. Sales price increases by 10%.


16. Sales price increases by 10%.

Sales price = $100 1.10 = $110


Required sales in units = Fixed costs + Target profit Contribution margin per unit

= $6,000 + $0 $70 per unit

= 86 units*

* Rounded up to next whole unit



Use CVP analysis to

calculate margin of

safety, operating

leverage, and

multiproduct

breakeven points


Margin of Safety

Smart Touch Learnings original breakeven point was 54 tablets. The company expects to sell 100 tablets.

Expected sales Breakeven sales = Margin of safety in units


Margin of Safety



100 tablets 54 tablets = 46 tablets


Margin of Safety




Margin of safety in units Sales price per unit = Margin of

safety in dollars


Margin of Safety





safety in dollars

46 tablets $500 per tablet = $23,000


Margin of Safety





safety in dollars


Margin of safety in units / Expected sales in units = Margin of

safety ratio


Margin of Safety





safety in dollars


Margin of safety in units / Expected sales in units = Margin of

safety ratio

46 tablets / 100 tablets = 46% Copyright 2014 Pearson Education, Inc. Publishing as Prentice Hall 20-97

Expected Contribution

Margin Income Statements

Company A Company B

Sales Revenue (500 passengers $25 per passenger) $ 12,500 $ 12,500

Variable Cost:

(500 passengers $5 per passenger) 2,500


Contribution Margin 10,000 5,000

Fixed Costs 6,000 1,000

Operating Income $ 4,000 $ 4,000


Actual Contribution

Margin Income Statements

Company A Company B

Sales Revenue (400 passengers $25 per passenger) $ 10,000 $ 10,000

Variable Cost:



Contribution Margin 8,000 4,000

Fixed Costs 6,000 1,000

Operating Income $ 2,000 $ 3,000


Degree of Operating Leverage

Degree of operating leverage = Contribution margin

Operating income


Degree of Operating Leverage


Operating income

Company A $10,000 = 2.50

$4,000

Company B $5,000 = 1.25

$4,000


Degree of Operating Leverage Predicting Change in Operating Income


Degree of Operating Leverage Predicting Change in Operating Income

Company A Company B

Estimated sales $ 12,500 $ 12,500

Actual sales (10,000) (10,000)

Dollar change $ 2,500 $ 2,500

Percent change in sales ($2,500 / $12,500) 20% ($2,500 / $12,500) 20%

Degree of operating leverage 2.50 1.25

Percent change in operating income 50% 25%

Estimated operating income $ 4,000 $ 4,000

Actual operating income (2,000) (3,000)

Dollar change $ 2,000 $ 1,000

Percent change in operating income ($2,000 / $4,000) 50% ($1,000 / $4,000) 25%


Sales Mix

Cool Cat Furniture sold 6,000 cat beds and 4,000 scratching posts. Total fixed costs are $40,000. The cat beds unit selling price is $44, and variable cost per bed is $24. The scratching posts unit selling price is $100 and variable cost per post is $30. What is the breakeven point?


Sales Mix

Cool Cat Furniture sold 6,000 cat beds and 4,000 scratching posts. Total fixed costs are $40,000. The cat beds unit selling price is $44, and variable cost per bed is $24. The scratching posts unit selling price is $100 and variable cost per post is $30. What is the breakeven point?

Cat beds Scratching Posts Total

6,000 4,000 10,000

60% 40% 100%

3 2 5


Breakeven Point with Sales Mix:

Step 1


Step 1: Calculate the weighted-average contribution margin per unit.


Step 2

Step 2: Calculate the breakeven point in units for the package of products.


Weighted-average contribution margin per unit



Step 2




= $40,000 + $0

$40 per item

= 1,000 items



Step 3

Step 3: Calculate the breakeven point in units for each product. Multiply the package breakeven point in units by each products proportion of the sales mix.



Step 3


Breakeven sales of cat beds (1,000 items 3/5) = 600 cat beds

Breakeven sales of scratching posts (1,000 items 2/5) = 400 scratching posts

In sales dollars:

600 cat beds at $44 selling price each $26,400

400 scratching posts at $100 selling price each 40,000

Total sales revenue $66,400



Contribution Income Statement

Cat

Beds

Scratching

Posts Total

Sales Revenue

Cat beds (600 $44) $ 26,400

Scratching posts (400 $100) $ 40,000 $ 66,400

Variable Costs

Cat beds (600 $24) 14,400

Scratching posts (400 $30) 12,000 26,400

Contribution Margin $ 12,000 $ 28,000 40,000

Fixed Costs 40,000

Operating Income $ 0


Sales Mix with Target Profit

How many units of each product must Cool Cat

sell to earn a target profit of $20,000?


Sales Mix with Target Profit:

Step 2

Step 2: Calculate the required sales in units for the package of products.




Sales Mix with Target Profit:

Step 2

Step 2: Calculate the required sales in units for the package of products.



= $40,000 + $20,000

$40 per item

= 1,500 items


Target Profit with Sales Mix:

Step 3

Step 3: Calculate the required sales in units for each product. Multiply the package required sales in units by each products proportion of the sales mix.



Step 3

Step 3: Calculate the required sales in units for each product. Multiply the package required sales in units by each products proportion of the sales mix.

Required sales of cat beds (1,500 items 3/5) = 900 cat beds

Required sales of scratching posts (1,500 items 2/5) = 600 scratching posts



Contribution Income Statement

Cat

Beds

Scratching

Posts Total

Sales Revenue

Cat beds (900 $44) $ 39,600

Scratching posts (600 $100) $ 60,000 $ 99,600

Variable Costs

Cat beds (900 $24) 21,600

Scratching posts (600 $30) 18,000 39,600

Contribution Margin $ 18,000 $ 42,000 60,000

Fixed Costs 40,000

Operating Income $ 20,000





fixed costs per month. Expected sales are 200

tables per month.


17. Calculate the margin of safety in units.


17. Calculate the margin of safety in units.

Breakeven sales in units = Fixed costs + Target profit


= $6,000 + $ 0

$60 per unit

= 100 units

Margin of safety in units = Expected sales Breakeven sales = 200 tables 100 tables = 100 tables


18. Determine the degree of operating leverage.


18. Determine the degree of operating leverage.

Sales revenue (200 tables $100 per table) $ 20,000

Variable costs (200 tables $40 per table) 8,000 Contribution margin (200 tables $60 per table) 12,000

Fixed costs 6,000 Operating income $ 6,000


Operating income

= $12,000

$6,000

= 2.00


19. The company begins manufacturing wood

chairs to match the tables. Chairs sell for $50

each and have variable costs of $30. The new

production process increases fixed costs to

$7,000 per month. The expected sales mix is

1 table for every 4 chairs. Calculate the

breakeven point.


Cat

Beds

Scratching

Posts Total

Sales price per unit $ 100 $ 50

Variable cost per unit 40 30

Contribution margin per unit 60 20

Sales mix in units 1 4 5

Contribution margin $ 60 $ 80 $ 140


($140 per unit / 5 units) $ 28


Step 1: Calculate the weighted-average contribution margin per unit.




= $7,000 + $0

$28 per item

= 250 items



Breakeven sales of tables (250 items 1/5) = 50 tables

Breakeven sales of chairs (250 items 4/5) = 200 chairs


l11 - nobles finman4 ppt 20

Documents

pearson education

tablets number of tablets

total variable costs

total fixed costs copyright

total cost change

mixed costs copyright

tablet total variable

total maintenance cost