BUS190 Linear Programming

BUS190 Linear - Microsoft Excel 12.0 Answer Report Worksheet[BUS190 Linear Programming]Sheet1 Report Created 4:15:20 PM Target Cell(Min Cell Name

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [BUS190 Linear Programming.xlsx]Sheet1 Report Created: 10/26/2009 4:15:20 PM Target Cell (Min) Cell Name Original Value Final Value $B$7 Optimal Solution Value 0 62000 Adjustable Cells Cell Name Original Value Final Value $C$6 Optimal Solution S 0 4000 $D$6 Optimal Solution M 0 10000 Constraints Cell Name Cell Value Formula Status Slack $C$15 Constraint 2 LHS 60000 $C$15>=$D$15 Binding 0 $C$16 Constraint 3 LHS 10000 $C$16>=$D$16 Not Binding 7000 $C$14 Constraint 1 LHS 1200000 $C$14<=$D$14 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
Microsoft Excel 12.0 Sensitivity Report Worksheet: [BUS190 Linear Programming.xlsx]Sheet1 Report Created: 10/26/2009 4:15:20 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$6 Optimal Solution S 4000 0 8 1.00E+030 4.25 $D$6 Optimal Solution M 10000 0 3 3.4 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$15 Constraint 2 LHS 60000 2.17 60000 42000 12000 $C$16 Constraint 3 LHS 10000 0 3000 7000 1.00E+030 $C$14 Constraint 1 LHS 1200000 -0.06 1200000 300000 420000
Background image of page 2
Innis Investments Variables S M Risk/Unit 8 3 Optimal Solution 4000 10000 Optimal Solution Value 62000 RHS Constraint 1 50 100 < 1200000 Constraint 2 5 4 > 60000 Constraint 3 1 > 3000 LHS RHS Constraint 1 1200000 1200000 Constraint 2 60000 60000 Constraint 3 10000 3000
Background image of page 3

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

View Full DocumentRight Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [BUS190 Linear Programming.xlsx]Sheet2 Report Created: 10/26/2009 4:01:49 PM Target Cell (Max) Cell Name Original Value Final Value $B$7 Optimal Solution Value 0 8400 Adjustable Cells Cell Name Original Value Final Value $C$6 Optimal Solution U 0 800 $D$6 Optimal Solution H 0 1200 Constraints Cell Name Cell Value Formula Status Slack $C$14 Constraint 1 LHS 80000 $C$14<=$D$14 Binding 0 $C$15 Constraint 2 LHS 700 $C$15<=$D$15 Binding 0 $C$16 Constraint 3 LHS 800 $C$16<=$D$16 Not Binding 200
Background image of page 4
Microsoft Excel 12.0 Sensitivity Report Worksheet: [BUS190 Linear Programming.xlsx]Sheet2 Report Created: 10/26/2009 4:01:49 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$6 Optimal Solution U 800 0 3 7 0.5 $D$6 Optimal Solution H
Background image of page 5

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

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

This note was uploaded on 09/08/2010 for the course BUS 190 at San Jose State University .

Page1 / 21

BUS190 Linear - Microsoft Excel 12.0 Answer Report Worksheet[BUS190 Linear Programming]Sheet1 Report Created 4:15:20 PM Target Cell(Min Cell Name

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

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