excelsolver

# excelsolver - The LP "tableau" for Chiang Max Y1 OBJ 40 Cut...

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

The LP "tableau" for Chiang Max Y1 Y2 Type RHS OBJ 40 30 Cut 1 0 LE 16 Mix 0 1 LE 8 Pkg 1 2 LE 24 Where LE means less than or equal to and RHS stands for "right hand side"

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

View Full Document
Enter the matrix into Excel X1 X2 RHS obj 40 30 cutting 1 0 LE 16 mixing 0 1 LE 8 packg 1 2 LE 24
Add a "used" column and an "answers" row X1 X2 RHS Used obj 40 30 cutting 1 0 LE 16 mixing 0 1 LE 8 packg 1 2 LE 24 answers

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

View Full Document
Add formulas to "used" column" X1 X2 RHS Used obj 40 30 0 cutting 1 0 LE 16 mixing 0 1 LE 8 packg 1 2 LE 24 answers =sumproduct(\$b\$7:\$c\$7,b3:c3) e.g. multiply the answers by the obj values to get the total profit. \$ holds values constant so we can copy this formula into other cells.
Complete the formulas in "used" X1 X2 RHS Used obj 40 30 0 cutting 1 0 LE 16 0 mixing 0 1 LE 8 0 packg 1 2 LE 24 0 answers Each entry in the "used" column is the sum of the products of the values in the answers row times the values in the corresponding row of the tableau.

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

View Full Document
Using Solver Platform The Solver tool is an add-on to Excel. It is available in our lab, but is not standard
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 11/15/2011 for the course AGEC 7100 taught by Professor Duffy,p during the Fall '08 term at Auburn University.

### Page1 / 19

excelsolver - The LP "tableau" for Chiang Max Y1 OBJ 40 Cut...

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

View Full Document
Ask a homework question - tutors are online