Assortment matrix (SKU: role, price, cost, sizes)
One row per style: category, role, price and cost excl. VAT, size range, colors and the buy plan in units.
What the template is for
Building the collection matrix before buying and checking margin by role.
- What one row is
- one row = a style (SKU)
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Style SKU | article | Text | yes | unique in the file |
| Name | name | Text | yes | not empty |
| Category | category | List value | yes | a value from the category reference |
| Role | role | List value | yes | traffic, core, image or review |
| Price excl. VAT | price | Number | yes | a number not below 0 |
| Unit cost excl. VAT | cost | Number | yes | a number not below 0 |
| Gross margin, % | gm | Number | yes | calculated: (price − cost) ÷ price × 100 |
| Size range | sizes | Text | yes | range limits: 36-41, S-XXL, 80-128 |
| Number of colors | colours | Integer | yes | an integer not below 1 |
| Buy plan, units | units | Integer | yes | an integer not below 0 |
| Planning type | plantype | List value | yes | seasonal or carryover: for carryover the stock is subtracted from the budget, for seasonal it is not |
| Supplier code | supplier | Text | yes | a value from the supplier reference |
Example rows
| Style SKU | Name | Category | Role | Price excl. VAT | Unit cost excl. VAT | Gross margin, % | Size range | Number of colors | Buy plan, units | Planning type | Supplier code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| W-COAT-01 | Wool coat | coat | core | 12,900 | 4,900 | 62 | 40-52 | 3 | 420 | carryover | S01 |
| W-DRS-07 | Midi dress | dress | image | 8,900 | 2,850 | 68 | 40-50 | 4 | 360 | seasonal | S02 |
| W-TEE-12 | Basic tee | tee | traffic | 1,990 | 640 | 67.8 | XS-XL | 6 | 1,800 | seasonal | S02 |
| M-JKT-03 | Padded jacket | jacket | core | 10,900 | 4,100 | 62.4 | S-XXL | 2 | 520 | carryover | S01 |
| K-OVR-05 | Kids overall | overall | review | 3,490 | 1,250 | 64.2 | 80-128 | 3 | 600 | seasonal | S03 |
The example data is illustrative: an exercise, replace it with your own.
Note
Take the split of units by size from the templates “Footwear size run 36–41” and “Kids size run 80–164”. Give the role “review” to styles with sales and margin below average. The example data is illustrative: an exercise, not a norm or an industry benchmark.
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
- Category roles: traffic driver, profit core, image
- Collection plan in value
- SKUs, barcodes and the labor of product cards
- Size-run completeness and core sizes
- Size curve: how to split a buy across sizes
- Reorder point and safety stock
- Width and depth: budget, models and pieces
- SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
Documents that need this data
- Assortment matrix and assortment plan
- Footwear: lasts, size run, returns and buying economics
- Kids: height sizing, back-to-school, TR CU 007/2011 and 10% VAT
- ABC-XYZ and Pareto: calculation, thresholds, link to safety stock and the range
- Allocation and replenishment
- A buyer session: the brand scorecard, the agenda and the order terms
- Optimization of range and allocation: knapsack by budget and shelf, marginal stock allocation, the transport problem
- Open-to-buy budget (OTB)
- Planogram and display in apparel: rails, walls, tables, selling slots, display stock and execution control
- Job profiles: merchandiser and collection product manager — what they count, which documents they make, how the week works
- Reader question: how to count safety stock for rare sizes when demand is not normal
- The six-month merchandise plan and model stock: sales, coverage, safety stock, purchases by month