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

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

View Full Document Right Arrow Icon
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"
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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.
Background image of page 4
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.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Using Solver Platform The Solver tool is an add-on to Excel. It is available in our lab, but is not standard
Background image of page 6
Image of page 7
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 Right Arrow Icon
Ask a homework question - tutors are online