Retail KPIs

These retail KPIs show buyers and merchandisers where the next pound of stock earns most and how much is left to spend this season. Each figure says whether it is at cost or at retail, so anyone at a range review can check the turns and ratios.

Last reviewed · Virgo Analytics

GMROI by category, example

Highest margin, lowest return: accessories earn £2.06 per £1 of stock

Example data

GMROI by category

12 months to October 2026

GMROI on accessories, at a 72% margin

£2.06

All five

Net sales
£8.6M
Gross margin
54.4%
Stock turn
2.7
GMROI
£3.23
GMROI by category, example. Highest margin, lowest return: accessories earn £2.06 per £1 of stock. Accessories: stock turn 0.8, margin 72%, GMROI £2.06. Knitwear: stock turn 2.0, margin 62%, GMROI £3.26. Footwear: stock turn 2.4, margin 52%, GMROI £2.60. Homeware: stock turn 3.0, margin 55%, GMROI £3.67. Basics: stock turn 6.0, margin 45%, GMROI £4.91.40%50%60%70%80%01234567Stock turn at cost£2£3£4£5Accessories: stock turn 0.8, margin 72%, GMROI £2.06Accessories £2.06Knitwear: stock turn 2.0, margin 62%, GMROI £3.26Knitwear £3.26Footwear: stock turn 2.4, margin 52%, GMROI £2.60Footwear £2.60Homeware: stock turn 3.0, margin 55%, GMROI £3.67Homeware £3.67Basics: stock turn 6.0, margin 45%, GMROI £4.91Basics £4.91GMROI by category, example. Highest margin, lowest return: accessories earn £2.06 per £1 of stock. Accessories: stock turn 0.8, margin 72%, GMROI £2.06. Knitwear: stock turn 2.0, margin 62%, GMROI £3.26. Footwear: stock turn 2.4, margin 52%, GMROI £2.60. Homeware: stock turn 3.0, margin 55%, GMROI £3.67. Basics: stock turn 6.0, margin 45%, GMROI £4.91.40%50%60%70%80%01234567Stock turn at cost£2£3£4£5Accessories: stock turn 0.8, margin 72%, GMROI £2.06Accessories £2.06Knitwear: stock turn 2.0, margin 62%, GMROI £3.26Knitwear £3.26Footwear: stock turn 2.4, margin 52%, GMROI £2.60Footwear £2.60Homeware: stock turn 3.0, margin 55%, GMROI £3.67Homeware £3.67Basics: stock turn 6.0, margin 45%, GMROI £4.91Basics £4.91Turns 0.8 times a year: £315K of stock for £252K of cost of sales45% margin, six turns:£4.91 per £1 of stockGMROI by category, example. Highest margin, lowest return: accessories earn £2.06 per £1 of stock. Accessories: stock turn 0.8, margin 72%, GMROI £2.06. Knitwear: stock turn 2.0, margin 62%, GMROI £3.26. Footwear: stock turn 2.4, margin 52%, GMROI £2.60. Homeware: stock turn 3.0, margin 55%, GMROI £3.67. Basics: stock turn 6.0, margin 45%, GMROI £4.91.40%50%60%70%80%01234567Stock turn at cost£2£3£4£5Accessories: stock turn 0.8, margin 72%, GMROI £2.06Accessories £2.06Knitwear: stock turn 2.0, margin 62%, GMROI £3.26Knitwear £3.26Footwear: stock turn 2.4, margin 52%, GMROI £2.60Footwear £2.60Homeware: stock turn 3.0, margin 55%, GMROI £3.67Homeware £3.67Basics: stock turn 6.0, margin 45%, GMROI £4.91Basics £4.91Turns 0.8 times a year: £315K of stock for £252K of cost of sales45% margin, six turns: £4.91 per £1 of stockGMROI by category, example. Highest margin, lowest return: accessories earn £2.06 per £1 of stock. Accessories: stock turn 0.8, margin 72%, GMROI £2.06. Knitwear: stock turn 2.0, margin 62%, GMROI £3.26. Footwear: stock turn 2.4, margin 52%, GMROI £2.60. Homeware: stock turn 3.0, margin 55%, GMROI £3.67. Basics: stock turn 6.0, margin 45%, GMROI £4.91.40%50%60%70%80%01234567Stock turn at cost£2£3£4£5Accessories: stock turn 0.8, margin 72%, GMROI £2.06Accessories £2.06Knitwear: stock turn 2.0, margin 62%, GMROI £3.26Knitwear £3.26Footwear: stock turn 2.4, margin 52%, GMROI £2.60Footwear £2.60Homeware: stock turn 3.0, margin 55%, GMROI £3.67Homeware £3.67Basics: stock turn 6.0, margin 45%, GMROI £4.91Basics £4.91Turns 0.8 times a year: £315K of stock for £252K of cost of sales45% margin, six turns: £4.91 per £1 of stock
Turns 0.8 times a year: £315K of stock for £252K of cost of sales45% margin, six turns: £4.91 per £1 of stock
GMROI by category, example data, £K
CategoryNet salesGross marginGross margin £Cost of goods soldAverage stock at costStock turnGMROI
Accessories£900K72%£648K£252K£315K0.8£2.06
Knitwear£2,000K62%£1,240K£760K£380K2.0£3.26
Footwear£1,500K52%£780K£720K£300K2.4£2.60
Homeware£1,200K55%£660K£540K£180K3.0£3.67
Basics£3,000K45%£1,350K£1,650K£275K6.0£4.91
All five£8.6M54.4%£4,678K£3,922K£1,450K2.7£3.23
Example data: an invented fashion and homeware retailer, 12 months to October 2026, sales excluding VAT, average stock from 13 month-end counts at cost. Accessories make the best margin in the shop and the least on the money held in stock.
Show the numbers
GMROI by category, example data, £K
CategoryNet salesGross marginGross margin £Cost of goods soldAverage stock at costStock turnGMROI
Accessories£900K72%£648K£252K£315K0.8£2.06
Knitwear£2,000K62%£1,240K£760K£380K2.0£3.26
Footwear£1,500K52%£780K£720K£300K2.4£2.60
Homeware£1,200K55%£660K£540K£180K3.0£3.67
Basics£3,000K45%£1,350K£1,650K£275K6.0£4.91
All five£8.6M54.4%£4,678K£3,922K£1,450K2.7£3.23

Retail KPIs and how to calculate them

The merchandise system, the buying plan and the store plans fill this table. The weekly trading figures (like-for-like sales, sell-through, weeks of cover, margin after markdown, transaction value, units per transaction, store conversion and shrinkage) are on retail analytics. Stock values below are at cost unless a row says otherwise, and sales exclude VAT.

KPIFormulaA good readingThe common mistake
Margin and stock
GMROIGross margin £ ÷ average stock at cost, both over the same 12 months. Valued at retail, the same stock gives a lower GMROI, so the dashboard says which basis it uses. Above the line where a category's margin covers its share of rent, staff and overheads Averaging stock from two points, opening and closing. The seasonal peak falls between them, so average 13 month-end counts.
Stock turn at costCost of goods sold ÷ average stock at cost, over 12 months Faster than the same category last year, with availability holding up Dividing sales at retail by stock at cost. The mixed basis adds the mark-up to the turn.
Aged stock shareStock at cost in lines held longer than the agreed age ÷ all stock at cost × 100. Age runs from the date each unit was first received. Small, and every aged line carries a plan to mark down, transfer or return it Ageing stock from the line's last delivery. A repeat order resets the clock and the old units hide behind the new ones.
The buying plan
Open to buyPlanned closing stock + planned sales + planned markdowns − opening stock − stock on order, for the month, all on one value basis Positive in the months the range plan needs new intake, and held back for the lines the plan names Leaving stock on order out of the sum. The plan then shows money to spend that a buyer has already committed.
Stock to sales ratioStock at the start of the month ÷ sales in the month, both at retail value Close to the plan for that month of the season Comparing four-week and five-week months. The longer month's sales make the ratio look leaner than it is.
Markdown rateMarkdown value ÷ (net sales + markdown value) × 100, where markdown value is full price minus selling price on every unit sold reduced. This row's variant reads markdown as a share of full-price value. Many retailers divide by net sales alone. Inside the markdown budget set at the buy, and landing in the weeks the plan said Counting permanent reductions alone. Promotions and staff discount also sell below full price, so the definition says which are in.
Space and range
Sales per square metreNet sales ÷ selling space in square metres, over the same period Rising year on year in the same space, read by store and by category Counting stockrooms and fitting rooms as space. Divide by selling floor only, measured the same way in every store.
AvailabilityLines in stock at the count ÷ lines ranged to that store × 100 High on the lines customers come in for, read every week Counting a line as in stock when its one unit is in the stockroom. Decide whether stockroom units count, write it down and keep to it.
Space share against sales shareA category's share of selling space ÷ its share of net sales Close to 1, or a written reason when a category holds more space than its sales earn Measuring space in fixtures in one store and square metres in the next. Use one unit across the estate.

Open to buy, worked through

Example data: knitwear, March, at retail value

Line£K
Planned closing stock400
+ Planned sales180
+ Planned markdowns20
− Opening stock350
− Stock on order150
Open to buy100

The knitwear buyer has £100K left to commit for March. Leave the £150K on order out and the plan shows £250K.

How to build a retail dashboard for buying and stock

  • Data sources

    From the merchandise system, each line's cost price and the stock held at that cost, the date every unit was received, which ages it, and the value committed on open orders, which open to buy takes off. The tills for units sold, selling price and full price, so markdown value can be worked out per unit. The range plan for planned sales, markdowns and closing stock by category and month. The store plans for selling space in square metres.

  • Grain

    One row per line per store per week for stock and sales, with stock valued at cost and at retail. Open to buy sits one level up, at category by month, because that's the level the plan is written at. Space sits at category per store, updated when a store is refitted.

  • Refresh cadence

    Weekly, once the week's stock position has been posted. Open to buy is worked out again on the same day, so a buyer never orders from last month's figure.

  • Value basis

    Decide cost or retail for each KPI before you build anything. On this page GMROI, stock turn and aged stock are at cost, and stock to sales and open to buy are at retail. A dashboard that mixes them without saying so produces turns and ratios nobody can check.

  • Average stock

    Decide how many counts make the average. This page uses 13 month-end counts for a 12-month figure, the opening position plus every month end. Some teams average the 12 month ends and leave out the opening position.

Questions a retail dashboard should answer

“Where should next season's money go?”GMROI by category, plotted against stock turn and margin as in the example.
“How much can I still buy for March?”Open to buy for that category and month, with stock on order taken off.
“Which lines are tying up cash?”Aged stock share, with the aged lines listed and a plan against each.
“Is this category paying for its floor space?”Space share against sales share, by store.
“Are we cutting prices too early?”Markdown rate against the markdown budget, week by week.

If the open-to-buy plan needs next season's sales per line first, demand forecasting estimates them.

Retail KPIs by tool

  • Power BI

    Write GMROI as one measure, total gross margin divided by average stock, so it works at any level from a single line to the whole business. Stock needs its own average measure across month ends, because a stock balance summed over twelve months is twelve times too big. Add a category's GMROI and every store's GMROI together and the total means nothing.

  • Data Studio (formerly Looker Studio)

    Build the stock table at month-end grain before Data Studio reads it, with the 13-count average already worked out per category. Then the chart only divides one sum by another. Ratios averaged across categories in the report give each category the same weight whatever its size.

  • Excel

    If the buying plan already lives in a buyer's workbook, keep open to buy beside it on the same layout: categories down, months across, the five lines of the sum in each cell. Link the opening stock and stock on order to the merchandise system's export, and keep the planned lines typed by the buyer.

  • Google Sheets

    Availability counts can be entered straight into a shared sheet from each store, one row per line per count, so the head office figure is read from the same rows the stores typed. Where the web shop runs on Shopify, our Fresh Sheets add-on can bring its orders and units ordered into the same spreadsheet, so web sales and the stores' counts are read side by side.

Valued at retail, accessories would show less than £2.06, so through our dashboards and BI service we agree the value basis for each KPI with your merchandisers before building on your merchandise system and buying plan. Web shop figures from Shopify itself are on the Shopify dashboard page.

Questions about GMROI and open to buy

What is a good GMROI?

A good GMROI covers what the stock costs you to hold and sell. Add up a category's share of rent, staff and overheads for the year, divide by its average stock at cost, and that is the GMROI it has to beat. Below that line a category loses money once those costs come off, whatever its margin looks like.

Should stock turn be measured at cost or at retail?

Either works if both halves of the sum use the same basis. This page uses cost: cost of goods sold over average stock at cost. Mixing them, with sales at retail over stock at cost, puts the mark-up in the turn, and a category with a high mark-up looks as if it sells faster than it does.

What should a retail dashboard for buyers show?

It should lead with GMROI and stock turn by category, plotted against each other as in the example, then open to buy by category and month against the range plan. Aged stock and markdown rate go underneath, to show which lines need action. Weekly trading figures belong on the store managers' trading dashboard.

How is open to buy different from a buying budget?

You set a budget once for the season, and you work open to buy out again every week or month from the stock you actually hold and the orders already placed. If sales run ahead of plan, stock falls and open to buy rises. If they lag, it shrinks, and the buyer sees it before placing the next order.

How do you calculate average stock for retail KPIs?

Take the stock value at cost at each month end across the year, plus the opening position, and average all thirteen. Two points, opening and closing, miss the seasonal peak in between. A retailer that buys heavily for autumn and sells through by January then shows far less average stock than it really carried.

Which category earns least on its stock?

From your range plan and a year of month-end stock at cost and sales by category, we work out GMROI for each category on the first call.

Book a call

Free 30 min call