Syntha Lab RU

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.

For retail

Open interactively →

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

  1. Calculate revenue and margin per meter for three zones of your store. Display: productivity of a linear meter and of facings by zone
  2. Find out what a meter of area costs including rent. Full cost of the premises: per square meter, per fixture and per linear meter
  3. Find items with gaps in the size run. Size-run completeness and core sizes
  4. Draw up a season change plan with dates and zones. Season result: from gross sales to contribution
  5. Check whether a new item pushed out its neighbors. Net effect of a new item: cannibalization
  6. Open the topic on the full cost of space and display. Full cost of the premises and display

Which measures to track

MeasureFormula
Sales per linear meterZone revenue excl. VAT ÷ meters of display
Margin per meterZone gross profit ÷ meters of display
Size-run completenessSizes in stock ÷ sizes in the item run
Share of space given to the saleMeters of the sale zone ÷ total meters of display
On-shelf availabilityItems displayed at the required depth ÷ planogram items
Zone pay-backZone margin uplift ÷ refit cost

Calculations in order

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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

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?

Where next

Full description of the role

Topics

Open interactively →