← All resources Free financial performance resource

Contribution Margin
Model

See what each revenue stream actually contributes after the direct labor and variable costs required to deliver it. A practical Excel model for contribution margin, break-even analysis and directional scenario planning.

Download the Free Excel Model Free · No email required
Contribution Margin Summary
CONTRIBUTION MARGIN SUMMARY
Revenue$
Direct Labor$
Variable Costs$
Contribution MarginCM
Margin %
CM / Unit
Break-even Units
SummaryInputsRevenueHeadcountVariable CostsScenario Analysis
See the economics clearly

Revenue tells you how much you sold. Contribution margin tells you what the revenue leaves behind.

Top-line growth can look healthy while the economics underneath it deteriorate. Pricing, labor productivity, service mix and variable costs can all change what a dollar of revenue is actually worth.

Contribution margin isolates the revenue from the direct labor and other variable costs required to deliver it.

That remaining contribution is what is available to cover fixed overhead, investment and profit.

What's included

One model. The supporting detail to understand what drives margin.

01

Revenue Build

Build revenue streams using volume, rate per unit and other revenue, with revenue per unit calculated for context.

02

Headcount & Fully Burdened Labor

Model salary, payroll taxes and monthly benefits. Classify each role as Direct or Indirect / Admin so only direct labor flows into contribution margin.

03

Variable Costs

Model non-labor direct costs using Per Unit, % of Revenue or Manual Amount drivers.

04

Contribution Margin Summary

See revenue, direct labor, other variable costs, contribution margin, margin percentage and contribution margin per unit.

05

Break-even Analysis

Use fixed operating costs and contribution margin per unit to calculate break-even units, break-even revenue and margin of safety.

06

Scenario Analysis

Test directional changes in volume, pricing, direct labor productivity and variable cost inflation across downside, base and upside cases.

A useful rule of thumb

If the revenue disappeared, which costs would disappear with it?

Those costs are the strongest candidates for direct or variable costs.

The goal is not perfect accounting allocation. It is a clear operating view of the economics of delivering the revenue.

Typically includeDirect delivery laborPayroll taxes & benefits on direct laborSupplies & consumablesVariable travel / delivery costsTransaction and other volume-driven costs
Typically excludeExecutive / corporate salariesGeneral administrative headcountRent & fixed occupancyFixed software / corporate infrastructureDepreciation, interest & taxes
Operator perspective

Growth is not the same as
economic progress.

A business can add customers, volume and revenue while creating less contribution with each incremental unit.

Contribution margin makes the tradeoffs visible: pricing versus volume, staffing versus productivity, customer mix versus delivery cost.

Once those economics are visible, management can decide whether the answer is pricing, productivity, mix, operating design or something more fundamental.

How to use it

Build the economics from the operating drivers up.

Start with the assumptions.Define the analysis period, volume unit, payroll tax rate, direct labor allocation and fixed operating costs used for break-even.
Build revenue by stream.Use volume, rate and other revenue so the model reflects how the business actually earns revenue.
Separate direct from indirect labor.Only roles classified as Direct flow into contribution margin. Indirect / Admin labor remains visible for context.
Model variable costs by driver.Use per-unit, percent-of-revenue or manual assumptions depending on how each cost behaves.
Challenge the economics.Use scenario analysis to test volume, pricing, labor productivity and variable cost inflation rather than relying on one static case.
Frequently asked questions

Contribution margin, explained.

What is contribution margin?+

Contribution margin is revenue less the direct and variable costs required to deliver that revenue. The remaining contribution is available to cover fixed overhead, investment and profit.

How do you calculate contribution margin?+

Subtract direct labor and other variable costs from revenue. Contribution margin percentage is contribution margin divided by revenue, and contribution margin per unit is contribution margin divided by volume.

Should direct labor be included in contribution margin?+

When labor is directly required to deliver the revenue, it should generally be included. This model lets you classify headcount as Direct or Indirect / Admin so only direct labor flows into contribution margin.

What costs should be excluded from contribution margin?+

Fixed overhead such as executive and corporate salaries, general administrative headcount, rent, fixed software infrastructure, depreciation, interest and taxes are generally excluded from contribution margin in this model.

What is break-even volume?+

Break-even volume is the number of units required for contribution margin to cover fixed operating costs. The model calculates break-even units and break-even revenue using your contribution margin assumptions.

Can I use this contribution margin model in Google Sheets?+

The model is provided as a macro-enabled Excel workbook. Google Sheets may open many workbook elements, but Excel is recommended to preserve the intended functionality and formatting.

Ready to use it?

See what the revenue actually contributes.

Download the complete model with supporting inputs, revenue, headcount, variable costs, break-even analysis and scenarios.

Download the Free Model Excel · Free · No email required
When the analysis raises harder questions

Knowing where margin is created is the beginning. Deciding what to do with it is the work.

Cadence & Compass helps leadership teams connect pricing, labor productivity, customer mix, operating design and financial performance.