Footwear size run 36–41 with half sizes
A split of 330 pairs of one style across EU sizes 36–41 in half steps: foot length, share, pairs in total and pairs per color (3 colors).
What the template is for
Preparing a women footwear order and finding edge sizes that cause broken runs.
- What one row is
- one row = a size of a style
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Style SKU | model | Text | yes | one SKU for all sizes |
| Size EU | size | Number | yes | a number from 35 to 42 in steps of 0.5 |
| Foot length, mm | foot | Number | yes | calculated: EU × 20 ÷ 3 − 12 |
| Share in the curve, % | share | Number | yes | from 0 to 100 |
| Pairs in total | pairs | Integer | yes | an integer not below 0; the sum equals the order size |
| Pairs per color | perColour | Number | yes | calculated: pairs ÷ number of colors (3) |
| Size class | class | List value | yes | core or edge; edge if the share is below 5% |
Example rows
| Style SKU | Size EU | Foot length, mm | Share in the curve, % | Pairs in total | Pairs per color | Size class |
|---|---|---|---|---|---|---|
| W-BOOT-02 | 36 | 228 | 2.5 | 8 | 2.7 | edge |
| W-BOOT-02 | 36.5 | 231.3 | 4.9 | 16 | 5.3 | edge |
| W-BOOT-02 | 37 | 234.7 | 8.2 | 27 | 9 | core |
| W-BOOT-02 | 37.5 | 238 | 11.8 | 39 | 13 | core |
| W-BOOT-02 | 38 | 241.3 | 14.7 | 49 | 16.3 | core |
The example data is illustrative: an exercise, replace it with your own.
Note
The curve is normal with a center at 38.5 and σ = 1.3: an exercise assumption for the women group, not sales statistics. Take your own curve from sales by size. Edge sizes (36, 36.5, 41) get 1–3 pairs per color: keep them in the DC and online. A maker guide; check it against your size chart.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- Size-run completeness and core sizes
- Size curve: how to split a buy across sizes
- Width and depth: budget, models and pieces
- Returns: what they cost and how they hit margin
- Sampling inspection and cost of defects
- Category roles: traffic driver, profit core, image
- Landed cost of an imported item
- Unit price by run tiers and the minimum run
Documents that need this data
- Footwear: lasts, size run, returns and buying economics
- Assortment matrix and assortment plan
- Footwear returns and warranty: reasons, calculation, procedure, defects by component
- Patterns, grading, fit and the technological card: from the base block to the measurement chart and tolerances
- Reader question: how to count safety stock for rare sizes when demand is not normal
- Footwear and leather goods production: the last, technology, tooling, yield per hide and defects