title: ÐÐµÑÐ¾Ð´Ð¸ÐºÐ° Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ¾ÑÑÐ°Ð²Ð° Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð² Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÑÑÐµÐ´ÑÑÐ² Ð±Ð¸Ð½Ð°ÑÐ½Ð¾Ð¹ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
title: Methodology for justifying the composition of an investment-construction project portfolio using binary optimization tools
Creators: name: ÐÑÑÐ½Ð¸Ñ, ÐÐ¾Ð»Ð¸Ð½Ð°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ Ð¼Ð¾Ð´ÐµÐ»Ñ
Ð±Ð¸Ð½Ð°ÑÐ½Ð°Ñ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ
Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ
ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð¿ÑÐ¾ÐµÐºÑ
Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð²
optimization model
binary optimization
modeling
construction project
project portfolio

description: ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐµ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ°Ð»ÑÐ½Ð¾Ð³Ð¾ ÑÑÐµÐ´ÑÑÐ²Ð°, ÑÐ¾ÑÑÐ°Ð²Ð»ÑÑÑÐµÐ³Ð¾ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÑ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ¾ÑÑÐ°Ð²Ð° Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð² Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ. ÐÐ°Ð´Ð°ÑÐ¸, ÑÐµÑÐµÐ½Ð½ÑÐµ Ð² Ð¿ÑÐ¾ÑÐµÑÑÐµ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð´Ð¸ÑÑÐµÑÑÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ: 1. ÐÐ±Ð·Ð¾Ñ Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð· Ð½Ð°ÑÑÐ½ÑÑ ÑÐ°Ð±Ð¾Ñ Ð² Ð¾Ð±Ð»Ð°ÑÑÐ¸ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ°ÑÐ°ÐºÑÐµÑÐ¸ÑÑÐ¸Ðº Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð², ÑÐµÐ°Ð»Ð¸Ð·ÑÐµÐ¼Ð¾Ð³Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð»ÑÐ½ÑÐ¼Ð¸ Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸ÑÐ¼Ð¸. 2. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð¼Ð¾Ð´ÐµÐ»Ð¸ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ°ÑÐ°ÐºÑÐµÑÐ¸ÑÑÐ¸Ðº Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð², ÑÐµÐ°Ð»Ð¸Ð·ÑÐµÐ¼Ð¾Ð³Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð»ÑÐ½Ð¾Ð¹ Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸ÐµÐ¹ Ð² ÑÐµÑÐµÐ½Ð¸Ðµ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½Ð¾Ð³Ð¾ Ð²ÑÐµÐ¼ÐµÐ½Ð½Ð¾Ð³Ð¾ Ð¿ÐµÑÐ¸Ð¾Ð´Ð°. 3. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÐ¸ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ¾ÑÑÐ°Ð²Ð° Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð² Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð½Ð° Ð¿ÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ¾Ð¼ Ð¿ÑÐ¸Ð¼ÐµÑÐµ. Ð Ð¿ÑÐ¾ÑÐµÑÑÐµ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ»Ð¸ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ñ Ð¾ÑÐ½Ð¾Ð²Ð½ÑÐµ Ð²Ð¾Ð¿ÑÐ¾ÑÑ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð² Ð² Ð¿ÑÐ¾ÑÐ¸Ð»ÑÐ½ÑÑ ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸ÑÑ. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð¿ÑÐ¾Ð¼ÐµÐ¶ÑÑÐ¾ÑÐ½Ð¾Ð³Ð¾ ÑÑÐ°Ð¿Ð° Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð±ÑÐ»Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ Ð¼Ð¾Ð´ÐµÐ»Ñ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ°ÑÐ°ÐºÑÐµÑÐ¸ÑÑÐ¸Ðº Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð², ÑÐµÑÐµÐ½Ð¸Ðµ ÐºÐ¾ÑÐ¾ÑÐ¾Ð¹ Ð¾Ð±ÐµÑÐ¿ÐµÑÐ¸Ð²Ð°ÐµÑÑÑ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸ÐµÐ¼ Ð¼ÐµÑÐ¾Ð´Ð° Ð²ÐµÑÐ²ÐµÐ¹ Ð¸ Ð³ÑÐ°Ð½Ð¸Ñ, Ð° ÑÐ°ÐºÐ¶Ðµ Ð¸Ð¼ÐµÑÑÐ°Ñ Ð±Ð¸Ð½Ð°ÑÐ½ÑÐµ Ð·Ð½Ð°ÑÐµÐ½Ð¸Ñ Ð½ÐµÐ¸Ð·Ð²ÐµÑÑÐ½ÑÑ Ð¿ÐµÑÐµÐ¼ÐµÐ½Ð½ÑÑ. ÐÐ°Ð½Ð½Ð°Ñ Ð¼Ð¾Ð´ÐµÐ»Ñ Ð±ÑÐ»Ð° ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ð° Ð² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð¹ ÑÑÐµÐ´Ðµ Â«Microsoft ExcelÂ» Ð¿Ð¾ÑÑÐµÐ´ÑÑÐ²Ð¾Ð¼ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð½Ð°Ð´ÑÑÑÐ¾Ð¹ÐºÐ¸ Â«ÐÐ¾Ð¸ÑÐº ÑÐµÑÐµÐ½Ð¸ÑÂ». Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð°Ñ Ð¼Ð¾Ð´ÐµÐ»Ñ Ð¿Ð¾ÑÐ»ÑÐ¶Ð¸Ð»Ð° Ð¾ÑÐ½Ð¾Ð²Ð¾Ð¹ Ð´Ð»Ñ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÐ¸ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ°ÑÐ°ÐºÑÐµÑÐ¸ÑÑÐ¸Ðº Ð¿Ð¾ÑÑÑÐµÐ»Ñ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð². Ð ÐºÐ°ÑÐµÑÑÐ²Ðµ ÑÐ°ÑÑÐ¼Ð°ÑÑÐ¸Ð²Ð°ÐµÐ¼ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð² â Ð¾Ð±ÑÐµÐºÑÑ Ð¶Ð¸Ð»Ð¸ÑÐ½Ð¾Ð³Ð¾ ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÑÑÐ²Ð°, Ð° ÑÐ°ÐºÐ¶Ðµ ÑÐ¾ÑÐ¸Ð°Ð»ÑÐ½ÑÐµ Ð¾Ð±ÑÐµÐºÑÐ¾Ð² Ð¸ ÑÐ»ÐµÐ¼ÐµÐ½ÑÑ ÑÑÐ°Ð½ÑÐ¿Ð¾ÑÑÐ½Ð¾Ð¹ Ð¸Ð½ÑÑÐ°ÑÑÑÑÐºÑÑÑÑ Ð½Ð° ÑÐµÑÑÐ¸ÑÐ¾ÑÐ¸Ð¸ Ð³. Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ Ð¸ ÐÐµÐ½Ð¸Ð½Ð³ÑÐ°Ð´ÑÐºÐ¾Ð¹ Ð¾Ð±Ð»Ð°ÑÑÐ¸. ÐÐ°Ð½Ð½Ð°Ñ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÐ° Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÑÐµÑ ÑÐ¾Ð±Ð¾Ð¹ ÑÑÑÐµÐºÑÐ¸Ð²Ð½ÑÐ¹ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½Ñ, Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð½ÑÐ¹ Ð½Ð° ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½ÑÑ Ð¼ÐµÑÐ¾Ð´Ð°Ñ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ. Ð£ÑÐµÑ ÑÐ°Ð·Ð»Ð¸ÑÐ½ÑÑ ÐºÐ°ÑÐµÐ³Ð¾ÑÐ¸Ð¹ Ð¸Ð½Ð²ÐµÑÑÐ¸ÑÐ¸Ð¾Ð½Ð½Ð¾-ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¾Ð² Ð¸ Ð¸Ñ Ð²Ð·Ð°Ð¸Ð¼Ð¾ÑÐ²ÑÐ·ÐµÐ¹ Ð¸ ÑÐ¿ÐµÑÐ¸ÑÐ¸ÐºÐ¸ ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½Ð¾Ð¹ Ð¾ÑÑÐ°ÑÐ»Ð¸ Ð² ÑÐµÐ»Ð¾Ð¼ ÑÐ¿Ð¾ÑÐ¾Ð±ÑÑÐ²ÑÐµÑ Ð¿ÑÐ¸Ð½ÑÑÐ¸Ñ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð½ÑÑ ÑÐµÑÐµÐ½Ð¸Ð¹ Ð½Ð° ÑÑÐ°Ð¿Ðµ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¿Ð¾ÑÑÑÐµÐ»Ñ, ÑÐµÐ¼ ÑÐ°Ð¼ÑÐ¼ Ð´ÐµÐ»Ð°Ñ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÑ Ð¿ÐµÑÑÐ¿ÐµÐºÑÐ¸Ð²Ð½Ð¾Ð¹ Ð´Ð»Ñ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ Ð² ÑÐµÐ°Ð»ÑÐ½ÑÑ ÑÑÐ»Ð¾Ð²Ð¸ÑÑ ÑÑÑÐ¾Ð¸ÑÐµÐ»ÑÐ½Ð¾Ð¹ Ð¾ÑÑÐ°ÑÐ»Ð¸.
description: This thesis is dedicated to the development of an instrumental tool for formulating a methodology for justifying the composition of an investment-construction project portfolio based on optimization modeling. Tasks accomplished during the dissertation research process: 1. Review and analysis of scientific works related to the justification of characteristics of investment-construction project portfolio implemented by relevant organizations. 2. Development of an optimization model for justifying the characteristics of an investment-construction project portfolio implemented by a specialized organization during a particular period of time. 3. Development and implementation of a methodology for justifying the composition of an investment-construction project portfolio based on optimization modeling through a practical example. In the process of work, main issues related to the formation of project portfolios in specialized construction organizations were investigated. As a result of completing the intermediate stage of the research, an optimization model was developed for justifying the characteristics of an investment-construction project portfolio, the solution of which is achieved by using the branch and bound method, featuring binary values for the unknown variables. This model was implemented within the Microsoft Excel software environment using the Solver add-in. The developed model served as the basis for the formulation of a methodology to justify the characteristics of investment-construction project portfolios. The considered projects included residential construction, social infrastructure objects, and elements of transport infrastructure in Saint Petersburg and the Leningrad Region. This methodology represents an effective tool based on modern optimization and data analysis methods. Considering various categories of investment-construction projects and their interrelationships, as well as the specifics of the construction industry in general, facilitates making well-founded decisions in the portfolio formation stage, thereby making the methodology promising for application in real conditions of the construction industry.