Travis Perkins uses supply chain analytics from SAS to optimize inventory across its 2,000 stores
Product availability and superior customer service are essential for retailers to attract and retain customers. Understanding the data behind products, suppliers, distribution and stores is critical to running a successful business. And that’s precisely what Travis Perkins is doing.
Travis Perkins is the UK’s leading builders’ merchant and home improvement retailer, operating four divisions and 2,000 branches nationwide, with annual revenues exceeding US$7.8 billion. In total, the group sells over 200,000 unique stock-keeping units (SKUs), ranging from plumbing and heating products to tiles, roofing and insulation.
“Many of the goods we sell are bulky, and space in our physical stores is limited,” says Peter Brewer, Supply Chain Development Manager at Travis Perkins. “We have an extensive range available on short lead times within our supply chain, but we need to identify and stock in-branch the products most important to our customers for immediate supply.
“The vast majority of our customers purchase in-branch, rather than online or over the phone. They like to inspect items, check measurements, pick up materials, then head to their next job, as they often run a packed schedule. If the branch they visit doesn’t have the items they need, they can leave frustrated and empty-handed, and we risk losing them as a customer. To mitigate this risk, we wanted to equip category managers with detailed data to help them make informed decisions about which products to stock at each branch.”
In the past, Travis Perkins managed inventory using spreadsheets fed into a legacy core system. To decide which products to stock at each branch, category managers had to sift through thousands of rows of data. The process was time consuming, and gaining insight was arduous. To help category managers make smarter decisions and work more productively, the company set out to build a better way of working.
SAS helps us gain deeper insight into the demand for individual products at a very granular level ... we can optimize our inventory to meet customer demand, put our limited store space to the best possible use and lift sales. Aaron Jenkins Plumbing and Heating Category Manager Travis Perkins
Laying the foundation of success
Travis Perkins decided to transform its approach to inventory management using SAS® solutions. For help on the journey, the company enlisted CoreCompete, a SAS partner specializing in analytics.
“Most range management solutions available on the market would not have been able to deal with the volume of products we stock or the complexity of our organization,” Brewer says. “SAS and CoreCompete proposed a robust solution that could cope with the size and diversity of our business and allowed us to layer sophisticated analytics over traditional range-management capabilities. We were particularly impressed with the purpose-built dashboards and user interface of the SAS offering.
“To turn our vision into reality, we needed an implementation partner with the right know-how to make the project a success,” Brewer continues. “We selected CoreCompete because they have significant experience in this area and demonstrated an exceptional knowledge of SAS solutions. Our choice paid off, as CoreCompete helped us complete the SAS implementation in a remarkably tight timeframe.”
Travis Perkins – Facts & Figures
Paving the way to greater sales and customer loyalty
Today, Travis Perkins gathers data on sales, customers, branches, suppliers and more using SAS Data Integration Studio. With the data in a single repository, category managers can slice and dice it from a category, branch, supplier or customer perspective using SAS Visual Analytics. As a result, they can make better decisions about which products to stock in each branch, without cumbersome number crunching.
“SAS helps us gain deeper insight into the demand for individual products at a very granular level,” says Aaron Jenkins, Category Manager in the plumbing and heating division of Travis Perkins. “Armed with that insight, we can optimize our inventory to meet customer demand, put our limited store space to the best possible use and lift sales. Critically, when customers visit us, we are more likely to have their desired items in stock, so they get a better experience, and we can boost their satisfaction and loyalty.”
With SAS, Travis Perkins doesn’t just see what is going on, but can also pinpoint the reasons behind changes in the numbers. “In the past, we could see fluctuations in sales of each product, but we couldn’t work out what was driving them,” Jenkins says. “Now, we have detailed data at our fingertips, so we can join the dots between products, customers and branches to build a clear picture of what’s going on.
“For example, if sales of certain products at one branch increase, we can see whether they are being purchased by one big customer or lots of little ones. If there’s one customer buying goods in bulk, we can examine their activity in isolation, so that their exceptional purchases don’t distort our average sales figures,” Jenkins explains. “Of course, if we recognize that we have major customers making lots of purchases, we can speak to them to get a better understanding of their needs, and ensure we stock the right products for them.”
With the new solutions, Travis Perkins has also gained deeper insight into its dealings with each supplier.
“We can see the number of products we buy from each supplier, including our profit margins and any bulk-buy discounts we receive. What’s more, we can see if, for example, a particular supplier contributes to 60 percent of our sales but just 40 percent of our profits, so we can better understand the value of the relationship,” Jenkins says. “That insight is especially handy if you’re negotiating a contract renewal.”
Previously, when Travis Perkins performed range management using spreadsheets, different people used slightly different formulas to calculate certain key metrics. By standardizing on SAS solutions, the company has built greater consistency across the business.
“Cutting-edge solutions from SAS are helping us optimize our inventory across our huge branch network,” Brewer says. “We’re confident that our investment in SAS will pay off by helping us drive sales, avoid stocking excess inventory and deliver a stellar customer experience.”
본 문서에 나오는 결과는 본 문서에 설명된 특정 상황, 비즈니스 모델, 데이터 입력 및 컴퓨팅 환경에 적합하게 되어 있습니다. 각 SAS 고객의 경험은 고유한 것으로, 비즈니스 및 기술적 변수에 따라 달라집니다. 따라서 모든 서술은 비전형적인 것이라는 점을 고려해야 합니다. 실제 절약, 결과 및 성능 특성은 개별 고객의 구성 및 조건에 따라 달라질 수 있습니다. SAS는 모든 고객이 비슷한 결과를 달성할 수 있다고 보증하거나 진술하지 않습니다. SAS 제품과 서비스에 대한 유일한 보증은 해당 제품 및 서비스에 대한 서면 계약의 보증서에 명시되어 있습니다. 본 문서의 어떠한 내용도 추가 보증을 구성하는 것으로 해석될 수 없습니다. 고객은 SAS 소프트웨어의 성공적인 구현에 따라 합의된 계약적 교환 또는 프로젝트 성공 요약의 일환으로 성공 사례를 SAS와 공유했습니다. 브랜드 및 제품 명칭은 각 기업의 상표입니다.