GBS Test Question #4 - Microsoft Excel 14.4 Answer Report Worksheet[Workbook16]Sheet1 Report Created 10:13:28 AM Result Solver found a solution All

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

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

Microsoft Excel 14.4 Answer Report Worksheet: [Workbook16]Sheet1 Report Created: 4/21/2015 10:13:28 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.524376 Seconds. Iterations: 8 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 1e-06, Use Automatic Scaling Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, Assum Objective Cell (Min) Cell Name Original Value Final Value \$C\$19 Objective Function (Min) M1 34.55 73,550.00 Variable Cells Cell Name Original Value Final Value Integer \$C\$16 M1 1.00 2000.00 Contin \$D\$16 M2 1.00 4000.00 Contin \$E\$16 M3 1.00 1400.00 Contin \$F\$16 XD 1.00 4000.00 Contin \$G\$16 XE 1.00 0.00 Contin \$H\$16 YA 1.00 2100.00 Contin Constraints Cell Name Cell Value Formula Status Slack \$C\$23 A Amount Used (LHS) 21,600.00 \$C\$23<=\$E\$23 Binding 0 \$C\$24 C Amount Used (LHS) 12,200.00 \$C\$24<=\$E\$24 Not Binding 2800 \$C\$25 B Amount Used (LHS) 18,000.00 \$C\$25<=\$E\$25 Binding 0 \$C\$26 D Amount Used (LHS) 6,000.00 \$C\$26=\$E\$26 Binding 0 \$C\$27 E Amount Used (LHS) 4,000.00 \$C\$27=\$E\$27 Binding 0 \$C\$28 E Amount Used (LHS) 3,500.00 \$C\$28=\$E\$28 Binding 0
me NonNegative
Microsoft Excel 14.4 Sensitivity Report

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

Want to read all 11 pages?

• Fall '14
• LHS, LHS)