Required Sales for Target Profit Calculator

Required Sales for Target Profit Calculator

Emerging AI Skill PRO

Enter Calculation

Results

Required Sales
2,400,000
sales revenue needed to reach the target profit
Contribution margin ratio 50%
Formula (Target Profit + Fixed Cost) / (1 - Variable Cost Ratio)

Formula

Required Sales=Target Profit+Fixed Cost1−Variable Cost Ratio (%)100\text{Required Sales} = \dfrac{\text{Target Profit} + \text{Fixed Cost}}{1 - \dfrac{\text{Variable Cost Ratio (\%)}}{100}}

Example

Required Sales=1000000+2000001−50100=2,400,000\text{Required Sales} = \dfrac{1000000 + 200000}{1 - \dfrac{50}{100}} = 2{,}400{,}000
Usage stats

Advertisement

Report an error on this page

What this calculator does

This tool tells you how much sales revenue (turnover) your business needs to generate in order to earn a specific target profit. It is based on cost-volume-profit (CVP) analysis, the same framework used for break-even calculations, but extended so the result covers not just your costs but also a profit you choose. It works with any currency — just enter your figures in the same units.

How to use it

Enter three values: the Target Profit you want to earn, the Variable Cost Ratio (variable costs expressed as a percentage of sales), and your total Fixed Cost. The calculator returns the Required Sales, rounded to the nearest whole currency unit.

Stacked bar dividing required sales into variable cost, fixed cost, and target profit
Each dollar of sales splits into variable cost, with the remaining contribution covering fixed cost and profit.

The formula explained

Profit equals Sales minus variable costs minus fixed costs. Variable costs scale with sales, so they equal Sales × v, where v is the variable cost ratio as a fraction. Setting profit equal to your target gives:

$$\text{Target Profit} = \text{Sales} \times (1 - v) - \text{Fixed Cost}$$

Solving for Sales: $$\text{Required Sales} = \dfrac{\text{Target Profit} + \text{Fixed Cost}}{1 - v}$$ The term \(1 - v\) is the contribution margin ratio — the share of every sales dollar available to cover fixed costs and profit.

Advertisement

Worked example

Suppose you want a profit of 1,000,000, your variable cost ratio is 50% (so \(v = 0.50\) and the contribution margin ratio is 0.50), and fixed costs are 200,000. Then $$\text{Required Sales} = \frac{1{,}000{,}000 + 200{,}000}{0.50} = \frac{1{,}200{,}000}{0.50} = 2{,}400{,}000$$ Check: at 2,400,000 sales, variable costs are 1,200,000, fixed costs 200,000, leaving exactly 1,000,000 profit.

Cost-volume-profit chart showing revenue and total cost lines crossing at break-even with profit region above
Required sales is where revenue covers fixed costs, variable costs, and the target profit.

Required Sales Under Different Cost Ratios and Profit Targets

The table holds fixed costs constant at 200,000 (any currency) and applies \(\text{Required Sales} = \dfrac{\text{Target Profit} + \text{Fixed Cost}}{1 - v}\), where \(v\) is the variable cost ratio as a decimal.

Variable cost ratio Contribution margin ratio Target profit 0 (break-even) Target profit 500,000 Target profit 1,000,000
40% 60% 333,333 1,166,667 2,000,000
50% 50% 400,000 1,400,000 2,400,000
60% 40% 500,000 1,750,000 3,000,000
70% 30% 666,667 2,333,333 4,000,000
80% 20% 1,000,000 3,500,000 6,000,000

Required sales rise nonlinearly as the variable cost ratio approaches 100%, because the denominator \(1 - v\) shrinks toward zero. With a 500,000 target, moving from 40% to 50% adds about 233,333 in required sales, while moving from 70% to 80% adds about 1,166,667. At a ratio of 100% the contribution margin is zero, so no sales level can cover fixed costs or reach a profit.

Key Terms in CVP Analysis

  • Target profit: the operating profit you want to earn over a period, in currency units. It is usually treated as pre-tax.
  • Variable cost ratio: variable costs as a percentage of sales revenue (variable costs ÷ sales × 100).
  • Contribution margin ratio: the share of each unit of sales left after variable costs to cover fixed costs and profit. Contribution margin ratio = 1 − variable cost ratio.
  • Fixed costs: costs that stay the same in total over the relevant range of activity, such as rent or salaried staff.
  • Variable costs: costs that change roughly in proportion to sales or volume, such as materials or sales commissions.
  • Break-even sales: the sales level at which profit is zero, equal to fixed costs ÷ contribution margin ratio.
  • Required sales: the sales revenue needed to reach a stated target profit, equal to (target profit + fixed costs) ÷ contribution margin ratio. It equals break-even sales when the target profit is zero.
Advertisement

Interpreting Your Required Sales Figure

The result is the revenue level at which total contribution margin equals fixed costs plus target profit. In symbols, \((1 - v) \times \text{Sales} = \text{Fixed Cost} + \text{Target Profit}\). At that sales level, the business has covered its variable costs and fixed costs and has exactly the target profit left over.

  • Constant variable cost ratio: the model assumes variable costs stay the same percentage of sales at every sales level. Volume discounts or price changes would alter the ratio.
  • Fixed costs unchanged: fixed costs are assumed to stay constant across the relevant range. A large increase in sales may require added capacity and so raise fixed costs.
  • Single product or constant mix: the model assumes one product, or a sales mix that stays the same, so that one ratio describes all sales.
  • Pre-tax result: the figure reflects pre-tax profit unless the target profit entered has already been grossed up for taxes.
  • Effect of the cost ratio: a lower variable cost ratio means a larger contribution margin per unit of sales and therefore a lower required sales figure for the same fixed costs and target profit. A higher ratio has the opposite effect.

FAQ

What is the variable cost ratio? It is your variable costs divided by sales, expressed as a percentage. If variable costs are typically 60 cents per dollar of sales, the ratio is 60%.

Why does a 100% ratio give an error? If variable costs equal sales, the contribution margin is zero, so no amount of sales can ever cover fixed costs or generate profit — the target is mathematically unachievable.

Can I plan for break-even instead? Yes — set Target Profit to 0 and the result is your break-even sales.

Last updated:

Most popular in Financial

View all Financial calculators