Question

In: Finance

Case In 1988, the total fabric wash sales were estimated to be 263,050 tonnes in Pakistan...

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?

Solutions

Expert Solution

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


Related Solutions

In 1988, the total fabric wash sales were estimated to be 263,050 tonnes in Pakistan consisted...
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 1988, the total fabric wash sales were estimated to be 263,050 tonnes in Pakistan consisted...
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...
The estimated sales of any investment were $175,000, the cost was $93,000 and the depreciation cost...
The estimated sales of any investment were $175,000, the cost was $93,000 and the depreciation cost was $24,800 per year. The tax rate is 23%. Use four approaches to operating cash flows to find operating cash flows and see if they have the same results. In other words, calculate the operating cash flows separately from the basic approach, the bottom-up approach, the top-down approach, and the tax-saving approach.
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...
You have the following information. BOM is $150,210, Purchases were $120,323, Sales were $51,210, and total...
You have the following information. BOM is $150,210, Purchases were $120,323, Sales were $51,210, and total Retail Reductions were $12,428. What is the EOM?
Sales were $1,840,000, the total debt ratio was .37, and total debt was $673,000. What is the return on assets (ROA)?
Return on Assets A fire has destroyed a large percentage of the financial records of the Excandesco Company. You have the task of piecing together information in order to release a financial report. You have found the return on equity to be 12.9 percent. Sales were $1,840,000, the total debt ratio was .37, and total debt was $673,000. What is the return on assets (ROA)?Return on Equity12.90%Sales$ 1,840,000.00Total Debt Ratio                    0.37Total Debt$     673,000.00Return on Assets03.41 Growth and Assets A firm...
Wilkerson Case Prepare a table ( per unit and in total) showing sales, direct labor expenses,...
Wilkerson Case Prepare a table ( per unit and in total) showing sales, direct labor expenses, material expenses, machine expenses overhead, setup labor overhead, receiving/ production control overhead, engineering overhead, packaging/ ship overhead, margin, and margin % for valves, pumps, flow controllers, unused capacity (difference between capacity units and actual driver unit usage x driver rate figured at capacity levels), and in total using driver rates based on capacity usage levels (machine hours, production runs, engineering hours and shipments.) Wilkerson...
Wilkerson Case Prepare a table ( per unit and in total) showing sales, direct labor expenses,...
Wilkerson Case Prepare a table ( per unit and in total) showing sales, direct labor expenses, material expenses, machine expenses overhead, setup labor overhead, receiving/ production control overhead, engineering overhead, packaging/ ship overhead, margin, and margin % for valves, pumps, flow controllers, unused capacity (difference between capacity units and actual driver unit usage x driver rate figured at capacity levels), and in total using driver rates based on capacity usage levels (machine hours, production runs, engineering hours and shipments.) The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT