Quantity discount break-even units · Calculation guide

Maintain the original total contribution after a uniform discount on all units.

Calculation guide

Variable cost per unit stays fixed and discounted unit contribution must be positive.

Minimum discounted units = round up(Original sales units × (Original unit price − Variable unit cost) / (Original unit price × (1 − Price discount / 100) − Variable unit cost)). Extra units required = Minimum discounted units − Original sales units

Inputs

Original unit price

Example entry 50 (in the selected currency).

Price discount

Example entry 10 %. Allowed range 0 to 100.

Variable unit cost

Example entry 30 (in the selected currency).

Original sales units

Example entry 100. Use whole numbers.

Worked example

InputValue
Original unit price50
Price discount10%
Variable unit cost30
Original sales units100
ResultValue
Minimum discounted units134
Extra units required34

Calculation steps

Minimum discounted units = round up(((Original sales units × (Original unit price − Variable unit cost)) ÷ ((Original unit price × (1 − (Price discount ÷ 100))) − Variable unit cost)))

round up(((100 × (50 − 30)) ÷ ((50 × (1 − (10 ÷ 100))) − 30))) = 134

Extra units required = (Minimum discounted units − Original sales units)

(134 − 100) = 34

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Original unit price5055Minimum discounted units134129
Price discount10%11%Minimum discounted units134138
Variable unit cost3033Minimum discounted units134142
Original sales units100110Minimum discounted units134147
Quantity discount break-even units →

Sources