Моделювання в процесі прийняття рішення про придбання обладнання з врахуванням обмеження площі розміщення та розміру інвестицій
Journal Title: Математичне моделювання - Year 2017, Vol 1, Issue 2
Abstract
SIMULATION IN THE PROCESS OF MAKING DECISIONS ABOUT PURCHASING EQUIPMENT TAKING INTO ACCOUNT THE LIMITATIONS OF THE LOCATION AND OF THE SIZE THE INVESTMENT Karimov I.K., Karimov G.I. Abstract In the process of making administrative decisions frequently adapt the methods of the mathematical programming, realization of which is connected with the need for the mastery of sufficiently complex mathematical apparatus and the large volume of calculations. For the specialists, whose basic work is not connected with mathematics, this approach leads to some difficulties and creates the imperative need for the search of the alternative methods of solution of problem. The purpose of a study is the analysis of the special features of the use of a tabular processor MS Excel for the solution of the problems of integral linear programming, development and approval of two-stage algorithm for solving the optimization problem of the distribution of investments into the acquisition of equipment. The formulation of the problem assumes the acquisition of the equipment of several forms for the modernization of production with the limitations to the area of arrangement and the size of investments. Basic purpose is to ensure maximum general productivity. Case study showed that there are several versions of the solution, and they are characterized by not only the distribution of investments into the purchase of the equipment of different types, but also by the necessary for the arrangement area and with the total volume of investments. Last fact gives grounds to assume classical solution of problem as the first stage of optimization. In the second stage it is proposed to solve the task of the minimization of costs of equipment. The general productivity of section must be not less than at the previous step. The results of solution of standard problem on the basis of the approach proposed testify about the possibility of an essential improvement in the administrative solution due to the considerable savings of means for the purchase of equipment. The most attractive features of the proposed approach include the ease of computer realization, simplicity and naturalness of the interpretation of results. The special features of the application of the proposed approach in the cases of the introduction of the additional characteristics of equipment (reliability, the accessibility of spare parts, the operating costs, etc) require further study. References [1] Eddowes M., Stensfield R. Metody prinyatiya reshenij. [Decision making techniques] – M.: UNITI, 1997. – 590 p. [2] Hamdy А. Taha. Vvedenie v issledovanie operacij. [Operations research. An introduction] – M. : Publishing house “Williams”, 2001. – 912 p. [3] Vovk V.M., Zomchak L.M. Optimizacijni metody i modeli. [Optimization methods and models] – Lviv: LNU, 2014. – 360 p. [4] Uliyanchenko O.V. Doslidgennea operacij v ekonovici. [Operations research in economics] – Sumi: Dovkillya, 2010. – 594 p. [5] Chemeris A., Jurinec R., Mishishin O., M. Metody optimizacii v ekonomici. [Optimization methods in economics] – K.: Center for academic publications, 2006. –152 p. [6] Kugda T., Glushak M., Modeluvannyaupravlinscih procesiv z vikoristannyam tipovih modelej menedzmentu. [Modelling managerial processes using typical models of management] /Galician economic bulletin – Ternopil : TNTU, 2014. – Volume 44. – № 1. – P. 11–21. [7] Kundrat A.M., Kundrat M.M. Naukovo-tehnichni obchislennya zasobami MathCAD i MS Excel. [Scientific and technical computing by means of MathCAD and MS Excel] – Rivne: NUVGP, 2014 – 252 p. [8] Porshnev S.V., Belenkova I.V. Chislennye metody na baze MathCAD [Numerical methods based on MathCAD] – SPb .: BHV-Petersburg, 2005. – 464 p. [9] Medvedev M.G., Listopad V.V.,Shoha V.P., Dva pidhodi do rozvyazannya ekonomichnih zadach optimizacii z dopomogoy Microsoft Excel [Two approaches to solving economic optimization problems using Microsoft Excel] //Intellect ХХІ. – 2014. – №2. – P. 111–118.
Authors and Affiliations
І. К. Карімов, Г. І. Карімов
Keywords
Related Articles
- EP ID EP276929
- DOI -
- Views 50
- Downloads 0
Адаптивная модель системы оценки психофизиологического состояния человека
The article deals with the problem of improving the accuracy and reliability of information about biomedical psychophysiological conditionof the human body based on adaptive computer model evaluation system. The model ta...
Оптимізація хімічного складу жаростійкого сплаву для виготовлення нагрівальних елементів
OPTIMIZATION OF THE CHEMICAL COMPOSITION OF HEAT-RESISTANT ALLOY FOR PRODUCTION OF HEATING ELEMENTS Grechka O.V., Mishchenko V.G. Abstract The development of metallurgy, engineering and chemical industry is associated w...
Математическая модель плавления утяжеленного комбинированного алюмосодержащего раскислителя цилиндрической формы в защитной оболочке
This article presents the one- and two-dimensional mathematical model of melting aluminum-weighted combined deoxidizer cylindrical shape in the containment in the melt and asymmetric boundary conditions at the interface...
Про оптимізацію параметрів системи автоматизованого обліку навчальної діяльності студента
ABOUT OPTIMISATION OF AUTOMATIC COUNTING’S PARAMETERS OF STUDENT STUDYING PROCESS Olyinik L.O., Kravets M.Yu. Abstract In the whole work authors focus on the problem of studying process automation. It is one of the most...
Дослідження алгоритму зміни поперечної різностінності на трубопрокатному агрегаті з автоматичним станом
RESEARCH OF THE ALGORITHM OF TRANSVERSE WALL THICKNESS DEVIATION OF PIPE WHICH HAS BEEN ROLLED ON THE TRP (TUBE ROLLING PLANT) WITH AUTOMATIC MILL Sokurenko V.P., Drozhzha P.V., Bikovec K.M. Abstract Seamless steel tube...