title: Ð¡Ð¸ÑÑÐµÐ¼Ð° Ð¿Ð¾Ð´Ð´ÐµÑÐ¶ÐºÐ¸ Ð¿ÑÐ¸Ð½ÑÑÐ¸Ñ ÑÐµÑÐµÐ½Ð¸Ð¹ Ð¿Ð¾ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¸ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð±ÑÐ´Ð¶ÐµÑÐ° ÐºÐ°Ð¿Ð¸ÑÐ°Ð»ÑÐ½ÑÑ Ð²Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Decision support system on the formation and optimization of the budget of capital investments of enterprises
Creators: name: ÐÐ¸ÑÐ°Ð¹Ð»Ð¾Ð², ÐÐ°Ð²ÐµÐ»
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: ÐÐ½Ð¾Ð³Ð¾ÐºÑÐ¸ÑÐµÑÐ¸Ð°Ð»ÑÐ½Ð°Ñ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ
Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ Ð¿Ð¾ ÐÐ°ÑÐµÑÐ¾
Ð¼ÐµÑÐ¾Ð´ Ð¸Ð´ÐµÐ°Ð»ÑÐ½Ð¾Ð¹ ÑÐ¾ÑÐºÐ¸
ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ðµ Ð±ÑÐ´Ð¶ÐµÑÐ°
Ð¿ÑÐ¸Ð½ÑÑÐ¸Ðµ ÑÐµÑÐµÐ½Ð¸Ð¹
ÑÐ¸ÑÑÐµÐ¼Ð° Ð¿Ð¾Ð´Ð´ÐµÑÐ¶ÐºÐ¸
ÐºÐ°Ð¿Ð¸ÑÐ°Ð»ÑÐ½ÑÐµ Ð²Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ
Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ
web-Ð¸Ð½ÑÐµÑÑÐµÐ¹Ñ
Python
Ð±Ð¸Ð±Ð¸Ð»Ð¾ÑÐµÐºÐ° Dash
Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ° Pandas.
Multi-criteria optimization
pareto optimization
ideal point method
budget allocation
decision making
support system
capex enterprises
data visualization
web-interface
python
dash library
pandas library

description: ÐÐ±ÑÐµÐºÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐ¸ÑÑÐµÐ¼Ð° Ð¿Ð¾Ð´Ð´ÐµÑÐ¶ÐºÐ¸ Ð¿ÑÐ¸Ð½ÑÑÐ¸Ñ ÑÐµÑÐµÐ½Ð¸Ð¹ Ð¿Ð¾ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¸ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð±ÑÐ´Ð¶ÐµÑÐ° ÐºÐ°Ð¿Ð¸ÑÐ°Ð»ÑÐ½ÑÑ Ð²Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ. ÐÐ°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ ÑÐµÑÐ°Ð»Ð¸ÑÑ Ð² ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ: 1) ÐÐ·ÑÑÐµÐ½Ð¸Ðµ Ð¼ÐµÑÐ¾Ð´Ð¾Ð² ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð±ÑÐ´Ð¶ÐµÑÐ° Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ. 2) Ð¤Ð¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ ÑÑÐµÐ½Ð°ÑÐ¸ÐµÐ² ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð±ÑÐ´Ð¶ÐµÑÐ° ÐºÐ°Ð¿Ð¸ÑÐ°Ð»ÑÐ½ÑÑ Ð²Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ, Ð²ÐºÐ»ÑÑÐ°Ñ Ð¼Ð½Ð¾Ð³Ð¾ÐºÑÐ¸ÑÐµÑÐ¸Ð°Ð»ÑÐ½ÑÑ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ Ð¿ÑÐ¸ Ð¸Ñ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ð¸. 3) ÐÑÑÐ²Ð»ÐµÐ½Ð¸Ðµ Ð¿ÑÐ¸Ð¼ÐµÐ½Ð¸Ð¼Ð¾ÑÑÐ¸ ÑÑÐµÐ½Ð°ÑÐ¸ÐµÐ² Ð´Ð»Ñ Ð´ÐµÑÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ, ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ðµ ÑÑÐµÐ½Ð°ÑÐ¸ÐµÐ². 4) Ð ÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ ÑÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð½ÑÑ ÑÑÐµÐ½Ð°ÑÐ¸ÐµÐ² Ð½Ð° ÑÐ·ÑÐºÐµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Python. 5) Ð ÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ web-Ð¸Ð½ÑÐµÑÑÐµÐ¹ÑÐ° Ð´Ð»Ñ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½ÑÑ ÑÑÐµÐ½Ð°ÑÐ¸ÑÐ¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ. Ð ÑÐ¾Ð´Ðµ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ»Ð¸ ÑÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ñ ÑÑÐµÐ½Ð°ÑÐ¸Ð¸ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð±ÑÐ´Ð¶ÐµÑÐ° ÐºÐ°Ð¿Ð¸ÑÐ°Ð»ÑÐ½ÑÑ Ð²Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð¿Ð¾ÑÑÐµÐ±Ð½Ð¾ÑÑÐµÐ¹ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ, Ð° ÑÐ°ÐºÐ¶Ðµ ÑÑÐµÐ½Ð°ÑÐ¸Ð¸ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð¼ÐµÑÐ¾Ð´Ð¾Ð² Ð¼Ð½Ð¾Ð³Ð¾ÐºÑÐ¸ÑÐµÑÐ¸Ð°Ð»ÑÐ½Ð¾Ð¹ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ (Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ Ð¿Ð¾ ÐÐ°ÑÐµÑÐ¾ Ð¸ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ Ð¼ÐµÑÐ¾Ð´Ð¾Ð¼ Ð¸Ð´ÐµÐ°Ð»ÑÐ½Ð¾Ð¹ ÑÐ¾ÑÐºÐ¸). ÐÐ¾ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ°Ð¼ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ ÑÑÐµÐ½Ð°ÑÐ¸ÐµÐ², Ð±ÑÐ»Ð¾ Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¾ ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ðµ Ð¼ÐµÐ¶Ð´Ñ Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½ÑÐ¼Ð¸ ÑÑÐµÐ½Ð°ÑÐ¸ÑÐ¼Ð¸ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð±ÑÐ´Ð¶ÐµÑÐ°. ÐÐ° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð´Ð°Ð½Ð½ÑÑ ÑÑÐµÐ½Ð°ÑÐ¸ÐµÐ² Ð±ÑÐ»Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ñ ÐºÐ¾Ð´Ñ Ð½Ð° ÑÐ·ÑÐºÐµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Python Ð¿ÑÐ¸ Ð¿Ð¾Ð¼Ð¾ÑÐ¸ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸ Pandas, ÐºÐ¾ÑÐ¾ÑÑÐ¹ Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÑÑ Ð¾Ð±ÑÐ°Ð±Ð°ÑÑÐ²Ð°ÑÑ Ð´Ð°Ð½Ð½ÑÐµ Ð¸Ð· ÑÐ»ÐµÐºÑÑÐ¾Ð½Ð½ÑÑ ÑÐ°Ð±Ð»Ð¸Ñ Ð¾Ñ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ. Ð Ð´Ð°Ð»ÑÐ½ÐµÐ¹ÑÐµÐ¼ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð´Ð°Ð½Ð½ÑÑ ÑÐ°Ð±Ð»Ð¸Ñ Ð±ÑÐ»Ð¸ Ð¸Ð½ÑÐµÐ³ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ñ Ð² web-Ð¸Ð½ÑÐµÑÑÐµÐ¹Ñ, ÐºÐ¾ÑÐ¾ÑÑÐ¹ ÑÐ°ÐºÐ¶Ðµ Ð±ÑÐ» ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½ Ð½Ð° ÑÐ·ÑÐºÐµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Python Ð¿ÑÐ¸ Ð¿Ð¾Ð¼Ð¾ÑÐ¸ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸ Dash. Ð ÐµÐ·ÑÐ»ÑÑÐ°Ñ ÑÐ°Ð±Ð¾ÑÑ Ð¼Ð¾Ð¶Ð½Ð¾ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÑ Ð´Ð»Ñ Ð¿ÑÐµÐ´Ð¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð½Ð°Ð³Ð»ÑÐ´Ð½Ð¾Ð¹ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÐºÐ¸ Ð´Ð»Ñ Ð¿ÑÐ¸Ð½ÑÑÐ¸Ð¹ ÑÐµÑÐµÐ½Ð¸Ð¹ Ð¾ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ð¸ Ð±ÑÐ´Ð¶ÐµÑÐ° ÐºÐ°Ð¿Ð¸ÑÐ°Ð»ÑÐ½ÑÑ Ð²Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸Ñ, Ð° ÑÐ°ÐºÐ¶Ðµ Ð´Ð»Ñ Ð¾ÑÐµÐ½ÐºÐ¸ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð±ÑÐ´Ð¶ÐµÑÐ° Ð² ÑÐ°Ð·ÑÐµÐ·Ðµ ÑÐ°Ð¼Ð¸Ñ ÑÑÐµÐ½Ð°ÑÐ¸ÐµÐ² Ð¸Ð»Ð¸ Ð¶Ðµ Ð² ÑÐ°Ð·ÑÐµÐ·Ðµ Ð´Ð¾ÑÐµÑÐ½Ð¸Ñ Ð·Ð°Ð²Ð¸ÑÐ¸Ð¼ÑÑ ÐÐ±ÑÐµÑÑÐ², ÐºÐ¾ÑÐ¾ÑÐ¾Ðµ ÐºÐ¾Ð½ÑÑÐ¾Ð»Ð¸ÑÑÐµÑÑÑ Ð¿ÑÐµÐ´Ð¿ÑÐ¸ÑÑÐ¸ÐµÐ¼.
description: The object of the study is a decision support system for the formation and optimization of the capital investment budget of the enterprise. Tasks that were solved during the study: 1) Study of methods of allocation of the enterprise budget. 2) Formation of scenarios for the allocation of the budget of capital investments of the enterprise, including multi-criteria optimization during their formation. 3) Determining the applicability of scenarios to the companys activities, comparing and analyzing budget allocation scenarios among themselves in order to identify their weaknesses and strengths 4) Implementation of generated budget allocation scenarios in the Python programming language. 5) Implementation of a web interface for visualizing data processed by scripts in the form of graphs and diagrams. In the course of the work, scenarios for the distribution of the companys capital investment budget were formed based on the needs of the enterprise, as well as distribution scenarios based on multi-criteria optimization methods (Pareto optimization and optimization by the ideal point method). Based on the results of the formation of scenarios, a comparison was made between the received budget allocation scenarios. Based on these scenarios, Python programming language codes were implemented using the Pandas library, which allows processing data from enterprise spreadsheets. Later, the results of processing these tables were integrated into a web interface, which was also implemented in the Python programming language using the Dash library. The result of the work can be used to provide visual analytics for making decisions about the allocation of the budget of capital investments of the enterprise, as well as to assess the effectiveness of budget allocation in the context of the scenarios themselves or in the context of subsidiaries controlled by the enterprise.