Skip to content
Omnikalc

Product mix calculator: which products to make when a resource is limited?

Enter the price, variable cost, hours per unit and demand for three products, with the hours available, to rank them and find the mix with the highest contribution.

Updated on
Your inputs

Value out of range

$

Value out of range

$

Value out of range

Value out of range

Value out of range

$

Value out of range

$

Value out of range

Value out of range

Value out of range

$

Value out of range

$

Value out of range

Value out of range

Value out of range

Results

Product 1: units to make

300.0

Product 2: units to make

50.0

Product 3: units to make

400.0

Total contribution

$10,650

Product 1: contribution per scarce hour
$9.00
Product 2: contribution per scarce hour
$6.25
Product 3: contribution per scarce hour
$10.00

This calculator gives estimates for education and planning. It is not investment, tax or legal advice; for decisions about your own situation, talk to a qualified financial professional.

When one resource limits what you can make, the best mix of products is not the one with the highest margin per unit. The product mix calculator takes the hours available and, for three products, the price, the variable cost, the hours needed per unit and the maximum demand, and gives the contribution per scarce hour, the units to make of each and the total contribution.

How the calculation works

  • A scarce resource, such as machine hours, limits how much you can make. Rank the products by contribution margin per hour of that resource, not per unit.
  • The contribution margin is the price minus the variable cost. Divide it by the hours each unit needs to get the contribution per scarce hour.
  • Make the product with the highest contribution per hour first, up to its maximum demand. Then move to the next, until the hours run out.
  • The total contribution is the sum of units × contribution margin. A product may be made only in part, or not at all, when the hours are used up.

Example

There are 1,200 machine hours. Product 1 contributes $18 a unit and needs 2 hours ($9 per hour, demand 300), product 2 contributes $25 and needs 4 hours ($6.25 per hour, demand 200), and product 3 contributes $10 and needs 1 hour ($10 per hour, demand 400). The order is 3, 1, 2. Product 3 takes 400 hours for 400 units, product 1 takes 600 hours for 300 units, and the remaining 200 hours make 50 units of product 2. The total contribution is $10,650.

Why it matters

Choosing products by unit margin can waste the scarcest input. Ranking them by contribution per scarce hour is the simple rule that gives the best use of a limit, and it shows which products to drop or to produce only in part.

Good to know

The calculation assumes a single constraint, fixed prices and costs, and a limit on demand for each product. Fixed costs do not change with the mix, so they are left out. If the resource can be expanded, or if products are linked, as when making one requires another, a fuller model such as linear programming is more appropriate.

The break-even calculator finds the volume that covers costs, the multi-product break-even calculator handles a sales mix and the make or buy calculator compares production with purchase.

Frequently asked questions

Why rank by contribution per scarce hour and not per unit?

When a resource is the limit, what matters is how much profit each hour of it earns. A product with a high margin per unit can earn less per hour than a cheap one that is quick to make. Ranking per unit would use the scarce hours poorly.

What is a scarce resource or bottleneck?

It is the input that limits output, for example machine time, skilled labor, floor space or a raw material. Any extra hour of it is valuable, and the best plan makes the most contribution from every hour. The theory of constraints builds management around this idea.

What if the products need different resources?

This calculator handles a single constraint. With several, a method such as linear programming is needed to find the best mix. The ranking rule used here is exact for one limited resource with an upper limit on demand for each product.

What does the result tell me about the value of an extra hour?

The contribution per hour of the last product made, partly or in full, is what an extra hour of the resource is worth. If you can buy more hours for less than that, increasing capacity pays. If not, it does not.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.