By the end of the course, the student will be able to formulate problems as mathematical models, identify different types of optimization models, solve primarily linear models using the Excel solver, and interpret the solutions obtained.
The aim of this course is twofold. On the one hand, it aims to provide an introduction to mathematical modelling, a tool commonly used in water management, transport and other fields. On the other hand, it aims to explore methods for solving these models – primarily linear models – enabling students to solve them using the Excel Solver and to interpret the solution obtained by the Excel Solver.
The course covers linear, integer, network, and nonlinear models, as well as methods for solving optimization problems. It also includes the use of Excel’s Solver and database functions, along with an application to traffic assignment.
Part I. Formulation of mathematical models
1. Linear models
2. Integer models
3. Network models
4. Non-linear models
Part II. Solving optimisation models
5. Graphical solution of linear models with two variables
6. Solving optimisation models using the Excel Solver
7. Economic interpretation of the optimal solution from Excel
8. Case study: the traffic allocation problem
Online sessions via Teams
Final written examination comprising exercises
[1] F.S. HILLIER AND G.S. LIEBERMAN, INTRODUCTION TO OPERATIONS RESEARCH, 10TH EDITION, MACGRAW-HILL EDUCATION, NEW YORK, 2015.
[2] F.S. HILLIER AND M.S. HILLIER, INTRODUCTION TO MANAGEMENT SCIENCES, 6TH EDITION, MACGRAW-HILL EDUCATION, NEW YORK, 2019.
[3] Y. NORBERT, R. OUELLET AND R. PARENT, OPERATIONS RESEARCH, GAËTAN MORIN, 3rd EDITION, 2002.
| Training | Block | Credits | Mandatory |
|---|---|---|---|
| Advanced Master in Sustainable Economics and Management | 1 | 2 | No |