Optimization of the Complex Multi-Facility Location Problem using Microsoft Excel
The result's identifiers
Result code in IS VaVaI
<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F60162694%3AG42__%2F24%3A00560202" target="_blank" >RIV/60162694:G42__/24:00560202 - isvavai.cz</a>
Result on the web
<a href="https://www.magnanimitas.cz/ADALTA/1301/PDF/1301.pdf" target="_blank" >https://www.magnanimitas.cz/ADALTA/1301/PDF/1301.pdf</a>
DOI - Digital Object Identifier
—
Alternative languages
Result language
angličtina
Original language name
Optimization of the Complex Multi-Facility Location Problem using Microsoft Excel
Original language description
The article presents the possibility of solving a complex Multi Facility Location Problem in Excel and its use in military practice. Based on a simple model example (25 branches, 5 centers), it gradually verifies the individual steps leading to the solution of the optimization requirement of increasing (decreasing) the number of centers, weight of branches, capacity of centers, and forbidden (permitted) areas. These examples are solved using the evolutionary method in Excel. Finally, this method solves an example in the range of 100 to 3 and the result is verified by calculation by the metaheuristic method. This demonstrates the ability to solve this type of tasks in the proposed way.
Czech name
—
Czech description
—
Classification
Type
J<sub>imp</sub> - Article in a specialist periodical, which is included in the Web of Science database
CEP classification
—
OECD FORD branch
10700 - Other natural sciences
Result continuities
Project
—
Continuities
S - Specificky vyzkum na vysokych skolach
Others
Publication year
2023
Confidentiality
S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů
Data specific for result type
Name of the periodical
AD ALTA: Journal of Interdisciplinary Research
ISSN
1804-7890
e-ISSN
2464-6733
Volume of the periodical
13
Issue of the periodical within the volume
1
Country of publishing house
CZ - CZECH REPUBLIC
Number of pages
13
Pages from-to
332-344
UT code for WoS article
001027245000057
EID of the result in the Scopus database
—