How to Prepare a Cost-Volume-Profit Analysis - dummies

# How to Prepare a Cost-Volume-Profit Analysis

Contribution margin indicates how sales affects profitability. Cost-volume-profit analysis helps you understand different ways to meet your net income goals. When running a business, a decision-maker or managerial accountant needs to consider how four different factors affect net income:

• Sales price

• Sales volume

• Variable cost

• Fixed cost

The graphs provide a helpful way to visualize the relationship among cost, volume, and profit. However, when solving problems, you’ll find that plugging numbers into formulas is much quicker and easier.

## Draft a cost-volume-profit graph

Pemulis Basketballs sells basketballs for \$15 each. The variable cost per unit of the basketballs is \$6. Pemulis had total fixed costs of \$300 per year.

Fixed costs are represented by a horizontal line because no matter the sales volume, fixed costs stay the same. Total variable costs are a diagonal line, starting at the origin (the point in the lower-left corner of the graph where there are zero sales).

Total costs (the sum of total variable costs and total fixed costs) are a diagonal line starting at the \$300 mark because when the company makes and sells zero units, total costs equal the fixed costs of \$300. Total costs then increase with volume. Finally, total sales forms a diagonal line starting at the origin and increasing with sales volume.

The figure shows when the company will earn net income or incur a loss. When the sales curve exceeds total costs, the company earns net income (represented by the shaded right side of the X). However, if total sales is too low to exceed total costs, then the company incurs a net loss (the shaded left side of the X).

The higher the sales volume — that is, the more sales volume moves to the right of the graph — the higher the company’s net income.

Dropping numbers into the chart shows exactly how much income can be earned at different sales levels. Assuming Pemulis has a sales price of \$15 per unit, a variable cost per unit of \$6, and total fixed costs of \$300, what happens if Pemulis sells 60 basketballs?

Total sales come to \$900 (60 units x \$15). Total variable costs multiply to \$360 (60 units x \$6). Add these total variable costs to total fixed costs of \$300 to get total costs of \$660.

Total sales (\$900) sits on the Total sales line. Total costs (\$660) sits on the Total cost line. The difference between these amounts (\$240) represents the net income from selling 60 units.

## Try out the total contribution margin formula

The following formula, based on total contribution margin, follows the same structure as the contribution margin income statement.

Net income = Total contribution margin – Fixed costs

Assume that Pemulis Basketballs sells 60 units for \$15 each for total sales of \$900. The variable cost of each unit is \$6 (so total variable costs come to \$6 x 60, or \$360), and total fixed costs are \$300. Using the contribution margin approach, you can find the net income in two easy steps.

1. Calculate total contribution margin.

Use the formula to compute total contribution margin, subtracting total variable costs from total sales:

Total contribution margin = Total sales – Total variable costs = (60 x \$15) – (60 x \$6) = \$540

This total contribution margin figure indicates that selling 60 units increases net income by \$540.

2. To calculate net income, subtract the fixed costs from the total contribution margin.

Just plug in the numbers from Step 1:

Net income = Total contribution margin – Fixed costs = \$540 – \$300 = \$240

Subtracting fixed costs of \$300 from total contribution margin of \$540 gives you net income of \$240.

## The contribution margin per unit formula

If you know the contribution margin per unit, the following approach lets you use that information to compute net income. Here’s the basic formula equating net income with contribution margin per unit:

Net income = (Sales volume x Contribution margin per unit) –Fixed costs

Say Pemulis Basketballs now wants to use this formula. It can simply plug in the numbers — 60 units sold for \$15 each, variable cost of \$6 per unit, fixed costs of \$300 — and solve. First compute the contribution margin per unit:

Contribution margin per unit = Sales price per unit – Variable costs per unit = \$15 – \$6 = \$9

Next, plug contribution margin per unit into the net income formula to figure out net income:

Net income = (Sales volume x Contribution margin per unit) –Fixed costs = (60 x \$9) – \$300 = \$240

## The contribution margin ratio formula

If you want to estimate net income but don’t know total contribution margin and can’t find out the contribution margin per unit, you can use the contribution margin ratio to compute net income.

You can compute contribution margin ratio by dividing total contribution margin by total sales. So if your contribution margin is 540 and your sales is 900, your contribution margin ratio is 60 percent:

This means that 60 cents of every sales dollar directly increases net income. After you know the contribution margin ratio, you’re ready for the net income formula:

Net income = (Sales x Contribution margin ratio) – Fixed costs

To calculate net income for the earlier example company, plug the contribution margin ratio of 60 percent into the formula:

Net income = (Sales x Contribution margin ratio) –Fixed costs = (900 x 60%) – \$300 = \$240