Plan apparel orders without losing the size and colour assortment

Why aggregate piece tracking fails apparel assortment commitments

In discrete metal or plastics manufacturing, producing 600 units against a 600-unit sales order usually means the order is complete. In garment and textile manufacturing, a single style order is a two-dimensional matrix of colours (or wash finishes) and graded sizes—such as S, M, L, XL—often delivered in contractually fixed pre-pack carton ratios.

Many factories plan capacity and track daily sewing floor output using a single style-level total while managing size breakdowns on disconnected cutting-room spreadsheets. That split creates three recurring failures between cutting, sewing and dispatch:

1. Over-cutting large or small sizes hides core-size deficits: When a fabric roll runs short on the final lay or a cutting table operator adds extra plies of XL to use up a roll end, total cut pieces still exceed the order total, so the ERP header marks cutting 100% complete even though size L is already four pieces short.
2. Shade-lot mixing triggers mid-order quarantine: Woven shirting, denim and dyed knits exhibit roll-to-roll shade variation (Shade Band A versus Shade Band B). If cutting issues collars or cuffs from Lot SL-22B into body bundles cut from Lot SL-22A, finishing quality control must reject the assembled garments—creating a sudden shortage in a single size hours before vessel cut-off.
3. Pre-pack carton ratios amplify single-size shortages: When a retail buyer orders 100 cartons packed in a mandatory 1 : 2 : 2 : 1 ratio (1 S, 2 M, 2 L, 1 XL = 6 pieces/carton), a 32-piece shortage in size M blocks 16 complete cartons (96 pieces of finished apparel) from shipping unless the planner triggers an immediate shade-matched recut or obtains written customer approval for single-size tail cartons.

Plan apparel orders without losing the size and colour assortment — reporting workflow

Follow the workflow below, or open its complete text version.

Read the complete workflow as text

1. Explode style order into size-colour matrix → Allocate fabric rolls by graded Consumption & shade
2. Allocate fabric rolls by graded Consumption & shade → Verify cut bundle counts per variant before sewing
3. Verify cut bundle counts per variant before sewing → Reconcile sewing and finishing QC by variant
4. Reconcile sewing and finishing QC by variant → Gate pre-pack carton release and recut shortages

Four-stage variant and shade-lot control architecture

To prevent aggregate piece counts from masking variant deficits, production planning must enforce variant-level balances at four operational handovers:

1. Graded BOM consumption and shade-band roll reservation

Instead of applying a single average fabric consumption across the whole style, the bill of materials (BOM) records graded marker consumption by size—for example, 1.45 m/pc for S, 1.55 m/pc for M, 1.65 m/pc for L and 1.75 m/pc for XL. Before releasing a cutting ticket, the planner reserves inspected fabric rolls grouped by shade band so every ply in a bundle—and every garment packed into a solid-colour carton—shares a single verified shade lot.

2. Marker ratio lock and bundle-ticket validation

When the cutting room spreads fabric plies and cuts a multi-size marker, the system compares actual cut pieces per size against the authorised marker plan. Over-cuts in one size are never credited toward the completion percentage of another size. Each cut bundle receives a barcoded bundle ticket carrying Style + Colour + Size + Shade Lot + Ply Range.

3. Sewing line balancing and shade-segregated WIP transfer

Sewing lines receive complete component sets (fronts, backs, sleeves, collars, cuffs and size labels) matched by bundle ticket. If an in-line inspector rejects a damaged panel, the sewing supervisor logs the defect against the exact size-colour variant and requests a shade-matched replacement panel from the remnant roll buffer rather than cannibalising another bundle.

4. Finishing QC and pre-pack assortment reconciliation

At pressing, folding and carton packing, the system calculates two distinct metrics for the apparel planner:

• Capped variant fulfilment: sum(min(Ordered_i, Passed_QC_i)) across all variants i, preventing surplus over-makes in S or XL from offsetting deficits in M or L.
• Pre-pack carton ceiling: min(floor(Passed_QC_i / Pack_Ratio_i)), identifying the exact limiting size that constrains complete ratio cartons.

Worked example: 600-piece Oxford shirt order (PO-APP-2026-600)

Consider an apparel manufacturer executing buyer order PO-APP-2026-600 for 600 pieces of Men's Long-Sleeve Oxford Shirt (Style ST-408, Colour Navy-04), contracted as 100 pre-pack cartons of 6 pieces each under a mandatory 1 S : 2 M : 2 L : 1 XL assortment ratio:

• Ordered variant quantities: 100 S, 200 M, 200 L and 100 XL (600 pieces total).
• Planned fabric requirement: (100 × 1.45 m) + (200 × 1.55 m) + (200 × 1.65 m) + (100 × 1.75 m) = 145.0 + 310.0 + 330.0 + 175.0 = 960.0 metres of Navy-04 shirting fabric.
• What went wrong on the floor:
  1. During cutting of size M, the operator cut 170 pieces from primary Shade Lot SL-22A and completed the remaining 32 pieces using a roll from Shade Lot SL-22B without inserting a shade-separation sheet. During sewing, sleeves from SL-22B were stitched onto bodies from SL-22A, causing finishing QC to quarantine 32 pieces of size M for visible shade mismatch (alongside 2 pieces rejected for stitch defects).
  2. On size L, a roll-end splice defect reduced the final lay by 4 pieces (196 pieces cut instead of 200), and 8 pieces failed buttonhole and oil-stain inspection, leaving 188 good pieces.
  3. On size XL, the cutting supervisor added extra single-size markers onto remnant roll ends of SL-22A to boost daily cutting output, cutting 146 pieces and finishing 142 good pieces against a requirement of only 100 pieces.

The table below reconciles the style total against the true variant-by-variant and carton-pack position:

Operational decisions from the reconciled assortment table

1. Exposing the 600-piece aggregate illusion: A conventional production report shows 600 pieces ordered and 600 pieces passed QC (0 net variance), leading management to assume the shipment is ready. The variant ledger shows that only 556 pieces (92.67%) can be applied to the purchase order, while 44 pieces (2 S + 42 XL) are unrequested over-makes and 44 pieces (32 M + 12 L) are missing.
2. Quantifying pre-pack dispatch impact: Because size M yields only 168 ÷ 2 = 84 complete pre-pack cartons, the factory can pack only 504 pieces (84.0% of the order) into compliant 1:2:2:1 cartons—leaving 18 S, 20 L and 58 XL finished shirts stranded on the packing floor.
3. Executing a bounded recut before shipment cut-off: To close the 32-piece M and 12-piece L deficit without mixing shade bands, the apparel planner releases an emergency recut work order against reserved Shade Lot SL-22A stock:
   • Size M recut: 32 pcs × 1.55 m/pc = 49.60 metres
   • Size L recut: 12 pcs × 1.65 m/pc = 19.80 metres
   • End-loss and 3% defect buffer: 3.00 metres
   • Total recut fabric issue: 72.40 metres of verified SL-22A fabric, restoring all 100 cartons (600 assortment-compliant pieces) prior to container stuffing.

Implementation checklist for apparel production planners

• Cap order progress by variant: Calculate work-order completion as sum(min(Ordered_i, Completed_i)) ÷ Total_Ordered at cutting, sewing and finishing so over-cuts in one size never mask shortages in another.
• Enforce shade-lot separation on bundle tickets: Require every cut bundle and replacement panel request to carry the roll's Shade_Band_ID, blocking mixed-shade assembly before sewing starts.
• Gate over-cut marker additions: Require apparel planner sign-off before the cutting room adds unscheduled single-size plies to consume remnant roll ends.