Free download
Apparel order planning spreadsheet
Plan a first order across styles, colors and sizes in one workbook, and see straight away which colors fall below the minimum. Download it, fill in the yellow cells and send the plan with your brief. No sign-up.
What the workbook does
A first order usually has several styles, each in more than one color and a run of sizes. Most suppliers set a minimum per style, and Nyxlete counts it per color too, so the total can look big while one color is still too small. This workbook checks the numbers the way a supplier does.
- Plan sheet: one row per style and color, with a column for each size, a row total, a minimum check and totals by size.
- Styles sheet: adds each style across its colors and shows "OK" or how many of its colors are below the minimum.
- Team sets: mark a style "Y" and it is checked against the team-set minimum in kits instead.
- Sample credit check: optional. Enter a threshold if a supplier credits a sample fee against a larger first order.
How to use it
- Set the minimums at the top of the Plan sheet. The defaults are 20 pieces per style per color and 15 kits for a team set, which are the minimums Nyxlete publishes. Change them to match any supplier.
- List each style and color and type the pieces for each size. Spell a style the same way on every row.
- List your styles on the Styles sheet and read the status column.
- Fix any color marked below the minimum by adding pieces, dropping that color or dropping the style from the first order.
At Nyxlete colors are not combined: every color of a style has to reach the minimum on its own. Other suppliers may count it differently, so ask before you split a style into many colors.
Keep going
Related guides
MOQ calculator
The same idea as an online tool, with a one-click send to a quote.
Custom sportswear MOQ explained
What a minimum per style and color means and how to plan around it.
Manufacturing specification checklist
The production brief to send with your plan.
Low minimum order manufacturing
How the minimum works for a small first order.
The product range
Choose the styles you are planning.
Send your plan with your brief
Attach the finished workbook to your quote request. The form accepts Excel files, and a sample can be a single piece.