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

Šedivý Josef (), Čejka Jiří () and Guchenko Mykola ()
Additional contact information
Šedivý Josef: University of Pardubice., Department of Transport Management, Marketing and Logistics, Studentská 95, 532 10 Pardubice, Czech Republic
Čejka Jiří: Institute of Technology and Business in České Budějovice., Department of Informatics and Natural Sciences, Okružní 517/10, 370 01 České Budějovice, Czech Republic
Guchenko Mykola: Kremenchuk Mykhailo Ostrogradskyi National University., Department of Computer and Information Systems, Pershotravneva st. 20, 39600 Kremenchuk, Ukraine

LOGI – Scientific Journal on Transport and Logistics, 2020, vol. 11, issue 1, 78-87

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.

Keywords: Vehicle routing problems; travelling salesman problem; optimization; Microsoft Excel; Solver (search for similar items in EconPapers)
Date: 2020
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
https://doi.org/10.2478/logi-2020-0008 (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:vrs:logitl:v:11:y:2020:i:1:p:78-87:n:8

DOI: 10.2478/logi-2020-0008

Access Statistics for this article

LOGI – Scientific Journal on Transport and Logistics is currently edited by Rudolf Kampf

More articles in LOGI – Scientific Journal on Transport and Logistics from Sciendo
Bibliographic data for series maintained by Peter Golla ().