In: Finance
Case
In 1988, the total fabric wash sales were estimated to be
263,050 tonnes in Pakistan consisted of 247,000 tonnes of laundry
soap, 14,500 tonnes of non-soap detergent (NSD) powders, and 750
tonnes of NSD bars. Lever Brothers’ Rin brand was the only NSD Bar
in the Pakistan fabric wash market. The price of Rin was Rs 6 for
the 250-gram pack. RIN was distributed through 315 distributors to
60,000 retail outlets in the country. This represented almost 100
percent coverage in retail outlets selling detergents. When RIN was
launched in 1984, the distributors received a margin of 3 percent
on the
retail selling price. The retailer margin was at 7 percent of the
retail price. In 1988, excise and octroi taxes were together
totalling to 5% of the retail selling price.
Production department transferred Rin at Rs. 3.6 per unit to
marketing department. Marketing department has planned to spend 1
Mn. on selling plus transportation costs and about Rs. 3.5 Mn. on
advertising expenses.
Question
a) What is the unit contribution? How many bars of RIN would be required to be sold in 1988 by Lever Brothers to break-even? How much sales in units Rin NSD bar is expected to make in 1988? What is the Gross Marketing Contribution? What is the Net Marketing Contribution?
Solution
i) Unit Contribution : The unit contribution can be defined as the additional money generated from the sale of each unit after netting off only the Variable cost per unit. Fixed cost is not considered here. Mathematically it can be interpreted as follows
Contribution Per Unit = Selling Price Per unit - Variable cost per unit
ii) Computation of Break Even Point (units) of BEP(Units) :
BEP (Units) = Fixed Cost / Contribution per unit
Where Fixed cost in the given case is computed as follows
Transportation cost = Rs10,00,000
Advertising Expenses = Rs35,00,000
Total Fixed cost = Rs 45,00,000
Computation of Contribution Per unit
Selling Price - Rs 6.00 (Per unit)
Less
Production cost -Rs(3.60)
Exc & Octroi 5% on 6 -Rs( 0.30) - Rs (3.90) (Per unit)
Gross Contribution Per unit Rs 2.10 ( Per unit)
Less
Dist Margin 3% on 6 -Rs (0.18)
Ret Margin 7$ on 6 -Rs (0.42) - Rs (0.60) (Per unit)
Net Contribution per unit - Rs 1.50
Substitituting the values in the formula to get
BEP(units) = Rs 45,00,000 /Rs 1.5 = 30,00,000 (units)
iii) Expected Sales for 1988:
It is given 750 tonnes of NSD Sales possible for 1988 & is expected to meet 100% requirement. Each bar weighs 250gm. Therefore number of Bars in sold would be [750x1000x1000]gms / 250 gms = 30,00,000 units
Expected Sales would be 30,00,000 units
iv) Computation of Gross Contribution Margin & Net Contribution Margin
Gross Contribution Margin = Gross Contribution Margin Per unit x No of units
= Rs2.10 x 30,00,000 = Rs63,00,000
Net Contribution Margin = Net Contribution Margin Per unit x No of units
= Rs1.5 x 30,00,000 = Rs 45,00,000