You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.
Background & Challenge
A subscription-based retail company ships boxes to 600,000 customers across the United States each week. The business relies on a number of shipping carriers to deliver boxes reliably and efficiently. The shipping method and carrier for each box was selected by default based on the destination’s zip code rather than an intelligent solution that could assess a number of factors.
The company sought to optimize their supply chain operations and minimize the cost of distributing boxes to customers. To accomplish this in a quick and efficient way, they chose the leading data blending and advanced analytics platform Alteryx.
As a close partner of Alteryx with experience in supply chain analytics, Keyrus took on the project to assist in productionizing and further developing their proof of concept (PoC) model. The project’s goals were to evaluate the optimization challenge and business objectives, assess the PoC, and implement an automated workflow that would save significant cost.
Solution
Our team implemented an Alteryx workflow that developed cost data for different shipping methods. Unlike the previous system, the workflow included box weight, which significantly affects shipping costs. It also connects to Google sheets, Big Query, and various APIs to calculate the shipping costs for every possible method. The company can run the workflow once a week to adjust the shipping carriers and select the most economical option.
Although we were initially focused solely on shipping costs at a box level, we also assessed delivery truck utilization in order to further optimize supply chain operations. The company pays for each truck they use, therefore it’s often more beneficial to sacrifice cost a box level to eliminate a truck entirely.
The solution produces an Excel report every week to summarize all of the needed boxes and trucks, then sends this information to shipping carriers as well as to their own internal packing facilities.
Results
The company now uses an intelligent workflow that helps optimize their supply chain. At a box level, the workflow saves $30,000 each week in shipping costs. Optimizing at the truck level saves an additional $10,000 each week. The automated report saves two days of work each week for one full time employee. Together, these results were significant enough to gain the attention of top management, who recently asked Keyrus to assess efficiencies in other business lines. We look forward to continuing our work together.
Never miss an insight
Stay updated on the latest articles, events, and more
Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.
Continue reading
Press release
Keyrus named amongst Top B2B Companies on Clutch
The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader.
Webinar
PDF Parsing with Alteryx Intelligence Suite
In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.
Webinar
Modern Cloud Analytics in Action: Keyrus and Red Ventures
The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.
Event
Pharma/Biotech GTN Summit 2022
Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit
Press release
Keyrus Achieves AWS Data and Analytics Competency Status
Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.
Webinar
Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)
Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)
Webinar
Tableau Embedded Analytics: Optimizing insights from Salesforce data
Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.
Success story
How C&S Wholesale Grocers maximized ROI with an analytics center of excellence
C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.
Success story
Implementing a cloud security automation tool at a global consulting firm
Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.
Success story
Leveraging Salesforce to improve operations at Pajama Program
Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.