MOD 04 Cost Volume Profit Analysis (2023)
MOD 04 Cost Volume Profit Analysis (2023)
MOD 04 Cost Volume Profit Analysis (2023)
MODULE 4
MANAGERIAL
ACCOUNTING
TOOLS FUNCTIONS
(A) (B)
Fundamental
Mgnt Acctg Concepts
PLANNING:
CVP(4), Budgeting(5)
(1)
Value
Creation
Strategic
Goals MANAGERIAL
(PLANNING)
One of the major organizational goals is to create value. To create value, organizations need
to set strategic goals (eg., increase profitability via revenue growth or cost reduction etc).
You as managers, should know which are these strategic goals [PLANNING], know how to
measure those goals, and know how your managerial decisions [DECISION MAKING] affect
these goals. After you implement your decision, you as a manager, you should be able to
evaluate whether you achieved your goals [CONTROL].
2016_06_MGRL ALL_Charitou 3
COST VOLUME PROFIT ANALYSIS (CVP):
A MANAGEMENT TOOL FOR PLANNING AND DECISION MAKING
Learning Objectives
1) (LO1) What actions managers take to improve firm’s
profitability?
2) (LO2) What is Cost Volume Profit Analysis? Characteristics?
Usefulness?
3) (L03) What is a breakeven point, margin of safety and
operating leverage?
4) (L04) How does CVP/breakeven analysis is applied when a firm
produces (renders) more than one type of product (service).
5) Practical Applications/Cases of CVP from the real world
Sales XX
Cost
Volume -Costs XX
Profit Profit XX
?
INCREMENTAL CONTROLLABLE FIXED
2. COSTS VS SUNK VS UNCONTR vs VARIABLE
Value
Creation
Strategic
Goals
(PLANNING)
Given
? ?
SCENARIOS SP pu Targeted BP
BP units
units BP $BP € million
profit (millions)
1. What is the BP? $25 0 90,000
90,000 2.25
2,25m
2. Targeted profit $30 260,000 255,833 6.396
260,000, Federer 500,000 120,392 3,61m
and Selling price=$30
3. Margin of safety? $25 0 125,306 3.76
30,000 0,75m
30,000 0.750
4. Operating leverage 4
2017_07_MGRL_ADV ALL_Charitou 19
GRAPH THE CVP RELATIONSHIPS (Q 1&2)
€ (revenue, VC, FC, total cost) Revenue
Break-even
point
Total
€3.5 Cost
€3.24*
Profit
€2.25 260000
BP € VC
Fixed
Cost
BP # Racquets
*3.24=140000units*VC pu+FC
90 140
2017_07_MGRL_ADV ALL_Charitou 20
=(140000* 19.80)+468,000
1. When management consultants discuss CVP analysis, one of the
major issues is the so called ‘Breakeven Point’. What do we mean
with BP? Find the BP (in units and sales volume) for the Deluxe
Wilson racquet, I.e., How many racquets should Wilson sell to
Breakeven?
SOLUTION:
The BP is the volume of activity at which an organization’s revenues and
expenses equal I.e. zero profit. Or the point that the organization achieves its
targeted profit.
€5.20
b. BP in sales euro =BP in units*Sales price p.u= 90,000units*25 =€2.25m
Solution:
120,000=
Solution: Budgeted
MS units = 120,000 - 90,000 = 30,000 racquets Sales
90,000= BP
Margin of Safety:
How much “breathing room” your
firms has (if sales budget is not
achieved) before the firm starts
making losses [and thus get into the
“shark´s mouth”.
2017_07_MGRL_ADV ALL_Charitou 29
Case: KRI-KRI
q KRI-KRI sells two types of ice-cream, Vanilla 3L (with 4
flavors) and the Fruits 0% (master mini 0% sugar red
fruits).
qInformation on sales for July follow:
The 9,000 units represent the total Vanilla3L and Fruits0% ice-creams
that KRI-KRI will sell at breakeven.
2. Find the BP in units and in sales revenue for each product separately
and total :
= 9,000 x % of units sold for each type of ice cream
The 79,200$ represents the total Vanilla3L and Fruits0% ice-creams that
KRI-KRI will sell at breakeven.
Assume the sales mix remains the same at all levels of sales.
qRequired
q1a. Find the BP in euro for Deloitte’s office.
q1b. Find the BP in euro for Deloitte’s office for each type
of service rendered.
q2 Find the total revenue to be generated to make a profit
BP = FC / WACM %
q = 120,000 euro / 45% = 266,667 euro for all services
q1b. Find the BP in euro for Deloitte’s office for each type
of service rendered.
200,000 €euro.
BP = FC + Targeted Profit / WACM %
q = 120,000€ + 200,000€ / 45% = 711,111€ for all services
2017_07_MGRL_ADV ALL_Charitou 36
COST VOLUME PROFIT ANALYSIS (CVP):
A MANAGEMENT TOOL FOR PLANNING AND DECISION MAKING
Branch ATM
REQUIRED.
As a management consultant, advice Bank of
Piraeus/EFG/NBG/ Bank of Cyprus etc… what they should
do regarding the decision they are facing.
a. Find the incremental fixed costs and incremental variable
costs from the decision to switch customers from branches
to ATMs.
SOLUTION:
Incremental Fixed Costs = 2.5 – 1 = 1.5 million
Incremental VC = 0.50 –0.20 = 0.30 cents
SOLUTION:
BP = FC / CM per unit
= (2.5m – 1 m) / (0.50 – 0.20)
= 1.5 m / 0.30 =
= 5 million
SOLUTION:
BP = (FC + Adv costs) / CM per unit
= (2.5m – 1 m +200,000) / (0.50 – 0.20)
= 1.7 m / 0.30 =
= 5,666,667 transactions
2017_07_MGRL_ADV ALL_Charitou 60
q 4. What % of sales in units is for each product or service?
q Product A: …………………………..Product B:…………………………………….
q 4. What is the breakeven point (BP) in units for the firm and for each
product/separately?
q Answer:
q BP = Fixed Costs / Contribution Margin (Weighted average)
q (where Contribution margin= Selling price p.u. – Variable cost p.u.)
q ………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………............................................................................
q 5. Find the breakeven point that will allow your firm to generate its targeted
profit (decide the targeted profit amount ).
q Answer:
q BP = (Fixed Costs + Targeted Profit) / Weighted average contribution Margin:
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………
q 6. What conclusions can you draw?
q ………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………
2017_07_MGRL_ADV ALL_Charitou 61
Case 4.8 on Cytavision and Cable TV
Up to 2019, the three major cable TV companies, Cytavision, Primetel and
Cablenet had contracts with all Cypriot football clubs to televise their games, so
clients had to subscribe to all three cable TV companies to watch all games,
which was a bit expensive. On the one hand, cable companies were making
money but on the other hand was not that good for the clients. Recently, these
three major cable TV companies agreed to give the opportunity to all clients to
watch all football games by having only one subscription with any of the three
cable firms. Cytavision prior to this agreement had on average 120,000 clients
and was charging 35 euro per client for this service. Currently, it charges only
28 euro for the same service. Assume that the annual fixed cost in providing
this service is 2,8 million euro and the variable cost for providing this service is
10 euro.
a) How many additional clients should they get to break even?
Break-even point ( in units ) = fixed costs = €2,800,000 + 200,000= 166,667 clients (after)
unit contribution margin €28.00 - €10
b2) What total revenue should they achieve to meet this profitability goal?
2023_11 _ _MGRL
What would you suggest to the owner? Justify fully ALL_Charitou
67
Case 4.10 on Covid19 and American Medical Centre (AMC)
Covid19 has changed our lives, the owner of the AMC, Dr. Christos Christou, said.
For this reason they are in the process of buying a new sophisticated equipment
that gives results in just 1.5 hrs. This equipment will cost 200,000 euro and will last
for 5 years, so annual cost is 40,000 euro. Additional fixed costs to operate
equipment relate to the expenses of doctors and nurses that will operate
equipment, cost of utilities and space, maintenance etc (20,000 euro), The
variable costs for each Covid19 test are 20 euros (processing costs, direct labor
from chemists, nurses, etc). Estimated charge for each Covid19 test is 80 euro. It
is estimated that the maximum Covid19 tests that will take place in Cyprus are
100,000 (note more tests will take place during the 1st years and fewer later on, but
average was given here) and AMC will have approximately 2% of the market.
b) Find BP in euro
BP euro = 1,000 patients * 80 euro = 80,000 euro
= $120,000 = 80%
$150,000
= $90,000 = $112,500
80%
2023_11 _ _MGRL ALL_Charitou 75
Case 4-52
Break-Even and Target Profit analysis [LO4, LO5, LO6]
Raven Products sells camping equipment. One of the company’s products, a camp
lantern, sells for $90 per unit. Variable expenses are $63 per lantern, and fixed
expenses associated with the lantern total $135,000 per month.
Required:
1. Compute the company’s break-even point in number of lanterns and in total
sales dollars.
2. If variable expenses per lantern increase as a percentage of the selling price,
will it result in a higher or lower break-even point? Why? (Assume that the
fixed expenses remain unchanged.)
3. At present, the company is selling 8,000 lanterns per month. The sales
manager is convinced that a 10% reduction in the selling price will result in a
25% increase in the number of lanterns sold each month. Prepare two
contribution format income statements, one under present operating
conditions, and one as operations would appear after the proposed changes.
Show both total and per unit data on your statements.
4. Refer to the data in (3) above. How many lanterns would have to be sold at
the new selling price to yield a minimum net operating income of $72,000 per
month?
1. Profit = Unit CM x Q – Fixed expenses
$0 = ($90 - $63) x Q - $135,000
$0 = ($27) x Q - $135,000
$27Q = $135,000
Q = $135,000 ÷ $27 per lantern
Q = 5,000 lanterns, or at $90 per lantern, $450,000 in sales
Alternative solution:
Unit sales to
break-even= Fixed expenses
Unit contribution
margin
= 5,000
= $135,000 lanterns
$27 per lantern
= 11,500
= $72,000 + $135,000 lanterns
$18 per lantern
Case 4-53
Multiproduct Break-Even Analysis
Okabee Enterprises is the distributor for the two products, Model A100 and Model B900.
Monthly sales and contribution margin ratios for the two products follow:
Product
Contribution Fixed
Variable Margin per expense Net Operating
Case Units Sold Sales expenses Unit s Income (Loss)
1 9,000 $270,000 $162,000 ? $90,000 ?
$170,00
2 ? $350,000 ? $15 0 $40,000
3 20,000 ? $280,000 $6 ? $35,000
4 5,000 $160,000 ? ? $82,000 $(12,000)
Case 4-54
Assume that more than one product is being sold in each of the four
b.
Annual
Fixed expenses:
Rent $80,000
Advertising 150,000
Salaries 70,000
Total fixed expenses $300,000
The company has asked you, as a member of its planning group, to assist in some basic analysis of its
stores and company policies
Case 4-55
Required:
1. Calculate the annual break-even point in dollar sales and in unit sales for Store
36.
2. Prepare a CVP graph showing cost and revenue data for Store 36 from zero
shirts up to 30,000 shirts sold each year. Clearly indicate the break-even point
on the graph.
3. If 19,000 shirts are sold in a year what would be Store 36,s net operating
income or loss?
4. The company is considering paying the store manager of Store 36 an incentive
commission of $3 per shirt (in addition to the salespersons’ commission). If this
change is made, what will be the new break-even point in dollar sales and in
unit sales?
5. Refer to the original data. As an alternative to (4) above, the company is
considering paying the store manager $3 commission on each shirt sold in
excess of the break-even point. If this change is made, what will be the store’s
net operating income or loss if the 23,500 shirts are sold in a year?
6. Refer to the original data. The company is considering eliminating sales
commissions entirely in its stores and increasing fixed salaries by $107,000
annually.
a. If this change is made, what will be the new break-even point in dollar sales
and in unit sales in Store 36?
b. Would you recommend that the change be made? Explain.
2023_11 _ _MGRL ALL_Charitou 89
2023_11 _ _MGRL ALL_Charitou 90
2023_11 _ _MGRL ALL_Charitou 91
2023_11 _ _MGRL ALL_Charitou 92
2023_11 _ _MGRL ALL_Charitou 93
2023_11 _ _MGRL ALL_Charitou 94
Case 4-56
Basics of CVP Analysis Structure
Memofax, inc., produces memory enhancements kits for fax machines. Sales
have been very erratic, with some months showing a profit and some months
showing loss. The company’s contributions format income statement for the
most recent month is given below:
Alvaro Bazan
All sales are made through the company’s own retail outlets. The Racket Division has the following
fixed costs:
Per Month
Fixed production costs $120,000
Advertising expense 100,000
Administrative salaries 50,000
Total $270,000
Case 4-58
Sales, in units, over the past two moths have been as follows:
Required:
1. What is the present yearly net operating income or loss?
2. What is the present break-even point In units and in Swiss franc sales?
3. Assuming that the marketing studies are correct, what is the maximum profit that
the company can earn yearly? At how many units and at what selling price per
unit would the company generate this profit?
4. What would be the break-even point in units and Swiss franc sales using the
selling price you determined in (3) above (i.e., the selling price at the level of
maximum profits)? Why is this break-even point different from the break-even
point you computed in (2) above?
END