Trim Matrix Explosion & Single-Variant Kitting Exposure

The formula

This is the expression the tool evaluates. Every term is named underneath, with the unit it must be supplied in.

How the result is derived

Step by step, from the values you type to the figure on screen.

1. The 7 inputs are read from the form on every keystroke: Colourways, Sizes, Order Quantity, Same on Every Garment, Change with Colour Only, Change with Size Only and Change with Both.
2. Each value is checked against the accepted range in the input table below. A value outside its range stops the calculation rather than producing a misleading figure — the results blank out and a message appears.
3. The validated values are substituted into the expression above, which resolves Distinct Trim Variants to Buy together with every supporting figure in one pass — no value is carried over from a previous entry.
4. The supporting outputs — Distinct SKUs, Trim Lines on the Style, Rows Held as Flat Per-SKU Bills, Rows Held as a Rule-Based BOM, Rows Avoided, Edits to Change One Trim Supplier, Order Halted by One Missing Size Variant and Order Halted by One Missing Grid-Cell Variant — come from the same pass, so they always describe the same case as the headline figure.
5. Results are rounded for display only. The full-precision value is used throughout the chain, so reading a rounded intermediate figure back into the tool by hand can shift the last digit.

What each input means

Where to read each value on the floor, the unit it must be in, and the range the tool accepts.

What the tool returns

The headline figure and every supporting value it is built from.

Worked example

The tool loads with this case already solved — the Distinct Trim Variants to Buy shown above is its answer. Change one value and the difference from this baseline is the sensitivity of the result to that variable.

How to use it

1. Work through the input groups in order — Style and Trims. The defaults are a realistic case, so you can change one value at a time and watch what moves.
2. There is no calculate button. Every figure recalculates as you type or drag, which is what makes this usable for a what-if sweep rather than a single answer.
3. Read Distinct Trim Variants to Buy in the dark results panel — that is the headline figure, expressed in variants.
4. Check the supporting rows underneath (Distinct SKUs, Trim Lines on the Style, Rows Held as Flat Per-SKU Bills, Rows Held as a Rule-Based BOM, Rows Avoided, Edits to Change One Trim Supplier, Order Halted by One Missing Size Variant and Order Halted by One Missing Grid-Cell Variant) before acting on the headline — they are where an implausible input usually shows itself first.
5. Reset to defaults returns every field to the reference case, which is the quickest way to check whether a surprising result came from the tool or from an input you had changed earlier.

Where this is used

• Process planning — establishing Distinct Trim Variants to Buy before a trial is booked, so machine time and material in Merchandising, Retail Math & Apparel Production are committed against a calculated figure rather than an estimate.
• Costing and quotation — Distinct Trim Variants to Buy is an input to the cost sheet, and quoting from a worked number rather than a remembered one is what keeps a margin intact.
• Troubleshooting — when the floor result drifts from plan, entering the measured values (starting with Colourways) shows how much of the gap in Distinct Trim Variants to Buy each variable explains.
• Teaching and study — the accepted ranges bracket normal Merchandising, Retail Math & Apparel Production practice, so moving one variable at a time shows the shape of the relationship rather than a single answer.

Assumptions and limits

• The variant count is the number that matters at purchase and the number nobody predicts, because it is not the trim lines and it is not the SKUs — it is the trim lines resolved against only the dimensions each one actually depends on. A line that changes with both dimensions costs a variant per cell of the grid on its own, which is why a single woven size-and-colour label can carry more part numbers than every other trim on the garment combined. The two exposure figures are the argument for kitting discipline: a size-dependent trim short by one variant does not delay a sixth of the order, it stops that size dead while everything else keeps running and piles up as work in progress against a shipment that cannot close. Grid-cell variants stop less, but there are far more of them and each is bought in the smallest quantity, so they are where shortages actually happen. The row comparison is the maintenance argument rather than the production one: flat per-SKU bills are not wrong, they are simply a copy of the same information once per SKU, and every copy is a place for the zipper supplier change to be missed.
• Every input is bounded to the range normal practice occupies (Colourways 1 to 60 count, Sizes 1 to 40 count and Order Quantity 1 to 5000000 garments, and so on for the rest). Those bounds are guard rails against typing errors, not a claim that the formula fails one unit outside them.
• The calculation is deterministic: the same inputs always give the same result. It carries no allowance for machine condition, operator skill, ambient conditions or lot-to-lot material variation unless an input above explicitly represents one.
• Nothing is sent anywhere. The maths runs in your browser, so the numbers you type never leave the page.

Questions people ask