# 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