GBS Test Question #3 - Microsoft Excel 14.4 Answer Report Worksheet[Workbook13]Sheet1 Report Created 9:39:14 AM Result Solver found a solution All

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

This preview shows page 1 - 3 out of 12 pages.

Microsoft Excel 14.4 Answer Report Worksheet: [Workbook13]Sheet1 Report Created: 4/21/2015 9:39:14 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied Solver Engine Engine: Simplex LP Solution Time: 0.399443 Seconds. Iterations: 4 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 0.000001 Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1% Objective Cell (Max) Cell Name Original Value Final Value $C$19 Objective Function (Min) X1 3,341.34 3,341.34 Variable Cells Cell Name Original Value Final Value Integer $C$16 X1 87.21 87.21 Contin $D$16 X2 65.12 65.12 Contin $E$16 X3 10.00 10.00 Contin $F$16 XD 3.19 3.19 Contin $G$16 XE 0.00 0.00 Contin Constraints Cell Name Cell Value Formula Status $C$23 A Amount Used (LHS) 100.00 $C$23<=$E$23 Binding $C$24 C Amount Used (LHS) 36.00 $C$24<=$E$24 Binding $C$25 B Amount Used (LHS) 50.00 $C$25<=$E$25 Binding $C$26 D Amount Used (LHS) 10.00 $C$26<=$E$26 Binding $C$27 E Amount Used (LHS) 3.19 $C$27<=$E$27 Not Binding $C$28 E Amount Used (LHS) - $C$28<=$E$28 Not Binding
Image of page 1
d.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 12 pages?

  • Fall '14
  • LHS)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture