title: Methodology for optimizing project parameters for integrated development of territories using linear-fractional programming
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
Creators: name: ÐÐ¾Ð¿Ð¾Ð²Ð°, ÐÐºÐ°ÑÐµÑÐ¸Ð½Ð°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2020
Subjects: Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð¿ÑÐ¾ÐµÐºÑ
Ð³ÑÐ°Ð´Ð¾ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÐµ Ð½Ð¾ÑÐ¼Ð°ÑÐ¸Ð²Ñ
Ð¿ÑÐ¾ÐµÐºÑ ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÑÑÐ²Ð°
ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑÐ½Ð¾Ðµ Ð¾ÑÐ²Ð¾ÐµÐ½Ð¸Ðµ ÑÐµÑÑÐ¸ÑÐ¾ÑÐ¸Ð¹
Ð¶Ð¸Ð»Ð¸ÑÐ½Ð¾Ðµ ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÑÑÐ²Ð¾
Ð´ÑÐ¾Ð±Ð½Ð¾-Ð»Ð¸Ð½ÐµÐ¹Ð½Ð¾Ðµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ
Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ
investment and construction project
urban planning standards
construction project
integrated development of territories
housing construction
linear fractional programming
optimization

description: ÐÐ°Ð½Ð½Ð°Ñ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°ÑÐµÐ»ÑÑÐºÐ°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¾Ð¿Ð¸ÑÑÐ²Ð°ÐµÑ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÑ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¸Ñ ÑÐ°ÑÐ°ÐºÑÐµÑÐ¸ÑÑÐ¸Ðº ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑÐ° Ð¾Ð±ÑÐµÐºÑÐ¾Ð² ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÑÑÐ²Ð° Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð´ÑÐ¾Ð±Ð½Ð¾-Ð»Ð¸Ð½ÐµÐ¹Ð½Ð¾Ð³Ð¾ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ. ÐÐ»ÑÑÐµÐ²ÑÐ¼ ÑÐ»ÐµÐ¼ÐµÐ½ÑÐ¾Ð¼ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ð¹ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÐ¸ ÑÐ²Ð»ÑÑÑÑÑ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½ÑÐµ Ð¼Ð¾Ð´ÐµÐ»Ð¸, ÑÐ²Ð»ÑÑÑÐ¸ÐµÑÑ Ð»Ð¸Ð½ÐµÐ¹Ð½ÑÐ¼Ð¸ Ð¾ÑÐ½Ð¾ÑÐ¸ÑÐµÐ»ÑÐ½Ð¾ Ð½ÐµÐ¸Ð·Ð²ÐµÑÑÐ½ÑÑ Ð¿ÐµÑÐµÐ¼ÐµÐ½Ð½ÑÑ Ð¸ Ð¿Ð¾ÑÐ¾Ð¼Ñ ÑÐµÐ°Ð»Ð¸Ð·ÑÐµÐ¼ÑÐµ Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÑÐ¸Ð¼Ð¿Ð»ÐµÐºÑ-Ð¼ÐµÑÐ¾Ð´Ð° Ð² ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½ÑÑ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÑÑÐµÐ´Ð°Ñ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ. ÐÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ðµ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÐ¸ Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ Ð¾Ð¿ÑÐµÐ´ÐµÐ»Ð¸ÑÑ Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾Ðµ ÐºÐ¾Ð»Ð¸ÑÐµÑÑÐ²Ð¾ Ð¶Ð¸Ð»ÑÑ, ÑÐ¾ÑÐ¸Ð°Ð»ÑÐ½ÑÑ Ð¸ Ð¾Ð±ÑÐµÑÑÐ²ÐµÐ½Ð½ÑÑ Ð¾Ð±ÑÐµÐºÑÐ¾Ð² Ñ ÑÑÐµÑÐ¾Ð¼ Ð³ÑÐ°Ð´Ð¾ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð½Ð¾ÑÐ¼ Ð¸ Ð¼Ð°ÐºÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¸Ð½Ð´ÐµÐºÑÐ° ÑÐµÐ½ÑÐ°Ð±ÐµÐ»ÑÐ½Ð¾ÑÑÐ¸.
Ð ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð±ÑÐ»Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ Ð¼Ð¾Ð´ÐµÐ»Ñ Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¿ÑÐ¾Ð´ÑÐºÑÐ° Microsoft Excel Ñ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸ÐµÐ¼ ÑÐ°ÑÑÐ¸ÑÐµÐ½Ð¸Ñ Solver Add-in. Ð ÐºÐ°ÑÐµÑÑÐ²Ðµ Ð¸ÑÑÐ¾ÑÐ½Ð¸ÐºÐ¾Ð² Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð¼Ð¾Ð´ÐµÐ»Ð¸ Ð±ÑÐ»Ð¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ñ Ð½Ð¾ÑÐ¼Ð°ÑÐ¸Ð²Ð½ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÑ, Ð° ÑÐ°ÐºÐ¶Ðµ ÐºÐ°ÑÐ°Ð»Ð¾Ð³Ð¸ ÑÐ¸Ð¿Ð¾Ð²ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð² Ð¶Ð¸Ð»ÑÑ Ð´Ð¾Ð¼Ð¾Ð² Ð¸ Ð¾Ð±ÑÐµÑÑÐ²ÐµÐ½Ð½ÑÑ Ð¾Ð±ÑÐµÐºÑÐ¾Ð².
Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ Ð¼ÐµÑÐ¾Ð´Ð¾Ð»Ð¾Ð³Ð¸Ð¸ Ð±ÑÐ»Ð¾ Ð¿Ð¾Ð»ÑÑÐµÐ½Ð¾ Ð¾Ð¿ÑÐ¸Ð¼Ð°Ð»ÑÐ½Ð¾Ðµ ÐºÐ¾Ð»Ð¸ÑÐµÑÑÐ²Ð¾ Ð¶Ð¸Ð»ÑÑ Ð¸ Ð¸Ð½ÑÑÐ°ÑÑÑÑÐºÑÑÑÐ½ÑÑ Ð¾Ð±ÑÐµÐºÑÐ¾Ð², ÑÐ¾Ð¾ÑÐ²ÐµÑÑÑÐ²ÑÑÑÐµÐµ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸ÑÐ¼ Ð½Ð¾ÑÐ¼Ð°ÑÐ¸Ð²Ð½ÑÑ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾Ð², Ð¸ Ð¾ÑÐ²ÐµÑÐ°ÑÑÐµÐµ ÑÑÐ»Ð¾Ð²Ð¸Ñ Ð¼Ð°ÐºÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¸Ð½Ð´ÐµÐºÑÐ° ÑÐµÐ½ÑÐ°Ð±ÐµÐ»ÑÐ½Ð¾ÑÑÐ¸.
description: This research paper describes a methodology for determining the organizational and technological characteristics of a complex of construction objects based on linear-fractional programming. The key element of the developed methodology is optimization model, which is linear with respect to unknown variables and therefore implemented using the simplex method in modern software environments for optimization modeling. Application of the method allows to determine the required number of residential, social and public facilities, taking into account urban development standards and maximizing the profitability index.
During the study, an optimization model was developed based on the Microsoft Excel software product using the Solver Add-in extension. Regulatory documents, as well as catalogs of standard designs of residential buildings and public facilities, were used as data sources for the model.
As a result of applying the methodology, the optimal number of residential and infrastructure facilities was obtained. Result meets the requirements of regulatory documents and meets the condition for maximizing the profitability index.
The dissertation presents the algorithm of the model, a description of the variables used, as well as an analysis of the results of the application of the technique.