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.
Related tools
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.