Abstract
When it comes to making of certain decisions everyday/routine or specific, which often imply planning, programming, selection of the most favorable alternative, financing or realization of business task, it is mostly based on the data analysis. Criteria which are imposed on that occasion are diverse and sometimes mutually opposed. Problems posed to the decision maker are often unstructured so there is no mathematical algorithm for solving them, and often there is a question of objectivity in choosing the optimal solution.The subject of this work is the use of Excel Solver in finding the optimal choice of products in the company which is engaged in trade of computer equipment, considering sales trends, available storage and human capacities as well as the financial limitations. The fundamentals of linear programming are presented with the concrete example of sales of the desktop computers, laptop computers and tablet appliances, and their implementation presents the base of the use of the Excel Solver.
Publisher
Centre for Evaluation in Education and Science (CEON/CEES)
Subject
General Earth and Planetary Sciences,General Environmental Science