Retail Analytics — Assortment Analysis


Retail Analytics — Assortment Analysis

Exhibit 31.5   Assortment optimization.

Retailers are constantly grappling with requests to list an ever-increasing parade of new products. Their space is finite — as new items get listed, some items on the shelf need to be de-listed.

One approach to optimizing assortment is on the basis of sales volume, sales value and profitability. This is covered in detail in Chapter Sales and Distribution. It is important also for the retailer to examine measures such as the proportion of shoppers who buy an item (% buyers), and particularly those who exclusively buy.

A low selling item might have relatively high base of shoppers who exclusively buy it. Such an item exhibits high brand loyalty. So, if it is de-listed, the likelihood that some shoppers may switch to other stores, is greater, and the retailer stands to lose their total spend in store when shoppers switch.

Exhibit 31.5 depicts an analysis of exclusive buyers and cumulative duplicate buyers of items for some category. The items are listed in order starting from the item with the biggest buyer base.

Observe, at the tail end, items r and v have a high proportion of exclusive buyers. Since their shoppers exhibit high loyalty, the retailer should refrain from de-listing items r and v; or do so only after careful consideration.


Previous     Next

Use the Search Bar to find content on MarketingMind.







Marketing Analytics Workshop

Marketing Analytics Workshop

In an analytics-driven business environment, this analytics-centred consumer marketing workshop is tailored to the needs of consumer analysts, marketing researchers, brand managers, category managers and seasoned marketing and retailing professionals.


Digital Marketing Workshop

Digital Marketing Workshop

Unlock the Power of Digital Marketing: Join us for an immersive online experience designed to empower you with the skills and knowledge needed to excel in the dynamic world of digital marketing. In just three days, you will transform into a proficient digital marketer, equipped to craft and implement successful online strategies.


Online Apps to train Category Managers

Online Apps to train Category Managers


The Plannogrammer is an experiential learning facility for category managers, trade marketers, and retailers in consumer markets. Ideally suited for hybrid learning programmes, Plannogrammer imparts hands-on training in the planning and evaluation of promotions and merchandising.

It supports a collection of simulation and analysis platforms such as Promotions and Space Planner for optimizing space and promotions, Plannogram for populating shelves and merchandising, a Due To Analysis dashboard that decomposes brand sales into the factors driving sales, and a Promotion Evaluator to evaluate the volume, value and profit impact of promotion plans.