Retail Analytics — Assortment Analysis


Exhibit 29.5   Assortment optimization.

Retailers are grappling constantly with a vast number of brands and items, as also the continual 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 across sections in Chapter Sales and Distribution. It is important also for the retailer to examine the proportion of shoppers who buy (% buyers), and particularly those who exclusively buy listed items. A low selling item might have relatively high base of shoppers who exclusively buy it. If the item is de-listed, some of the shoppers may switch to other stores, in which case the retailer stands to lose their total spend in store.

Exhibit 29.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 base of buyers. Observe, at the tail end, items r and v have a high proportion of exclusive buyers. Since these shoppers exhibit high loyalty to items r and v, the retailer should probably refrain from de-listing them; or do so only after careful consideration.

Previous     Next

Note: To find content on MarketingMind type the acronym ‘MM’ followed by your query into the search bar. For example, if you enter ‘mm consumer analytics’ into Chrome’s search bar, relevant pages from MarketingMind will appear in Google’s result pages.







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.