Question

In: Accounting

Lindstrom Company produces two fountain pen models. Information about its products follows: Product A Product B...

Lindstrom Company produces two fountain pen models. Information about its products follows:

Product A Product B
Sales revenue $ 120,000 $ 125,000
Less: Variable costs 60,000 66,000
Contribution margin $ 60,000 $ 59,000
Total units sold 7,000 7,000


Lindstrom’s fixed costs total $84,500.

Required:
1.
Determine Lindstrom’s weighted-average unit contribution margin and weighted-average contribution margin ratio. (Round your weighted-average CM to 2 decimal places and your CM ratio to 1 decimal place (i.e. .123 should be entered as 12.3%)).



2. Calculate Lindstrom’s break-even point in units and in sales revenue. (Round your "Sales Revenue" answer to 2 decimal places and "Sales Units" answer to the nearest whole number.)


    
3. Calculate the number of units that Lindstrom must sell to earn a $120,000 profit. (Round your answer to the nearest whole number.)


    
4. Calculate Lindstrom’s margin of safety and margin of safety as a percentage of sales if it sells 11,000 total pens. (Round your margin of safety in units to the nearest whole number and your percentage of sales answer to 2 decimal places (i.e. .1234 should be entered as 12.34%))

Solutions

Expert Solution

Solution:
1. Weighted-average unit contribution margin =$8.5 per unit
Weighted-average contribution margin ratio =48.6%
Working Notes:
Weighted-average unit contribution margin =Total contribution margin of all products/Total units for all products
=119,000/14,000
=$8.5 per unit
Weighted-average contribution margin ratio =Total contribution margin of all products/Total SALES for all products
=119,000/245,000
=0.48571428
=48.57%
=48.6%
Notes: i II III=I+II
Product A Product B Total
Sales revenue 120,000 125,000 245,000 a
Less: Variable costs 60,000 66,000 126,000 b
Contribution margin 60,000 59,000 119,000 c=a-b
Total units sold 7,000 7,000 14,000 d
2. Break-even point in units =9,941 units
Break-even point in sales revenue =$173,970.59
Working Notes:
Breakeven point = Fixed cost /unit contribution margin
=$84,500/$8.50 $8.50 unit contribution margin used from 1.
=9,941.176
=9,941 units
Break-even point in sales revenue = Fixed cost /Contribution margin ratio
=$84,500/0.48571428
=$173,970.5903 contribution margin ratio = 0.48571428 from 1.
=$173,970.59
3. Number of units that Lindstrom must sell to earn a $120,000 profit = 24,059units
Working Notes:
Target units=(Total fixed cost + target profit) / Unit Contribution Margin
= (84,500 + 120,000)/8.50
= 204,500/8.50
=24,058.823
=24,059 units nearest whole no.
4. Margin of safety = 1,059 units
margin of safety as a percentage of sales=9.63%
Working Notes:
Margin of safety units= Actual or budgeted sales - Break even sales
=11,000 -9,941.176
=1,058.824
=1,059 nearest whole no.
Margin of safety as a percentage of sales=Margin of safety in units/Total sales units
= 1,058.824/11,000
=0.096256727
=0.0963
=9.63%
Please feel free to ask if anything about above solution in comment section of the question.

Related Solutions

Jonah Hill Company manufactures two products. Information about the two products is as follows: ​ Product...
Jonah Hill Company manufactures two products. Information about the two products is as follows: ​ Product X Product Y Selling price per unit $80 $30 Variable costs per unit 40 20 Contribution margin per unit $40 $10 The company expects fixed costs to be $185,000. The firm expects 70% of its sales (in units) to be Product X and 30% to be Product Y (a sales mix of 7:3). a. Calculate the weighted average contribution margin or contribution margin by...
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?
A company makes two products, the variable costs are as follows; Product A Product B £...
A company makes two products, the variable costs are as follows; Product A Product B £ £ Direct materials 1 3 Direct labour (£6 per hour) 6 3 Variable overhead 1 1 8 7 The sale price of A is £14 and B is £11. During the month of July the availability of Direct Labour is limited to 5000 hours due to staff taking holidays. Sales demand is expected to be 3000 units of A and 5000 units of B....
Pin Cushion Company produces two models of sewing basket. Information about Pin Cushion’s products is given...
Pin Cushion Company produces two models of sewing basket. Information about Pin Cushion’s products is given below: Product A Product B Sales revenue $ 39,000 $ 54,000 Less: Variable costs 15,800 24,200 Contribution margin $ 23,200 $ 29,800 Total units sold 1,000 2,040 Pin Cushion’s fixed costs total $38,500. Required: 1. Determine Pin Cushion’s weighted-average unit contribution margin and weighted-average contribution margin ratio. Weighted-Average Unit CM Weighted-Average CM Ratio % 2. Calculate Pin Cushion’s break-even units and break-even sales revenue....
Command Company produces two types of electronic products, Product A and Product B. Electronic gaming products...
Command Company produces two types of electronic products, Product A and Product B. Electronic gaming products are hot products now and either product A or product b could be sold to keep the manufacturing facility operating a full capacity. The constraint is direct labour hours and it is insufficient to meet the combined demand for both.   Both products are processed through the same production departments. The relevant information is as follows: Product A Product B Sales Price $ $250 $140...
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.)
Chastain Corporation produces three products, with costs and selling prices as follows: Product A Product B...
Chastain Corporation produces three products, with costs and selling prices as follows: Product A Product B Product C Selling price per unit $ 30 100 % $ 20 100 % $ 15 100 % Variable costs per unit 18 60 % 15 75 % 6 40 % Contribution margin per unit $ 12 40 % $ 5 25 % $ 9 60 % A particular machine is the bottleneck. On that machine, 3 machine hours are required to produce each...
The following information is for X Company's two products, A and B: Product A Product B...
The following information is for X Company's two products, A and B: Product A Product B Revenue $93,000 $90,000 Total contribution margin 39,990 41,400 Total fixed costs 25,750 57,620 Profit $14,240 $-16,220 $13,648 of Product A's fixed costs are avoidable; $29,962 of Product B's fixed costs are avoidable. X Company plans to drop Product B since it shows a loss and increase sales of Product A by $34,800. Accompanying the sales increase will be a fixed cost increase of $5,000....
The following information is for X Company's two products, A and B: Product A Product B...
The following information is for X Company's two products, A and B: Product A Product B Revenue $93,000    $90,000    Total contribution margin 39,990    37,800    Total fixed costs 30,430    55,990    Profit $9,560    $-18,190    $15,215 of Product A's fixed costs are avoidable; $33,034 of Product B's fixed costs are avoidable. X Company plans to drop Product B since it shows a loss and increase sales of Product A by $29,600. Accompanying the sales increase will be a fixed cost increase of $4,800....
A Company produces two products. Relevant information for each product is shown in the Table below....
A Company produces two products. Relevant information for each product is shown in the Table below. The company has a goal of $48 in profits and incurs $1 penalty for each dollar it falls short of this goal. A total of 32 hours of labor are available. A $2 penalty is incurred for each hour of overtime (labor over 32 hours) used, and $1 penalty is incurred for each hour of available labor that is unused. Marketing considerations require at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT