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.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
hi@scite.ai
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.