SOLVING LOGISTIC TASKS WITH THE TOOLS OF THE TABULAR PROCESSOR EXCEL

Abstract

Goal. The article aims at solving the problem of using table processor Microsoft Excel for building a model of developing a plan for grain crop transportation using motor transport with minimum expenditures. Grain crop is transported from specific grain crop storage to specific users. The cost of transportation of 1 ton of grain crop from suppliers to consumers is set. Problem. Almost all examples of building such models and solving such tasks have an abstract approach, which doesn’t deal with any branch of science, manufacturing or education. Methodology of solving such a problem is in using methods of linear programming, which take into consideration two common basic features. The first feature is presence of restrictions. The second feature is that each model of linear programming has a single index, which must be minimized or maximized. Originality. Originality is in one of the Excel’s possibilities of solving problems of linear programming - finding a solution. Practical value is in possibility of building linear models very simply and fast and getting the results of solving transportation problems by making appropriate decisions.

Authors and Affiliations

D. P. Labenko

Keywords

Related Articles

METHODS TO CALCULATE AND EVALUATE THE EFFICIENCY OF COMBINED TRAFFIC MODE IN THE CONTEXT OF URBAN BUS ROUTES

Despite certain governmental support, the efficiency of urban passenger transport remains low under the current inflation. Improved economic feasibility of AOCs is possible if only combined operation mode for buses is im...

ON THE POTENTIAL OF TECHNOLOGICAL ASSETS OF AUTOMOBILE FLEETS

The algorithm for estimating the savings potential of technological assets of trucking companies is proposed. Rrecommendations on organization of work with an efficient use of energy resources are given. The ways of achi...

TEACHING IMPROVEMENT OF THE COURSE IN FUNDAMENTALS OF OCCUPATIONAL SAFETY DUE TO APPLICATION OF IT TECHNOLOGIES

An example of an electronic textbook on Fundamentals of Occupational Safety and a specialized program for test control of knowledge on the discipline developed for Electrical Engineering students has been presented. The...

ПРИСТРІЙ ДЛЯ ГІДРОІМПУЛЬСНОЇ ОЧИСТКИ ПОВЕРХОНЬ

Розглянуто проблеми відновлення робочих поверхонь шляхом гідроімпульсної очистки, наведено промивний пристрій.

[b]APPLICATION OF MECHATRONIC PRINCIPLES WHILE TRACTION  TESTING OFF-ROAD TECHNOLOGICAL VEHICLES[/b]  

Components of mechatronic information-measuring complex for traction testing off-road tech-nological vehicles have been considered. 

Download PDF file
  • EP ID EP483617
  • DOI 10.30977/BUL.2219-5548.2018.83.0.74
  • Views 103
  • Downloads 0

How To Cite

D. P. Labenko (2018). SOLVING LOGISTIC TASKS WITH THE TOOLS OF THE TABULAR PROCESSOR EXCEL. Вестник Харьковского национального автомобильно-дорожного университета, 83(), 74-77. https://europub.co.uk/articles/-A-483617