Cost-Volume-Profit (CVP) Analysis Explained

Cost-volume-profit analysis is the model that links your costs, your sales volume and your profit, and it answers the questions managers ask most often: how much must we sell to break even, what happens to profit if price, cost or volume moves, and how risky is our cost structure? Unlike a budget, which gives one forecast, CVP is a set of relationships you can flex. This guide explains the model and its assumptions, builds one company's CVP analysis with checked arithmetic, runs price, cost, volume and combined scenarios, shows how a choice between fixed and variable costs changes the risk, and lists the limits of the method. It belongs to unit economics and budgeting and forecasting, builds on the break-even point formula and break-even analysis for a new product, and leads to operating leverage and activity-based costing.

The model

CVP analysis rests on a simple profit equation:

Profit = (Price - Variable cost per unit) × Units - Fixed costs

Everything else follows from this and its rearrangements: break-even units, units for a target profit, margin of safety and operating leverage.

Assumptions

A worked model

A hypothetical company: price $50, variable cost $30, fixed costs $200,000 a year.

• Contribution per unit = 50 - 30 = $20
• Contribution margin ratio = 20 / 50 = 40%
• Break-even units = 200,000 / 20 = 10,000 units
• Break-even revenue = 10,000 × 50 = $500,000

At expected sales of 15,000 units:

• Total contribution = 15,000 × 20 = $300,000
• Profit = 300,000 - 200,000 = $100,000
• Margin of safety = (15,000 - 10,000) / 15,000 = 33.3%
• Degree of operating leverage = 300,000 / 100,000 = 3.0

Target profit

To earn $150,000: (200,000 + 150,000) / 20 = 17,500 units.

To earn $100,000 after tax at a 25 percent rate: pre-tax profit needed = 100,000 / 0.75 = 133,333; units = (200,000 + 133,333) / 20 = 16,667 units.

Scenarios

Change one input at a time from the base case (15,000 units, profit $100,000):

Check: 200,000 / 22.50 = 8,888.9; 15,000 × 22.50 = 337,500, less 200,000 = 137,500. 200,000 / 17 = 11,764.7; 15,000 × 17 = 255,000, less 200,000 = 55,000. 240,000 / 20 = 12,000; 300,000 - 240,000 = 60,000. 12,000 × 20 = 240,000, less 200,000 = 40,000.

A 5 percent price rise adds 37.5 percent to profit. A 10 percent rise in variable cost cuts profit by 45 percent. A 20 percent volume decline cuts profit by 60 percent. The combination of a variable cost rise and a volume decline is worse: at 12,000 units and $17 of contribution, profit is 12,000 × 17 - 200,000 = 204,000 - 200,000 = $4,000, almost nothing. Two moderate adverse changes together nearly eliminate profit. That is the main reason to run combined scenarios and not just single-factor tests.

Choosing a cost structure

CVP is useful for comparing alternative cost structures. Suppose the company can automate part of its production. This raises fixed costs to $320,000 and lowers variable cost to $22, so contribution rises to $28 per unit.

Check: 320,000 / 28 = 11,428.6. Automated profit at 12,000: 12,000 × 28 = 336,000 - 320,000 = 16,000. At 15,000: 420,000 - 320,000 = 100,000. At 20,000: 560,000 - 320,000 = 240,000.

The two structures earn the same profit at 15,000 units. The indifference point can be found by setting the profit equations equal: 20Q - 200,000 = 28Q - 320,000, so 8Q = 120,000 and Q = 15,000. Below that volume, the current structure is better; above it, the automated one is better. If the company is confident of selling more than 15,000 units, automation pays. If demand is uncertain, the higher fixed cost brings more risk: the break-even is higher and the downside is steeper. This is the trade-off captured in operating leverage.

Multi-product CVP

With several products, use the weighted average contribution per unit, or the weighted contribution margin ratio, based on the expected sales mix. Run scenarios for different mixes. For example, if 70 percent of sales shifts into a product with half the contribution, the weighted contribution falls, and break-even rises, even if total units are unchanged. See product mix analysis.

Adding time and cash

CVP is a static model. To use it for planning, add time: seasonal volumes, a ramp for new products, and timing of cash. Extend it into a monthly model linked to the budget. A CVP summary is a good front page to a budget, showing break-even, margin of safety and sensitivities. See budgeting and forecasting.

Step costs and capacity

When volume approaches capacity, fixed costs step up. Suppose the company can produce 18,000 units with current resources, and each additional block of 6,000 units needs $60,000 more fixed cost. At 20,000 units, fixed costs become $260,000, and profit is 20,000 × 20 - 260,000 = $140,000, not the $200,000 the linear model predicts. Always check that the volume you are modeling lies within the relevant range.

Using CVP in the organization

Link to supply chain

CVP assumes units produced equal units sold. In real businesses the gap between the two is inventory. Over-production inflates reported profit on an absorption basis and consumes cash, and under-production loses sales. Linking CVP to demand and inventory plans keeps the model honest. See demand planning and inventory optimization.

Common mistakes

• Ignoring the relevant range.
• Treating the model as a forecast rather than a set of relationships.
• Running single-factor tests only.
• Using a stale mix.
• Misclassifying semi-variable costs.
• Forgetting taxes and cash timing.
• Using the model to justify price cuts without checking the volume needed.

Presenting CVP results to decision-makers

Executives do not need the algebra. Give them a one-page summary with five numbers: break-even volume, expected volume, margin of safety, operating leverage and the profit under a plausible downside. Add a table of the three largest sensitivities, ranked by their effect on profit, and one sentence on what would have to be true for the downside to occur. In the example company, the ranking by profit effect is variable cost (down $45,000 for a 10 percent rise), volume (down $60,000 for a 20 percent fall) and fixed costs (down $40,000 for a 20 percent rise). The ranking depends on how big a change you think is plausible, so state the assumed range of each.

Linking CVP to the budget

The most useful CVP model is the one that sits behind the annual budget. Build the budget from the same inputs, so that when price, volume or cost assumptions change during the year, the break-even and the forecast change with them. Review the CVP page at each monthly forecast. If actual contribution per unit falls below plan for two consecutive months, update the model, find the cause, and decide whether to respond with price, cost or mix actions. A model used only at budget time is soon out of date.

FAQs

What is cost-volume-profit analysis?

A model of how costs, sales volume and prices affect profit, used to find break-even, target profit volumes and margin of safety, and to test scenarios.

What are the assumptions of CVP analysis?

Linear revenue and costs, a relevant range of activity, a constant sales mix, production equal to sales, and costs that can be split into fixed and variable.

How is CVP different from break-even analysis?

Break-even analysis is one result of CVP. CVP also covers target profit, margin of safety, operating leverage and scenario testing.

How do I do CVP analysis in Excel?

Set up inputs for price, variable cost and fixed cost, compute contribution and profit by formula, and use a data table or scenario columns to vary one or two inputs.

What are the limitations of CVP?

It simplifies behavior, assumes a constant mix and linear costs, and ignores timing, taxes and cash unless you extend it.