2021
DOI: 10.3390/a14040106
|View full text |Cite
|
Sign up to set email alerts
|

Optimization of the Multi-Facility Location Problem Using Widely Available Office Software

Abstract: Multi-facility location problem is a type of task often solved (not only) in logistics. It consists in finding the optimal location of the required number of centers for a given number of points. One of the possible solutions is to use the principle of the genetic algorithm. The Solver add-in, which uses the evolutionary method, is available in the Excel office software. It was used to solve the benchmark in 4 levels of difficulty (from 5 centers for 25 points to 20 centers for 100 points), and one task from p… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
2
2
1

Citation Types

0
7
0

Year Published

2022
2022
2024
2024

Publication Types

Select...
6

Relationship

0
6

Authors

Journals

citations
Cited by 9 publications
(7 citation statements)
references
References 28 publications
0
7
0
Order By: Relevance
“…It relies on controlled sampling combined with deterministic methods to explore the search space efficiently. Second, it can handle non-smooth and discontinuous functions [ 37 ]. The evolutionary method parameters were the population size, random seed, mutation rate, convergence value, and maximum time without improvement.…”
Section: Optimization Algorithmmentioning
confidence: 99%
“…It relies on controlled sampling combined with deterministic methods to explore the search space efficiently. Second, it can handle non-smooth and discontinuous functions [ 37 ]. The evolutionary method parameters were the population size, random seed, mutation rate, convergence value, and maximum time without improvement.…”
Section: Optimization Algorithmmentioning
confidence: 99%
“…This prevents GRG from yielding optimal solutions since it cannot properly account for the non-smooth areas where curvature information is undefined. On the other hand, EA relies on random sampling with localized deterministic searching to effectively explore wide search space 14 , 30 . Moreover, EA can accommodate discontinuous and non-smooth objective functions, unlike gradient-based techniques which require continuous differentiable formulas 31 .…”
Section: Optimization Algorithmmentioning
confidence: 99%
“…With the equations presented in the previous topic (Pumping of cutting fluid in the system), a system of equations was formulated to solve the objective problem [20]: determine the pressure variation of the flow system as shown below. In the software, the Solver add-in aims to find the values for variables that meet all the constraints of the mathematical model [20] and that can also minimize or maximize the value of a function [16], using the GRG (Generalized Reduced Gradient) numerical method [21]. The system performs interactions using onedimensional research through a variation of Newton's method [22].…”
Section: Determination Of System Pressure Variation For Pump Validationmentioning
confidence: 99%