Merchandiser: what to learn and where to start
A merchandiser answers for how product lies and hangs in the store: which items get space, how many facings, when the display changes with the season. Start with linear metres, the cost of space and the size run.
What to understand
- Space costs money
- A meter of shelf or rail takes floor area that rent pays for.
- Facings and depth
- A facing is the front-facing unit of an item on the shelf.
- The planogram as an agreement
- A planogram records what lies where and ties purchasing, the warehouse and the store together.
- The broken size run
- When only edge sizes remain, the run looks empty and the item sells worse.
- Seasonal transitions
- A collection change needs a plan: what goes, what stays, where the sale zone is.
- Cannibalization inside a zone
- A new item next to an old one may not add sales but take them.
- Windows and entrance
- The window and the first zone at the entrance sell what is in stock at the right depth.
The first 30 days
- Calculate revenue and margin per meter for three zones of your store. Display: productivity of a linear meter and of facings by zone
- Find out what a meter of area costs including rent. Full cost of the premises: per square meter, per fixture and per linear meter
- Find items with gaps in the size run. Size-run completeness and core sizes
- Draw up a season change plan with dates and zones. Season result: from gross sales to contribution
- Check whether a new item pushed out its neighbors. Net effect of a new item: cannibalization
- Open the topic on the full cost of space and display. Full cost of the premises and display
Which measures to track
| Measure | Formula |
|---|---|
| Sales per linear meter | Zone revenue excl. VAT ÷ meters of display |
| Margin per meter | Zone gross profit ÷ meters of display |
| Size-run completeness | Sizes in stock ÷ sizes in the item run |
| Share of space given to the sale | Meters of the sale zone ÷ total meters of display |
| On-shelf availability | Items displayed at the required depth ÷ planogram items |
| Zone pay-back | Zone margin uplift ÷ refit cost |
Calculations in order
- Display: productivity of a linear meter and of facings by zone
Compares store zones by revenue and margin per linear meter and per facing, shows the index (share of sales ÷ share of space), the best and worst zones and estimates whether moving meters from a weak zone to a strong one pays when returns diminish. - Full cost of the premises: per square meter, per fixture and per linear meter
Collects rent (fixed and a percentage of turnover), service charges, utilities, security and cleaning and staff, spreads them over a sales square meter, a fixture and a linear meter of display and compares with revenue and margin. Shows the revenue per meter needed for the store not to lose money. - 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. - 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. - Season result: from gross sales to contribution
Lays out the season result as a ladder: gross sales at list price, discounts, returns, net sales, cost of goods, gross margin, write-offs, selling costs. Shows how many margin points discounts ate. Fits a brand, a category and a retailer; check the names of the rungs against your own reporting. - Control week: full-price sell-through
At the control week of the season, separates what sold at full price from what sold on discount, calculates sell-through from the on-hand stock at the start of the season, compares it with your goal and red line, shows the pace to the season goal and suggests: revisit the price-cut schedule, hold or consider a reorder. - Chain pilot: the effect against control stores
Checks that a new display, seller uniform or price gave an effect rather than the season: compares the change in sales in pilot stores with the change in control stores. Shows the effect in percent, an interval from the spread across stores and the profit of the pilot.
Documents to start with
- 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
- The display in numbers: usable hall area, running meters, capacity and density, zoning by productivity and the rotation of the display
- Excel for retail, part I: lookup by key, pivot tables and data validation
Data templates
Stock snapshot
Stock by SKU and location on a date: warehouse, store, in transit.
Sales by SKU and day
Sales and returns by SKU, store or channel and date; price and discount separate.
Questions you will be asked
- How many meters to give a category at this revenue and margin per meter?
- What does a meter of area cost with rent and what pays for it?
- When to consolidate leftovers and shrink a run so as not to keep an empty rail?
- What to remove and move at the season change so space is not held for slow goods?
- Did the new item add sales to the zone or take them from neighbors?
- Did the rearrangement pay back in one store and can it be rolled out across the chain?