Decisions Support Systems
- Ending: Examination
- Range: 2P + 2C
- Semester: summer
- Year: 2
- Faculty of Economic Informatics
Teachers
Included in study programs
Teaching results
In particular, students acquire the following abilities:
- on systems for optimization calculations, on advantages and disadvantages of individual systems
- on programming in VBA language under MS Excel
- on programming in the GAMS language.
Students acquire in particular the following skills:
- to select adequate software support to solve the related problem based on a mathematical model
- solve specific optimization problems by creating programs in two languages (VBA under MS Excel and GAMS)
Students will acquire the following competencies:
- practical skills and competences in creating programs to solve various optimization problems that occur in economic practice
Indicative content
1. Description of MS Excel tools for solving mathematical programming problems.
2. Using of standard MS Excel functions for solving problems of structure analyses and models of replacement.
3. Visual Basic commands.
4. Creation of user’s functions of models of inventory.
5. Creation of user‘s functions of models of queuing theory.
6. Solving mathematical programming problems using Solver.
7. Solving the Traveling Salesman Problem using Solver.
8. Introduction to GAMS language, optimization calculations.
9. Basic GAMS language commands, control features.
10. Solving linear programming problems using GAMS.
11. Solving nonlinear problems using GAMS.
12. Solving location-allocation problems using GAMS.
13. Solving the Traveling Salesman Problem using GAMS.
Support literature
1. Ivaničová, Z. – Brezina, I. – Pekár, J.: Operačná analýza, IURA Edition, Bratislava 2007
2. Pecinovský, J.: Excel 2002 (podrobný průvodce pokročilého uživatele), Grada, 2002
3. Premium Solver Platform for use with Microsoft Excel, Frontline Systems, 2000
4. Pekár, J. – Čičková, Z.: Softvérová podpora vybraných modelov operačného výskumu. Ekonóm 2013.
5. Rosenthal, R. E.: A GAMS Tutorial by Richard E. Rosenthal, dostupné na: https://www.gams.com/latest/docs/UG_Tutorial.html
Requirements to complete the course
40 % final paper and continuous testing
60 % final exam
Student workload
Total study load (in hours): 6 credits x 26 hours = 156 hours
Lectures participation: 26 hours
Seminars participation: 26 hours
Final paper preparation: 52 hours
Preparation for the exam and continuous tests: 52 hours
Language whose command is required to complete the course
Slovak
Date of approval: 28.03.2024
Date of the latest change: 28.03.2024