Using Excel solver to find optimal warehouse locations

preview_player
Показать описание
Where is the optimal warehouse location to minimize shipping cost? Why is Lexington, KY an appealing logistic location?

YouTube users who are not students of UH may download the data file using the following Patreon link (subscription required):
  1. Ye Hu
Рекомендации по теме
Using Excel Solver 0:00:48

Using Excel Solver to find which numbers add up to a given sum - Excel Cell by Cell

Excel Solver - 0:09:57

Excel Solver - Example and Step-By-Step Explanation

How to install 0:00:45

How to install Solver Add-in in Excel

Using The Excel 0:05:56

Using The Excel Solver To Find The Price That Maximizes Profit

Exponential Smoothing in 0:04:49

Exponential Smoothing in Excel (Find α) | Use Solver to find smoothing constant alpha

Using Excel solver 0:21:00

Using Excel solver to find optimal warehouse locations

Find numbers in 0:03:58

Find numbers in sum [Excel Solver]

Use the Excel 0:05:29

Use the Excel Solver to Find the value of a simple Optimization Problem

RRB JE 2024 0:55:43

RRB JE 2024 CBT-1: Express Series | Time & Work Classes by Narendra Matta Sir | ACE Online

Adding Solver to 0:02:40

Adding Solver to Excel | Solver Excel Add-in

Using Excel evolutionary 0:08:37

Using Excel evolutionary solver to find the shortest distance for a traveling salesperson (updated)

Using the Excel 0:04:20

Using the Excel Solver to find break even / etc

Using Excel solver 0:20:00

Using Excel solver to find optimal warehouse locations (updated)

Excel Solver & 0:23:34

Excel Solver & Goal Seek Tutorial

Solve Linear Program 0:05:22

Solve Linear Program problem in Excel (Solver)

Maximum and minimum 0:05:44

Maximum and minimum of a function | 'Solver' tool [Ep:02]

Solver in Excel 0:10:57

Solver in Excel - Step by Step Tutorial

Identify numbers that 0:06:34

Identify numbers that sum up to a target value (Solver)

Optimal portfolios with 0:06:22

Optimal portfolios with Excel Solver

Linear Programming Sensitivity 0:07:00

Linear Programming Sensitivity Analysis - Interpreting Excel's Solver Report

Using Excel evolutionary 0:08:38

Using Excel evolutionary solver to find the shortest distance for a traveling salesperson

Using the Solver 0:08:10

Using the Solver Add In to Find an Optimal Product Mix in Excel

Using Excel 2016 0:07:42

Using Excel 2016 Solver to Find the Optimum Value of Alpha for an Exponential Smoothing Forecast

Finding the Best 0:02:45

Finding the Best Warehouse Location Using Excel Solver

Комментарии
Автор

great timing I was looking for a tool to help advise on next warehouse location.. thanks Ye Hu, great work..

drew
Автор

hello sir, can i ask you how to choose solving methods when solving a problem? thank you

anhnguyentai
Автор

how to calculate hoy many warehouses i need for next deploy the location analysys?

ing.franciscolopez
Автор

Hello, thank you for your detailed explanations! What about if there are existing warehouses in the network, and you’re trying to solve for where the next warehouse should be?

nann
Автор

Thanks so much for the video. Can you give me a hint how to apply the video to solve my problem? We have a headquarters' location fixed and we want to find optimal location for several branches.

MinhNguyen-hkxk
Автор

If I was to hypothetically calculate the "cost" of said DC(s) I can use a cost per mile value on top of the distance × #shipments?

Also, I could extrapolate this out to 3, 4, 5, DCs by updating new min distance columns, and changing the solver for new line of lat/long?

andrewsaysyes
Автор

what is total number of shipments sir, without fixing warehouse how can determine total no of shipments

vrpriceactiontrades