Digital Transformation: Transforming Range Management to Reduce Inventory and Maximize Availability

The Client

Travis Perkins is a leading British builders merchant and home improvement retailer operating 21 distinct businesses across its branches, with more than 100,000 stock keeping units (SKUs) to manage.

The Challenge

Travis Perkins wanted to reduce inventory while maximizing availability. New capabilities were needed to optimize store inventories and analyze product performance across many attributes through analysis of huge volumes of data. More than 100K products, substitutes, and 1000+ branches of multiple types made this a daunting problem.

The Solution

Core Compete developed a comprehensive bespoke solution for weekly performance reviews and analysis across many attributes. The new solution enables end-to-end annual line reviews, collaboration, and ‘what if’ analysis to simulate product change impacts throughout the supply chain, store-SKU assignments and direct integration into replenishment systems.

Highlights

  • Assortment Optimization to get the right product to the right store

  • End-to-End integration to simplify planogram analytics and execution across multiple banners

  • Analytics that help understand merchandise performance across dimensions like customers, transactions, inventory, sales, promotions etc.

Core Compete in Action

  • Domain

    Large volumes of data including Invoices, Daily Inventory, Customer Master, Planograms, and Trade Promotions. A comprehensive data model enables dynamic insights spanning sales, market basket, and performance related to inventory, promotions, planograms, and branch-specific metrics.

  • Analytics

    Several retail analytics areas were integrated to facilitate end-to-end assortment workflows including Assortment (product-branch) scoring, market basket analyses, and automated outlier detection and elimination to compute standard rates of sale for products.

  • Technology

    The solution was deployed on a Hadoop Data Lake on AWS. Spark was used for automated aggregation routines to address complex large-scale calculations. SAS platform enables visualizations and analytics. Core Compete provides 24/7 management of the environment allowing the client to focus on their business.

  • Agility

    The solution was delivered in phases over a 9 month development and delivery cycle. Within 12 weeks, the data lake was deployed with more than a dozen weekly performance and attribute based analytics dashboards. Subsequent phases addressed planogram management and comprehensive annual line review workflows.

The Result

Travis Perkins has moved closer to the goal of reduced non-productive inventory through a deeper understanding of range performance that drives effective actions. Another big benefit is the elimination of multiple weeks of latency through instantaneous impact analysis of range changes on the supply chain. Changes to the range can now be executed far more easily with more collaboration.

Our site uses cookies to improve your experience. You can control cookies by adjusting your browser or device settings. By using our site and closing this box, you consent to our use of cookies.