LP_Examples

# LP_Examples - Objective function coefficients, c Left-hand...

This preview shows pages 1–2. Sign up to view the full content.

Coefficients Desks Tables Chairs Objective: 60 30 20 280 Row 1: 8 6 1 24 <= 48 Row 2: 4 2 1.5 20 <= 20 Row 3: 2 1.5 0.5 8 <= 8 Row 4: 1 0 <= 5 Variable Row: 2 0 8 Notes 1. In Excel, we first define some set of cells whose values will correspond to the decision va 2. In addition, we need to put in all of the parameters of the problem: Vector of objective function coefficients, c, constraint matrix coefficients, A, and right-hand s 3. Once we have defined where the objective coefficients and variable cells are, we create (The sumproduct function provides the sum of the component-wise multiplication of two vec 4. In addition to having the above, I prefer to define a column vector that contains each elem to multiply each row of the A matrix by the decision variable vector x. 5. Once it is setupt this way, it is easy to feed it into the solver, which you get to by going to (If it is not listed under tools, then it is an add-in that was not added with the installation, and 6. Once you open solver, make sure that the "Set Cell" box contains your objective function

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 05/12/2010 for the course ESI 6323 taught by Professor Guan during the Summer '09 term at University of Florida.

### Page1 / 4

LP_Examples - Objective function coefficients, c Left-hand...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online