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.
Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
