Answer:
1.(a). Breakeven point (in units) = Fixed cost / Contribution margin per unit
Contribution margin per unit = Selling price per unit - Variable cost per unit
= 500 - 400 = 100 per unit
Breakeven point = 150,000 / 100 per unit
Breakeven point = 1500 units
Breakeven point ( in revenue) = Fixed Cost / Contribution margin ratio
Contribution margin ratio = ( Selling price per unit - Variable cost per unit) / Selling price per unit ×100
= ($500 - $400) / $500 ×100
= 20%
Breakeven point ( in revenue) = $150,000 / 20%
Breakeven point ( in revenue) = $750,000
(b). Let x be the unknown quantity of units Bernard Windows must sell to earn an operating income of $100,000. Selling price is $500
Revenue - Variable cost - Fixed cost = operating income
($500 * x) - ($400*x) - $150,000 = $100,000
($100* x) = $250,000
x = $250,000 / $100 per unit = 2,500 units
Quantity of units required to be sold = 2,500 units
Revenue to earn an operating income of $100,000 is
Revenue = Number of units required to be sold * Selling Price
Revenue = 2,500 * $500 = $1,250,000
2. Target operating income = Target net income / (1 - Tax Rate)
= $63,000 / (1 - 0.30)
= $90,000
In other words, to earn a target net income of $63,000, Bernard Windows Target operating income is $90,000.
Proof: Target operating income $90,000
Tax at 30% ( $90,000*0.30) $27,000
Target net income $63,000
Calculation of number of units Bernard Windows must sell:
Quantity of units required to be sold = Fixed cost + Target operating income / Contribution margin per unit
= $150,000 + $90,000 / $100 = $2,400 units
Quantity of units required to be sold = 2,400 units
Revenue to earn net income of $63,000 is:
Revenue = Number of units required to be sold * Selling price
= 2,400 * $500
Revenue = $1,200,000
3. Margin of Safety = Budgeted revenue - Breakeven revenue
= $1,200,000 - $750,000
Margin of Safety = $450,000
Margin of safety (in units) = Budgeted Sales (units) - Breakeven Sales (units)
= 2,400 - 1,500
Margin of safety (in units) = 900 units
The margin of safety indicated that sales would have to decrease by 900 units and revenue by $450,000 before the breakeven point is reached.
Margin of safety percentage = Margin of safety in dollars / Budgeted revenues
= $450,000 / $1,200,000 * 100 = 37.5%
This result means that revenue would have to decrease substantially, by 60%, to reach the breakeven revenues.
5. Let we assume that the budgeted sales mix (2,500 units of chad windows sold for every 1,000 units of Musk windows sold, that is a ratio of 5:2) will not change at different levels of total unit sales.
Number of units of Contribution Margin
Chad Windows and per unit for Chad Windows
Musk Windows in and Mask Windows Contribution
each bundle margin the bundle
Chad Windows 5 $100 $500
Musk windows 2 $75 $150
Total $650
To calculate breakeven point, we calculate the number of bundles Bernard needs to sell.
Breakeven point in bundles = Fixed cost / Contribution margin per bundle
= $195,000 / $650 = 300 bundles
a. Breakeven point in units of Chad Windows and Musk windows is as follows:
Chad windows: 300 bundles× 5 units per bundle = 1,500 units
Musk windows: 300 bundles ×2 units per bundle = 600 units
Total number of units to breakeven = 1,500 + 600 = 2,100 units
b. The breakeven point in dollars for Chad windows and Musk windows is as follows:
Chad windows: 1,500 units × $500 per unit = $750,000
Musk windows: 600 units ×$350 per unit = $210,000
Breakeven revenue = $750,000 + $210,000 = $960,000
