| |
|
Comparison of systems for evaluating the efficiency of using DEA models
Murinová, Michaela ; Šindelářová, Irena (advisor) ; Chýna, Vladislav (referee)
Diploma thesis deals with the evaluation of the efficiency using DEA models focusing on the use of dedicated software tools. There are four chapters in the thesis where different approaches to efficiency are briefly presented. The method of data envelopment analysis (DEA) with its modifications is described in detail -- basic models, CCR, BCC and additive model. The main part of the work is presented in the second part of this thesis where I describe how to work with each program and summarize its advantages and disadvantages. The last chapter applies prior knowledge on real situation -- the evaluation of the efficiency of the regional police stations in the Czech Republic.
|
|
Optimizing a diet during pregnancy using the methods linear programming
Stehlíková, Irena ; Šindelářová, Irena (advisor) ; Skočdopolová, Veronika (referee)
This thesis concerns creation of a dietary plan for a woman during her pregnancy. Its goal is to create a nourishment plan for 7 days with minimal costs along with fulfilling nutritional recommendations. Work also includes some other recommendation pregnant women receive about sustenance. The diet is created and solved using linear programming techniques and calculated with optimization software LINGO. The goal of this thesis is to create a model, whose results are applicable in practice and is going to customizable according to changing needs of the pregnant woman.
|
|
System for solving distribution problems of LP – LINGO/Excel interface
Krčál, Adam ; Jablonský, Josef (advisor) ; Zouharová, Martina (referee)
Discrete problems of linear programming, i. e. problems with integer or binary variables, have a great amount of real-life applications. Among distribution problems, belong many different kinds of problems with discrete character -- transportation problem, container transportation problem, allocation problem, assignment problem, plant location problem, traveling salesman problem etc. In this work the theoretical aspects of chosen types of problems are explained and then an application in Microsoft Excel 2010 environment is created. For that purpose programming language VBA is the key instrument. The application cooperates with two different optimization systems -- the Solver add-in in Excel and professional optimization system Lingo. Functionality of the application is thereafter tested on some examples.
|
|
Multi-Criteria evaluation of projects in Raiffeisenbank a. s.
Serbová, Eva ; Fiala, Petr (advisor) ; Kuncová, Martina (referee)
Diploma thesis describes the slection of supplier of testing services for Everest project at Raiffeisenbank a. s. with aid of methods of multi-criteria decision and operation research. Thesis compares achieved results with the decision made in real tender realised in year 2010. Solution deals with two approaches via operation research. For the first round of tender were used three methods of multi-criteria evaluation of alternatives, WSA, TOPSIS and ELECTRE III. According to the results of each method were chosen suppliers who advanced to the next round. Second round operates with prices of particular phases of project and discounts offered by suppliers. Solution uses modified model of Reverse Auction. Calculations were supported by program packages SANNA and LINGO. Diploma thesis proved usability of mathematical modelling of multi-criteria decision task as support for management decision in real life business.
|
|
Logical puzzles and brainteasers as optimization problems
Lukesová, Kristýna ; Chýna, Vladislav (advisor) ; Šindelářová, Irena (referee)
This thesis applies classical optimization problems such as assignment or set-covering problem on logical puzzles or brainteasers. Listed in the first part are mathematical model, description and typical example of each optimization problem used in this thesis. The second part contains these models applied to the particular brainteasers for example Sudoku or Einstein's Puzzle. Exercises are divided into simpler and more complex ones. There is specification, source and a described method of solution stated for each of them. The calculation examples use Lingo or MS Excel or both. The aim is to show the possibility to address logical puzzles and brainteasers with the use of optimization problems, and thus confirm the wide possibilities of using these models. These examples can clarify and diversify the curriculum.
|
|
Optimization in MS Excel using VBA
Lhoták, Petr ; Chýna, Vladislav (advisor) ; Šindelářová, Irena (referee)
There are available various professional applications for the solving of optimization problems. This thesis deals with comparison of these optimization systems and simplicity of their connection with MS Excel through VBA. Problem of designing model together with his calculation in MS Excel or other systems connected via VBA, like MPL for Windows or LINGO, is demonstrated on concrete examples. Application in Visual Basic for Applications was created for this purpose. This application is easy to use and it is solving Knapsack Problem, Distribution Problem and also Quadratic Assignment Problem. Finally, comparison of these systems is made using Multi-criteria evaluation.
|
| |
| |
| |