Pairing advanced analytics with intuitive tools to transform retail markdown management

| Article

Retailers face a multitude of challenges when it comes to pricing during the clearance cycle (Exhibit 1). Merchants are under tremendous pressure to both improve margins and manage inventory, but they often use a “peanut butter” approach—using the same pricing strategy across a range of products—regardless of item or store-level performance. This thinking is usually driven by a lack of clarity about the approach or a lack of data or tools that would make pricing during the clearance cycle more effective and efficient.

Pricing during the markdown cycle is often both ineffective and inefficient.

In this article, we lay out a vision for an approach to markdown management many retailers need, and we address the common questions that naturally arise when thinking about how to bring this approach to life. In our experience, this approach typically generates four to eight percent in markdown margin rate improvement—potentially worth millions of dollars to the bottom line—with relatively quick time to impact (12–14 weeks).

Four critical questions underpin best-in-class markdown management

Retailers should pay close attention to a few factors related to making decisions about clearance items.

  • What items should be put on clearance, given their performance during the season?
  • Where should the items be put on clearance, given performance across their footprints?
  • When should the items be sent to clearance to balance the markdown budget and achieve margin impact and sell-through targets?
  • How deep should the clearance price be to achieve the margin and sell-through goals?

The ‘what’ and the ‘where’

Segmenting products at the store level enables merchants to understand pockets of underperformance.

Identifying the right items to mark down and where to mark those items down is grounded in the ability to visualize the item’s performance in the current season compared with its plan. By aggregating in-season item performance data with the item’s plan in a simple visualization tool, merchants can visually identify “stars” and “dogs” in the portfolio. As a result, merchants can detect which items are performing well and can be held back from clearance, and detect underperforming items that should be sent to markdown more quickly in order to maximize margins across the product set.

Similarly, the segmentation of items can be executed at the store level, which enables merchants to understand pockets of underperformance across the store network in custom groups, such as assortment tier or climate zone (Exhibit 2). After visualizing performance, merchants have a clear understanding of what items to mark down and where those items should be sent to clearance.

The ‘when’ and the ‘how deep’

Setting the optimal clearance price requires leveraging consumer-centric analytics and configured business rules from merchants and planners to set the right discount level (Exhibit 3). For the items identified by merchants through the visualization, an optimal clearance price can be identified using easy-to-use tools to optimize gross margins and sell-through, subject to a set of business rules or constraints.

Consumer demand analytics are then utilized to predict the expected sales pattern and financial impact of executing the optimal clearance price. This “accessible” advanced-analytics approach builds conviction and transparent logic merchants and planners can test before taking action. Merchants and planners can use these analytics to run scenario analyses on the prices and timing of markdown to maximize their overall goals.

Sustainable impact is supported through a standard process.

Building sustainable impact through a people-driven approach

Retailers should be cognizant of common barriers to adoption when implementing a new process and any big data and analytics tool that goes along with it. Data can be incomplete or inaccessible, and there are varying levels of excitement among employees in adopting a new approach.

For employees with a lack of knowledge or comfort in analytics, it is critical that the tools merchants use be simple and intuitive to ensure adoption. We have opened the aperture of the breadth of analytics that teams can perform to better understand the consumer and trends in the business, and have built these tools with the end user in mind by designing backward—showing what they need to know and running the advanced analytics in the background.

Would you like to learn more about our Retail Practice?

As we work with the organization to operationalize, scale, and fully transfer ownership of markdown management, we ensure that the new process is embedded to enable maximum value capture. There are a few markers of success:

  • pinpoint elements of existing processes that need to change to incorporate the right touchpoints and decisions
  • identify an executive sponsor who conveys support, sets targets, and role models the behavior of data-driven decisions versus intuition
  • engage all areas of the business—including business intelligence, engineering, data science, merchant and planning, and central pricing–to achieve the set of targets and to be liable for tracking to the key performance indicators
  • set early goals of running pilots to prove impact while continuously refining the approach to increase buy-in and adoption

Markdowns can be optimized through intuitive tools grounded in advanced analytics (Exhibit 4).

By optimizing markdowns, retailers can drive impact quickly.

Too often, retailers take a peanut-butter approach to clearance pricing, which leads to suboptimal margin generation and sell-through. Markdown management aims to answer four questions: what, where, when, and how much to markdown. The ability to source, integrate, cleanse, and aggregate large data sets is becoming a commodity. Using accessible tools that support advanced analytics will ensure that the right prices are set and the desired impact is achieved. New processes and operating models should be put in place to ensure sustainable adoption.

Explore a career with us