Maximum Capacity 10000 10000 Chicago or Detriot 1 1 Max number of Hubs 2 2

# Maximum capacity 10000 10000 chicago or detriot 1 1

This preview shows page 5 - 9 out of 18 pages.

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