APPLICATION OF MS EXCEL FOR SOLVING OF OPTIMIZATION QUANTITATIVE MODELS AND DERIVING OF STATISTICAL QUANTITATIVE MODELS

U ovom završnom radu prikazan je način rješavanja optimizacijskog te dobivanje statističkog kvantitativnog modela u programskom paketu Microsoft Excel-u. Optimizacijski kvantitativni model je rješavan pomoću Alata Rješavač te je dobiveno optimalno rješenje. U problemu je bilo potrebno ostvariti maksimalnu dobit proizvodnje uvažavajući pri tome kapacitete i troškove strojeva te troškove materijala. Rezultati optimizacije ukazali su na potrebnu količinu pojedinog proizvoda kako bi se postigla maksimalna dobit. U završnom radu je opisan i Alat Statistička analiza podataka te ostale mogućnosti dobivanja statističkog kvantitativnog modela (gotove funkcije, crtanje krivulje trenda i dodatak Design of Experiment for Excel).This bachelor thesis shows the solving of optimization quantitative model and obtaining the statistical quantitative model in program package Microsoft Excel. Optimization quantitative model is solved by using the tool Solver, which gave an optimal solution. The task was to realize a maximal profit taking into account equipment's capacity and cost, as well as material cost. Optimization results indicated a necessary quantity of each product to obtain maximal profit. In the bachelor thesis the statistical analysis tool is described and used as well as some other posibilities to derive statistical quantitative model (functions, trend line and addition DOE PRO XL sofrware for Microsoft Excel – trial version)