J 2020

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

ŠEDIVÝ, Josef; Jiří ČEJKA and Mykola GUCHENKO

Basic information

Original name

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

Authors

ŠEDIVÝ, Josef; Jiří ČEJKA and Mykola GUCHENKO

Edition

LOGI - Scientific Journal on Transport and Logistics, Warsaw, Poland, De Gruyter Poland, 2020, 2336-3037

Other information

Language

English

Type of outcome

Article in a journal

Field of Study

20104 Transport engineering

Country of publisher

Poland

Confidentiality degree

is not subject to a state or trade secret

References:

Marked to be transferred to RIV

Yes

RIV identification code

RIV/75081431:_____/20:00002173

Organization unit

Institute of Technology and Business in České Budějovice

EID Scopus

Keywords in English

vehicle routing problems; travelling salesman problem; optimization; Microsoft Excel; Solver

Tags

Changed: 27/10/2021 07:35, Mgr. Nikola Petříková

Abstract

In the original language

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.

Files attached

Possible_Application_of_Solver_Optimization_Module_for_Solving_Single-circuit_Transport_Problems.pdf
Request the author's version of the file