Weighted contribution per bottleneck hour · Calculation guide

Weight the mix by planned units, sum contributions and divide by total bottleneck hours used.

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 unitsUnit contributionBottleneck hours per unit
100201
50201
ResultValue
Mix contribution per bottleneck hour20
Total bottleneck hours150

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Planned product units (row 1)100110Total bottleneck hours150160
Unit contribution (row 1)2022Mix contribution per bottleneck hour2021.333333
Bottleneck hours per unit (row 1)12Mix contribution per bottleneck hour2012
Weighted contribution per bottleneck hour →

Sources