Assortment planning is rarely a simple process for retailers. As companies evolve, the number of factors that need to be considered when making decisions about buy quantities increases exponentially. Growing companies need to factor in additional channels and new locations – shrinking companies need to adapt to new realities and find ways to become more efficient.
Human beings simply aren’t capable of handling the amount of information required to make decisions for each individual location. It’s too resource intensive and the return on investment quickly diminishes as complexity increases.
In light of this, most companies have adopted some method of clustering their stores to simplify decision making.
Simply put, clustering is the process of grouping stores with similar characteristics to make it easier to purchase inventory for those stores. Rather than making dozens (if not more) decisions related to each customer touchpoint, managers, planners, buyers and allocators can make decisions for groups, or “clusters” of stores.
The most common characteristic retailers use to cluster their stores is sales volume. The stores with the highest sales volume form the first cluster, followed by a few clusters of stores with successively lower sales volumes. Following this strategy, merchants can choose to buy certain items only for the stores with the highest sales volumes, where they can actually be sold.
Others may cluster by store size. A small downtown store simply can’t hold the same amount of inventory as a sprawling suburban location. Being able to make decisions about buy quantities based on capacity makes the merchant’s job easier – and prevents stores from being crammed full or left with bare shelves.
Still others may cluster by sales channel. Having separate buy plans for ecommerce and bricks-and-mortar accommodates the “endless aisle” online shoppers expect while managing the physical constraints of traditional stores.
The most advanced retailers, however, cluster by customer demand. Rather than choosing attributes that describe the location (such as the ones above), this strategy revolves around the preferences of the customers shopping in those locations.
Just as you might expect customers in New York City and Portland, Oregon to have different tastes, you might be surprised to find that they tend to share an affinity for certain products. Being able to identify these trends is crucial for getting the right products in front of the right customers.
So how do you identify which products will perform best at which locations?
This is accomplished through indexing, which takes some work up front to examine historical sales data and forecast the season you’re buying for. A baseline is established for each product class, representing the sales volume the typical store is likely to achieve. Stores are given an index of how much product they’re likely to sell relative to the baseline, and locations are clustered based on their indices.
This clustering method allows you to bring buys much more closely in line with customer demand by directly addressing customer preferences by each location. Additionally using assortment planning to tailor buys according to other location characteristics, like country or climate, allows you to plan buy quantities with incredible accuracy.
See also: What is Assortment Planning?
The drawback to this method is that it requires a lot of work up-front and can be difficult to implement if your company uses manual tools to plan assortments. However, the extra effort is quickly rewarded as inventory expenses come under control and customer satisfaction improves.
Whatever method you use to cluster, it’s important to continually re-evaluate. Retail organizations evolve quickly and it’s possible for clusters to become outdated. Whether your company is just getting started with clustering, or your methods are well established, it’s worth taking a step back to evaluate whether the method you’re using is still suiting the needs of the business. If you find your clusters don’t help you match customer demand, you may find your definition of clustering is too narrow.