|
| |
|
| |
|
|
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.
|
|
|
Lingo syntax in MS Excel Solver
Zajíček, Miroslav ; Chýna, Vladislav (advisor) ; Šindelářová, Irena (referee)
The linear programming is the part of optimization analyses. It's focused on finding a solution of the real problem, which would be better than the current one. The process of finding is provided by tools, which try to find the solution from specific formed input. This writing is about presenting a new created tool of MS Excel add-in, which is determined for linear programming task solvers. It tries to use good attributes from already existing tools. The reader of this piece will get familiar with their basic properties, the comparison of each other and the demonstration of the new add-in usage in typical tasks for the linear programming.
|
|
|
Portfolio optimization
Arzumanov, Eduard ; Šindelářová, Irena (advisor) ; Chýna, Vladislav (referee)
Nowadays, when the financial sector influences directly or indirectly nearly every part of person's life, when inflation is taken as a normal phenomenon, when we are witnessing bankrupts of different companies, banks and other financial institutions almost on a daily basis due to the incorrect managing of the financial assets or due to the incorrect estimation of overall economic development, more and more often one should consider how to manage his funds to prevent their depreciation or even how to use them to increase its value. For these reason investment into securities has become one of the most common ways of increasing the value of one's financial funds. Particularly -- one way of investment is becoming more and more popular nowadays - financial portfolio investment. That is why this thesis not only will introduce the basic principles and rules of portfolio investment, diversification and the concept of risk (in theoretical part), but will also demonstrate how is the diversification of a portfolio done in practice. The example of portfolio optimization is done using multi-criteria decision analysis applied to a model, designed in MS EXCEL with help of VBA environment.
|
|
|
Optimization of distribution of sales representatives and business places ČMSS
Holaj, Jaroslav ; Jablonský, Josef (advisor) ; Chýna, Vladislav (referee)
Building savings is currently in decline and probably will not be used to such an extent as in previous years. The state contribution decreases and for the people ceases to be so attractive banking product. Moreover, the building savings could be provided by more financial institutions than only by building societies. Therefore it is necessary to more effectively exploit the potential of this product, which is increasingly getting thinner and this work should help to improve that. It aims to reveal to some extent possibilities of individual regions of the Czech Republic and to outline the ideal distribution of sales representatives and business locations so that the most efficient use of their potential. Indirectly it also propose a method of assessment of sales representatives ČMSS according to efficiency of their regions.
|
|
|
Optimization in MS Excel
Brůna, Daniel ; Chýna, Vladislav (advisor) ; Šindelářová, Irena (referee)
This thesis describes a number of selected supplements to MS Excel from the perspective of users and their subsequent comparison with the help of multi-criteria evaluation of alternatives. Optimization in the world today is widely applied to various problems ranging from simple production problems to more complex problems, which are without using optimization software difficult to solve. Moreover, solving would take too much time. In this work are described and evaluated supplements for MS Excel because MS Office package is included in most of today's computers and many users have easy access to it. To do this, we set a number of criteria such as price, difficulty controlling and difficulty of installation, solving speed and range and possibilities of options for solving problems.
|
|
|
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.
|
|
|
Graph theory – an alternative method of solving LP problems
Hrabovská, Michaela ; Šindelářová, Irena (advisor) ; Chýna, Vladislav (referee)
This bachelor thesis analyses an example of an alternative method of solving selected linear programming problems using graph theory. These alternative methods are explained not only theoretically, but also illustrated on the practical examples. For comparison, there is a theoretical description and also practical solution of selected problems with using linear programming stated in the text. In the introductory part of the thesis, the theory of operations research is briefly discussed. The selected problems are: knapsack problem, transportation problem, assignment problem.
|
guest ::
