Nofly corporation sells three different models of a mosquito "zapper." model a12 sells for $50 and has variable costs of $35. mo
del b22 sells for $100 and has variable costs of $70. model c124 sells for $400 and has variable costs of $300. the sales mix of the three models is a12, 60%; b22, 15%; and c124, 25%. if the company has fixed costs of $269,500, how many units of each model must the company sell in order to break even?
1 answer:
The first step you need to do to solve this problem is to calculate the contribution margin per unit for each model:
Model a12 b22 c124
Sales Price per unit 50 100 400
Less: Variable Cost per unit 35 70 300
Contribution Margin per unit 15 30 100
The next step is to calculate the weighted-average contribution margin per unit for the sales mix using the following formula:
Model a12 CM per Unit ×
Model a12 Sales Mix Percentage<span>
+ Model b22 CM per Unit × Model b22 Sales Mix Percentage
+ Model c124 CM per Unit × Model c124 Sales Mix Percentage
<span>= Weighted Average Unit Contribution Margin (WACM)</span></span>
Contribution Margin per unit 15 30 100
X Sales Mix Percentage 60% 15% 25%
WACM 9 4.5 25
Weighted Average Unit Contribution Margin (sum) 38.5
The next step is to find the break-even point using the WACM.
<span> <span><span> <span> Total Fixed Cost </span> <span> $269,500 </span> </span> <span> <span> ÷ Weighted Average CM per Unit </span> <span> $38.50 </span> </span> <span> <span> Break-even Point in Units of Sales Mix </span> <span> 7,000 </span> </span> </span></span>
The next step is to calculate the number of units of each model at break-even point
<span> <span><span> <span> Model </span> <span> a12 </span> <span> b22 </span> <span> c124 </span> </span> <span> <span> Sales Mix Ratio </span> <span> 60% </span> <span> 15% </span> <span> 25% </span> </span> <span> <span> × Total Break-even Units </span> <span> 7,000 </span> <span> 7,000 </span> <span> 7,000 </span> </span> <span> <span> Product Units at Break-even Point </span> <span> 4,200 </span> <span> 1,050 </span> <span> 1,750 </span> </span> </span></span><span> </span>
You might be interested in
Answer:
Ans. The best estimate of the current intrinsic stock price is $36.51
Explanation:
Hi, first, we have to determine the cash flows for year 1 and 2 (when the stock grows at 25%) and then, the terminal value (using the constant growth rate of 6%). Then we have to bring to present value all the cash flows (terminal value included) and since the terminal value is an amount of money expressed in dollars of year 2, we have to bring it to present value, discounted at the WACC.
Normally, we need to use the rate of return of the equity but in this case this is not possible due to the lack of information. What we can do is to find the value of the company´s equity, which means that If we bring to present value tha cash flows of year 1 and 2 and the terminal value (using thte WACC as a discount rate) and add the short term invesments and substract the debt of the company, we can find the equity´s value and divide it by the outstanding shares, therefore obtaining a good aproximation to the intrinsic value of the stock. It all goes like this.
Note. Notice that 1.75 millions were the last cash flow so we need to find the cash flow for year 1 (CF1)
Where (PV) means present value.
Now, let´s do the following operation
Then, the equity´s value is $36.51 millions.
Now, the intrinsic value of the stock is the value of its equity divided by the number of outstanding shares.
So, the intrinsic value of Huxley Building Supplies' is $36.51
Best of luck.