Maximum Capacity
10000 <=
10000
Chicago or Detriot
1 <=
1
Max number of Hubs
2 <=
2
Total Profit
25700000

BD
RHS
0
0
0
-3500
0
10000
1
1
2
-3500000
0
a.
Let:
A = Flights from Atlanta Hub
B = Flights from Boston Hub
C = Flights from Chicago Hub
D = Flights from Detroit Hub
BA = 1 if a Hub is opened in Atlanta, 0 otherwise
BB = 1 if a Hub is opened in Boston, 0 otherwise
BC = 1 if a Hub is opened in Chicago, 0 otherwise
BD = 1 if a Hub is opened in Detroit, 0 otherwise
Max (Profit): A*(3,000)+B*(3,800)+C*(3,500)+D*(4,000)-BA*(2,500,000)-BB*(4,500,0
S.t.
A,B,C,D >= 0, int
Non-negativity, integer
A-2,800*BA <= 0
Flight capacity for Atlanta
B-4,000*BB <= 0
Flight capacity for Boston
C-7000*BC <= 0
Flight capacity for Chicago
D-3,500*BD <= 0
Flight capacity for Detroit
A+B+C+D <= 10,000
Total flight capacity
BA+BB+BC+BD <= 2
Maximum hubs opened
BD+BC <= 1
If Detroit then not Chicago

000)-BC*(6,000,000)-BD*(3,500,000)

Microsoft Excel 16.0 Answer Report
Worksheet: [hw 4.xlsx]Ch. 6 Question 19
Report Created: 3/6/2018 11:36:12 PM
Result: Solver found a solution.
All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.032 Seconds.
Iterations: 13 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 NonNegativ
Objective Cell (Max)
Cell
Name
Original Value
Final Value
$B$35
Total Winning Probability LHS
3.1
3.1
Variable Cells
Cell
Name
Original Value
Final Value
Integer
$B$12
Attorney 1 Divorce
1
1 Contin
$C$12
Attorney 1 Bankruptcy
0
0 Contin
$D$12
Attorney 1 Labor & Employment
0
0 Contin
$E$12
Attorney 1 Criminal Law
0
0 Contin
$B$13
Attorney 2 Divorce
0
0 Contin
$C$13
Attorney 2 Bankruptcy
0
0 Contin
$D$13
Attorney 2 Labor & Employment
1
1 Contin
$E$13
Attorney 2 Criminal Law
0
0 Contin
$B$14
Attorney 3 Divorce
0
0 Contin
$C$14
Attorney 3 Bankruptcy
1
1 Contin
$D$14
Attorney 3 Labor & Employment
0
0 Contin
$E$14
Attorney 3 Criminal Law
0
0 Contin
$B$15
Attorney 4 Divorce
0
0 Contin
$C$15
Attorney 4 Bankruptcy
0
0 Contin
$D$15
Attorney 4 Labor & Employment
0
0 Contin
$E$15
Attorney 4 Criminal Law
0
0 Contin
$B$16
Attorney 5 Divorce
0
0 Contin
$C$16
Attorney 5 Bankruptcy
0
0 Contin
$D$16
Attorney 5 Labor & Employment
0
0 Contin
$E$16
Attorney 5 Criminal Law
0
0 Contin
$B$17


You've reached the end of your free preview.
Want to read all 18 pages?
- Spring '14
- ArthurA.Alexander
- Management, criminal law, Lawyer, attorney, LHS