News & Articles

Getting best bang for your buck from your range: efficiency and effectiveness

The average pharmacy ranges up to 4000 skus, the majority of which only move 1 item per week, often indicating inefficient ranging. In this third article in the series, ShopAbility discuss how to tweak your existing range for best return and improved run rates.

By ShopAbility for Retail Pharmacy Magazine

Last article we talked about how you decide what things to range, taking into account your competitive strategy and shopper types, and concepts such as category weighting, segmentation, depth, and breath.

We looked at how to determine what your range should be at a total store level.

This time around let’s take this thinking one step further and look at how to make the most of your existing range within a given category, now that you’ve established what it should be.

What is Efficient Assortment?

Otherwise known as ‘Range Optimisation’ or ‘Range Rationalisation’, Efficient Assortment ‘right sizes’ your range in a given category based on the top selling products either or both of volume and value terms, and as measured against stock turn velocity and return on inventory.

Why is Efficient Assortment Important?

You might have the deepest or broadest range, or the most high margin products, but not all of it is necessarily moving or worth a lot to you.
Efficient Assortment helps you get best bang for buck from your available space for a given category, because it ensures you’re ranging the top selling and fastest moving products and minimizing space wastage on slow movers.

Which ‘level’ is Efficient Assortment performed at?

‘Efficient Assortment’ is normally performed at Category level, involving individual products and SKUs (see Fig 1). Traditionally, category segments, individual brands and unique SKUs are secondary considerations.

How it works – the 80/20 rule

You’ve heard of the 80/20 rule, otherwise known as the Pareto Principle.  Traditional Efficient Assortment uses the Pareto Principle to determine how many SKUs (individual products – stock keeping units) are worth 80% of category sales (the 80% analysis should be done for both volume and value).

Anything over the 80% line is called the ‘tail’. Anything that is in the Tail, unless it performs a unique role or is of high value, is ripe for rationalization – particularly if it duplicates the functionality of a product in the top 80%.

Below is an example Cumulative SKU graph (in both volume and value) for Category X. This kind of cumulative graph can be done very simply in an Excel spreadsheet, drawing from your sales data/point of sale system.
In Figure 2, the category is a sparse one (as opposed to dense one) because only a small number of SKUs make up the Top 80%. In this example there is a long tail.

Docking the Tail

The fastest way to shorten the tail is to ‘deduplicate’ it.
This simply means looking at the products in the tail and determining which ones have an identical function or role to their counterparts in the Top 80%.
In the Figure 2 example, though, there may not be many duplications as there are so few products making up the Top 80%.
So if they’re not duplicate products, how else can you determine what should go from the tail?

Return on Inventory

Look at what’s in the tail and what it’s worth to you – not just from a gross margin perspective on an individual item, but its stock turn rates.  You can’t bank margin – there’s no point ranging something that gives you 60% margin if you only sell one item a year unless it’s an extremely high $ value item. 60% of nothing is still nothing.
What we’re referring to here is GMROI – gross margin return on inventory. Using GMROI, a product with a lower margin but a high stock turn rate might actually be netting you more $ than a higher margin product that isn’t moving.

So in looking at the ‘tail’ in your category, have a look at the margins of the individual products versus their velocity – both hurdle rates (units per store per week) and annual stock inventory.
Products that are in the tail that are two or more of a) duplicates of something else b) low margin and c) low stock turn, should be the first cabs off the rank to be rationalized.

But make sure you don’t leave home without …

… checking what’s missing.
A traditional Efficient Assortment analysis tells you what to delete, but not what to range (which was the focus of the first article).  The 80/20 method of range rationalization looks at individual SKU contributions, but doesn’t look at coverage or unique needs.
So in doing an Efficient Assortment analysis, and looking at your Top 80%, you also need to keep in mind the following:

• Category coverage: Do my Top 80% skus cover most or all of the needs of the category?
• Segment coverage: Do my Top 80% skus represent products from each Segment of the category? Or are there products in the Tail that fulfill this function?
• Unique skus: are any of the products in the Tail a unique SKU that fulfills a special need and therefore can’t be deleted?
• New products: are any of the products in the Tail newly introduced (ie in the past 6 months)?

To mitigate the newness factor, Efficient Assortment analysis needs to be done on a quarterly or 6 monthly basis so you can track the progress of new product introductions and their potential entry into the Top 80% – ie to track trends rather than just dipstick one point in time.

So I’ve done my analysis, now what?

Once you’ve done your analysis you need to put the results into action instore. This might include:

• Out with the Old: Sell through (via special, promotion or other mechanic) or return the items in the tail that you’ve decided to rationalize (working with suppliers on how best to do this)
• Go with the Goers: Put a plan in place for how you will better support the products in the Top 80%. Decide whether you will focus on further supporting your Top 20% of skus or whether you will put focus on growing and improving the SKUs that sit between the 20% and 80% marks. This might include facing them up (giving them more facings on shelf), since you’ve now got more space to play with, or things like point of sale at the fixture and consumer promotions.

In summary: why you should look at Efficient Assortment

You might need to do an Efficient Assortment exercise on a category if you answer yes to one or more of the following:
1. You have a number of products that perform the same functions
2. You have a lot of products for a category but not enough space and you need to get rid of some
3. You don’t know which products are your top sellers and/or bottom performers
4. You are spending time and money promoting products that you suspect aren’t moving.

We’ve talked a bit here about the role of space on range. Next issue we’ll look at how to think about laying out a category and the products in it in more detail.

In the meantime, we welcome feedback on these articles – what you agree with, what you don’t – and what you’d like to hear about. Email us with feedback on enquiries@sh-opportunity.com.au

Looking for something in particular?