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.
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
| Input | Value |
|---|---|
| Period fixed costs | 10,000 |
| Unit selling price A | 40 |
| Variable unit cost A | 25 |
| Units A per bundle | 2 |
| Unit selling price B | 80 |
| Variable unit cost B | 50 |
| Units B per bundle | 1 |
| Result | Value |
|---|---|
| Minimum complete bundles | 167 |
| Units A to sell | 334 |
| Units B to sell | 167 |
| Sales at minimum whole-bundle volume | 26,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Period fixed costs | 10,000 | 11,000 | Minimum complete bundles | 167 | 184 |
| Unit selling price A | 40 | 44 | Minimum complete bundles | 167 | 148 |
| Variable unit cost A | 25 | 28 | Minimum complete bundles | 167 | 186 |
| Units A per bundle | 2 | 3 | Minimum complete bundles | 167 | 134 |
| Unit selling price B | 80 | 88 | Minimum complete bundles | 167 | 148 |
| Variable unit cost B | 50 | 55 | Minimum complete bundles | 167 | 182 |
| Units B per bundle | 1 | 2 | Minimum complete bundles | 167 | 112 |
