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...

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
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture