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
d.

#### You've reached the end of your free preview.

Want to read all 12 pages?

• Fall '14
• LHS)