Download White Paper: Facility Location Optimization

Abstract

Most companies make facility location decisions based on convenience (proximity to employees or existing facility), lease or start-up costs or subjective criteria such as liking a certain location.  In supply chain management we consider facility location decisions to be one of the most strategic and long-lasting decisions a company can make.

In this case study we demonstrate the benefits of determining the optimal solution based on maximizing sales and minimizing costs.  Optimization is an over-used word these days.  Many companies (especially software companies) claim to “optimize” when all they are doing is using some known formula.  Optimization is a solution-method to determine the true best answer. In our case we use optimization modelling (also-known-as linear programming) to determine the best number, location and size of warehouses to maximize our Client’s profit.  This quantitative best answer is then combined with qualitative factors to enable this company to make the best decision.  The result is getting the most sales with the least cost, or maximizing long-term profits.

Background

Our Client is a leading retailer/e-tailer of specialty sporting good equipment in the USA.  They experienced fast growth increasing from three stores in a single market in 2005, to 32 stores spread over 12 markets in 2015.  E-commerce is 35% of our Client’s sales (with the balance generated by their 32 retail stores).  As Amazon has shown, the closer you are to a customer the more likely you are to get their sale.  With companies offering free shipping on all e-commerce sales, and the price-comparison capability of the internet, location, or speed of delivery, is becoming the competitive advantage.  Therefore, our Client wanted to determine where its e-commerce warehouse(s) should be located.  In 2015 they had only one warehouse near where the company was founded in the Midwest.

The Tradeoff: More Sales versus Lower Costs

In 1964 David Huff, a Professor at the University of Texas, developed a facility location formula called the “attraction” model.  He proposed that the likelihood of a customer shopping at your store, versus shopping at a competitor’s store, is a function of the distance from that store.  This “attraction” model is the basis for many companies (Amazon perhaps being the most famous) building e-commerce facilities to be as close as possible to as many customers as possible.  An example of this attraction function is shown below in Figure 1.  The further away a market is from your facility, the lower your share of the sales in that market.

 

One way to get close to all of your customers is to open more warehouses, stores or factories, but that can be expensive.  (Economies of scale dictate that unit costs get lower as facilities get larger because fixed costs are allocated over more volume.)  In addition, sometimes being close to your customers means paying for premium real estate (anyone want to put a warehouse in New York City?).

The key problem you are trying to solve, when locating your warehouse, store or factory is to be as close to as many customers as possible, while minimizing your operating costs, which can broadly be defined as facility operations and shipping.  This is the tradeoff… more sales versus lower costs.

Getting the Data

  • Market potential
  • Market-share by distance function
  • Shipping costs and times
  • Facility opening and operating costs

The data to optimally determine the locations of your facilities is not very complicated, but it will take time to acquire.  The model we developed for our Client (and most facility location optimization models) required determining the market share potential.  If you are trying to maximize your market share, you probably want to maximize it in markets that are the largest.  Therefore, you need to have some understanding of what 100% market share equals in sales.  While this may seem daunting, if you don’t know the market potential, how can you make any plans based on serving a market?  Estimates such as the number of potential customers in a market and the sales per customer are a great starting point.

The next step is understanding what effect distance, or delivery time, has on market share.  This is presented in the equation below.

Market Share % = 1 / (Delivery Time * Market Share Factor)

As an example, the “market share factor” used in Figure 1 above is three.  Given this factor, if our Client has an e-commerce warehouse one day away from a market, we would expect to get 33% of the e-commerce orders originating in this market.  Two days away equals 16.5% market share, three days equals 8.25%, and four days equals 4.125%.  The “market share factor” is determined by management.  We recommend that you run sensitivity analysis on this factor to ensure that you evaluate the highest and lowest possible market share and therefore make fully-informed decisions.  Ultimately people, not an optimization model, make the final decision.

You will need to get data from your shipping sources of the distance and cost from each potential site to each customer location.  If you have thousands of customers you can summarize your customer-locations into groups, such as metropolitan service areas (MSAs).  MSA data is also available from the government census.

The last data needed are facility opening and operating costs.  This includes rent, labor, utilities, inventory holding cost and others to represent your ongoing operating costs, and moving, construction, installation, and equipment purchases for your facility opening costs.  The costs you gather should represent the operating cost differences throughout the regions in the US.

What is Optimization Modelling?

Optimization modelling (also known as linear programming) is a mathematical solution methodology that short-cuts to the absolute best answer.  The problem our Client was evaluating has over 64 million possible solutions.  However, the optimization model only had to evaluate about 10,000 choices to find the highest profit warehouse locations and sizes.  The model simultaneously maximizes sales and minimizes shipping and facility costs by choosing which warehouses to open, the size of each warehouse and the primary shipping locations for each market (or MSA).

Model Results

Without using the optimization model, our Client was planning to keep their original Midwest warehouse and open a single large warehouse in the Northeast.  This seemed logical as the Midwest warehouse served a large number of markets in one to two days.  The proposed Northeast warehouse (to be located in eastern Pennsylvania, which is a popular site for distribution centers) would handle the large Northeast and New England markets in one to two days.  This solution generated a profit of $6.9 million.

Instead, the optimization model’s solution was to open five small warehouses; one in the West, one in the upper Midwest, one in the “Ohio Valley”, one in the Mid-Atlantic and one in New England.  These five sites increased profit to $8.7 million, a 25% increase!  These five sites were more expensive, increasing facilities costs from about $1 million to $1.5 million.  However, sales due to the shorter delivery time to most major markets increased by $5 million.  In addition the average delivery time across the network was 2.5 days in the baseline design versus 1.95 days in the optimal solution.

To quote the CEO, these results defied common-sense.  “Why wouldn’t we keep our existing warehouse and add one more equally large warehouse in the Northeast?”  Closing the existing warehouse and opening five small facilities in different cities just didn’t make sense.  However, when there are 64 million possible solutions, common-sense may not be the best decision making tool.

Sensitivity Analysis

When using inputs, such as the market-share earned by being close to a market, or the e-commerce market share due to having retail stores in a market (See Figure 1 above), it is best to conduct sensitivity analysis.  In this case we changed the percentages due to these market shares to evaluate best and worst case scenarios.

Decision Support, Not Decision Making

Sensitivity analysis is so important because optimization models are decision support tools, not decision making tools.  At the end of this process we didn’t expect management to simply implement the model’s solution.  It takes a combination of qualitative criteria and quantitative answers to make the best decision.

Management decided to leave the original warehouse open but halve its size.  Having a warehouse in the same facility as the supply chain, marketing and customer service functions improves access to inventory for multiple purposes.  In addition, the “Ohio Valley” location was moved from the recommendation, a secondary market, to one of our Client’s top markets, which was only 60 miles away.  It was a bit more expensive, and slightly reduced sales, but there are other non-quantifiable factors including ease of flying and the desire to have a warehouse near large markets.

Conclusion

Locating your facility is an important and difficult-to-change decision.  It should be done with a blend of qualitative criteria and optimization solutions.  Including optimization in the analysis can result in a dramatic difference in company profitability and service to customers.

"*" indicates required fields

Ask us your Lean, Six Sigma, or Supply Chain question.

We're the experts! We'll get back within 48 hrs. with a valuable response.

This field is for validation purposes and should be left unchanged.

“We are pleased that Essex selected Supply Velocity, Inc. as our Lean Implementation Partner. At one facility, we have saved over $350,000 in work-in-process inventory, reduced throughput time from 2 weeks to minutes and increased inventory turns 3 to 8 times per year. All these results are in just 6 months. Our return of investment is very high.”
Terry Etter, Vice President of Operations , Essex Medical Systems
“We engaged with Supply Velocity to help us embed process improvement at all levels of the business. Our team learned from Mitch to let the data drive decisions, to use Lean tools to help us see our processes critically and objectively, and to create a control plan to manage all of the tasks that were the outcome of the data study.

The project turned out to be very significant to the company and most importantly, our customers. We reduced our customer wait times by 40%, and cut in half the labor cost to fulfill customer orders.

Some results are not able to be measured. However, as a result of this project, we have started to build a Lean mindset and culture, which is part of our strategic mission to save our customers money. Supply Velocity has been a valued partner in this mission.”

Dionne Dumitru, COO, Weekends Only
“Supply Velocity is driving instrumental change in our inventory management processes. This is critical for us to be competitive in a supply chain environment with numerous disruptions. They are making change happen, which can be challenging in a 182 year old organization.”
Jim Carroll, Executive Vice President Operations, Schaeffer Manufacturing
“Closure Medical recently completed a major reorganization in order to enhance our ability to rapidly create innovative medical devices. We hired Supply Velocity to help us map out the process and service flows of the new organization that would maximize our product development process (PDP). In four weeks, Supply Velocity helped us envision a new PDP structure, develop measures and accountability for each step, and gain consensus within the organization. Supply Velocity’s focus on speed and accountability helped us complete a critical project in a timely fashion.”
Gabe Szabo, Vice President, Product Development, Closure Medical – A Division of Johnson & Johnson

“I am thrilled to provide this testimonial for Supply Velocity and their outstanding work in implementing Lean Warehouses and processes at Crescent Parts & Equipment through the COVID pandemic. With their data-first focus and Mitch’s exceptional coaching and experience, they transformed our business into a more supply chain-oriented organization, enabling us to grow while prioritizing employee safety and creating a better work environment. Supply Velocity’s expertise in Lean methodologies and their comprehensive evaluation of our customers have been instrumental in optimizing our operations and increasing customer satisfaction. We highly recommend Supply Velocity to any company seeking to implement Lean processes and enhance their supply chain efficiency.”

Josh Cole, Director of Supply Chain, Crescent Parts & Equipment
“Myerson engaged Supply Velocity, specifically Ray Davis to visit our plant in Trinidad to conduct a two day assessment of our production procedures and provide us feedback on areas for improvement and where applicable, areas for future analysis.

Put simply, we got everything we paid for and in addition to more in depth analysis, we got specific tasks that were immediately actionable. Our local management team found Ray to be engaging, highly credible and insightful based on his wide experience. In other words the cultural differences and lack of specific industry knowledge weren’t impediments to things we could implement immediately and on our own. In a nutshell it was money well spent and will pay itself back many times over.”

Lee Hartwell CPA, Plant Manager, Myerson Tooth

“Supply Velocity created visibility within our Assurance Services Group… visibility of performance, Client-service, employee satisfaction and processing time. Using the Supply Velocity System, Audit Report Cycle time is down over 50%. We are using his strategies to create greater Client loyalty.”

Fred Kostecki, Partner-In-Charge, Assurance Services, Rubin Brown
“We used Supply Velocity on our Warehouse optimization project. One of the key characteristics of Supply Velocity is that they listened to our requirements and provided a clear path for our Warehouse processes using lean tools and our future sales growth as objectives.”
Haris Tokalic, President, Grand Rock, Inc.
“For several years we have worked with Supply Velocity to support us with their expertise on Lean Operations and Supply Chain Management. Supply Velocity has helped us implement Lean, improve our inventory systems, and educate our people. They are professionals who are always available to help us as needed.”
Lorenza Pasetti, CEO, Volpi Foods

“Supply Velocity gave us the tools to analyze our business and processes based on the facts and numbers versus our perceptions. Our common quote was “Let the numbers lead us”. The key for our organization was how quickly we moved from classroom to actual project initiation. We were able to jump in, start using the tools and see a difference right away.

The get-into-action approach was good for our culture.”

Ned Lane, President, CeeKay Supply
“Supply Velocity has helped Clean succeed in a number of ways. First, they provided the education that kicked off our Lean Process Improvement journey. They also facilitated a number of large supply chain and process improvement projects including: 1) building quality into our direct-labor productivity incentive program, 2) designing the layout of our garment warehouse, and 3) streamlining our route service process.

We have integrated the methods that Supply Velocity taught us into our management and strategic planning. In the process our quality measurement has improved 22% from 2013 to 2015, we have reduced required annual labor by 2200 hours from the garment facility layout project and we’ve seen 50% decrease in error rate. Obviously the numbers speak for themselves, but just as important, Supply Velocity has been fun to work and have become true partners. They have “taught us how to fish” so our internal teams are able to implement change on their own, with the skills we learned from Supply Velocity. This relationship has been invaluable.”

Jeff Lazaroff, Senior Vice President, Clean Uniform
“We are using Supply Velocity’s Lean Six Sigma methods to analyze a variety of processes including rationalizing SKUs (stock-keeping-units). By using math to evaluate SKUs we took some of the emotion out of our decisions. We expect significant increases in sales and productivity from reducing poor performing SKUs.”
Mark Kelso, Director of Process Improvement, Save-A-Lot
“C&R was struggling with labor productivity. The construction crews were often missing materials that they needed to do their work. This caused significant idle time. Supply Velocity, Inc. and C&R used value stream mapping and visual management tools to make dramatic improvements in operations. Most importantly, two years later C&R is sustaining and improving on the implementation. C&R’s return on investment was 11:1. C&R had a record year last year in both sales and profits and would not have been able to pull it off without the changes Supply Velocity, Inc. helped us make.”
Tom Kuthe, V.P. Construction Operations, C&R Mechanical
“We used Supply Velocity to rethink our sales process. By analyzing the entire process we found wasted time in our Sales, Admin and Operations departments. Streamlining this process created extra time for each Sales Rep, allowing them to spend more time with Customers and increase the value we add. Gross profit margins are up 40%!

We are now using Supply Velocity to help us rethink our entire Strategic Plan.”

Jeff Reitz, Vice President, Central States Bus
“The role of the Erie Insurance Marketing Department has been evolving over the past several years – from a support role to a more critical role of driving growth in our organization. Because of our increased workload and desire to prioritize the most critical projects, we hired Supply Velocity to teach us the skills of Lean Six Sigma.

Participants included the Promotions, Market Research and Agency Licensing sections of the Marketing Department.

We learned valuable tools to help us to prioritize based on the voice of the customer.

I firmly believe these skills made a difference in how we work every day. We are moving new projects forward, eliminating or changing ineffective processes, and we are a much stronger department. We continue to use the tools to help us with our highly-complex and time-consuming projects. Supply Velocity helped us to accomplish our goals.”

Karen Rugare, Director of Marketing, Erie Insurance
“Supply Velocity has provided the technical expertise and political capital to move our project forward. They have just the right amount of push and the right amount of support. Supply Velocity has helped us make real changes to improve efficiencies in logistics without jeopardizing our performance. We’re happy and our customers are happy.”
David Walters, President, Hy-C
“Isolating a problem, finding short, and long term solutions with measurable results is what was promised and results is what was delivered by Supply Velocity. Upon launch of the Lean Six Sigma Selling System, we knew more about our customers, our products, and were able to create a solid plan to increase sales of our most profitable products. Within months of implementation, our booked sales jumped 60% and our most valued customers were getting direct, active, and calculable attention.”
Mark A. Presker, General Manager, Architectural Millwork of St. Louis

“In a time of volatile supply chain disruption, Supply Velocity is helping us develop Demand and Supply Planning processes to proactively tackle these new challenges. They are genuine partners, working with our team, facilitating and teaching.”

Jane Thrasher, Vice President of Supply Chain, Horizon Hobby
“Supply Velocity’s Lean Six Sigma System has given us new tools to help improve our sales performance. We have learned new ways to analyze our business which makes problem solving more accurate and has made us better leaders.”
Rachel Andreasson, Executive Vice President – Marketing, Wallis Companies

“Your process encourages this group to work together, better communicate and have fun doing it.”

George Edinger, President, C&R Mechanical
“Mitch Millstein and his team helped guide our shop fabrication division in the re-layout of our custom pipe and steel fabrication facility when we moved into a new building. It is not only the results but how he helped. We were involved in every step. I personally did time studies and was able to see the non-value added steps required to manufacture in our old layout. When we created our new layout, everyone was involved, from the executive team to our direct labor force. With Mitch’s help we increased our throughput by a 3x multiple, while providing more competitive prices to our clients as a result of the efficiency improvements.

This has enabled us to not only make more money but also to expand our commercial reach and serve more, and larger customers. I would recommend Supply Velocity to any company that wants to make improvement in supply chain and operations.”

Geoff Gross, President, Gross Mechanical
“In thirty years of hiring consultants, Supply Velocity, Inc. was the first to tell me what they were going to do, set a price they stuck to and substantially exceed my expectations. I have recommended them to friends and acquaintances. They were true partners in assisting with the turnaround of an acquisition we had been struggling with for two years.

Their math-based technology, solid down-to-earth facilitation skills, and positive, patient and enthusiastic attitude combined to make our implementation of Lean a very rewarding experience.

We increased our production by 50% in the first month of implementation and continue to see improvements. Improvements have not only been realized in productivity, but also in quality and morale. We have increased profitability by $2M on flat sales of $10M.

Based on Supply Velocity, Inc.’s integrity and our results, I will continue to refer them to others and utilize them in the future as we expand our company through acquisitions.”

Bill Gilbert, President, Fusion Coatings
“Many thanks to all three Supply Velocity presenters. I think you guys took a very difficult time for learning and capitalized on everyone’s time and training needs. I truly hope this helps your business as this was a considerable undertaking on the part of Supply Velocity. Outstanding!!”
Mark Holdinghausen, VP of Operations, DEMA Engineering
“Anheuser-Busch Precision Printing had been implementing Lean Operations on our own for the past two years. We needed to move faster and partnered with Supply Velocity, Inc. Through Supply Velocity, Inc.’s mathematical workflow balancing and visual management tools, dramatic improvements were achieved. The entire converting operation was rearranged based on Lean principles. The result is a 20.6% productivity improvement, enabling us to operate with 23 fewer people in production.”
Rich Lavosky, General Manager, Anheuser-Busch Precision Printing
“In 2015 we began working with Dr. Mitch Millstein to optimize our inventory locations supporting e-commerce and in-store inventory needs. From this work we developed a new omni-channel warehousing and inventory plan that entirely redefined our approach to warehousing, inventory management, store distribution and fulfillment. As a result of the analyses by Dr. Millstein we have begun the move to an improved omni-channel design by reassigning MSAs to new warehouses, greater leveraging of in-store inventories to satisfy e-commerce demands, and exploring acquisitions of new warehousing space in strategic locations. We have already seen an improvement of $300,000 from both more efficient shipping strategies due to better inventory management.”
Rob Bowers, Vice President of Strategy, Total Hockey
“In the spring of 2003, the St. Louis Area Chapter of the American Red Cross engaged Supply Velocity, Inc. to perform a study and make recommendations to streamline office processes, maximize cash flow in purchasing and warehousing and restructure and enhance our maintenance department. Supply Velocity, Inc.’s process was methodical, flexible, staff-oriented, inclusive and, above all, trackable.

In the last six months, our Chapter has realized expense savings of over $380,000 annually, and significant improvement in intra-company service levels has been attained. Supply Velocity, Inc. will return to the Chapter periodically throughout the next 18 months to audit our newly implemented processes. We have been pleased with our results and Supply Velocity, Inc.’s professionalism.”

Joe White, CEO, American Red Cross – Saint Louis Chapter
“Our experience with Supply Velocity was one of the best values we have ever had from a consulting project. Cyril Narishkin brought a structured lean methodology, invaluable experience and engaging facilitation skills to help us streamline a very complex and disjointed sales order process. Just as importantly, our team now has the knowledge and process competencies to address other business improvement opportunities going forward.”
Mike Howard, CEO, Aspeq