Syntha Lab RU

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.

For a brand

Open interactively →

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

  1. Open the brand history by season: growth, discounts, margin, sell-through. Brand history by season: growth, discounts, margin and sell-through
  2. Calculate the width and depth of the current collection. Width and depth: budget, models and pieces
  3. Check the price tiers and the margin of each. Price tiers: good, better, best
  4. Assign roles to categories and check them against pricing policy. Category roles: traffic driver, profit core, image
  5. Forecast one novelty from analogs. Forecast of a new item from analogs
  6. Find duplicate styles and assess cannibalization. Net effect of a new item: cannibalization

Which measures to track

MeasureFormula
Revenue per SKUSeason revenue excl. VAT ÷ number of SKUs
Novelty shareNovelty SKUs ÷ all season SKUs (and by revenue)
Sell-through by stageSold ÷ received at the date
Margin by price tier(Price excl. VAT − cost) ÷ price by tier
Share of best and low sellersRevenue of leading items ÷ total revenue and the share of low-return items
Net effect of a new styleSales of the new style − lost sales of neighboring styles

Calculations in order

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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

Data templates

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?

Where next

Full description of the role

Topics

Open interactively →