Question

In: Accounting

Malibu, Inc., which has fixed costs of $2,978,000, sells three products whose sales price, variable cost...

Malibu, Inc., which has fixed costs of $2,978,000, sells three products whose sales price, variable cost per unit, and percentage of sales units are presented in the table below.

Product A Product B Product C
Sales Price $ 8.00 $ 13.00 $ 30.00
Variable Cost $ 5.00 $ 5.00 $ 16.00
Product Mix 60 % 20 % 20 %


a. What is the weighted average unit contribution margin? (Round your answer to 2 decimal places.)

  

b. At the break-even point, how many units of Product A must be sold? (Round intermediate calculations to 2 decimal places. Round your answer to the nearest whole number.)



c. To make a profit of $1,115,000, how many units of Product B must be sold? (Round intermediate calculations to 2 decimal places. Round your answer to the nearest whole number.)

Solutions

Expert Solution

Solution:

Part a –

Product A

Product B

Product C

Unit Selling Price

$8.00

$13.00

$30.00

Less: Variable Costs

$5.00

$5.00

$16.00

Contribution Margin per unit

$3.00

$8.00

$14.00

x Product/Sales Mix Ratio

0.60

0.20

0.20

$1.80

$1.60

$2.80

Weighted Average Contribution Margin per unit 1.8+1.6+2.8)

$6.20

Weighted Average Contribution Margin Per Unit = $6.20

Part b –

Break Even Point for Company in Units = Total Fixed Cost $2,978,000 / Weighted Average CM Per Unit $6.20

= 480,322.58

At the break-even point, number of units of Product A must be sold = Break Even Point for Company in Units 480,322.58 * Product Mix Ratio for Product A 60%

= 288,194 Units

Part c –

To make a profit of $1,115,000, number of units of Product B must be sold

Break Even Point for Company in Units to achieve profit $1,115,000 = (Total Fixed Cost $2,978,000 + Profit $1,115,000) / Weighted Average CM Per Unit $6.20

= $4,093,000 / $6.20

= 660,161.29 Units

Number of Units of Product B to be sold to make a profit of $1,115,000 = Break Even Point for Company in Units 660,161.29 * Product Mix Ratio for Product B 20%

= 132,032 Units

Hope the above calculations, working and explanations are clear to you and help you to understand the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you


Related Solutions

Malibu Corporation has monthly fixed costs of $66,000. It sells two products for which it has...
Malibu Corporation has monthly fixed costs of $66,000. It sells two products for which it has provided the following information. Sales Price Contribution Margin Product 1 $ 15 $ 9 Product 2 20 4 a. What total monthly sales revenue is required to break even if the relative sales mix is 30 percent for Product 1 and 70 percent for Product 2? (Round your answer to the nearest dollar amount.) b. What total monthly sales revenue is required to earn...
Malibu Corporation has monthly fixed costs of $56,000. It sells two products for which it has...
Malibu Corporation has monthly fixed costs of $56,000. It sells two products for which it has provided the following information. Sales Price Contribution Margin Product 1 $ 15 $ 9 Product 2 20 4 a. What total monthly sales revenue is required to break even if the relative sales mix is 30 percent for Product 1 and 70 percent for Product 2? (Round your answer to the nearest dollar amount.) b. What total monthly sales revenue is required to earn...
Malibu Corporation has monthly fixed costs of $63,000. It sells two products for which it has...
Malibu Corporation has monthly fixed costs of $63,000. It sells two products for which it has provided the following information. Sales Price Contribution Margin Product 1 $ 15 $ 9 Product 2 20 4 a. What total monthly sales revenue is required to break even if the relative sales mix is 30 percent for Product 1 and 70 percent for Product 2? (Round your answer to the nearest dollar amount.) b. What total monthly sales revenue is required to earn...
If the unit sales price is $12, the unit variable cost is $7.00 and fixed costs...
If the unit sales price is $12, the unit variable cost is $7.00 and fixed costs are $125,000; what is the, break-even quantity in # of units? ___________________________________ Please Show steps
Dallas Inc. sells a product for $62. Variable costs are 60% of sales, and monthly fixed...
Dallas Inc. sells a product for $62. Variable costs are 60% of sales, and monthly fixed costs are $58,776. a. What is the break-even point in units? (Do not round intermediate calculations.) b. What unit sales would be required to earn a target profit of $123,256? (Do not round intermediate calculations.) c. Assume they achieve the level of sales required in part b, what is the margin of safety in sales dollars? (Do not round intermediate calculations.)
No. of Products Total Variable Costs, $ Total Costs $ Average Fixed Cost $ Average Variable...
No. of Products Total Variable Costs, $ Total Costs $ Average Fixed Cost $ Average Variable Cost $ Average Total Cost $ Marginal Cost$ 0 0 1 12 2 20 3 24 4 27 5 40 6 65 7 98 Assume that the fixed cost is $80, calculate the above costs in the table and explain the difference between average total costs and marginal costs. In a graph illustrate the Average Total Cost and Marginal Cost Curves, explain their relationship....
Identify Fixed and Variable Costs Intuit Inc. develops and sells software products for the personal finance...
Identify Fixed and Variable Costs Intuit Inc. develops and sells software products for the personal finance market, including popular titles such as Quickbooks® and TurboTax®. Classify each of the following costs and expenses for this company as either variable or fixed to the number of units produced and sold: a. Packaging costs Fixed b. Sales commissions Variable c. Property taxes on general offices d. Shipping expenses e. Straight-line depreciation of computer equipment f. President’s salary g. Salaries of software developers...
Identify Fixed and Variable Costs Intuit Inc. develops and sells software products for the personal finance...
Identify Fixed and Variable Costs Intuit Inc. develops and sells software products for the personal finance market, including popular titles such as Quickbooks® and TurboTax®. Classify each of the following costs and expenses for this company as either variable or fixed to the number of units produced and sold: a. Packaging costs b. Sales commissions c. Property taxes on general offices d. Shipping expenses e. Straight-line depreciation of computer equipment f. President’s salary g. Salaries of software developers h. Salaries...
A store will cost $875,000 to open. Variable costs will be 51% of sales and fixed...
A store will cost $875,000 to open. Variable costs will be 51% of sales and fixed costs are $210,000 per year. The investment costs will be depreciated straight-line over the 9 year life of the store to a salvage value of zero. The opportunity cost of capital is 8% and the tax rate is 40%. sales revenue is $700,000 per year. Using an operating cash flow of 118,688.89, calculate the Net Present Value. = -133574.24 Find the net present value...
Ibhar Manfacturing Company has fixed cost of $3,000,000 and variable costs are 40% of sales. What...
Ibhar Manfacturing Company has fixed cost of $3,000,000 and variable costs are 40% of sales. What are the required sales if Ibhar desires net income of $300,000? a. $5,000,000 b. $5,500,000 c. $8,250,000 d. $7,500,500
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT