In my work I deal with the issue of data mining and its use in the commercial sphere. Specifically, I focused on marketing and sales forecast. The aim of my work was first to assemble knowledge from data mining and then use it to create sales forecasts using data mining add-on for Excel. In the first part I gather the theoretical information about data mining. I focused on definition, the methodology, algorithms and of course on the most frequent usage. The second part consists of the practical application of acquired knowledge. I focus on making the sales forecast of HERO CZECH company. I used data mining add-on for Microsoft Excel 2007. Results are compared with real forecasts prepared by the Key Account Manager. Results of my work proved that forecasts from data mining add-on for Excel were not more accurately than the existing ones from Key Account Manager. Nevertheless, I believe that the use of data mining methods have found use in preparing the forecast, at least as a means of support.

Master ’s thesis deals with evaluation of investment using advanced methods of analysis and modeling with regards to the best offer. The content of the thesis consists of creating two decision making systems based on fuzzy logic. The thesis also contains a theoretical basics which are necessary for the creation of both systems and evaluating the benefits of the solution.

The diploma thesis is focused on the design of heating of the digestion tank, which is part of the waste water purification process and where the process of sludge digestion takes place. Anaerobic digestion (methanisation) is a process main goal of which is the hygienesation of incoming sludge and related biogas production. In the first part the reader is introduced to the subject of mixed and heated industrial vessels. In the second part of the thesis thermo-hydraulic calculation of the heating process is carried out in case the vessel is agitated and in case the agitation is not applied. The next part of the thesis describes the procedure for creating a calculation tool, which is later used to solve two sample problems. The last part describes the experimental measurement of the pumping characteristics of the agitator.

The diploma thesis deals with the application of the theory of fuzzy logic in the evaluation of client translation commissions for a foreign language text. This fuzzy model is used for better selection of orders and faster allocation of human resources for specific orders. The fuzzy model is composed of multi-valued decision-making criteria that are essential for the company. The model is processed in MS Excel using VBA and MathWorks MATLAB.

Presented diploma thesis is focused on evaluation of the supplier’s risk and the selection of the most suitable supplier with the use of artificial intelligence. The main part of the diploma thesis deals with the creation of the decision models. The decision models will be created in MS Excel and MATLAB based on the rules of the fuzzy logic. These models will determine the most suitable supplier for the company expert Elektro GOLA s.r.o. and they will also evaluate the supplier’s risk.

The master’s thesis deals with the topic of the use of artificial intelligence for managerial decision making in the firm. This thesis contains proposal of model of fuzzy logic in MS Excel and MATLAB for evaluation of the client’s solvency of bank for the purposes of loan providing.

The thesis deals with possibilities of mathematical modeling for public university budgets. Firstly, external conditions of public university financial inflows are discussed and~illustrated by using particular data. The related basic legislature is introduced. In~the~next part, internal financial flows are described the help of a general scheme. Step-by-step, a mathematical model of the university budget was built with using analysis of existing data, rules and formulas. The proposed model represents nonlinear multi–stage scenario-based stochastic programme, involving linear and network-flow like constraints. It allows to take into account more objective functions and related parametric analysis. The model was implemented in the algebraic modeling system GAMS with~interface to MS Excel. The aim of the presented mathematical model was not to offer a tool that would be used for automatic distribution of financial resources of the university, but to give flexible possibilities to its user to realize computational experiments and in this way to achieve a deeper insight into the modeled problem.

Diploma thesis analyzes and evaluates problems selecting a contractor for the Faculty of Chemistry VUT Brno for using fuzzy logic in MS Excel and MATLAB Mathworks Inc. The result will be a choice of one or more suppliers who meet pre-specified criteria and collide possible risks common to the activity of selecting a supplier to the minimum possible.

Master's thesis deals with design and development of two decision-making systems, which can be supportive during suppliers rating and selection the most suitable one from them. Both of the models, that one, which was made in the MS Excel, and also that one, which was made in the MATLAB, use principle of fuzzy logic and are designed according to the requirements of the selected company. Diploma thesis contains also all of theoretical bases, which are necessary for a design of both systems, and evaluation of benefits of the solution.

Cílem této diplomové práce je navrhnout vhodnou metodu pro vyhodnocení dodavatelů průmyslových větráku pro společnost První brněnská strojírna a.s. (PBS Brno). Společnost existuje více než 200 let na trhu a má více než 100 dodavatelů po celém světě. Proto je potřeba navrhnout adekvátní systém hodnocení dodavatelů. Pro vyhodnocení budou použité programy MS Excel a MATLAB.