Category manager: what to learn and where to start
A category manager answers for the range of a category: width and depth, product roles, price and sell-through speed. Start with category roles, ABC-XYZ analysis and turnover.
What to understand
- Category contribution
- A category is judged by contribution to revenue and margin, stock turns and GMROI, not by revenue.
- ABC and item classes
- ABC splits items by contribution and exposes the tail that does not sell.
- Bestsellers and low sellers
- A bestseller and a low seller are defined relative to the category and period, not by an absolute number.
- Price tiers and price position
- Price tiers (base, better, best) and market position decide who buys you.
- Cannibalization and analogs
- A new style can take sales from a neighbor.
- Sizes and the core
- The size curve and core sizes answer which sizes to hold deep.
- Classifier and attributes
- Category analytics rests on unified category and attribute reference books.
- Categories in contribution roubles
- Contribution to growth and category margin, this year against last, show where development goes.
- Style classes
- Bestsellers, lowsellers and no-sale styles need different decisions: reorder, top-up, promotion, delisting.
- New styles and carry-over
- The share, yield per style, sell-through and margin of the two groups are compared separately.
- Price monitoring and top-up
- Price position to market and top-up rules by size curve link range with availability.
- Category roles
- A category can be a traffic magnet, a profit core or an image builder.
- Sizes and size returns
- A size recommendation tool pays back only when size returns are significant.
- Card quality and master data
- Attribute completeness (category, size, color, composition) drives search, filters and reports.
The first 30 days
- Open the season topic and split categories year on year. Categories: contribution to growth and margin, this year versus last
- Classify styles by ABC and sell-through. SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
- Compare new styles with carry-over. New and carryover: share, return per SKU, sell-through and margin
- Check price position to market. Price monitoring by SKU: index to the market, position and price-scraping freshness
- Check top-up rules. Replenishment by size: what and how much to send to stores by size
- Read the category and attribute references. Category reference book (tree)
- Assign category roles and check the goals. Category roles: traffic driver, profit core, image
- Check card completeness. Completeness and quality of product master data
- Assess whether size recommendation is needed. Size recommendation: payback of the tool
Which measures to track
| Measure | Formula |
|---|---|
| Category share of revenue and margin | Category revenue ÷ total revenue; margin likewise |
| Category GMROI | Category gross profit ÷ average stock at cost |
| Category sell-through | Units sold ÷ units received |
| Price position | Your price ÷ market median on comparable styles |
| Net effect of a new style | New style sales − lost sales of neighbors |
| Width and depth | Number of styles; units per style |
| Category contribution to growth | Category revenue change ÷ brand revenue change |
| Bestseller, lowseller and no-sale shares | Styles of a class ÷ all category styles |
| Yield per style: new versus carry-over | Group revenue ÷ number of styles in the group |
| Card completeness | Filled required fields ÷ all required fields |
| Size-return share | Returns for size reasons ÷ all returns |
Calculations in order
- ABC analysis of the range
Splits styles or groups into A, B and C by contribution to revenue or margin: what feeds the business, the middle, and what can be cut. - Post-season review by category
After the season shows what sold at full price, how much went on markdown, the margin that was left and how much money sits in leftovers. A basis for the next buy. - GMROI: gross profit per unit of stock
Compares categories by return on stock: gross profit per unit of money invested in stock, and turnover. Shows what earns and what only freezes cash. - 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. - Price position among competitors
Compares your price with prices of similar items: median, range, rank and gap. Shows whether you are expensive or cheap for the market and which price falls inside the corridor. - 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. - 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. - Size-run completeness and core sizes
Finds the core sizes of a style, shows whether the run is intact, how many weeks of sales each size covers and which sizes to top up or redistribute. - Product classifier check
Shows how fully the required attributes of a product table (group, category, season, size, color, fibre content) are filled, how many duplicates there are and which attributes fall below your target. Without a single classification, analytics does not add up. - Footwear returns: reasons, reverse logistics, the share back on sale and the loss
Splits footwear returns by reason (size, defect, did not like), calculates reverse logistics and handling, what share went back on sale as new and at a reduced price (worn returns), how much is lost on the price reduction and write-offs and what one return costs. - Categories: contribution to growth and margin, this year versus last
Shows which categories raised or dropped sales and how many points of growth each gave, and splits the change in the total margin into a mix effect (category shares shifted) and a rate effect (margin within categories changed).
Documents to start with
- Sales plan
- Open-to-buy budget (OTB)
- Assortment matrix and assortment plan
- Merchandise stock balance
- Stock turnover and dead stock
- Promo calendar and promotion effectiveness
- Allocation and replenishment
- Collection calendar (critical path) and lead time
- Market pyramid: segments, markups and business model
- Footwear: lasts, size run, returns and buying economics
Data templates
Product master data
One row per SKU: style, color, size and code. The base for stock, sales and marking.
Stock snapshot
Stock by SKU and location on a date: warehouse, store, in transit.
Questions you will be asked
- Which items bring revenue and which pile up in stock?
- Which category to widen and which to trim?
- Where is our price versus the market?
- What will a new style add after cannibalization?
- How to forecast a new item with no history?
- Are our product categories tagged correctly?
- What did last season show by category?
- How much money is in leftovers and how much margin does each collection role give?
- Which category drove growth and which lost margin?
- Which styles to reorder and which to drop?
- Are we pricier or cheaper than the market?
- Which role should each category have and what is its goal?
- Will a size recommendation tool pay back?