SOLVING LOGISTIC TASKS WITH THE TOOLS OF THE TABULAR PROCESSOR EXCEL
Journal Title: Вестник Харьковского национального автомобильно-дорожного университета - Year 2018, Vol 83, Issue
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
ОСОБЕННОСТИ РАБОТЫ УСКОРИТЕЛЬНОГО КЛАПАНА УСОВЕРШЕНСТВОВАННОЙ КОНСТРУКЦИИ
Приведена конструкция усовершенствованного ускорительного клапана. На основе результатов математического моделирования рабочих процессов, протекающих во время работы ускорительного клапана, показано отличие предлагаемой...
THE CONTENT AND STRUCTURE OF MODELING THE PROCESS OF BRIDGE STRUCTURES OPERATION
In the analysis of the actual situation arising from the operation of bridges, the situation «as is» is the original model for the simulation of the state «as it should be». In accordance with the objectives set there is...
[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.
[b]DEVELOPING A SEMI-EMPIRICAL METHOD OF CONSTRUCTING A GENERALIZED PARAMETRIC MODEL OF MINE HOIST DRUMS [/b]
A semi-empirical method enabling a substantiated approach to selecting parameters of mine hoist drums has been developed. Its application in design allows creating mine hoists that feature reduced weight, increased stren...
ПРОГНОЗУВАННЯ ДОБОВОЇ ЗМІНИ ТЕРМОВ’ЯЗКОПРУЖНОГО СТАНУ ДОРОЖНЬОГО ОДЯГУ. ЧАСТИНА 1. ПОСТАНОВКА ЗАДАЧІ
Дано математичне формулювання задачі при дослідженні нестаціонарної термов’язкопружної/термопружної поведінки шарів дорожнього одягу на ґрунтовій основі. Граничні умови враховують метеорологічні та дорожні параметри моде...