Kids size run 80–164
A split of 1200 units of one style across heights 80–164 in 6 cm steps: age, girths, share and units.
What the template is for
Ordering a kids style by size run and checking which sizes fall into the tail by age.
- What one row is
- one row = a height (size) of a style
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Style SKU | model | Text | yes | one SKU for all sizes |
| Height (size), cm | height | Integer | yes | an integer from the 80–164 run in steps of 6 |
| Age by the chart, months | ageM | Integer | yes | a guide from the height and age table |
| Chest, cm | chest | Integer | yes | a guide ±2 cm |
| Waist, cm | waist | Integer | yes | a guide ±2 cm |
| Hips, cm | hips | Integer | yes | a guide ±2 cm |
| Share in the curve, % | share | Number | yes | from 0 to 100 |
| Units | units | Integer | yes | calculated: share × order size (1200) ÷ 100 |
Example rows
| Style SKU | Height (size), cm | Age by the chart, months | Chest, cm | Waist, cm | Hips, cm | Share in the curve, % | Units |
|---|---|---|---|---|---|---|---|
| K-OVR-05 | 80 | 11 | 48 | 46 | 48 | 2 | 24 |
| K-OVR-05 | 86 | 16 | 51 | 48 | 52 | 3 | 36 |
| K-OVR-05 | 92 | 24 | 53 | 50 | 54 | 5 | 60 |
| K-OVR-05 | 98 | 36 | 55 | 51 | 57 | 7 | 84 |
| K-OVR-05 | 104 | 48 | 57 | 52 | 59 | 9 | 108 |
The example data is illustrative: an exercise, replace it with your own.
Note
The curve and order size are illustrative, an exercise. Children grow differently and sizes drop out by age, so carrying stock into the next season is limited: plan the edge heights with small shares and pre-packs of two sizes. 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
- Size curve by store cluster and pack composition
- Returns: what they cost and how they hit margin
- Sampling inspection and cost of defects
- Category roles: traffic driver, profit core, image
- VAT for a period: charged, deductible, payable
- SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
Documents that need this data
- Kids: height sizing, back-to-school, TR CU 007/2011 and 10% VAT
- Assortment matrix and assortment plan
- Knitwear and children’s clothing as production: yarn, gauge, fully-fashioned knitting or cut-and-sew, size growth and construction safety
- 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