BLAH 1 - Microsoft Excel 15.24 Answer Report Worksheet[Workbook1]Sheet1 Report Created 7:27:47 PM Result Solver found a solution All constraints and

# BLAH 1 - Microsoft Excel 15.24 Answer Report...

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

Microsoft Excel 15.24 Answer Report Worksheet: [Workbook1]Sheet1 Report Created: 10/11/16 7:27:47 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.172886 Seconds. Iterations: 5 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume Objective Cell (Min) Cell Name Original Value Final Value \$B\$15 OBJ.VAL 387000 387000 Variable Cells Cell Name Original Value Final Value Integer \$D\$14 FM 5000 5000 Contin \$E\$14 FP 0 0 Contin \$F\$14 SM 3000 3000 Contin \$G\$14 SP 7000 7000 Contin \$H\$14 TM 0 0 Contin \$I\$14 TP 5000 5000 Contin Constraints Cell Name Cell Value Formula Status Slack \$C\$17 CONST1 LHS 22200 \$C\$17<=\$E\$17 Binding 0 \$C\$18 CONST2 LHS 16900 \$C\$18<=\$E\$18 Not Binding 8900 \$C\$19 CONST3 LHS 24100 \$C\$19<=\$E\$19 Not Binding 17300 \$C\$20 CONST4 LHS 5000 \$C\$20>=\$E\$20 Binding 0 \$C\$21 CONST5 LHS 10000 \$C\$21>=\$E\$21 Binding 0 \$C\$22 CONST6 LHS 5000 \$C\$22>=\$E\$22 Binding 0
NonNegative
Microsoft Excel 15.24 Sensitivity Report

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

Want to read all 8 pages?

• Fall '08
• Chen,J
• LHS