prikaz prve stranice dokumenta Optimalna alokacija resursa pomoću linearnog programiranja u excelu
Access restricted to students and staff of home institution
undergraduate thesis
Optimalna alokacija resursa pomoću linearnog programiranja u excelu
Zadar: University of Zadar, 2016. urn:nbn:hr:162:377317
Barić, Robert
University of Zadar
Department of Economics

Institutional repository: University of Zadar Institutional Repository

Cite this document

Barić, R. (2016). Optimalna alokacija resursa pomoću linearnog programiranja u excelu (Undergraduate thesis). Zadar: University of Zadar. Retrieved from https://urn.nsk.hr/urn:nbn:hr:162:377317

Barić, Robert. "Optimalna alokacija resursa pomoću linearnog programiranja u excelu." Undergraduate thesis, University of Zadar, 2016. https://urn.nsk.hr/urn:nbn:hr:162:377317

Barić, Robert. "Optimalna alokacija resursa pomoću linearnog programiranja u excelu." Undergraduate thesis, University of Zadar, 2016. https://urn.nsk.hr/urn:nbn:hr:162:377317

Barić, R. (2016). 'Optimalna alokacija resursa pomoću linearnog programiranja u excelu', Undergraduate thesis, University of Zadar, accessed 30 November 2024, https://urn.nsk.hr/urn:nbn:hr:162:377317

Barić R. Optimalna alokacija resursa pomoću linearnog programiranja u excelu [Undergraduate thesis]. Zadar: University of Zadar; 2016 [cited 2024 November 30] Available at: https://urn.nsk.hr/urn:nbn:hr:162:377317

R. Barić, "Optimalna alokacija resursa pomoću linearnog programiranja u excelu", Undergraduate thesis, University of Zadar, Zadar, 2016. Available at: https://urn.nsk.hr/urn:nbn:hr:162:377317

Metadata
TitleOptimalna alokacija resursa pomoću linearnog programiranja u excelu
Title (english)Optimal Allocation of Resources Using Excel Linear Programming
AuthorRobert Barić
MentorJosipa Perkov (mentor)
Committee memberAleksandra Krajnović (predsjednik povjerenstva)
Committee memberJosipa Perkov (član povjerenstva)
Committee memberJurica Bosna (član povjerenstva)
GranterUniversity of Zadar
(Department of Economics)
Zadar
Defense date and country2016-09-30, Croatia
Scientific / art field,
discipline and subdiscipline		SOCIAL SCIENCES
Economics
Business Informatics
Abstract
Ovim radom želi se istražiti utjecaj optimizacije pomoću linearnog programiranja unutar Microsoftovog tabličnog kalkulatora Excel te njegove ugrađene komponente Excel Solver-a na procese vezane uz alociranje resursa. Excel Solver je alat za najsloženije oblike "What-If" analize i problema linearne i nelinearne optimizacije u poslovnom okruženju. Svrha ovog alata je pronalaženje rješenja, tj. dostizanje optimalnih vrijednosti na osnovi zadanih ograničenja i niza parametarskih veličina koje se mogu mijenjati - to mogu biti vrijednosti, ali i odabrane metode kojima će složeni matematički model biti podvrgnut. Pri razmatranju problema analizirat će se procesi donošenja odluka vezanih uz alociranje resursa te mogućnost njihovog matematičkog programiranja odnosno optimizacije izradom matematičkog modela, izrada analize osjetljivosti tog matematičkog modela i primjena postavljenog matematičkog modela unutar Excel programa kako bi se dobili optimalni rezultati.
Abstract (english)
This paper will explore the impact of optimization using linear programming within a Microsoft Excel spreadsheet and its built-in component Excel Solver for the processes related to the allocation of resources. Excel Solver is a tool for the most complex forms of "What-If" analyses and the problems of linear and nonlinear optimization in the business environment. The purpose of this tool is finding optimal values on the basis of the set limitations and a number of parameter values that can be changed - they may be values, but also the methods that a complex mathematical model will undergo. In examination of the issues, the decision-making processes related to the allocation of resources will be analyzed and the possibility of their mathematical programming and optimization by creating mathematical models, creating the analysis of the sensitivity of the mathematical models and application of said mathematical models within Excel program in order to achieve optimal results.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:162:377317
Study programmeTitle: Management
Study programme type: university
Study level: undergraduate
Academic / professional title: sveučilišni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) ekonomije (sveučilišni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) ekonomije)
Type of resourceText
File originBorn digital
Access conditionsAccess restricted to students and staff of home institution
Terms of useLicence In copyright icon
Created on2018-03-08 09:48:19