Autors: FilipovaPetrakieva, S. K., Stankov, I. S.
Title: Automatic solution of transport problems using a new add-in to Excel
Keywords: transport problems (closed and open – with insufficiency or overstock); Simplex method; Add-in to Excel for good data visualization, created by Visual Studio Tools for MS Office

Abstract: Transport problem is a basic problem arising in transportation the products from several distributors to several clients. Its solution consists of determining optimal transportation according to needed allocations of the products. This problem describes with a linear programming model which in general solves with the simplex method. The algorithm of this method is a build-in tool for Excel – SOLVER. Unfortunately when it has a large amount of input data the filling of the Excel’s tables is a very difficult process. Thus, in this paper is suggested an add-in that visualizes and makes it easier to input the initial data. It uses the Visual Studio Tools for the development of the add-ins for MS Office. The main advantage of this solution consists of the user-friendly interface of the mathematical model of the problem which significantly makes easily and good visualization of the input data and final solution in tables. The proposed add-in is applied on the illustrative example.

References

    Issue

    Annual of TU - Sofia, vol. 70, issue 2, pp. 1 - 10, 2020, Bulgaria, ТУ - София, ISSN 1311-0829

    Copyright изд. на ТУ - София

    Вид: статия в списание, публикация в реферирано издание