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 -
olve Without Integer Constraints , Assume NonNegative
Microsoft Excel 14.4 Sensitivity Report Worksheet: [Workbook18]Sheet1 Report Created: 4/21/2015 11:50:23 AM

You've reached the end of your free preview.

Want to read all 8 pages?

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