MGMT 414 CU Management Analytics Lab Report

MGMT 414: Management Analytics Chapter 5 Lab #3Please see the Excel File on blackboard for a template in completing your labs.
Any questions can be completed in a Textbox.
1. A furniture manufacturer has warehouses in cities represented by nodes 1, 2,
and 3 in Figure 5.37. The values on the arcs indicate the per unit shipping costs
required to transport living room suites between the various cities. The supply of
living room suites at each warehouse is indicated by the negative number next to
nodes 1, 2, and 3. The demand for living room suites is indicated by the positive
number next to the remaining nodes.
a)
b)
2. The blood bank wants to determine the least expensive way to transport
available blood donations from Pittsburgh and Staunton to hospitals in
Charleston, Roanoke, Richmond, Norfolk, and Suffolk. The supply and demand for
donated blood is shown below along with the unit cost of shipping along each
possible arc.
Answer
3. The U.S Department of Transportation (DOT) is planning to build a new
interstate to run from Detroit, Michigan, to Charleston, South Carolina. A number
of different routes have been proposed and are summarized in Figure 5.44,
where node 1 represents Detroit and node 12 represents Charleston. The
numbers of the arcs indicate the estimated construction costs of the various links
(in millions of dollars). It is estimated that all of the routes will require
approximately the same total driving time to make the trip from Detroit to
Charleston. Thus, the DOT is interested in identifying the least costly alternative.
a.
b.
Bonus. Draw the network representation of the following network flow problem.
Furniture Distribution
Arcs
Ship:
From:
To:
Cost
Node
Net Flow
Supply or Demand
0
0
0
0
0
0
1
1
2
2
3
3
3
4
4
5
4
6
$20.0
$30.0
$10.0
$20.0
$20.0
$40.0
1
2
3
4
5
6
0
0
0
0
0
0
-30
-40
-20
10
30
40
0
0
0
4
5
5
6
4
6
$30.0
$50.0
$30.0
Total:
$0.0
Blood Bank
Ship
From
To
Unit Cost
0
0
0
0
0
0
0
1
1
2
2
3
3
3
Pittsburgh
Pittsburgh
Staunton
Staunton
Charleston
Charleston
Charleston
3
4
3
4
4
5
6
Charleston
Roanoke
Charleston
Roanoke
Roanoke
Richmond
Norfolk
$3
$4
$3
$4
$7
$9
$6
0
0
0
0
0
4
4
4
5
6
Roanoke
Roanoke
Roanoke
Richmond
Norfolk
3
6
7
6
7
Charleston
Norfolk
Suffolk
Norfolk
Suffolk
$7
$4
$8
$3
$2
Total Transportation Cost
$0
Nodes
1
2
3
4
5
6
7
Net Flow
Supply/Demand
Pittsburgh
Staunton
Charleston
Roanoke
Richmond
Norfolk
Suffolk
0
0
0
0
0
0
0
-1300
-1200
300
200
800
700
400
US Dept of Transportation
Arcs
Ship:
From:
To:
Cost
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
2
2
3
4
4
4
5
5
5
2
3
4
5
6
6
6
7
9
6
8
9
$1.0
$3.0
$2.0
$4.0
$3.0
$2.0
$2.0
$3.0
$4.0
$1.0
$3.0
$3.0
0
0
0
0
0
0
0
0
0
6
7
7
8
9
9
10
10
11
9
9
10
11
11
12
11
12
12
$2.0
$2.0
$3.0
$2.0
$1.0
$2.0
$3.0
$5.0
$3.0
Total:
$0.0
Node
1
2
3
4
5
6
7
8
9
10
11
12
Net Flow
Supply or Demand
0
0
0
0
0
0
0
0
0
0
0
0
-1
0
0
0
0
0
0
0
0
0
0
1
Insert a picture of a hand written drawing of your network model
MGMT 414: Management Analytics Chapter 5 Lab #3
Please see the Excel File on blackboard for a template in completing your labs.
Any questions can be completed in a Textbox.
1. A furniture manufacturer has warehouses in cities represented by nodes 1, 2,
and 3 in Figure 5.37. The values on the arcs indicate the per unit shipping costs
required to transport living room suites between the various cities. The supply of
living room suites at each warehouse is indicated by the negative number next to
nodes 1, 2, and 3. The demand for living room suites is indicated by the positive
number next to the remaining nodes.
2. The blood bank wants to determine the least expensive way to transport
available blood donations from Pittsburgh and Staunton to hospitals in
Charleston, Roanoke, Richmond, Norfolk, and Suffolk. The supply and demand for
donated blood is shown below along with the unit cost of shipping along each
possible arc.
3. The U.S Department of Transportation (DOT) is planning to build a new
interstate to run from Detroit, Michigan, to Charleston, South Carolina. A number
of different routes have been proposed and are summarized in Figure 5.44,
where node 1 represents Detroit and node 12 represents Charleston. The
numbers of the arcs indicate the estimated construction costs of the various links
(in millions of dollars). It is estimated that all of the routes will require
approximately the same total driving time to make the trip from Detroit to
Charleston. Thus, the DOT is interested in identifying the least costly alternative.
Bonus. Draw the network representation of the following network flow problem.