homewrkweek 10

profilewmsras
hw10_answer_sheet_2015.xlsx

P1

1. transportation problem
From To (cost)
1 2 3
A $5 $4 $3
B 2 3 5
C 4 8 7
DV From To Supply Note: Blue cells are your decision variables
1 2 3 Constraint
A <= 130
B <= 70
C <= 100
Constraint
= = =
Demand 80 110 60
Objective Minimize Cost

P2

2. transportation problem
From To (cost)
1 2 3
A $5 $12 $2
B 2 9 5
C 4 24 7
DV From To Supply Note: Blue cells are your decision variables
1 2 3 Constraint
A <= 130
B <= 70
C <= 100
Constraint
= = =
Demand 80 110 60
Objective Minimize Cost

P3

3. World Foods, Inc.
From To (cost)
4. Norfolk 5. New York 6. Savannah
1. Hamburg $420 $390 $610
2. Marseilles 510 590 470
3. Liverpool 450 360 480
Warehouse Distribution Center
7. Dallas 8. St. Louis 9. Chicago
4. Norfolk $75 $63 $81
5. New York 125 110 95
6. Savannah 68 82 95
DV From To (cost) Supply from sources
4. Norfolk 5. New York 6. Savannah Constraints
1. Hamburg <= 55
2. Marseilles <= 78
3. Liverpool <= 37
Warehouse Distribution Center
7. Dallas 8. St. Louis 9. Chicago Constraints Net Flow (distribution center)
4. Norfolk = 0.00
5. New York = 0.00
6. Savannah = 0.00
Constraints
= = =
Demand 60 45 50
Objective Minimize Cost

P4

4. Omega pharmaceutical firm
Region (days)
Sales-person A B C D E
1 17 10 15 16 20
2 12 9 16 9 14
3 11 16 14 15 12
4 14 10 10 18 17
5 13 12 9 15 11
DV Sales-person A B C D E Assignment
1 = 1
2 = 1
3 = 1
4 = 1
5 = 1
Constraints
= = = = =
Region assigned 1 1 1 1 1
Objective Minimize Time