SOLVING OF OPTIMIZATION QUANTITATIVE MODELS BY MATLAB AND MS EXCEL

U ovom završnom radu je prikazano rješavanje optimizacijskih kvantitativnih modela pomoću programa Matlab i MS Excel. U uvodnom dijelu su pojašnjeni određeni pojmovi vezani uz programe, rad programa, njihova svrha, te razlika između Matlab-a i MS Excel-a. U naredna dva poglavlja se govori najprije o funkcijama i alatima za optimiranje u računalnom programu Matlab te zatim o alatu Rješavaču u računalnom programu MS Excel. Četvrto poglavlje obuhvaća dio o definiranju problema i dobivanju optimalnog rješenja pomoću prethodno navedena dva računalna programa. Usporedba korištenih računalnih programa prikazana je u zaključku.In this bachelor thesis solving optimization quantitative models using Matlab and MS Excel is shown. In introduction part certain concepts connected to programs, work of programs, their function and difference between Matlab and MS Excel are described. In the next two chapters the functions and tool for optimization in program Matlab as well as tool solver in MS Excel are presented. Chapter four includes part about defining problems and getting optimal solution with previously referred two programs. Comparison of these two used programs is presented in the conclusion