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
Image of page 5
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
Image of page 6
000)-BC*(6,000,000)-BD*(3,500,000)
Image of page 7
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
Image of page 8
Image of page 9

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture