Aiming to use data and science to set service-level goals, Advance Auto Parts engaged Core Compete to deliver a fully integrated service-level (Inventory) optimization system using SAS® Inventory Optimization and SAS/OR® software. The system has the ability to run inventory simulations and execute large-scale optimization for service-level goal optimization, leveraging the batch services on Amazon Web Services. A very large mixed integer optimization problem for inventory cost reduction is solved using the OPTMODEL procedure. The solution has the ability to recommend optimized service-level goals at the SKU/location level. System design integrates a simple Microsoft Excel user interface, data processing in Apache Hadoop, and optimization in SAS® in the cloud and the dashboards in SAS® Visual Analytics in order to review results. The end-to-end process flow for implementing simulations and optimization in large scale is discussed in this paper.

What You Will Learn in the Whitepaper

  • Inventory Optimization Problem
  • Solution Design
  • Technical Challenges and Resolutions
  • Business Challenges and Resolutions

Download the Whitepaper Today!

Download Now
Optimizing-Inventory-of-Slow-Moving-Products-Using-SAS-Optimization-insights-page2

About Core Compete

Founded in 2012, Core Compete is a pioneer in Cloud Analytics and is based in Durham, North Carolina with offices in Dallas, London and India (Pune and Hyderabad). We currently have 200+ employees and over 450 cloud and technology certifications across these locations, with highly specialized skills including: domain consultants, data scientists, and big data & cloud engineers.  We are an ISO 27001 and SOC 2 certified organization.

We have delivered successful cloud analytics and big data transformations for major corporations worldwide. We partner with AWS, Google Cloud, Microsoft Azure, Snowflake, SAS, Hortonworks and Tableau to deliver the modern, elastic cloud analytic solutions.

We have been recognized as:

  • Consulting Magazine Top 5 Fastest Growing Consulting Firms 2016, 2017 and 2018
  • SAS Partner of the Year (2016, 2018)
  • NC Top 10 Startups to Watch