Application of Linear Programming Modeling on Blending

Linear programming modeling has numerous applications in various fields, including blending different substances together. In this note, we will explore how to use SOLVER to solve a linear programming problem related to blending.

Step 1: Create a Worksheet Representation of the Model

To start, you need to create a worksheet representation of the model. This involves setting up the variables, constraints, and objective function in an Excel spreadsheet.

Step 2: Define the Problem

Once you have set up the model, define the problem to be solved. In our case, we are trying to blend different substances together to obtain a product with certain characteristics or properties.

Using SOLVER to Solve Linear Programming Problems

SOLVER is a powerful tool in Excel that can help you solve linear programming problems. To use it, go to the 'Data' tab and click on 'Solver.' A new window will appear, where you can enter the model information, including the objective function and constraints.

Blending Models

Another classic problem that can be modeled as a linear program concerns blending or mixing ingredients to obtain a product with certain characteristics or properties. For example, imagine we want to blend different types of fuel together to create a high-octane gasoline that meets certain specifications.

How to Determine if a Constraint is Binding or Not

When solving a linear programming problem, it's important to determine if a constraint is binding or not. A binding constraint is an equation in the linear program that satisfies the optimal solution through its value.

Solving Linear Programming Problems Using Excel Solver

If you know that you are going to have problems with linear programming, then it is important for you to stay calm and collected. Finding the satisfactory optimal solution through certain constraints can be challenging, but with the right tools and techniques, it's achievable.

In conclusion, linear programming modeling has numerous applications in various fields, including blending different substances together. By using SOLVER and other linear programming tools, we can solve complex problems and obtain optimal solutions.

Mathtype 6.9 office 365