SOLVE A LINEAR PROGRAMMING PROBLEM IN MICROSOFT EXCEL USING THE SOLUTION SEARCH MODULE

Abstract

Having studied the algorithms for manual solution of linear programming problems, it is useful to get acquainted with a way to simplify this process. It is clear that the more difficult the task, the more variables and conditions it contains, the more tedious and longer it takes to solve it. In such cases, it is convenient to use special mathematical packages, or the MS Excel program available to many. The standard way to solve a linear programming problem is to create a product in MS Excel using the Search for Solutions application. The most optimal solution for solving this problem is a very effective method that has been developed and used.