Examples: Absorption Costing & Marginal Costing
Q. Rajkumar Ltd. provides you the following information
|
Sales (Rs.) |
Profit (Rs.) |
Period 1 |
10,000 |
2,000 |
Period 2 |
15,000 |
4,000 |
You are required to calculate:
- P/V ratio
- Fixed cost
- Break-even sales volume
- Sales to earn a profit of Rs. 3,000 and
- Profit when sales are Rs. 8,000
i)
|
Change in profit |
|
|
P/V ratio = |
|
x |
100 |
|
Change in rate |
|
|
ii)
Fixed Cost = Contribution - Profit
|
10000 |
|
|
|
|
= |
|
x |
40 - 2000 |
= |
2000 |
|
100 |
|
|
|
|
iii)
|
Fixed Cost |
Break-even sales volume = |
|
|
P/V ratio |
= 5000
iv)
|
Fixed cost + Profit |
Sales = |
|
|
P/V ratio |
= 12500
v)
Profit = Sales - Variable cost - Fixed cost
Variable cost = 8000 x (60/100) = 4800
Profit = 8000 - 4800 - 2000 = 1200
Q. From the following information relating to Smith sons,
calculate the break-even point and the turnover required to earn
a profit of Rs. 3,00,000
Fixed Overhead = 2,10,000 (total)
Variable Cost = 20 per unit
Selling price = 50 per unit
If the company is earning a profit of Rs. 3,00,000, what is the
margin of safety available to it? Also state the significance of
this margin.
Selling price |
= 50 |
Less variable cost |
= 20 |
Contribution |
= 30 |
|
Fixed cost |
BEP in units = |
|
|
Contribution per unit |
|
2,10,000 |
|
|
= |
|
= |
7,000 units |
|
30 |
|
|
|
2,10,000 |
|
|
BEP in amount = |
|
= |
3,50,000 |
|
60% |
|
|
Calculation of turnover to earn a profit of Rs. 3,00,000
|
Fixed cost + Desired Profit |
Sales = |
|
|
Contribution per unit |
= 17000 units
|
Fixed cost + Desired Profit |
Sales (amount) = |
|
|
P/V ratio |
= 8,50,000
Margin of Safety
Margin of safety = Total sales - sales at BEP
MOS (Amount) = 850000 - 350000 = 500000
MOS (Units) = 17000 - 7000 = 10000 units
> For theory part please refer to chapter 9.
Q. Premier Ltd. produces a standard article. The results
of the last four quarters of the year 2000 are as follows:
Quarters |
Output (unit) |
I |
1,000 |
II |
1,500 |
III |
2,000 |
IV |
3,000 |
The cost of direct material is Rs. 30 and direct labour is Rs.
20 per unit. Variable expenses are Rs 10 per unit. Fixed expenses
are Rs 6,000 per annum. (i) Find out full cost percent for each
quarter. (ii) Find out BEP (Break Even Point) in units for each
quarter if selling price is Rs 100 per unit and the entire output
is sold.
|
I |
II |
III |
IV |
Output |
1000 |
1500 |
2000 |
3000 |
Direct material Rs. 30 |
30000 |
45000 |
60000 |
90000 |
Direct Labour Rs. 20 |
20000 |
30000 |
40000 |
60000 |
Variable Expenses Rs. 10 |
10000 |
15000 |
20000 |
30000 |
Fixed Expenses |
1500 |
1500 |
1500 |
1500 |
Annual expenses = 6000
Quaterly expense = 6000/4 = 1500
i) Full cost percent for each quarter
Total |
61500 |
91500 |
121500 |
181500 |
Percentage |
13.5 |
20 |
26.7 |
39.80 |
ii) BEP in units
BEP = Fixed cost/ contribution per unit
Contribution = Sales - Variable cost
= 100 - (30 + 20 + 10)
= 40
BEP = 6000/40 = 150 units
Q. From the following data :
Selling Price = Rs. 40 per unit
Variable manufacturing cost = Rs. 20 per unit
Variable selling cost = Rs. 10 per unit
Fixed factory overheads = 10,00,000 per year
Fixed selling costs 4,00,000 per year
Calculate : i) Break-even point expressed in rupee sales. ii) Number
of units that must be sold to earn a profit of Rs. 2,00,000 per
year.
i)
Contribution = Sales - variable cost
= 40 - (20 + 10)
= 10
Total fixed cost = Fixed factory overheads + Fixed selling cost
= 10,00,000 + 4,00,000 = 14,00,000
|
Fixed cost |
BEP in units = |
|
|
Contribution per unit |
= 1,40,000 units
BEP (Value) = Fixed cost/(P/V ratio)
|
Contribution |
|
|
P/V ratio = |
|
x |
100 |
|
Sales |
|
|
= 10/40 X 100 = 25%
BEP (value) = (14,00,000/25) X 100
= 56,00,000
ii) Number of units must be sold to earn a profit of
Rs. 2,00,000 per year
|
Fixed cost + Desired Profit |
Sales = |
|
|
P/V ratio |
= (14,00,000 + 2,00,000) / 25%
= 64,00,000
Q. A medical advisory service offers to its subscribers
complete information on doctors, paramedicals, health insurance,
super speciality hospitals and general health awareness. It now
plans to computerise these sevices and has a choice of two systems
on which to offer these services. Under option A, a computer system
would be leased for Rs. 50 lakhs per year and the subscriber requests
would be processed with avariable cost of Rs. 20 per request. Under
plan B, a computer system would be leased for Rs. 10 lakhs per year
and the subscriber requests would be processed with a variable cost
of Rs. 120 per request. Under either option, the subscriber can
and is happy to pay Rs 220 per request that is processed. On the
basis of this data
(i) Which option is more risky?
(ii) Draw break even charts for both options.
(iii) At what volume of business would the operating profit under
either option be the same?
(iv) Which plan has a higher degree of operating leverage?
(i)
PLAN A
BEP (units) = Fixed costs/contribution per unit
= 50,00,000/(220 - 20)
= 25,000 requests
PLAN B
BEP (units) = Fixed costs/contribution per unit
= 10,00,000/(220 - 120)
= 10,000 requests
Plan is more risky because initial fixed cost is very high. If
sales fall below 25,000 requests, losses will be incurred.
(ii) Break even chart
iii) Profit under plan A = (Price - Varaible cost) X Units
- FC
= (220 - 20) X (x) - 50,00,000
Profit under plan B = (220 - 120) X (x) - 10,00,000
Equating both the equations we get
(220 - 20) X (x) - 50,00,000 = (220 - 120) X (x) - 10,00,000
100x = 40,00,000
x = 40,000 requests
iv) Operating Leverage
Degree of operating leverage = %change in net operating income
/ % change in units sold or sales
= Contribution/EBIT
Where EBIT is Earning before interest & tax
In both the plans the contribution is calculated taking hypothetical
data of 50,000 requests because the question does not provide any
information.
PLAN A
|
50000 X (Rs. 220 - Rs. 20) |
= |
|
|
50000 X (220 - 20) - Rs. 50,00,000 |
= 2
PLAN B
|
50000 X (Rs. 220 - Rs. 120) |
= |
|
|
50000 X (220 - 120) - Rs. 10,00,000 |
= 1.25
Plan A has greater operating leverage owing to higher fixed costs.
|
|