<abstract xmlns="http://www.w3.org/1999/xhtml"><p>The article deals with the possible application of the Solver optimization module to solving the single-circuit transport problems. First, the article describes the single-circuit transport problems and the optimization module Solver itself. Using the specific model example of beer distribution, the author demonstrates the algorithm which may be applied to solving single-circuit transport problems by means of Solver. The travel route designed by Solver is then compared with the originally proposed route. The values being compared include the total length of travel routes created and the associated variable costs spent on serving customers and also route design time. Thus, using the practical example of beer distribution, the manuscript has demonstrated the algorithm which is used for addressing the single-circuit transport problems. Nonetheless, possible application of the Solver tool is not limited to seeking a solution to the travelling salesman problem only. It can also be implemented even to discussing the multi-circuit transport problems with various confinements.</p></abstract>

The article deals with the possible application of the Solver optimization module to solving the single-circuit transport problems. First, the article describes the single-circuit transport problems and the optimization module Solver itself. Using the specific model example of beer distribution, the author demonstrates the algorithm which may be applied to solving single-circuit transport problems by means of Solver. The travel route designed by Solver is then compared with the originally proposed route. The values being compared include the total length of travel routes created and the associated variable costs spent on serving customers and also route design time. Thus, using the practical example of beer distribution, the manuscript has demonstrated the algorithm which is used for addressing the single-circuit transport problems. Nonetheless, possible application of the Solver tool is not limited to seeking a solution to the travelling salesman problem only. It can also be implemented even to discussing the multi-circuit transport problems with various confinements.

Possible Application of Solver Optimization Module for Solving Single-circuit Transport Problems

Department of Transport Management, Marketing and Logistics

Department of Informatics and Natural Sciences

Kremenchuk Mykhailo Ostrogradskyi National University

Department of Computer and Information Systems

LOGI – Scientific Journal on Transport and Logistics

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

The article deals with the possible application of the Solver optimization module to solving the single-circuit transport problems. First, the article...

Possible Application of Solver Optimization Module for Solving Single-circuit Transport Problems

Data publikacji: 29 maj 2020

Zakres stron: 78 - 87

DOI: https://doi.org/10.2478/logi-2020-0008

Słowa kluczowe
Vehicle routing problems, travelling salesman problem, optimization, Microsoft Excel, Solver

© 2020 Josef Šedivý et al., published by Sciendo

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Possible Application of Solver Optimization Module for Solving Single-circuit Transport Problems

Data publikacji: 29 maj 2020

Zakres stron: 78 - 87

DOI: https://doi.org/10.2478/logi-2020-0008

Słowa kluczoweVehicle routing problems, travelling salesman problem, optimization, Microsoft Excel, Solver

© 2020 Josef Šedivý et al., published by Sciendo

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Słowa kluczowe
Vehicle routing problems, travelling salesman problem, optimization, Microsoft Excel, Solver