Target Profit Planning: How Many Units Must You Sell?

· omnicalc.info

Break-even is a starting point, not necessarily a business goal. To plan for a profit above zero, add that profit target to fixed costs and divide by contribution per unit. This turns a desired result into a sales requirement that can be checked against capacity and demand.

Build the target from four inputs

You need fixed costs for a selected period, target profit for that period, selling price per unit and variable cost per unit. Contribution is selling price minus variable cost. Required units = (fixed costs + target profit) ÷ contribution, rounded up.

Suppose fixed costs are $1,000, target profit is $500, price is $30 and variable cost is $18. Contribution is $12. The required quantity is ($1,000 + $500) ÷ $12 = 125 units, generating $3,750 revenue.

Reconcile the result

At 125 units, variable costs total $2,250. Subtracting those costs and $1,000 fixed costs from $3,750 revenue leaves exactly $500. This reverse check is a useful way to catch a mistaken per-unit input or a missing cost.

The target profit has the same scope as your cost model. If taxes, interest or overhead are omitted, the output is not a target for after-tax accounting net income.

Test the effect of a lower price

If the selling price drops to $28 while variable cost stays $18, contribution falls to $10. The same $500 target then needs 150 units. Revenue is $4,200, but more revenue is required because each unit contributes less.

If the store can supply only 140 units, the revised price does not achieve the target: 140 × $10 − $1,000 = $400. A sales target that exceeds capacity needs a different plan, not a more optimistic spreadsheet.

Add a margin-of-safety view

At the original $30 price, break-even is 84 whole units because $1,000 ÷ $12 = 83.33. A 125-unit plan therefore sits 41 whole units above that operational break-even quantity.

For the conventional continuous calculation, the safety margin is (125 − 83.33) ÷ 125, approximately 33.33%. Be clear about whether you are using theoretical break-even or rounded whole units when reporting a percentage.

Check your plan

Use the Target Profit Units Calculator and compare it with the Break-Even Units Calculator. Repeat with conservative prices and realistic variable costs before treating the output as a committed sales plan.

Related reading

Continue with Discounts and Profit: How Much Extra Volume Makes a Sale Worthwhile? for another part of the calculation.