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

[b]THE STUDY OF BULK SOLIDS MOTION IN THE FEED HOPPER OF VERTICAL SCREW CONVEYERS[/b]

A mathematical model for feeding vertical screw conveyers has been proposed. An algorithm of numerical solution of the system of differential equations with derivatives for bulk solids motion in the feed screw has been d...

DEVELOPMENT AND USE OF VIDEOTUTORIALS ON THE BASIC SECTIONS OF COMPUTER GRAPHICS IN THE EDUCATIONAL PROCESS

The questions of effective educational tasks preparation for development of computer modeling of engineering parts were considered. On their basis, video tutorials for learning 3D modeling in the Autodesk Inventor enviro...

НАПРАВЛЕНЕ РЕГУЛЮВАННЯ ТЕРМОВ’ЯЗКОПРУЖНИХ ВЛАСТИВОСТЕЙ АСФАЛЬТОБЕТОНУ

Запропоновано регулювати термомеханічні властивості асфальтобетону відповідно до умов його роботи в конструкції дорожнього одягу. Для цього використовуються критерії граничного стану і сучасні наукові положення теорії тв...

IMPACT OF OPERATING CONDITIONS ON THE DURABILITY OF LARGE-SIZE TYRES 

Regularities of variations in characteristics of large-size tyre durability under varying oper-ating factors e.g. load and speed modes, tyre pressure, road and climatic working conditions have been analyzed.

TO THE QUESTION ON CLASSIFICATION OF CONTAMINENTS OF COMBUSTION ENGINES TAKING INTO ACCOUNT CHARACTER OF MORBIDITY OF URBAN POPULATION  

The analysis of classification of contaminents of produced by ICE is conducted depending on chemical composition and features. It is offered bringing to introduce to the groups of contaminents descriptions of their impac...

Download PDF file
  • EP ID EP483617
  • DOI 10.30977/BUL.2219-5548.2018.83.0.74
  • Views 111
  • 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