Collection product lead: what to learn and where to start
A product lead builds the collection as a product: how many styles, how deep, at which prices and with which category roles, then takes an item from the tech pack to the receipt of the lot. Start with width and depth, cost by specification and a comparison of factory quotes on full cost.
What to understand
- Width and depth
- Width is the number of styles, depth the stock of each across sizes and colors.
- Price tiers
- Three tiers good, better, best simplify the buyer choice.
- Category roles
- A magnet draws traffic, the core earns profit, the image category shapes the brand.
- Novelties and carry-over
- Carry-over is predictable, a novelty is not.
- Forecast by analogs
- For a new style similar past ones by price, category and season are taken, their sell-through is read and adjusted.
- Cannibalization inside the collection
- Two similar styles share one demand.
- How many SKUs you can carry
- Every SKU loads samples, purchasing, the warehouse and merchandising.
The first 30 days
- Open the brand history by season: growth, discounts, margin, sell-through. Brand history by season: growth, discounts, margin and sell-through
- Calculate the width and depth of the current collection. Width and depth: budget, models and pieces
- Check the price tiers and the margin of each. Price tiers: good, better, best
- Assign roles to categories and check them against pricing policy. Category roles: traffic driver, profit core, image
- Forecast one novelty from analogs. Forecast of a new item from analogs
- Find duplicate styles and assess cannibalization. Net effect of a new item: cannibalization
Which measures to track
| Measure | Formula |
|---|---|
| Revenue per SKU | Season revenue excl. VAT ÷ number of SKUs |
| Novelty share | Novelty SKUs ÷ all season SKUs (and by revenue) |
| Sell-through by stage | Sold ÷ received at the date |
| Margin by price tier | (Price excl. VAT − cost) ÷ price by tier |
| Share of best and low sellers | Revenue of leading items ÷ total revenue and the share of low-return items |
| Net effect of a new style | Sales of the new style − lost sales of neighboring styles |
Calculations in order
- Collection plan in value
From the collection grid (styles, depth, prices and cost) computes revenue, margin and leftover at a given sell-through and markdown, and checks that depth per style is not too small. - Width and depth: budget, models and pieces
Turns a buying budget into a number of models (width) and pieces per model and per size-by-color cell (depth). Shows how many models the budget can carry at a minimum depth, what stock will be left at the end of the season and how many weeks of sales sit in stock. - Price tiers: good, better, best
Calculates the average price and unit margin for a split of sales across tiers and shows the effect of shifting part of sales one tier up. Checks whether the step between tiers is noticeable to a customer. - Category roles: traffic driver, profit core, image
Assigns each category a role from two indices: sales density (share of sales ÷ share of area) and margin (category margin ÷ average margin). A traffic driver brings sales at a modest margin, the profit core gives both, image gives margin at a low return per meter, review lags on both. You set the index thresholds. - Forecast of a new item from analogs
A new model has no history, so its sales are estimated from your past analogs, adjusted for price, store reach and seasonal level. Gives expected weekly sales, a range from the spread of the analogs and pieces over the horizon. - New and carryover: share, return per SKU, sell-through and margin
Compares groups of SKUs of a season, for example new items, carryover (carried over from past seasons) and basics: the share in the range and in sales, sales per SKU, sell-through and margin. Shows which group gives a return above its share in the range. - ABC-XYZ matrix: a SKU’s contribution to sales and demand stability
From a table of SKU sales over several periods splits them into classes A, B, C by contribution to sales and X, Y, Z by demand stability (the coefficient of variation), shows the matrix of sales shares and the number of SKUs and suggests a stock policy for each SKU. - Net effect of a new item: cannibalization
Compares the margin gained from a new item with the margin lost on neighboring items after launch (adjusted for the overall trend in control stores). Shows the net effect on the category and the cannibalization share. - Collection mix: core, fashion, image
For collection roles (core, fashion, image or your own) calculates the share of the buy, planned revenue and margin, turnover and the money at risk in leftovers, and compares the shares with your target ranges and the margin with your target. Thresholds are editable: there is no single norm for the mix. - Brand history by season: growth, discounts, margin and sell-through
Builds a history report for a brand or category: net sales, discount depth, gross margin and sell-through by season, and compares each season with the same season a year earlier and the last year with the previous one. - Collection gates (stage-gate): a funnel of hypotheses, the price of a hit, the saving against “everything into a trial” and the stop rule of the pilot batch
From the number of ideas, the cost of the stages per model and the share of models passing each gate (idea, tech pack, sample, pilot batch) it counts how many models reach a hit, how much is spent in all, what one hit costs, what part of the spend went to rejected models and how much the gates save against “all ideas go to the end”. Separately it counts the stop rule of the pilot batch: the sales threshold at the control week, the loss on stopping and the loss avoided by not scaling blindly. Take the pass shares from past seasons; here illustrative.
Documents to start with
- Swimwear and lingerie: the size run, returns and the season as a separate economy
- Sports and technical clothing: fabrics, finishing, tests, the season and the price of a functional fabric
- Denim: fabric consumption with shrinkage, washing and finishing, the garment price by stage
- Knitwear and the economics of yarn: consumption, gauge, waste and the garment price by stage
- Jewelry: metal, fineness, stones and the cost by metal
- A reference of fabrics, trims and defects: fibers and compositions, density, shrinkage, the four-point defect score and roll acceptance
- The swatch and trim card and the materials order: the composition of the card, consumption, losses and shrinkage, packing and the minimum lot, the order date, approval and the table template
- Trends and the range forecast: from a signal to the trend share in the matrix, the life window, the test batch and the chase order
- A collection roadmap by gates: hypotheses, the pilot batch, stop criteria and decisions (stage-gate)
Data templates
Product master data
One row per SKU: style, color, size and code. The base for stock, sales and marking.
Sales by SKU and day
Sales and returns by SKU, store or channel and date; price and discount separate.
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.
Questions you will be asked
- How many styles and how deep to plan for the season at a given budget?
- Which price tiers are needed and is the middle one not empty?
- What roles do categories play and what discount is acceptable for each?
- How much will a novelty sell judging by analogs?
- Which styles duplicate each other and what happens if one is dropped?
- How many SKUs can the team carry without losing quality?