Question

In: Accounting

Norman Berhad sells two products; product X and product Y. The information about sales price, variable...

Norman Berhad sells two products; product X and product Y. The information about sales price, variable expenses and total fixed expenses is given below:

	Product X	Product Y
Selling price per unit	RM50	RM100
Variable expenses per unit	RM30	RM40

The total monthly fixed expenses of the company are RM 270,000. Norman Berhad wants to generate a sales revenue of RM 1,000,000 in the next month. To obtain this goal the company has the following options:

Option 1: Sell 6,000 units of product X and 7,000 units of product Y.
Option 2: Sell 14,000 units of product X and 3,000 units of product Y.

Required:

Prepare contribution margin income statement and calculate break-even point in units and sales if Norman Berhad decides to select option 1.

Marks)

Prepare contribution margin income statement and calculate break-even point in units and sales if Norman Berhad decides to select option 2.

marks)

Whichever is the better option, (1) or (2)? Explain.

Solutions

Expert Solution

	X	Y
Selling price	50	100
Less: Variable cost	30	40
Contribution per unit	20	60

Option 1- 6000 x and 7000 y

Total sales is 6000 x 50+7000 x 100= 1000000

Total contribution 6000 x 20 + 7000x60 = 540000

Ratio of X = 300000/100000 = 30%

Ratio 0f Y = 700000 /100000 =70%

weighted selling price = 50 x 30% + 100 x 70% = 85

Weighted variable cost 30 x 30% + 40 x70% = 37

Weighted contribution = W. selling price - W. variable cost

= 85-37 = 48 per unit

Breakeven sales = fixed cost /contribution per unit

= 270000/48 = 5625 units

x units = 5625 x 30% =1687.5 or 1688

y units =5625 x 70% = 3937.5 or 3938

OPTION 2- 14000 of X and 3000 of Y (Alternative way so that u can understand both method)

Total sales = 14000 x 50 + 3000 x100 = 1000000

Total contribution = 14000 x20 + 3000 x60 =460000

X ratio = 700000/100000 = 70%

Y ratio = 30%

	X	Y
Contribution	20	60
Ratio	70%	30%

Weighted contribution 70% x 20 + 60 x 30% = 32

Fixed cost = 270000

Break even = 270000/32 =8437.5 or 8438

X 8438 x70 % = 5906.6 or 5907

Y 8438 x 30% = 2531.4 or 2532

Comparing contribution

	Option 1	Option 2
Total contribution	540000	460000
Ranking	1	2

Option 1 is better due to higher contribution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

A company sells two products. Information about two products is as follows: Product A: Sales Units-1200...

A company sells two products. Information about two products is as follows: Product A: Sales Units-1200 Selling price per unit-$20 variable costs per unit 11 Product B: Sales unit- 800 Selling price per unit- $25 Variable costs per unit- 18 If fixed costs are expected to be $12,300, what is the margin of safety?

Norman Corporation produces and sells a single product. The unit selling price is $150 and variable...

Norman Corporation produces and sells a single product. The unit selling price is $150 and variable expense per unit is $42. Total fixed expenses are $421,200. Enter answers using whole dollar amounts, no commas or dollar signs or decimals. Determine the unit sales needed to earn a target profit of $21,600. ? Determine the dollar sales needed to earn a target profit of $54,000 ? Calculate the margin of safety in dollars for each target profit amount above ? If...

Norman Goods sells only two products, Product A and Product B. Product A Product B Total...

Norman Goods sells only two products, Product A and Product B. Product A Product B Total Selling price $50 $80 Variable cost per unit $33 $48 Total fixed costs $550,000 Norman Goods sells three units of Product A for each two units it sells of Product B. Norman Goods has a tax rate of 20%. Required: a. What is the breakeven point in units for each product, assuming the sales mix is 3 units of Product A for each two...

A consumer consumes two products X and Y. The price of product X is $2 and...

A consumer consumes two products X and Y. The price of product X is $2 and price of product Y is $4. Suppose xx-axis represents quantity of product X, and y-axis represents quantity of product Y. The optimal consumption bundle is (10, 5). If we plot the consumer's indifference curves on this graph, can you say what the slope of the indifference curve is at point (10,5)? A) No. There is not sufficient information about preferences to answer that. B)...

BC Company sells three products, X, Y, and Z. During October, Product X had sales of...

BC Company sells three products, X, Y, and Z. During October, Product X had sales of $500,000; Product Y had sales totaling $300,000; and Product Z reported sales of $200,000. ABC Company as a whole reported total fixed costs of $443,000, a total segment margin of $77,000, and a net income of $53,000. The traceable fixed costs for Product X amounted to $80,000 during October and the traceable fixed costs for Product Z were $60,000 in October. Calculate the traceable...

You are given the following information about y and x: y x Dependent Variable Independent Variable...

You are given the following information about y and x: y x Dependent Variable Independent Variable 5 15 7 12 9 10 11 7 Calculate the value of SSR, using the formula.

Edgewater Enterprises manufactures two products. Information follows: Product A Product B Sales price $ 19.50 $...

Edgewater Enterprises manufactures two products. Information follows: Product A Product B Sales price $ 19.50 $ 22.75 Variable cost per unit $ 6.95 $ 7.65 Product mix 40.00% 60.00% Suppose that each product’s sales price increases by 10.00 percent. Sales mix remains the same and total fixed costs are $310,000.00. Calculate the new break-even point for Edgewater. (Round your intermediate calculations to 2 decimal places and final answer to the nearest whole number.)

A company sells two products, Product A and Product B. Assume that the variable costs for...

A company sells two products, Product A and Product B. Assume that the variable costs for each product are $7. In a particular market, men and women value the two products as follows: Value to the Customer Product A Product B Men (50 % of market) $ 12 $ 15 Women (50 % of market) $ 14 $ 11 If management is considering offering a bundle containing both products, what is the maximum price that could be charged for this...

25) A company sells two products with information as follows: A B Sales price per unit...

25) A company sells two products with information as follows: A B Sales price per unit $12 $28 Variable cost per unit $10 $12 The products are machine made. Four units of product A can be made with one machine hour and two units of product B can be made with one machine hour. The company has a maximum of 5,000 machine hours available per month. The company can sell up to 18,000 units of product A per month, and...

Twin Products Company produces and sells two products. Product M sells for $12 and has variable...

Twin Products Company produces and sells two products. Product M sells for $12 and has variable costs of $6. Product W sells for $15 and has variable costs of $10. Twin predicted sales of 25,000 units of M and 20,000 of W. Fixed costs are $60,000 per month. Assume that Twin achieved its sales goal of $600,000 for September, but fell short of its expected operating income of $190,000. Which of the following descriptions best describes the actual results reported...

Subjects