# Product Mix Calculator: Throughput per Constraint Minute

> Source: https://netray.co/tools/constraint-product-mix-throughput-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Rank two products by throughput per bottleneck minute and see the best weekly mix when constraint time is limited.

## Category

mes-shop-floor

## Industry

Discrete Manufacturing

## Audience

- Production scheduler
- Plant manager
- Finance controller

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Constraint minutes available per week

**Key:** cap

**Type:** number

**Default:** 2400

**Min:** 1

**Step:** 60

**Unit:** minutes

#### Product A selling price

**Key:** pa

**Type:** number

**Default:** 140

**Min:** 0

**Step:** 1

**Unit:** per unit

#### Product A truly variable cost

**Key:** ma

**Type:** number

**Default:** 60

**Min:** 0

**Step:** 1

**Unit:** per unit

**Help:** Raw material and purchased parts, plus any variable outside processing. Exclude labor and overhead.

#### Product A minutes on the constraint

**Key:** min_a

**Type:** number

**Default:** 8

**Min:** 0.1

**Step:** 0.5

**Unit:** min/unit

#### Product A weekly demand

**Key:** dem_a

**Type:** number

**Default:** 250

**Min:** 0

**Step:** 10

**Unit:** units

#### Product B selling price

**Key:** pb

**Type:** number

**Default:** 95

**Min:** 0

**Step:** 1

**Unit:** per unit

#### Product B truly variable cost

**Key:** mb

**Type:** number

**Default:** 35

**Min:** 0

**Step:** 1

**Unit:** per unit

#### Product B minutes on the constraint

**Key:** min_b

**Type:** number

**Default:** 3

**Min:** 0.1

**Step:** 0.5

**Unit:** min/unit

#### Product B weekly demand

**Key:** dem_b

**Type:** number

**Default:** 500

**Min:** 0

**Step:** 10

**Unit:** units

**Outputs:**

#### Product A throughput per constraint minute

**Key:** tpm_a

**Expr:** (pa - ma) / min_a

**Format:** currency

**Primary:** true

#### Product B throughput per constraint minute

**Key:** tpm_b

**Expr:** (pb - mb) / min_b

**Format:** currency

**Primary:** true

#### Product A units to schedule

**Key:** units_a

**Expr:** if(gte(tpm_a, tpm_b), min(dem_a, cap / min_a), min(dem_a, max(cap - min(dem_b, cap / min_b) * min_b, 0) / min_a))

**Format:** integer

#### Product B units to schedule

**Key:** units_b

**Expr:** if(gte(tpm_a, tpm_b), min(dem_b, max(cap - min(dem_a, cap / min_a) * min_a, 0) / min_b), min(dem_b, cap / min_b))

**Format:** integer

#### Constraint minutes used

**Key:** used

**Expr:** units_a * min_a + units_b * min_b

**Format:** number

#### Weekly throughput

**Key:** tp

**Expr:** units_a * (pa - ma) + units_b * (pb - mb)

**Format:** currency

**Primary:** true

**Description:** Sum of price minus truly variable cost for the units scheduled.

**Chart:**

#### Weekly throughput vs constraint minutes

**Type:** line

**X:** cap

**From:** 600

**To:** 5000

**Steps:** 30

**Series:**

- tp

**Disclaimer:** Treats the constraint as the only limit and demand as firm. Check for other constraints, minimum order commitments and customer priorities before locking a mix.

## Content

**Intro:** When one resource limits the plant, the right question is not which product has the best margin but which earns the most per minute of the bottleneck. This calculator ranks two products by throughput per constraint minute and schedules the best mix inside the available time.

**Sections:**

#### How to use it

**Body:** Enter the minutes per week the constraint can actually run, then price, truly variable cost, constraint minutes per unit and weekly demand for each product. Truly variable cost is material and anything that rises one for one with units. Do not include direct labor or overhead, because they do not change with the mix this week. The calculator fills the constraint with the higher earning product up to its demand and gives the remainder to the other.

**Bullets:**

- Use constraint minutes net of downtime and setups
- Use firm demand, not forecast hopes
- Include only truly variable cost
- Re-run when the constraint or price changes

#### The method

**Body:** Throughput per constraint minute = (price minus truly variable cost) / minutes on the constraint. With the defaults, A earns (140 - 60) / 8 = 10 per minute and B earns (95 - 35) / 3 = 20 per minute. B has the lower unit margin but earns double per bottleneck minute. B's 500 units use 1,500 minutes and A gets the remaining 900 minutes, which is 112 units, for a weekly throughput of about 30,000 + 9,000 = 39,000.

#### Reading the chart

**Body:** The line rises steeply while extra constraint minutes go to the best product, then flattens in segments as demand is met. Where it becomes flat, more capacity at the constraint no longer adds throughput, and the constraint has moved or demand is the limit. That makes the chart a rough case for or against adding capacity at the bottleneck.

#### Common mistakes

**Body:** Ranking by gross margin percent or by margin per unit is the standard trap and can reverse the right answer. Another is using full standard cost, which hides how much of it is fixed this week. Finally, making a plan for the constraint without protecting it from starvation wastes the benefit, because every lost constraint minute is lost throughput for the whole plant.

**Cta:** We can pull price, bill of material cost and routing times from your ERP so this ranking is computed across your whole product list, not two products at a time.

**Faq:**

#### What is throughput in this context?

**Answer:** Throughput is selling price minus truly variable cost, the money the system generates through sales. It is the term used in throughput accounting and the theory of constraints, and differs from gross margin because it excludes labor and overhead allocations.

#### Why not rank by margin percent?

**Answer:** Because the plant does not run out of percent, it runs out of constraint time. A high margin product that uses many bottleneck minutes can earn less per minute than a low margin one that uses few.

#### What if I have more than two products?

**Answer:** Rank them all by throughput per constraint minute and fill the available minutes from the top, limited by demand. This tool handles two; repeat it pairwise or use a worksheet to rank a longer list.

#### Should I always follow the ranking?

**Answer:** Use it as the starting point. Contract commitments, customer relationships and strategic items sometimes override pure throughput. The ranking shows the cost of those choices so they are deliberate.

## Search terms

throughput per constraint minute, product mix constraint calculator, theory of constraints product mix, bottleneck product mix, throughput accounting calculator, which product to run on the bottleneck, throughput per bottleneck hour, constrained product mix optimization

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json