PDA

View Full Version : Cost Volume Profit


michi424
Aug 12, 2009, 11:44 AM
If A and B account for 60% and 40% of total sales, respectively, and variable costs are 60% and 85% respectively, what is the breakeven point (in sales), given fixed costs of $150,000?

Hello. Im stuck with this question. Please help?

Thanks, michelle :)

ArcSine
Aug 12, 2009, 02:08 PM
Breakeven occurs when your Contribution Margin (in dollars) exactly equals your total Fixed Costs; in this case, 150K.

Let A, B, and S represent total sales dollars from Product A, Product B, and total Sales combined, respectively.

From the supplied info we know two things: For one, A = 60% x S, and B = 40% x S.

We also know that A's contribution margin, in dollars, is 40% x A, and B's contribution margin is 15% x B. (Remember that Contribution Margin % is (1 minus Variable Cost %).)

Going back to my first statement, we need to set the total Contribution Margin to equal 150K, or...

(0.40)A + (0.15)B = 150,000

Now recall that in the third line above we expressed both A and B in terms of S; that is, A = (0.60)S, and B = (0.40)S. So let's replace 'A' and 'B' in the above Contribution Margin equation, to get an equation with one variable. The equation becomes...

(0.40)(0.60)S + (0.15)(0.40)S = 150,000

Solve for S, and that'll give you the sales dollars S at which total Contribution Margin is exactly 150K. Important: Check your answer! Make sure that for whatever answer you derive, if the contribution margin on 60% of your answer is 40%, and the CM on 40% of your answer is 15%, then your total contribution margin is indeed 150,000.

ArcSine
Aug 13, 2009, 04:49 AM
Thanks, Rehmanvohra, I do appreciate it. When I looked back on my answer a bit after the fact, it seemed kind of clumsy, and a cleaner exposition came immediately to mind. So I'm glad to hear that the original version "worked" (at least for one reader :))

michi424
Aug 13, 2009, 12:21 PM
Hello ArcSine:

I just wanted to tell you that you are the bomb! :) Nobody could figure this out. You should definitely teach accounting. Excellent explanation. Very tricky question though. Thank thank you soooo much! :)

michi424
Aug 13, 2009, 01:05 PM
Hello ArcSine:

I also forgot to tell you that my answer was $500,000. Is that right?

ArcSine
Aug 13, 2009, 01:40 PM
Always a pleasure... thanks for the kind words.

Let's confirm that $500K of sales puts us at a breakeven point: We know that 60% of our sales (product A) is throwing off a 40% profit margin, so A's profit at this level of sales would be

500,000 x 0.60 x 0.40 = $120,000.

The other 40% of our sales is generating a 15% profit margin, so B's profit at this sales level is

500,000 x 0.40 x 0.15 = $30,000.

So at total sales of $500,000, A and B together are producing a total profit of $150,000. Since that exactly covers our fixed costs, we're definitely at breakeven.

Looks like we can stamp this one "done".

morgaine300
Aug 13, 2009, 08:02 PM
When I looked back on my answer a bit after the fact, it seemed kinda clumsy, and a cleaner exposition came immediately to mind.

Oh... if I had a dollar for every time I thought that...

If I had the time I'd like to sit down and re-write and re-write some explanations, until they all make clear sense, and then just paste them in. I started to put some stickies together for this board of a variety of topics, but have never had time to work on it.