GBS Test Question #1 - Microsoft Excel 14.4 Answer Report Worksheet[Workbook18]Sheet1 Report Created 11:50:23 AM Result Solver found a solution All

GBS Test Question #1 - Microsoft Excel 14.4 Answer Report...

This preview shows page 1 - 4 out of 8 pages.

Microsoft Excel 14.4 Answer Report Worksheet: [Workbook18]Sheet1 Report Created: 4/21/2015 11:50:23 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.524165 Seconds. Iterations: 5 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 1e-06 Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, So Objective Cell (Min) Cell Name Original Value Final Value $C$19 Objective Function (Min) X1 3.15 0.41 Variable Cells Cell Name Original Value Final Value Integer $C$16 X1 1.00 0.10 Contin $D$16 X2 1.00 0.21 Contin $E$16 X3 1.00 0.09 Contin $F$16 X4 1.00 0.10 Contin Constraints Cell Name Cell Value Formula Status Slack $C$23 A Amount Used (LHS) 0.50 $C$23=$E$23 Binding 0 $C$24 C Amount Used (LHS) 6.00 $C$24>=$E$24 Binding - $C$25 B Amount Used (LHS) 5.00 $C$25>=$E$25 Binding - $C$26 D Amount Used (LHS) 5.00 $C$26>=$E$26 Binding -
Image of page 1
olve Without Integer Constraints , Assume NonNegative
Image of page 2
Microsoft Excel 14.4 Sensitivity Report Worksheet: [Workbook18]Sheet1 Report Created: 4/21/2015 11:50:23 AM
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '14
  • objective function, Report Created, LHS)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes