Explore Westonci.ca, the premier Q&A site that helps you find precise answers to your questions, no matter the topic. Join our platform to connect with experts ready to provide accurate answers to your questions in various fields. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

Exercise 18-22 (Algo): CVP Analysis with Two Products

Handy Home sells windows (60% of sales) and doors (40% of sales). The selling price of each window is \[tex]$340 and of each door is \$[/tex]730. The variable cost of each window is \[tex]$195 and of each door is \$[/tex]490. Fixed costs are \[tex]$446,950.

1. Compute the break-even point in units using the weighted-average contribution margin.

\[
\begin{tabular}{|c|c|c|}
\hline
Numerator: & Total fixed costs & \$[/tex]446,950 \\
\hline
Denominator: & Weighted average contribution margin per unit & \$335.8 \\
\hline
& Break-even units & 1,331 \\
\hline
\end{tabular}
\]

2. Compute the number of units of each product that will be sold at the break-even point.

[tex]\[
\begin{tabular}{|c|c|}
\hline
Windows & 799 units \\
\hline
Doors & 532 units \\
\hline
\end{tabular}
\][/tex]

Sagot :

Alright, let's go through the problem step-by-step to find the break-even point and the number of units for each product that will be sold at that point.


### Step 1: Calculate the Contribution Margin for Each Product

The contribution margin is calculated by subtracting the variable cost from the selling price for each product.

- Contribution margin for windows:

[tex]\[ \text{Selling price of windows} - \text{Variable cost of windows} = \$340 - \$195 = \$145 \][/tex]

- Contribution margin for doors:

[tex]\[ \text{Selling price of doors} - \text{Variable cost of doors} = \$730 - \$490 = \$240 \][/tex]


### Step 2: Calculate the Weighted Average Contribution Margin

The weighted average contribution margin is calculated by multiplying the contribution margin of each product by its sales ratio and then summing the results.

- Weighted average contribution margin:

[tex]\[ \text{Weighted average contribution margin} = (\text{Contribution margin of windows} \times \text{Sales ratio of windows}) + (\text{Contribution margin of doors} \times \text{Sales ratio of doors}) \][/tex]

[tex]\[ = (\$145 \times 0.60) + (\$240 \times 0.40) \][/tex]

[tex]\[ = \$87 + \$96 = \$183 \][/tex]

### Step 3: Calculate the Break-Even Point in Units

To find the break-even point in units, we divide the total fixed costs by the weighted average contribution margin.

- Break-even point in units:

[tex]\[ \text{Break-even point} = \frac{\text{Total fixed costs}}{\text{Weighted average contribution margin}} \][/tex]

[tex]\[ = \frac{\$446,950}{\$183} \][/tex]

[tex]\[ \approx 2442.35 \text{ units} \][/tex]


### Step 4: Calculate the Number of Units for Each Product at the Break-Even Point

Now, to find the number of units for each product at the break-even point, we multiply the total break-even units by the sales ratio of each product.

- Number of windows:

[tex]\[ \text{Number of windows} = \text{Break-even units} \times \text{Sales ratio of windows} \][/tex]

[tex]\[ = 2442.35 \times 0.60 \][/tex]

[tex]\[ = 1465.41 \text{ units} \][/tex]


- Number of doors:

[tex]\[ \text{Number of doors} = \text{Break-even units} \times \text{Sales ratio of doors} \][/tex]

[tex]\[ = 2442.35 \times 0.40 \][/tex]

[tex]\[ = 976.94 \text{ units} \][/tex]


### Summary

- Contribution margin for windows: \[tex]$145 - Contribution margin for doors: \$[/tex]240
- Weighted average contribution margin: \$183
- Break-even point in units: 2442.35 units
- Number of windows at break-even point: 1465.41 units
- Number of doors at break-even point: 976.94 units

This is the step-by-step solution to determine the break-even point in units and the number of units for each product that will be sold at that point.