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

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

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

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

View Full Document
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
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

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

View Full Document
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
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

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

View Full Document
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
Ask a homework question - tutors are online