What is the break-even formula this template uses?

Break-even quantity equals fixed costs divided by contribution margin per unit, where contribution margin is selling price minus variable cost per unit. If fixed costs are 20,000 dollars, price is 15 dollars, and variable cost is 9 dollars, the margin is 6 dollars and break-even is 3,334 units. Every unit past that point contributes 6 dollars of profit. Round up, since you cannot break even on a fraction of a part.

Which costs count as fixed versus variable?

Fixed costs do not change with volume: dedicated tooling, fixtures, one-time programming, and setup for the run. Variable costs scale per part: material, per-piece machine time, direct labor, consumables, and packaging. Overhead is trickier; allocate the portion tied to this job as fixed. A common mistake is treating setup as variable, which understates break-even. If it happens once per batch regardless of quantity, it is fixed for that batch.

How do I decide if a tooling investment is justified?

Compare break-even quantity to the customer's expected order volume plus reasonable reorders. If a 40,000 dollar mold gives a 5 dollar contribution margin, you need 8,000 parts just to recover it. If the forecast is 12,000 units, you clear tooling and net 20,000 dollars. If it is only 6,000, walk away or ask for an upfront tooling charge. Always test a pessimistic volume, not just the optimistic quote.

How does contribution margin differ from gross profit?

Contribution margin is price minus variable cost only, ignoring fixed costs, and it tells you how much each unit contributes to covering fixed cost and profit. Gross profit subtracts all cost of goods sold including allocated fixed overhead. A part with a 6 dollar contribution margin might show only 2 dollars of gross profit once tooling and overhead are absorbed. Use contribution margin for accept or reject decisions on incremental volume.

How do I use break-even to test pricing sensitivity?

Drop the price and watch break-even climb. At 15 dollars with a 6 dollar margin, break-even is 3,334 units on 20,000 dollars fixed. Cut price to 13 dollars and margin falls to 4 dollars, pushing break-even to 5,000 units, a 50 percent jump for a 13 percent price cut. This shows why small price concessions on thin-margin work are costly. Run three price points before conceding anything in negotiation.

Does break-even account for capacity or lead time?

No. Break-even is purely cost versus revenue and assumes you can produce the volume. Check separately whether break-even quantity fits your available machine hours and the customer's delivery window. If break-even is 8,000 units but your cell only runs 2,000 per week and the order is due in three weeks, the math clears but the schedule does not. Treat break-even as a financial gate, then run a capacity check.

Manufacturing Cost and Quoting

Break-Even Analysis Spreadsheet Template

Find the production volume at which total revenue equals total cost, separating fixed costs from variable costs per unit.

Overview

This template finds the production volume where total revenue equals total cost by separating fixed costs from variable cost per unit. It is built for estimators, plant managers, and owners deciding whether to accept a job, justify tooling, or set a price. Guessing the break-even point is dangerous because a job that looks profitable at planned volume can lose money if the order runs short. Working the math on a spreadsheet shows the exact quantity where the job starts making money.

You enter total fixed costs (tooling, setup, allocated overhead), variable cost per unit from your cost build-up, and selling price. The sheet computes contribution margin per unit (price minus variable cost) and divides fixed cost by that margin to get break-even quantity. The scenario table then shows profit at several volumes so you can see how sensitive the job is. A thin contribution margin means small volume shortfalls swing the job from profit to loss quickly.

In real use, run this before committing a quote or approving a 40,000 dollar mold. Enter a realistic price and check whether the customer's forecast clears break-even with margin to spare. Change the selling price to test how much room you have to negotiate. Compare a low-tooling, high-variable option against a high-tooling, low-variable one to pick the cheaper path at expected volume. Pair it with the Break-Even Quantity Calculator for quick single-point checks.

What this template includes

Fixed cost summary (tooling, setup, overhead)
Variable cost per unit input
Selling price per unit
Break-even quantity calculation
Contribution margin per unit
Profit at multiple volume scenarios
Simple chart-ready data table

Suggested use case

Use this to decide whether to take a new job, justify a tooling investment, or test pricing sensitivity before committing to a quote.

How to use it

Enter total fixed costs for the job or product.
Enter variable cost per unit from your cost build-up.
Set a selling price per unit.
Break-even quantity calculates automatically.
Run the scenario table to see profit at different volumes.

Frequently Asked Questions

What is the break-even formula this template uses?: Break-even quantity equals fixed costs divided by contribution margin per unit, where contribution margin is selling price minus variable cost per unit. If fixed costs are 20,000 dollars, price is 15 dollars, and variable cost is 9 dollars, the margin is 6 dollars and break-even is 3,334 units. Every unit past that point contributes 6 dollars of profit. Round up, since you cannot break even on a fraction of a part.
Which costs count as fixed versus variable?: Fixed costs do not change with volume: dedicated tooling, fixtures, one-time programming, and setup for the run. Variable costs scale per part: material, per-piece machine time, direct labor, consumables, and packaging. Overhead is trickier; allocate the portion tied to this job as fixed. A common mistake is treating setup as variable, which understates break-even. If it happens once per batch regardless of quantity, it is fixed for that batch.
How do I decide if a tooling investment is justified?: Compare break-even quantity to the customer's expected order volume plus reasonable reorders. If a 40,000 dollar mold gives a 5 dollar contribution margin, you need 8,000 parts just to recover it. If the forecast is 12,000 units, you clear tooling and net 20,000 dollars. If it is only 6,000, walk away or ask for an upfront tooling charge. Always test a pessimistic volume, not just the optimistic quote.
How does contribution margin differ from gross profit?: Contribution margin is price minus variable cost only, ignoring fixed costs, and it tells you how much each unit contributes to covering fixed cost and profit. Gross profit subtracts all cost of goods sold including allocated fixed overhead. A part with a 6 dollar contribution margin might show only 2 dollars of gross profit once tooling and overhead are absorbed. Use contribution margin for accept or reject decisions on incremental volume.
How do I use break-even to test pricing sensitivity?: Drop the price and watch break-even climb. At 15 dollars with a 6 dollar margin, break-even is 3,334 units on 20,000 dollars fixed. Cut price to 13 dollars and margin falls to 4 dollars, pushing break-even to 5,000 units, a 50 percent jump for a 13 percent price cut. This shows why small price concessions on thin-margin work are costly. Run three price points before conceding anything in negotiation.
Does break-even account for capacity or lead time?: No. Break-even is purely cost versus revenue and assumes you can produce the volume. Check separately whether break-even quantity fits your available machine hours and the customer's delivery window. If break-even is 8,000 units but your cell only runs 2,000 per week and the order is due in three weeks, the math clears but the schedule does not. Treat break-even as a financial gate, then run a capacity check.