Take home 2-1 MS - Microsoft Excel 14.4 Answer Report Worksheet[Workbook4]Sheet1 Report Created 12:17:33 PM Result Solver found a solution All

# Take home 2-1 MS - Microsoft Excel 14.4 Answer Report...

• 7

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

Microsoft Excel 14.4 Answer Report Worksheet: [Workbook4]Sheet1 Report Created: 2/27/2017 12:17:33 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 1.365351 Seconds. Iterations: 17 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 0.000001, Use Automatic Scalin Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, Assu Objective Cell (Max) Cell Name Original Value Final Value \$F\$25 Total Repairmen Avaliable 0 45 Variable Cells Cell Name Original Value Final Value Integer \$B\$16 Repairman 1 Plane 1 0 0 Contin \$C\$16 Repairman 1 Plane 2 0 0 Contin \$D\$16 Repairman 1 Plane 3 0 0 Contin \$B\$17 Repairman 2 Plane 1 0 1 Contin \$C\$17 Repairman 2 Plane 2 0 0 Contin \$D\$17 Repairman 2 Plane 3 0 0 Contin \$B\$18 Repairman 3 Plane 1 0 0 Contin \$C\$18 Repairman 3 Plane 2 0 0 Contin \$D\$18 Repairman 3 Plane 3 0 1 Contin \$B\$19 Repairman 4 Plane 1 0 0 Contin \$C\$19 Repairman 4 Plane 2 0 1 Contin \$D\$19 Repairman 4 Plane 3 0 0 Contin \$B\$20 Repairman 5 Plane 1 0