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
| Input | Value |
|---|---|
| Original unit price | 50 |
| Price discount | 10% |
| Variable unit cost | 30 |
| Original sales units | 100 |
| Result | Value |
|---|---|
| Minimum discounted units | 134 |
| Extra units required | 34 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Original unit price | 50 | 55 | Minimum discounted units | 134 | 129 |
| Price discount | 10% | 11% | Minimum discounted units | 134 | 138 |
| Variable unit cost | 30 | 33 | Minimum discounted units | 134 | 142 |
| Original sales units | 100 | 110 | Minimum discounted units | 134 | 147 |
