Break Even Point

Download as pdf or txt
Download as pdf or txt
You are on page 1of 38

Module 12.

Cost Volume
Profit Analysis
Dr. Varadraj Bapat
Indian Institute of Technology,
Mumbai
[email protected]
9892413119

Dr. Varadraj Bapat, IIT Mumbai 1


Dr. Varadraj Bapat

CA., CWA., M.Com., DISA, PhD.


School of Management
Indian Institute of Technology, Mumbai
Teaching Interests: Financial Accounting,
Management Accounting, Indian Economy
Research Interests: Financial Accounting,
Financial Inclusion, Corporate Finance
Others: Yoga, Spirituality, Sanskrut, Bharatiya
Sanskriti, ABVP
Cost Volume
Profit (CVP)
 Introduction
 Fixed costs

 Variable costs

 Semi variable costs

 Contribution margin

 Break even point

 PV Ratio

Dr. Varadraj Bapat, IIT Mumbai 3


CVP Analysis

CVP analysis is the analysis of three


variable viz. cost, volume and profit.
Such analysis explores the
relationship existing amongst costs,
revenue, activity level and resulting
profit. It aims at measuring variation of
cost with profit.
Dr. Varadraj Bapat, IIT Mumbai 4
Fixed Cost

These are the costs which incurred


for a period and which within certain
output and turnover limits, tend to
be unaffected by fluctuations in the
levels of activity (Output or
turnover).

Dr. Varadraj Bapat, IIT Mumbai 5


For example: Rent, insurance of
factory building etc. remain the same
for different levels of production.

Dr. Varadraj Bapat, IIT Mumbai 6


Fixed Cost Graph

Total Cost
Amt

Fixed Cost

Units
Dr. Varadraj Bapat, IIT Mumbai 7
Variable Cost

These costs tend to very with the


volume of activity. Any increase in
activity results in an increase in the
variable cost and vice versa.
For example: Cost of direct labour,
direct material, etc.

Dr. Varadraj Bapat, IIT Mumbai 8


Variable Cost
Graph

Variable Cost
`

Units 9
Dr. Varadraj Bapat, IIT Mumbai
Semi-Variable Cost

These costs contain both fixed and


variable components and thus partly
affected by fluctuation in the level of
activity.
Examples of semi variable costs are
telephone bill, gas and electricity etc.

Dr. Varadraj Bapat, IIT Mumbai 10


Semi-Variable Cost
Graph
Semi-Variable Cost
`

Units
Dr. Varadraj Bapat, IIT Mumbai 11
Cost-Volume-Profit
Analysis
CVP analysis :
 Takes into account

– the total costs (fixed and variable)

– the total sales revenues

– desired profits vis-a-vis the sales


volume

Dr. Varadraj Bapat, IIT Mumbai 12


It is used for forecasting or predicting
how the changes in costs and sales
volume affect profit. It is also known
as 'Break-Even Analysis'.
CVP analysis could be helpful in the
following situations:

Dr. Varadraj Bapat, IIT Mumbai 13


Budget planning: for forecasting
profit by considering cost and profit
relation, and volume of production
volume. This will help in determining
the sales volume required to make a
profit.
–To make decisions regarding
pricing and sales volume.

Dr. Varadraj Bapat, IIT Mumbai 14


Determining the sales mix of different
products, in what proportions each of
the products can be sold.
–Preparing flexible budget considering costs
at different levels of production

Dr. Varadraj Bapat, IIT Mumbai 15


Objectives of CVP
Analysis
– Understand the interaction
among
 Prices of products
 Volume or level of activity

 Per unit variable cost

 Total fixed cost

 Mix of product sold


Dr. Varadraj Bapat, IIT Mumbai 16
Assumptions of CVP
Analysis
• Expenses can be classified as either
variable or fixed.
• CVP relationships are linear over a
wide range of production and sales.
• Sales prices, unit variable cost, and
total fixed expenses will not vary within
the relevant range.
Dr. Varadraj Bapat, IIT Mumbai 17
• Volume is the only cost driver.
• The relevant range of volume is
specified.
• Inventory levels will be unchanged.
• The sales mix remains unchanged
during the period.

Dr. Varadraj Bapat, IIT Mumbai 18


Calculations
 Profit Equation and Contribution
Margin
1. Profit =Sales -Total costs
2. Profit = Sales -Total variable costs -
Total Fixed costs
3. Contribution margin = Total revenue –
Total variable costs

Dr. Varadraj Bapat, IIT Mumbai 19


Sales XX
-Variable Cost (XX)
Contribution XX
-Fixed Cost (XX)
Profit XX

Dr. Varadraj Bapat, IIT Mumbai 20


 Profit = (S-V)*Q – FC
 Q = (FC + Expected Profit)
(S-VC)
 Q is the no. of units required to be
sold to obtain target profit.
 S=Selling Price p.u. VC=Variable
cost p.u. FC=Fixed Cost
Dr. Varadraj Bapat, IIT Mumbai 21
Example:

Suppose that Super Bikes wants to


produce a new mountain bike called
Hero1 and has forecast the following
information.
 Price per bike = `800

 Variable cost per bike = ` 300

 Fixed costs related to bike


production = ` 55,00,000

Dr. Varadraj Bapat, IIT Mumbai 22


 Target profit = ` 2,00,000
 Estimated sales = 12,000 bikes

We determine the quantity of bikes


needed for the target profit as
follows:
 Quantity = (`55,00,000 + `2,00,000) /
(`800 - `300) = 11,400 bikes

Dr. Varadraj Bapat, IIT Mumbai 23


Profit Volume Ratio
(PV)
The contribution margin ratio (CMR)
i.e. PV ratio is the percentage by
which the selling price (or revenue)
per unit exceeds the variable cost
per unit, or contribution margin as a
percentage of revenue.

Dr. Varadraj Bapat, IIT Mumbai 24


Example
For Hero1, we could use the forecast
information about volume (12,000
bikes) to determine the contribution
margin ratio.
 Total revenue = `800 * 12,000

= ` 96,00,000

Dr. Varadraj Bapat, IIT Mumbai 25


 Total variable cost
= ` 300* 12,000 = ` 36,00,000
 Total contribution margin =

`9,600,000 - ` 3,600,000 =
`6,000,000
 Contribution margin ratio =

`6,000,000 / `9,600,000 =0.625

Dr. Varadraj Bapat, IIT Mumbai 26


BEP analysis

 Breakeven analysis is used to find


the minimum level of production
required
 Evaluates both fixed and variable

costs

Dr. Varadraj Bapat, IIT Mumbai 27


 Uses:
1. To find a suitable product mix

2. To find the sales required to reach


a desired revenue.
3. The profits at certain price level

and sales

Dr. Varadraj Bapat, IIT Mumbai 28


Break even Point (BEP)

 A CVP analysis can be used to


determine the BEP, or level of
operating activity at which revenues
cover all fixed and variable costs,
resulting in zero profit.
 In other words this is the point where
no profit or losses have been made
Dr. Varadraj Bapat, IIT Mumbai 29
Cost-Volume-Profit Graph

Break-even Total sales


point
re a
t a
Sales in Rupees

o fi
P r
Total expenses

Fixed expenses
r ea
s a
os
L

Dr. Varadraj Bapat, IIT Mumbai 30


Units Sold
Break even
Applications
• New Product decisions :-
Enables to determine the sale
volume required for a firm
(or an individual product) to
breakeven , given expected sales
price and expected costs.
• Pricing decisions:- Enables to
study the effect of changing price
and volume relationship on total
profits.
Dr. Varadraj Bapat, IIT Mumbai 31
• Modernizations or automation
decisions:- Analysis the profit in
implication of a modernization or
automation programme.
• Expansion Decisions :- studies
the aggregate effect of a general
expansion in production and
sales.

Dr. Varadraj Bapat, IIT Mumbai 32


Formulae
 BEP in units = Total fixed costs
(Sales price – variable cost p.u.)
= Fixed cost
Contribution per unit
 BEP in sales value = Fixed cost
PV Ratio

Dr. Varadraj Bapat, IIT Mumbai 33


Example
• Sales 5000 units
• Sales price per unit Rs. 50
• Variable cost per unit Rs. 30
• Fixed cost Rs. 35000
• Therefore, contribution per unit =
50-30 =Rs. 20

Dr. Varadraj Bapat, IIT Mumbai 34


BEP in units = 35000/20
= 1750 units
1750 * 50 = Rs. 87500
 BEP in sales value = 35000 *

250000 / 87500
= Rs. 100000

Dr. Varadraj Bapat, IIT Mumbai 35


Margin of safety
• Represents the strength of the
business
• Margin of Safety= Actual Sale –
BEP Sale
• Margin of safety% = (Sales -
BEP)/Sales x 100

Dr. Varadraj Bapat, IIT Mumbai 36


• Margin of safety = (5000-1750)
5000
=65%
• Hence even if the sales decrease by
65%, the business wont face any
loss

Dr. Varadraj Bapat, IIT Mumbai 37


Dr. Varadraj Bapat, IIT Mumbai 38

You might also like