Optimization of the Weighted Multi-Facility Location Problem Using MS Excel

Autor: Petr Němec, Petr Stodola, Miroslav Pecina, Jiří Neubauer, Martin Blaha
Jazyk: angličtina
Rok vydání: 2021
Předmět:
Zdroj: Algorithms, Vol 14, Iss 7, p 191 (2021)
Druh dokumentu: article
ISSN: 1999-4893
87052385
DOI: 10.3390/a14070191
Popis: This article presents the possibilities in solving the Weighted Multi-Facility Location Problem and its related optimization tasks using a widely available office software—MS Excel with the Solver add-in. To verify the proposed technique, a set of benchmark instances with various point topologies (regular, combination of regular and random, and random) was designed. The optimization results are compared with results achieved by a metaheuristic algorithm based on simulated annealing principles. The influence of the hardware configuration on the performance achieved by MS Excel Solver is also examined and discussed from both the execution time and accuracy perspectives. The experiments showed that this widely available office software is practical for solving even relatively complex optimization tasks (Weighted Multi-Facility Location Problem with 100 points and 20 centers, which consists of 40 continuous optimization variables in two-dimensional space) with sufficient quality for many real-world applications. The method used is described in detail and step-by-step using an example.
Databáze: Directory of Open Access Journals
Nepřihlášeným uživatelům se plný text nezobrazuje