Chapter 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines

Questions answered in this chapter:

  • Where in the United States should an Internet shipping company locate a single warehouse to minimize the total distance that packages are shipped?

  • Where in the United States should an Internet shipping company locate two warehouses to minimize the total distance that packages are shipped?

Beginning with Excel 2010, Solver has been blessed with many new exciting optimization capabilities. In this chapter (and Chapters 37 and 38), I will explain how these algorithms can help you solve many important optimization problems.

Understanding the GRG Multistart and Evolutionary Solver engines

As I pointed out in Chapter 29, “An Introduction ...

Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.