HW2-Sol-Excel

HW2-Sol-Excel - 3 P x Px 0.67 1 1 1 0.41 0.86 1 0.5 1 1...

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

View Full Document Right Arrow Icon
Engineering 62 HW #2 Solutions xT 1.8 0.6 cTx -2.4 cT -1 -1 Ax b A -1 -2 -3 -3 -1 2 -0.6 4 1 7 6 6
Background image of page 1

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

View Full DocumentRight Arrow Icon
Microsoft Excel 11.0 Sensitivity Report Worksheet: [HW5_excel_solns.xls]Problem 3 Report Created: 11/6/2005 12:43:22 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$6 xT 1.8 0 -1 0.5 1.00E+030 $D$6 xT 0.6 0 -1 1.00E+030 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$10 A Ax -3 1.2 -3 1.29 3 $F$11 Ax -0.6 0 4 1.00E+030 4.6 $F$12 Ax 6 0.2 6 4.5
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3 P x Px 0.67 1 1 1 0.41 0.86 1 0.5 1 1 0.27 0.86 1 1 0.25 1 0.18 0.86 1 1 1 0.14 0.86 1 1 1 1 eTx: 1 v: 0.86 e v ve 1 0.86 0.86 1 0.86 1 0.86 1 0.86 P x Px 0.67 1 1 0.8 0.47 0.84 1 0.5 1 0.8 0.32 0.84 1 1 0.25 0.8 0.21 0.84 1 1 1 1 eTx: 1 v: 0.84 e v ve 1 0.84 0.84 1 0.84 1 0.84 0.67 1 1 0.2 0.47 0.84 1 0.5 1 0.2 0.32 0.84 1 1 0.25 0.2 0.21 0.84 1 1 1 1 1 1 1 1 1 0.84 1 0.84 0.84 1 0.84 1 0.84 1 0.84...
View Full Document

This note was uploaded on 09/23/2009 for the course ENGR 62 taught by Professor Unknown during the Spring '06 term at Stanford.

Page1 / 8

HW2-Sol-Excel - 3 P x Px 0.67 1 1 1 0.41 0.86 1 0.5 1 1...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online