Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Success Stories

Learn how Alteryx customers transform their organizations using data and analytics.
STORIES WANTED

Showcase your achievements in the Maveryx Community by submitting a Success Story now!

SUBMISSION INSTRUCTIONS

Corsicana Mattress Optimizes Shipping Routes and Saves $5 Million

ThalitaC
Alteryx Alumni (Retired)
4C.Corsicana.TM.png
 
Overview of Use Case

Having grown from a family-owned business to one of the largest mattress manufacturers in the United States, Corsicana Mattress wanted to improve efficiencies across the enterprise. Ramzey Zbeida and the logistics team created a spatial analysis to realign facility assignments and optimize shipping routes. They estimate an annual saving of $5 million and over 250 metric tons of CO2 emissions annually.  

 
Describe the business challenge or problem you needed to solve

Corsicana Mattress Company is celebrating its 50th anniversary this year. It grew from a family-owned business in a cottage industry to one of the largest mattress manufacturers in the United States. Like many firms experiencing rapid growth, efficiency was not as high a priority as serving the needs of Customers and delivering on commitments to maintain their hard-earned trust. After being acquired by private equity, attention turned to increasing efficiencies across the enterprise. Given the nature of our product, freight is costly. Our loads always cube out before they weigh out. The Logistics team explored every possible option to reduce fixed and variable freight costs, but were limited by their analytical capabilities.

 

As a leader in the Analytics team, I was more familiar with our data than most. I had seen instances of orders being fulfilled out of a plant that was not the default facility for the Ship To location in question and had to account for this in my analysis and reporting. In some cases, this was done to avoid delays due to material availability or capacity. However, in other instances it was apparent that every order for a Ship To was being manually reassigned to a facility other than the location’s default. Upon further investigation, it emerged that our schedulers knew a Ship To had been improperly assigned, but instead of the assignment being corrected they manually reassigned each of the locations’ orders to the optimal facility.

 

In the case of returns, however, the schedulers were not involved in setting appointments and so a truck would be sent from the default facility to make a pickup. Since this was also a manual intervention, schedulers did not catch every order so in some cases the shipment would be routed through a facility potentially hundreds of road-miles further away. Even though Logistics knew these errors in facility assignments were costly they had no way to audit default facility assignments without manually checking Google Maps for driving distances, until we began using Alteryx.

 

Describe your working solution

The solution to this challenge emerged through an iterative process in cooperation with our Logistics Director. After a meeting in which we discussed Logistics cost savings initiatives, I asked about this problem I had noticed with facility assignments. The team was aware of the issue and implemented process changes to ensure that all new Ship Tos were assigned to the default facility that was closest. However, when it came to auditing the facility assignments of the more than 25,000 Ship Tos in our system, the team saw this as beyond their capacity. Thankfully, this process was ripe for automation by leveraging the point-to-point driving distance calculation capabilities of Alteryx.

 

Annotated Workflow Screenshot.png

 

The first step in our journey involved assessing the scope of the problem. We geocoded our facilities and the locations we ship to and used the Find Nearest macro. By selecting a driving distance metric as the criteria for finding the nearest facility, we generated a list of the closest facility for every Ship To. When comparing this list with our existing default facility assignments, it was clear that we had potentially thousands of incorrect assignments.

 

Narrowing the scope and defining the impact to capacity utilization at each facility were the focus of the second phase of our analysis. To get buy-in from leadership on realigning facility assignments we needed to be able to speak in concrete terms about impacts. To do this, I filtered out prospective default facility reassignments where the distance savings between current and proposed default facility were relatively small.

 

In these cases, labor rate differentials between facilities could have swamped the freight savings. We also wanted to limit the volume we would be shifting around the network. To enable this we blended in stats on the number of orders shipped to each location that had traveled further than necessary over the prior 12 months. In the end, our analysis resulted in a list of potential default facility reassignments ranked by their savings potential. We could estimate how many road-miles would have been avoided over the preceding 12 months if the location had been serviced from the facility we were recommending. Most importantly, when our COO decided we needed to close one of our facilities we were able to simulate this by filtering the facility from our analysis to identify the optimal way to reassign the locations that were serviced by the defunct plant.

 
Describe the benefits you have achieved

The impact of the spatial analysis workflows we built to support this initiative is still unfolding. As changes occur or simulated impacts of network changes are requested, we revisit them and reuse them as appropriate. Being able to tap into the location intelligence capabilities typically only accessible to large multinational corporations has been highly impactful. Especially throughout the past year when disruption was so widespread, it became vital to be able to quickly understand the impacts of shifting volume from a facility that had to suspend operations due to local COVID restrictions.

 

We have not yet conducted a retrospective analysis to determine realized freight cost savings and we did not implement all proposed default facility reassignments. The primary reason was the need to operate within capacity constraints. However, the analysis was sound and if we were able to perfectly realize all the savings identified we estimated it would mitigate up to 2.5 million road-miles on an annual basis across the network. Even at a conservative estimate of $2 per mile, this would translate to an annual savings of $5 million.

 

More importantly to me, given that I worked on a year-long GHG mitigation policy project while a graduate student at the LBJ School of Public Affairs, as a member of the transport sector team nonetheless, this could have mitigated substantial CO2 emissions. By my back-of-the-envelope calculations, over 250 metric tons annually. This is power of analytics: to expose inefficiency and identify opportunities to revisit assumptions. By keeping an open mind and methodically pursuing continuous improvements, we can alter outcomes once taken as given.

 
Comments
joshuaburkhow
ACE Emeritus
ACE Emeritus

@rzbeidaCMC Such a great use case! Just love all the 'hidden' gems like quickly being able to run scenarios on closing of a location! 

rzbeidaCMC
6 - Meteoroid

@joshuaburkhow Thanks for your feedback! I am glad others in the community are benefiting from this use case being shared.

 

You may enjoy listening to the Alter Everything podcast episode I recorded after the Excellence Award was announced for this case. I enjoyed sharing my reflections on what helped take this from a random thought to a workflow that changed how we operated.

demlaelu
5 - Atom

It is a great use case, not only to understand how Alteryx can provide a way to see and resolve an issue, but also, how once created, the same workflow can be modified easily to provide many more fast check points and resolutions to other existing issues. 

 

rzbeidaCMC
6 - Meteoroid

Thanks for your thoughts, demlaelu! I agree, this case does show the flexibility of Designer to conduct sensitivity analysis or model scenarios for planning.

 

In my experience, building a workflow is usually the starting point of a conversation for an analyst. There are usually follow-on questions that can be answered relatively easily with a well-placed filter or by revising queries to expand the dataset.

Kishan25896
5 - Atom

Great Use Case.

Daniel_B_82
Alteryx
Alteryx

Great use case! Love that the spatial analysis workflow provided cost benefit to the company and as an added benefit reduced CO2 emissions. 

BOUSAAD_Imane22
5 - Atom

Great Use case, would you share with us the .yxzp file

rzbeidaCMC
6 - Meteoroid

@BOUSAAD_Imane22 I will see if I can get approval to share. I would need to prep some dummy data to make it usable as well. If you want to connect privately it may be easier.