8S Final - Microsoft Excel 14.5 Answer Report Worksheet[Workbook2]Sheet1 Report Created 9:16:26 PM Result Solver found a solution All constraints and

# 8S Final - Microsoft Excel 14.5 Answer Report...

• Test Prep
• 8

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

Microsoft Excel 14.5 Answer Report Worksheet: [Workbook2]Sheet1 Report Created: 11/29/2015 9:16:26 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 1.313111 Seconds. Iterations: 18 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 N Objective Cell (Min) Cell Name Original Value Final Value \$N\$26 Total Cost = 1050 1050 Variable Cells Cell Name Original Value Final Value Integer \$D\$17 Sources Destinations 0 0 Contin \$E\$17 Sources 15 15 Contin \$F\$17 Sources 75 75 Contin \$G\$17 Sources 0 0 Contin \$H\$17 Sources 0 0 Contin \$I\$17 Sources 0 0 Contin \$J\$17 Sources 0 0 Contin \$K\$17 Sources 0 0 Contin \$D\$18 Destinations 105 105 Contin \$E\$18 0 0 Contin \$F\$18 0 0 Contin \$G\$18 0 0 Contin \$H\$18 0 0 Contin \$I\$18 0 0 Contin \$J\$18 0 0 Contin \$K\$18 0 0 Contin \$D\$19 Destinations 45 45 Contin \$E\$19 60 60 Contin \$F\$19 0 0 Contin \$G\$19 0 0 Contin \$H\$19 0 0 Contin \$I\$19 0 0 Contin \$J\$19 0 0 Contin \$K\$19 0 0 Contin \$D\$20