Calculation guide
Include the time needed per unit for the same constrained resource.
Weighted contribution per hour = Σ units × unit contribution / Σ units × hours per unit
Inputs
Planned product units
Example entry 100.
Unit contribution
Example entry 20 (in the selected currency).
Bottleneck hours per unit
Example entry 1.
Worked example
Planned product mix
| Planned product units | Unit contribution | Bottleneck hours per unit |
|---|---|---|
| 100 | 20 | 1 |
| 50 | 20 | 1 |
| Result | Value |
|---|---|
| Mix contribution per bottleneck hour | 20 |
| Total bottleneck hours | 150 |
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 |
|---|---|---|---|---|---|
| Planned product units (row 1) | 100 | 110 | Total bottleneck hours | 150 | 160 |
| Unit contribution (row 1) | 20 | 22 | Mix contribution per bottleneck hour | 20 | 21.333333 |
| Bottleneck hours per unit (row 1) | 1 | 2 | Mix contribution per bottleneck hour | 20 | 12 |
