DESCRIPTION AND APPLICATION OF A COMPUTER PROGRAMME FOR SOLVING LINEAR PROGRAMMING MODELS

U ovom završnom radu je u uvodnom dijelu opisan dodatak Rješavač u računalnom programu MS Excel. Primjena Rješavača je za rješavanje linearnih i nelinearnih matematičkih modela, uz mogućnost dobivanja cjelobrojnih, ne cjelobrojnih i binarnih rješenja. Nakon rješavanja, prikazuju se izvještaji odgovora, osjetljivosti i granica varijabli. Spremanje više matematičkih modela za isti definirani problem je jedna od korisnih mogućnosti alata Rješavač. Zatim je Rješavač primijenjen za rješavanje proizvodnog problema i problema raspoređivanja radnika, uz upotrebu simplex metode.In this bachelor thesis, the tool Solver in the computer program MS Excel was described. The application of the Solver is for solving linear and nonlinear mathematical models, with the possibility of obtaining integer, non-integer and binary solutions. The answer report, sensitivity analysis and limit report can be obtained after the process of solving. Saving the multiple mathematical models for the same formulated problem is one of the useful features of the Solver. The Solver was then applied to solve the production and assignment problem, using the simplex method