40 Target Profit Analyis

Minnesota Kayak has a few investors who are interested in getting a return on their investment.  They have talked with your supervisor, and between them all, would like to get $30,000 a month in profit to divide between them. You have been tasked with figuring out how many kayaks need to be sold in order to get the investors their return!

Target profit analysis helps us to know how much in dollar sales a company will need to reach a certain profit point. This is one of the key uses of the CVP analysis. Once the basic data is calculated, it can offer a great deal of insight and help in planning.

Minnesota Kayak Company needs to sell 28 kayaks in our example to break even. The equation method or the formula method can be used with the same result. Remember the formula method is simply a shortened version of the equation method, so both ways should come to the same conclusion.

With the previous information you can then figure out, the dollar sales needed to break even:

28 kayaks x $500 per kayak = $14,000 in sales

What if they now want to show a $30,000 a month profit?

So with that information we now have the following:

With this information, how many kayaks do we need to sell to show a $30,000 profit at the end of the month? It is the same exact formula we used to calculate the break-even point! Remember, we put -0- for the profit in when we were looking to break-even. We simply replace the -0- with $30,000 and now we can calculate how many kayaks we need to sell to meet our profit goal. Pretty neat huh?

Using the equation method:

Profit   =  Unit CM x Q – Fixed Expense
$30,000    =   $275 x Q – $7,700
$30,000 + $7,700    =  $275 x Q
$37,700   =   Q
275

So we now need to sell 138 kayaks to profit $30,000! How much in sales do we need?

138 × $500 each= $69,000 in sales.

How would we get there using the formula method?

So in our kayak case

$\begin{array}{ccc}\text{Unit sales needed}& =& \frac{\$30,000+\$7,\mathrm{700/}}{\$275}\end{array}$

$\begin{array}{ccc}& =& \frac{\$37,\mathrm{700/}}{\$275}\end{array}$

So again, we need 137 kayaks sold to make a $30,000 profit!

137 kayaks × $500 selling price per kayak = $68,500 in sales.

We can now plug in any amount of desired profit and calculate how many units we need to sell! This is amazing information for business owners and managers to have available. But see the importance of good numbers for your fixed and variable costs? Remember from our CVP analysis in early lessons, how much a small difference in costs can affect our profit!