Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As part of it its portfolio of products, Mahim Manufacturers Limited has three products in the fast-moving consumer goods market. The company diversified its portfolio

As part of it its portfolio of products, Mahim Manufacturers Limited has three products in the fast-moving consumer goods market. The company diversified its portfolio to ensure that it has some protection against a sudden drop in the sales of any particular product. The budgeted selling price and other relevant information at the beginning of 2019 are as follows:

Products

P123

X456

Y789

Selling price

300

300

300

Variable cost

125

245

210

Sales mix

45%

33%

22%

Fixed costs

205,000

Total revenue

556,500

At the end of the year, the initial forecast was not achieved. The company expected to sell a large volume of P123 but X456 ended up being the most popular product. This led to a change in the actual sales mix at the end of the year. Moreover, there were also changes in the variable costs for all products due to a sudden regulatory change in the market. As a result, the companys overall revenue did not meet the original expectations. Mahim Manufacturers Ltd.s actual performance at the end of 2019 is as follows:

Products

P123

X456

Y789

Selling price

300

300

300

Variable cost

140

285

231

Sales mix

28%

43.2%

28.8%

Fixed costs

205,000

Total revenue

495,000

[CONTINUED]

Since the 2019 performance was rather frustrating for the company, its managers hired a financial analyst to evaluate the business. After analysing the actual sales data, the analyst recommended that the company drop one of its three products. He argues that the company should focus on two products and transfer the resources spent so far on the dropped product to develop a stronger marketing campaign to build up a brand image for the company and the two remaining products. The company board has accepted the analysts recommendations and agreed to drop a product. Thus, in the new sales mix, there are two products, each of which carries 50% weight of the total sales mix. The board instructed the marketing department to design an extensive advertising campaign for the products in the new sales mix.

Required:

a)

Calculate the break-even point for Mahims original sales mix of the three products in units and pounds. Support your answer by showing calculations for each product and the sales mix.

Mahim manufactures
P 123 X 456 Y 789 Total Total
Selling price 300.00 300.00 300.00 A
Variable cost 125.00 245.00 210.00 B
Contribution per unit 175.00 55.00 90.00 C=A-B
Sales mix 45% 33% 22% D
Weighted Contribution per unit 78.75 18.15 19.80 116.70 E=C*D
Fixed costs 205,000.00 F
Breakeven units 1,757.00 G=F/E
Breakeven units 790.65 579.81 386.54 1,757.00 H=G*D
Selling price 300.00 300.00 300.00 See A
Breakeven sales (amount) 237,195.00 173,943.00 115,962.00 527,100.00 I=H*A

b)

How much profit does the company generate with the original sales mix?

c)

Calculate the profit of the company using the end of year (actual) data.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles Understanding Important Terms And Principles Of Accounting

Authors: Lyndsay Sudduth

1st Edition

B0B5KV57NJ, 979-8840104033

More Books

Students also viewed these Accounting questions

Question

List the functions that are served by short-term memory.

Answered: 1 week ago