How to Allocate a Factory MOQ Across Product Variants

Once a factory's total MOQ is accepted, the next risk is allocating it badly across sizes, colours or models. Do not split the total equally by default. Define the retained variants, build a demand-share baseline, apply minimum presentation and service-risk overrides, round to real factory pack multiples, then reconcile the exact total and test downside demand.

This is an allocation decision, not an MOQ-negotiation tactic. If the total commitment itself is unacceptable, return to the MOQ negotiation process. If too many weak variants remain, rationalise the SKU range before allocating the order.

Confirm what the factory minimum actually constrains

Obtain the supplier's written rule before building the sheet. The constraint may apply to:

• the total order;
• each colour, size, model or artwork;
• a shared material or component;
• each production run or mould setup;
• each carton or inner-pack multiple; or
• a combination of these.

Also confirm whether variants may be mixed within cartons, whether the pack ratio is fixed, and whether rounding must occur at unit, inner, carton or production-lot level. A total MOQ of 1,200 units means little if every colour also has a 300-unit minimum.

Freeze the retained variant list

Shopify's assortment-planning guidance distinguishes assortment breadth from depth, including the number of sizes or colours within a product. More depth can improve choice, but it also divides the purchase across more inventory positions.

Create one row per retained sellable variant with a stable SKU. Include:

• variant and SKU;
• demand-history quality;
• forecast demand share;
• minimum presentation or channel quantity;
• customer or service commitment;
• factory minimum and pack multiple;
• margin or strategic role where relevant;
• current inventory and inbound stock; and
• risk note and owner.

Do not add a variant merely because the supplier offers it. Current Shopify guidance on SKU proliferation warns that unchecked expansion increases operational complexity, carrying cost, forecasting difficulty and slow or dead stock.

Build a demand-share baseline

For established variants, use clean comparable demand rather than product-level sales divided by gut feel.

baseline units for variant = total accepted MOQ x variant demand share

The shares must total 100%. Where stockouts distorted a variant's history, flag the gap and use a scenario rather than pretending the observed share is complete. For a new range, use an analogue or research-based range and label the confidence low.

This fictional example is OPL analysis. It illustrates the arithmetic; it does not prescribe a safe mix.

Apply minimums and risk overrides visibly

An equal or demand-share allocation may fail a commercial constraint. Add overrides as separate columns:

• minimum viable presentation quantity for a retail or marketplace launch;
• customer commitment or pre-order;
• core-size availability requirement;
• known product transition or phase-out;
• uncertainty penalty for an untested option; and
• carton, pallet or production multiple.

Do not overwrite the raw demand allocation. Show baseline, override, rounded quantity and reason separately. That keeps the decision reviewable.

Round, then reconcile the residual

Rounding every variant up can exceed the accepted total. Rounding down can breach a factory or channel minimum. Use a controlled reconciliation:

1. apply hard per-variant minimums;
2. round each row to its valid pack multiple;
3. calculate residual = accepted total - rounded total;
4. add or remove complete packs according to a declared priority; and
5. recheck every minimum and the exact total.

A suitable priority may favour a proven core variant with strong forecast confidence and low current cover. It should not automatically favour the highest margin, the buyer's favourite colour or the variant with the loudest stakeholder.

If the sum of hard minimums and valid packs exceeds the accepted total, the problem is infeasible. Reduce the variant set, change the supplier constraint or increase the total through a separately approved decision. Do not hide the breach with fractional cartons.

Test inventory position, not forecast alone

Allocation should consider the post-receipt position:

projected available = current sellable stock + confirmed inbound + proposed allocation - expected demand before receipt

Use the same units and date basis for every row. Separate quarantined, returned or unconfirmed stock. Link the demand inputs back to the governed demand-forecasting process once that record is live.

Shopify inventory reports can provide variant-level inventory, sales and sell-through information for relevant merchants. The allocation sheet still needs a declared snapshot date because current stock changes while the purchase decision is being reviewed.

Run downside, base and upside scenarios

For each variant, test at least:

• downside demand or slower launch;
• base demand under the approved forecast; and
• upside demand or stronger service requirement.

Report months or weeks of projected cover only when the denominator and future period are explicit. A low-volume variant can show unstable cover. A new variant may need a cash-at-risk or units-at-risk view instead.

Do not call a mix optimal unless an agreed model, constraints and objective function support that term. This worksheet produces a defensible candidate, not a guarantee.

Obtain a supplier read-back before release

Send the final mix as a controlled table and require the supplier to confirm:

• exact SKU or variant description;
• unit quantity;
• pack and carton ratio;
• artwork or label revision;
• total quantity;
• any material or component constraint; and
• effect on price, schedule and packing.

Then reconcile the supplier acknowledgement to the approved purchase-order release. A supplier saying “OK” to the total is not evidence that every variant row was accepted as issued.

Record the decision and learn from sell-through

Store the raw demand shares, override reasons, rounding sequence, final mix, approver and assumptions. After receipt and a meaningful selling period, compare forecast, allocation, availability, returns and residual stock by variant.

The immediate next step is to take the next accepted factory MOQ and calculate the hard-minimum total before debating the mix. If the minimums already exceed the order, resolve the structural problem first. If they fit, allocate the residual transparently and make every complete pack earn its place.