IMSE 328 HOMEWORK 7

IMSE 328 HOMEWORK 7 - Microsoft Excel 12.0 Answer Report...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 2/20/2012 10:56:40 PM Target Cell (Max) Cell Name Original Value Final Value $C$13 Funds x1 0 20 Adjustable Cells Cell Name Original Value Final Value $C$5 x1 0 6.666666667 $D$5 x2 0 13.33333333 Constraints Cell Name Cell Value Formula Status Slack $C$13 Funds x1 20 $C$13<=20 Binding 0 $C$14 Loan amount x1 0 $C$14<=0 Binding 0
Background image of page 1

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

View Full DocumentRight Arrow Icon
2-5 Decesion Variables x1(personal) x2(car) (in thousands) 6.6666666667 13.33333 2.308 Objective Function x1 x2 0.1286 0.1088 2.308 Constraints x1 x1 Funds 20 1 21 20 Loan amount 0 -1 -1 0
Background image of page 2
Microsoft Excel 12.0 Answer Report Worksheet: [Book1]Sheet2 Report Created: 2/20/2012 11:30:12 PM Target Cell (Max) Cell Name Original Value Final Value $E$4 (in thousands) 141.818181818 141.8181818 Adjustable Cells Cell Name Original Value Final Value $C$4 (in thousands) x1(personal) 54.5454545455 54.54545455 $D$4 (in thousands) x2(car) 10.9090909091 10.90909091 Constraints Cell Name Cell Value Formula Status
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

IMSE 328 HOMEWORK 7 - Microsoft Excel 12.0 Answer Report...

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

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