2025/2026
Оптимизационное моделирование в управлении операциями
Статус:
Маго-лего
Где читается:
Высшая школа бизнеса
Когда читается:
2 модуль
Охват аудитории:
для своего кампуса
Преподаватели:
Павлов Валерий Петрович
Язык:
английский
Кредиты:
3
Контактные часы:
24
Course Syllabus
Abstract
This course introduces students to core concepts in optimization modeling with a practical focus on operations management. Using Excel Solver as the primary tool, students will formulate, analyze, and solve linear and integer programming problems relevant to logistics, production, planning, and investment decisions. (From the program Annotation).
Learning Objectives
- By the end of the course, students will be able to: Construct and solve linear and integer optimization models using Excel Solver Model discrete decisions and time-based planning problems Apply optimization techniques to investment, production, and logistics problems Critically analyze solution outputs and communicate findings effectively
Expected Learning Outcomes
- Recognize sources of uncertainty, use probabilities to quantify uncertainty, and create a model to support decision-making.
- Use binary variables to model binary decisions in optimisation models.
- Analyse business problems to identify those that require models using integer variables, create and solve such models.
- Understand the main principles of linear programming, analyse a business problem, create a linear program and use Solver to find its optimal solution.
- Analyse and identify logistics problems that can be formulated as a transhipment model, create a model and use Solver to find the optimal solution.
- Synthesize a multi-period planning model by identifying the flows in the business problem and using the flow conservation method to link single-period models.
Course Contents
- Foundations of Linear Programming
- Modeling Binary Decisions in Optimisation
- Transportation and Supply Network Modeling
- Multi-Period Production Planning
- Integer Programming
- Decision-making under uncertainty
Assessment Elements
- Seminar task 1Each assignment must be completed before the next week's test.
- Exam
- Test 1
- Test 2
- Test 3
- Test 4
- Test 5
- Seminar task 2
- Seminar task 3
- Seminar task 4
- Seminar task 5
Interim Assessment
- 2025/2026 2nd module0.35 * Exam + 0.06 * Seminar task 1 + 0.06 * Seminar task 2 + 0.06 * Seminar task 3 + 0.06 * Seminar task 4 + 0.06 * Seminar task 5 + 0.07 * Test 1 + 0.07 * Test 2 + 0.07 * Test 3 + 0.07 * Test 4 + 0.07 * Test 5
Bibliography
Recommended Core Bibliography
- Gilboa,Itzhak. (2009). Theory of Decision under Uncertainty. Cambridge University Press. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsrep&AN=edsrep.b.cup.cbooks.9780521517324
- Spreadsheet modeling and decision analysis : a practical introduction to management science, Ragsdale, C. T., 2004
- Токарев, В. В. Методы оптимальных решений : учебное пособие : в 2 томах / В. В. Токарев. — 3-е изд. — Москва : ФИЗМАТЛИТ, [б. г.]. — Том 2 : Многокритериальность. Динамика. Неопределенность — 2012. — 420 с. — ISBN 978-5-9221-1400-4. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/59653 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.
Recommended Additional Bibliography
- Linear programming : an introduction, Feiring, B.R., 1986
- Linear programming and economic analysis, Dorfman, R., 1987