CVP Analysis
CVP Analysis
CVP ANALYSIS
Meaning: It is a managerial tool showing the relationship between various ingredients
of profit planning viz., cost, selling price and volume of activity. As the name suggests,
cost volume profit (CVP) analysis is the analysis of three variables cost, volume and
profit. Such an analysis explores the relationship between costs, revenue, activity levels
and the resulting profit. It aims at measuring variations in cost and volume.
Assumptions:
1. Changes in the levels of revenues and costs arise only because of changes
in the number of product (or service) units produced and sold – for
example, the number of television sets produced and sold by Sony
Corporation or the number of packages delivered by Overnight Express. The
number of output units is the only revenue driver and the only cost driver.
Just as a cost driver is any factor that affects costs, a revenue driver is a
variable, such as volume, that causally affects revenues.
2. Total costs can be separated into two components; a fixed component that
does not vary with output level and a variable component that changes with
respect to output level. Furthermore, variable costs include both direct
variable costs and indirect variable costs of a product. Similarly, fixed costs
include both direct fixed costs and indirect fixed costs of a product
3. When represented graphically, the behaviours of total revenues and total
costs are linear (meaning they can be represented as a straight line) in
relation to output level within a relevant range (and time period).
4. Selling price, variable cost per unit, and total fixed costs (within a
relevant range and time period) are known and constant.
5. The analysis either covers a single product or assumes that the proportion
of different products when multiple products are sold will remain
constant as the level of total units sold changes.
6. All revenues and costs can be added, subtracted, and compared without
taking into account the time value of money. (Refer to the FM study
material for a clear understanding of time value of money).
14.2 COST AND MANAGEMENT ACCOUNTING
Importance
It provides the information about the following matters:
1. The behavior of cost in relation to volume.
2. Volume of production or sales, where the business will break-even.
3. Sensitivity of profits due to variation in output.
4. Amount of profit for a projected sales volume.
5. Quantity of production and sales for a target profit level.
Impact of various changes on profit:
An understanding of CVP analysis is extremely useful to management in budgeting
and profit planning. It elucidates the impact of the following on the net profit:
(i) Changes in selling prices,
(ii) Changes in volume of sales,
(iii) Changes in variable cost,
(iv) Changes in fixed cost.
14.7.1 Marginal Cost Equation
The contribution theory explains the relationship between the variable cost and
selling price. It tells us that selling price minus variable cost of the units sold is the
contribution towards fixed expenses and profit. If the contribution is equal to fixed
expenses, there will be no profit or loss and if it is less than fixed expenses, loss is
incurred. Since the variable cost varies in direct proportion to output, therefore if
the firm does not produce any unit, the loss will be there to the extent of fixed
expenses. These points can be described with the help of following marginal cost
equation:
Sales xxxx
MARGINAL COSTING 14.3
A higher contribution to sales ratio implies that the rate of growth of contribution
is faster than that of sales. This is because, once the breakeven point is reached,
profits shall grow at a faster rate when compared to a product with a lesser
contribution to sales ratio.
By transposition, we have derived the following equations:
(i) C = S × P/V ratio
C
(ii) S=
P / VRatio
Composite contribution per unit by taking weights for the product sales quantity
4 3
=Product J- ` 40 + Product K- `20 = `22.86 + `8.57 = `31.43
7 7
Common Fixed Cost `6,16,000
Composite Break-even point = =
Composite Contribution per unit `31.43
= 19,600 units
4
Break-even units of Product-J = 19,600 = 11,200 units
7
3
Break-even units of Product- K = 19,600 = 8,400 units
7
ILLUSTRATION 2
CALCULATE:
(a) Break-even point
(b) Sales to earn a profit of ` 20,000
SOLUTION
Fixed cost `1,50,000
(a) Break-even point (BEP) = = = 10,000 Units
Contribution per unit * `15
* (Contribution per unit = Sales per unit – Variable cost per unit = ` 30 - `15)
`1,50,000+ `20,000
= ×`30 = ` 3,40,000
`15
Or
14.6 COST AND MANAGEMENT ACCOUNTING
ILLUSTRATION 3
A company has a P/V ratio of 40%. COMPUTE by what percentage must sales be
increased to offset: 20% reduction in selling price?
SOLUTION
Desired Contribution 0.40
Revised Sales Value = = = 1.6
Revised P / VRatio * 0.25
Selling price is reduced by 20% that means it became `8 per unit. Since, we have
to maintain the earlier contribution margin i.e. `400 by increasing the sales quantity
only. Therefore, the target contribution will be `400.
The new P/V Ratio will be
(`)
Sales 8.00
Variable cost 6.00
Contribution per unit 2.00
P/V Ratio 25%
DesiredContribution `400
Sales Value = = = `1,600
Revised P / VRatio 0.25
ILLUSTRATION 4
PQR Ltd. has furnished the following data for the two years:
2019-20 2020-21
Sales ` 8,00,000 ?
Profit/Volume Ratio (P/V ratio) 50% 37.5%
Margin of Safety sales as a % of total sales 40% 21.875%
There has been substantial savings in the fixed cost in the year 2020-21 due to the
restructuring process. The company could maintain its sales quantity level of 20 19-
20 in 2020-21 by reducing selling price.
You are required to CALCULATE the following:
(i) Sales for 2020-21 in Value,
(ii) Fixed cost for 2020-21 in Value,
(iii) Break-even sales for 2020-21 in Value.
SOLUTION
In 2019-20, PV ratio = 50%
Variable cost ratio = 100% - 50% = 50%
Variable cost in 2019-20 = ` 8,00,000 50% = ` 4,00,000
14.8 COST AND MANAGEMENT ACCOUNTING
In 2020-21, sales quantity has not changed. Thus, variable cost in 2020-21 is `
4,00,000.
In 2020-21, P/V ratio = 37.50%
Thus, Variable cost ratio = 100% − 37.5% = 62.5%
4,00,000
(i) Thus, sales in 2020-21 = = `6,40,000
62.5%
In 2020-21, Break-even sales = 100% − 21.875% (Margin of safety) = 78.125%
(ii) Break-even sales = 6,40,000 78.125% = ` 5,00,000
(iii) Fixed cost = B.E. sales P/V ratio
= 5,00,000 37.50% = `1,87,500.
ILLUSTRATION 5
You are given the following data for the current financial year of Rio Co. Ltd:
FIND OUT (a) Break-even point, (b) P/V ratio, and (c) Margin of safety. Also DRAW
a break-even chart showing contribution and profit.
SOLUTION
Sales - Variable Cost 1,00,000 - 60,000
P / V ratio = = = 40%
Sales 1,00,000
Fixed Cost 30,000
Break Even Point = = = ` 75,000
P / V ratio 40%
Margin of safety = Actual Sales – BE point = 1,00,000 – 75,000 = ` 25,000
Break even chart showing contribution is shown below:
MARGINAL COSTING 14.9
Break-even chart
ILLUSTRATION 6
PREPARE a profit graph for products A, B and C and find break-even point from the
following data:
Products A B C Total
Sales (`) 7,500 7,500 3,750 18,750
Variable cost ( `) 1,500 5,250 4,500 11,250
Fixed cost (`) --- --- --- 5,000
SOLUTION
Statement Showing Cumulative Sales & Profit
Profit in `
(+) 5,000
`3,250
(+) 2,500 `2,500
`1,000
the projected sales and breakeven sales in units multiplied by the contribution per
unit. This is possible because, at the breakeven point all the fixed costs are
recovered and any further contribution goes into the making of profits. It also can
be calculated as:
Profit
Margin of Safety =
P / V Ratio
ILLUSTRATION 7
A company earned a profit of ` 30,000 during the year. If the marginal cost and
selling price of the product are ` 8 and ` 10 per unit respectively, FIND OUT the
amount of margin of safety.
SOLUTION
Selling price-Variable cost per unit `10- `8
P/V ratio = = = 20%
Selling price `10
Profit 30,000
Margin of safety = = = ` 1,50,000
P/V ratio 20%
ILLUSTRATION 8
A Ltd. Maintains margin of safety of 37.5% with an overall contribution to sales ratio
of 40%. Its fixed costs amount to ` 5 lakhs.
CALCULATE the following:
i. Break-even sales
ii. Total sales
iii. Total variable cost
(i) We know that: Break- even Sales (BES) × P/V Ratio = Fixed Cost
Break-even Sales (BES) × 40% = ` 5,00,000
Break- even Sales (BES) = ` 12,50,000
S = ` 12,50,000 + 0.375S
Or, S = ` 20,00,000
S−V
iii. S × P/V Ratio = F + P or Contribution P/V Ratio =
S
iv BES × P/V Ratio = F (at BEP profit is zero)
Fixed Cost
v BES =
P / V Ratio
Fixedcost
vi P/V Ratio =
BES
vii S × P/V Ratio = Contribution (Refer to iii)
Contributi on
viii P/V Ratio =
Sales
ix (BES + MS) × P/V Ratio = Contribution (Total sales = BES + MS)
x (BES × P/V Ratio) + (MS × P/V Ratio) = F + P
By deducting (BES × P/V Ratio) from L.H.S. and F from R.H.S. in (x) above,
we get:
xi M.S. × P/V Ratio = P
Change in profit
xii P/V Ratio =
Change in sales
Change in contribution
xiii P/V Ratio =
Change in sales
Contributi on
xiv Profitability =
Key factor
Profit
xv Margin of Safety = Total Sales – BES or .
P / V ratio
14.14 COST AND MANAGEMENT ACCOUNTING
ILLUSTRATION 9
By noting “P/V will increase or P/V will decrease or P/V will not change”, as the case
may be, STATE how the following independent situations will affect the P/V ratio:
(i) An increase in the physical sales volume;
(ii) An increase in the fixed cost;
(iii) A decrease in the variable cost per unit;
(iv) A decrease in the contribution margin;
(v) An increase in selling price per unit;
(vi) A decrease in the fixed cost;
(vii) A 10% increase in both selling price and variable cost per unit;
(viii) A 10% increase in the selling price per unit and 10% decrease in the physical
sales volume;
(ix) A 50% increase in the variable cost per unit and 50% decrease in the fixed cost.
(x) An increase in the angle of incidence.
SOLUTION
A 10% increase in both selling price and variable cost per unit.
Reasoning 1. Assumptions: a) Variable cost is less than selling price.
b) Selling price `100 variable cost ` 90 per unit.
100 − 90
c) P/V ratio = = 10%
100
10% increase in S.P. = `110
10% increase in variable cost = `99
110 − 99
P/V ratio = = 10% i.e. P/v ratio will not change
10
Reasoning 2. Increase or decrease in physical sales volume will not change P/V
ratio. Hence 10% increase in selling price per unit will increase P/V
ratio.
Reasoning 3. Increase or decrease in fixed cost will not change P/V ratio. Hence
50% increase in the variable cost per unit will decrease P/V ratio.
Reasoning 4. Angle of incidence is the angle at which sales line cuts the total cost
line. If it is large, it indicates that the profits are being made at higher
rate. Hence increase in the angle of incidence will increase the P/V
ratio.
280
L ine
260
les
Sa
240
220
200
ea
it Ar
180 of
Cost and Sales (Rs. ‘ 000)
Pr C ost
Line
Margin Angle of Total
Cost and Sales (` '000)
160 of incidence
Safety Break even point
140
100
80
a
Ar e
60 oss
L
40 Margin
of Fixed cost
20 Safety
0
2 4 6 8 10 12 14 16 18 20 22 24 26 28
B.E.sales Actual sales
Volume of sales (Unit ‘000)
ILLUSTRATION 10
Moon Ltd. produces products 'X', 'Y' and 'Z' and has decided to analyse its production
mix in respect of these three products - 'X', 'Y' and 'Z'.
You have the following information:
X Y Z
Direct Materials ` (per unit) 160 120 80
Variable Overheads ` (per unit) 8 20 12
Direct labour:
Departments: Rate per Hour Hours per unit Hours per Hours per
(` ) unit unit
X Y Z
Department-A 4 6 10 5
Department-B 8 6 15 11
Particulars X Y Z
(`) (`) (`)
Selling Price (A) 312 400 240
Variable Cost:
Direct Material 160 120 80
Direct Labour
Dept. A (Rate x Hours) 24 40 20
Dept. B (Rate x Hours) 48 120 88
Variable Overheads 8 20 12
Total Variable Cost (B) 240 300 200
Contribution per unit (A - B) 72 100 40
Hours in Dept. A 6 10 5
Contribution per hour 12 10 8
Rank I II III
Existing Hours = 10,000 x 6hrs. + 12,000 x 10 hrs. + 20,000 x 5 hrs. = 2,80,000 hrs.
Best possible product mix (Allocation of Hours on the basis of ranking)
Produce ‘X’ = 12,000 units
Hours Required = 72,000 hrs (12,000 units × 6 hrs.)
Balance Hours Available = 2,08,000 hrs (2,80,000 hrs. – 72,000 hrs.)
14.20 COST AND MANAGEMENT ACCOUNTING
ILLUSTRATION 11
ABC Limited produces and sells two product- X and Y. The product is highly
demanded in the market. Following information relating to both the products are
given as under :
Per Unit ( `)
X Y
Direct Materials 140 180
Direct Wages 60 100
Variable Overheads ( ` 5 per machine hour) 20 40
Selling price 300 450
The company is facing scarcity of machine hours for working. The availability of
machine hours are limited to 60,000 hrs in a month. At present, the monthly demand
of product X and product Y is 8,000 units and 6,000 units respectively. The fixed
expenses of the company are ` 2,25,000 per month.
You are required to:
DETERMINE the product mix that generates maximum profit to the company in the
given situation and also CALCULATE the profit of the company.
SOLUTION
Workings -
MARGINAL COSTING 14.21
existing customers or market, long term customer relationship, ethical and legal
impact etc. shall also be given due consideration.
ILLUSTRATION 12: Processing of Special Order
PQR Ltd. manufactures medals for winners of athletic events and other contests. Its
manufacturing plant has the capacity to produce 10,000 medals each month. The
company has current production and sales level of 7,500 medals per month. The
current domestic market price of the medal is ` 150.
The cost data for the month of August 2021 is as under:
(` )
Variable costs:
- Direct materials 2,62,500
- Direct labour cost 3,00,000
- Overhead 75,000
Fixed manufacturing costs 2,75,000
Fixed marketing costs 1,75,000
10,87,500
PQR Ltd. has received a special one-time only order for 2,500 medals at ` 120 per
medal.
Required:
(i) Should PQR Ltd. accept the special order? Why? EXPLAIN briefly.
(ii) Suppose the plant capacity was 9,000 medals instead of 10,000 medals each
month. The special order must be taken either in full or rejected totally.
ANALYSE whether PQR Ltd. should accept the special order or not.
SOLUTION
In this question, the existing demand for the medals is 7,500 units per month
against the 10,000 units capacity. There is an idle capacity for 2,500 medals in a
month. Since, the capacity of the plant (supply) is more than the demand, any
additional order could increase the existing profit provided the offered price is
more than the marginal cost.
The existing cost and profit structure is as under:
MARGINAL COSTING 14.23
The offer for 2,500 unit be accepted as it increases the profit by ` 87,500
(` 1,25,000 – ` 37,500).
(ii) In this instant case, the capacity to produce medals is decreased by 1,000 unit
per month and the existing demand for the medals is 7,500. The spare
capacity is for 1,500 medals only but the special demand is for 2,500 medals.
By accepting the offer, the company has to lose contribution on 1,000 medals
from existing customers. The offer will only be acceptable if the gain from the
new offer supersedes the loss from the existing customers.
Particulars Amount Amount
14.24 COST AND MANAGEMENT ACCOUNTING
(`) (`)
A. Sales Value {(` 150 × 6,500) + (` 120 × 2,500)} 12,75,000
B. Variable Cost (` 85 × 9,000) 7,65,000
C. Contribution (A-B) 5,10,000
D. Fixed Costs:
- Fixed manufacturing costs 2,75,000
- Fixed marketing costs 1,75,000 4,50,000
E. Profit (C-D) 60,000
By accepting the special order at ` 120 per unit, the total profit of the company is
increased by ` 22,500 (` 60,000 – ` 37,500) hence the order may be accepted,
however, other qualitative factors may also be taken care-off.
Short-term Decisions: Make or Buy
Make or Buy is a situation of decision making where it is to be decided whether the
product should be made using the own production facility or to be produced
outside by outsourcing or to buy from the market instead of making. This type of
situation arises when Demand for the product is more than the supply of resources
(material, men, machine etc.). The resource is limiting or key factor and decision is
made keeping optimum utilization of the key resource and the maximization of
profitability into consideration. However, as discussed earlier the qualitative factors
shall also be kept into consideration.
ILLUSTRATION 13: Make or Buy Decision
NN Ltd. manufactures automobiles accessories and parts. The following are the total
cost of processing 2,00,000 units:
Direct materials cost ` 375 per unit
Direct labour cost ` 80 per unit
Variable factory overhead ` 16 per unit
Fixed factory overhead ` 500 lakhs
The purchase price of the component is ` 485. The fixed overhead would continue to
be incurred even when the component is bought from outside.
REQUIRED:
(a) Should the part be made or bought from outside considering that the present
facility when released following a buying decision would remain idle?
MARGINAL COSTING 14.25
(b) In case the released capacity can be rented out to another manufacturer for
` 32,00,000 having good demand. What should be the decision?
SOLUTION
The present cost structure is as follows:
Variable cost per unit is:
SOLUTION
X Y Z
(*) Opportunity cost is the maximum possible contribution forgone by not producing
alternative product i.e. if Product X is produced then opportunity cost will be maximum of
(` 6,000 from Y, ` 4,500 from Z).
ILLUSTRATION 15
M.K. Ltd. manufactures and sells a single product X whose selling price is ` 40 per
unit and the variable cost is ` 16 per unit.
(i) If the Fixed Costs for this year are ` 4,80,000 and the annual sales are at 60%
margin of safety, CALCULATE the rate of net return on sales, assuming an
income tax level of 40%
(ii) For the next year, it is proposed to add another product line Y whose selling
price would be ` 50 per unit and the variable cost ` 10 per unit. The total fixed
costs are estimated at ` 6,66,600. The sales mix values of X : Y would be 7 : 3.
DETERMINE at what level of sales next year, would M.K. Ltd. break even? Give
separately for both X and Y the break-even sales in rupee and quantities.
SOLUTION
(i) Contribution per unit = Selling price – Variable cost
= `40 – `16 = `24
` 4,80,000
Break-even Point = = 20,000 units
`24
MARGINAL COSTING 14.27
(`)
Sales Value (50,000 units × `40) 20,00,000
Less: Variable Cost (50,000 units × `16) 8,00,000
Contribution 12,00,000
Less: Fixed Cost 4,80,000
Profit 7,20,000
Less: Income Tax @ 40% 2,88,000
Net Return 4,32,000
` 4,32,000
Rate of Net Return on Sales = 21.6% ×100
`20,00,000
(ii) Products
X Y
(`) (`)
Selling Price 40 50
Less: Variable Cost 16 10
Contribution per unit 24 40
Sales Ratio 7 3
Contribution in sales Ratio 168 120
Break-even Point
7
X = ×23,145.80 = 16,202 units
10
or 16,202 × ` 40 = ` 6,48,080
3
Y = ×23,145.80 = 6,944 units or 6,944 × ` 50 =` 3, 47,200
10
Based on distributing fixed cost in the weighted Contribution Ratio
Fixed Cost
168
X = ×6,66,600 = ` 3,88,850
288
120
Y = ×6,66,600 = ` 2,77,750
288
Break-even Point
Fixed Cost 3,88,850
X = = = 16,202 units or ` 6, 48,000
Contribution per unit 24
Fixed Cost 2,77,750
Y = = = 6,944 units or ` 3, 47,200
Contribution per unit 40
ILLUSTRATION 16
X Ltd. supplies spare parts to an air craft company Y Ltd. The production capacity of
X Ltd. facilitates production of any one spare part for a particular period of time. The
following are the cost and other information for the production of the two different
spare parts A and B:
Part A Part B
Per unit
Alloy usage 1.6 kgs. 1.6 kgs.
Machine Time: Machine P 0.6 hrs 0.25 hrs.
Machine Time: Machine Q 0.5 hrs. 0.55 hrs.
Target Price (`) 145 115
Total hours available Machine P 4,000 hours
Machine Q 4,500 hours
Part A Part B
Machine “P” (4,000 hrs) 6,666 16,000
Machine “Q” (4,500 hrs) 9,000 8,181
Alloy Available (13,000 kg.) 8,125 8,125
Maximum Number of Parts to be manufactured 6,666 8,125
(Minimum of the above three)
(`) (`)
Material (`12.5 × 1.6 kg.) 20.00 20.00
Variable Overhead: Machine “P” 48.00 20.00
Variable Overhead: Machine “Q” 50.00 55.00
Total Variable Cost per unit 118.00 95.00
Price Offered 145.00 115.00
Contribution per unit 27.00 20.00
Total Contribution for units produced …(I) 1,79,982 1,62,500
Spare Part A will optimize the contribution.
(ii)
Part A
Parts to be manufactured numbers 6,666
Machine P : to be used 4,000
Machine Q : to be used 3,333
14.30 COST AND MANAGEMENT ACCOUNTING
ILLUSTRATION 17
The profit for the year of R.J. Ltd. works out to 12.5% of the capital employed and the
relevant figures are as under:
Sales……………………………………………………………… ` 5,00,000
Direct Materials………………………………………………… ` 2,50,000
Direct Labour…………………………………………………….. ` 1,00,000
Variable Overheads…………………………………………… ` 40,000
Capital Employed……………………………………………… ` 4,00,000
The new Sales Manager who has joined the company recently estimates for next year
a profit of about 23% on capital employed, provided the volume of sales is increased
by 10% and simultaneously there is an increase in Selling Price of 4% and an overall
cost reduction in all the elements of cost by 2%.
Required
FIND OUT by computing in detail the cost and profit for next year, whether the
proposal of Sales Manager can be adopted.
SOLUTION
Statement Showing “Cost and Profit for the Next Year”
Particulars Existing Volume, Costs, Estimated Sale,
Volume, etc. after 10% Cost, Profit,
etc. Increase etc.*
(`) (`) (`)
Sales 5,00,000 5,50,000 5,72,000
Less: Direct Materials 2,50,000 2,75,000 2,69,500
Direct Labour 1,00,000 1,10,000 1,07,800
Variable Overheads 40,000 44,000 43,120
Contribution 1,10,000 1,21,000 1,51,580
MARGINAL COSTING 14.31