Using Excel solver to find optimal warehouse locations
HTML-код
- Опубликовано: 23 окт 2022
- Where is the optimal warehouse location to minimize shipping cost? Why is Lexington, KY an appealing logistic location?
RUclips users who are not students of UH may download the data file using the following Patreon link (subscription required):
/ data-files-for-72826747
great timing I was looking for a tool to help advise on next warehouse location.. thanks Ye Hu, great work..
Thanks bro. This really helped me!
how to calculate hoy many warehouses i need for next deploy the location analysys?
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?
In the two warehouses case, fix the location of one of the warehouses (existing). Use both warehouses to calculate the total shipping cost, and then minimize the cost by solving for only the location of the second warehouse.
Got it. Thank you so much!
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.
It sounds like the "branches" are like the "warehouses" in this video. The specific setup depends on what you are trying to optimize.
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?
Yes, you can factor in the costs of shipping. And yes, you can extrapolate this to more warehouses, similar to what the video does from one warehouse to two warehouses.
big brain
what is total number of shipments sir , without fixing warehouse how can determine total no of shipments
Warehouse location has nothing to do with shipment. Imagine Amazon, shipments are how many products Amazon sells in each region. An optimal warehouse location would minimize the total cost of shipments.
🧠