A pack recipe becomes an orderable product, and consumption can be measured from a CAD marker or read from a customer’s colour × size sheet.
A Sized Recipe Balances Per Size
A three-colour five-pack offered in five sizes is fifteen lines summing to twenty-five. Checking that aggregate against the pack size rejects that correct recipe and accepts one where a size is short by exactly what another is over, so each size is now balanced on its own. A missing colour or size is refused by name rather than silently creating a second material under the same colour.
Operational Pre-Packs
A colour-assortment pack recipe could previously be made but not sold: nothing carried the pack as an identity, so it could not be ordered, priced, reserved against or planned. A recipe now provisions a pack finished-goods material with one variant per size and generates the bill of material rules behind it — after which a pack is an ordinary material on an ordinary sales order line, and explodes correctly through planning with no special handling anywhere downstream.
CAD Marker Intake — Measured Per-Size Consumption
Every other number in a style is typed by a person; a marker’s weights come off the cutting room floor. A CAD marker can now be attached to a style and its measured consumption applied. A single-size marker measures its size exactly; several mixed markers measure every size when their mixes are independent. Anything less is reported as under-determined with the blended figure clearly labelled as not-per-size, and contradictory markers are refused rather than averaged into confident nonsense. Both the gross and net basis are shown and the choice is required, so cutting loss is neither double-counted nor dropped.
Customer Colour × Size Excel Reader
A customer’s colour × size sheet can be read directly into a style: the grid is found rather than assumed to start at the first row, so a title block, a left margin, a serial-number column, a totals row, merged headers and numeric sizes are all handled. Every value carries the cell it came from, so the reading is auditable, and a sheet that cannot be read comes back with the reason instead of guessing between two plausible interpretations.