Sales mix break-even · Calculation guide

Work out how many two-product bundles cover fixed costs.

Calculation guide

Each bundle has a fixed number of A and B units. Prices and variable costs are per unit; fixed costs cover the entire period. Require positive total contribution per bundle; round up to whole bundles.

bundles = ceil(fixed/((price_a-cost_a)*units_a+(price_b-cost_b)*units_b)); quantity_a = bundles*units_a; quantity_b = bundles*units_b; revenue = bundles*(price_a*units_a+price_b*units_b)

Inputs

Period fixed costs

Example entry 10000 (in the selected currency).

Unit selling price A

Example entry 40 (in the selected currency).

Variable unit cost A

Example entry 25 (in the selected currency).

Units A per bundle

Example entry 2. Minimum 1.0. Use whole numbers.

Unit selling price B

Example entry 80 (in the selected currency).

Variable unit cost B

Example entry 50 (in the selected currency).

Units B per bundle

Example entry 1. Minimum 1.0. Use whole numbers.

Worked example

InputValue
Period fixed costs10,000
Unit selling price A40
Variable unit cost A25
Units A per bundle2
Unit selling price B80
Variable unit cost B50
Units B per bundle1
ResultValue
Minimum complete bundles167
Units A to sell334
Units B to sell167
Sales at minimum whole-bundle volume26,720

Calculation steps

Minimum complete bundles = round up((Period fixed costs ÷ (((Unit selling price A − Variable unit cost A) × Units A per bundle) + ((Unit selling price B − Variable unit cost B) × Units B per bundle))))

round up((10,000 ÷ (((40 − 25) × 2) + ((80 − 50) × 1)))) = 167

Units A to sell = (Minimum complete bundles × Units A per bundle)

(167 × 2) = 334

Units B to sell = (Minimum complete bundles × Units B per bundle)

(167 × 1) = 167

Sales at minimum whole-bundle volume = (Minimum complete bundles × ((Unit selling price A × Units A per bundle) + (Unit selling price B × Units B per bundle)))

(167 × ((40 × 2) + (80 × 1))) = 26,720

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Period fixed costs10,00011,000Minimum complete bundles167184
Unit selling price A4044Minimum complete bundles167148
Variable unit cost A2528Minimum complete bundles167186
Units A per bundle23Minimum complete bundles167134
Unit selling price B8088Minimum complete bundles167148
Variable unit cost B5055Minimum complete bundles167182
Units B per bundle12Minimum complete bundles167112
Sales mix break-even →

Sources