Relief Supply

Vala Rahmati and Halit Uster

A.    Computational Study Data

The link to download the instance data files used for computational study is given below

·         Computational study Data Instances - Dataset.zip

There are 24 excel files representing classes C1 - C8 for 3 different networks G1 – G3, and within each file there are 10 sheets representing instances that are randomly generated. The folder names follow a particular naming convention to help a user match easily:

Folder name format: G[A]-C[B]-[C]-[D]-[E]-[F]-[G]-[H]

A: = Utilized graph, B: = Class Number, C: = number of DCs, D: = number of transfer nodes,

E: = number of Shelters, F: = Time period, G: = number of relief items, H: = Number of arcs.

For example,

G2-C6-16-88-22-20-4-363 contains 10 instance sheets of class 6 applied on network 2 with 16 DCs, 88 transfer nodes, 22 shelters, 20 time periods, 4 relief items, and 363 arcs.

Each instance sheet within such a file is named as Ii where i = 1, …, 10 (index number).

 

We now explain the content of a data file.

The legend used in these data files is explained in the following table.

Symbol

Details

DC List [ID, X, Y, Item1_Capacity, Item2_Capacity, Item3_Capacity, Item4_Capacity, Fixed Cost]

DC ID, (x, y) coordinates, Capacity of items stored in that DC, and fixed cost for opening that DC.

Transfer List [ID, X, Y, Fixed Cost, Associated Preparation Cost]

Transfer node ID, (x, y) coordinates, fixed cost of utilizing that transfer node, and associated preparation cost in transfer node.

Shelter List [ID, X, Y, Capacity]

Shelter ID, (x, y) coordinates, and the capacity of people hosted in that shelter.

Arc List [Origin ID, Destination ID, Fixed Cost, Variable Cost, Capacity, Distance]

Arc’s origin node ID, Arc’s destination node ID, fixed cost of utilizing that arc, transportation cost of using that arc, arc capacity for relief items, Distance between origin and destination of that arc.

 

 

B.     Case Study Data

The case study data are available in the folder GIS-data within dataset.zip. In this folder, all model parameters are given in Excel files, labeled as follows:

·         DC Data: All data related to distribution centers are stored in this excel file.

Header

Description

ID

ID of DC

CNTY_NM

County that DC

Population

Population of DC county

X

X-coordinates

Y

Y-coordinates

Capacity_Item1

Capacity of item 1 in DC

Capacity_Item2

Capacity of item 2 in DC

Capacity_Item3

Capacity of item 3 in DC

Capacity_Item4

Capacity of item 4 in DC

Fixed_Cost

Fixed cost of opening DC

 

·         Transfer Data: All data related to transfer nodes are stored in this excel file.

Header

Description

ID

ID of transfer node

X

X-coordinates

Y

Y-coordinates

Fixed_Cost

Fixed cost of utilizing transfer node

Associated_Preparation_Cost

Preparation cost of using transfer nodes

 

·         Shelter Data: All data related to shelters are stored in this excel file.

Header

Description

ID

ID of shelter

X

X-coordinates

Y

Y-Coordinates

County

County of shelter

Capacity

Capacity of shelter for evacuees

 

·         Arc Data: All data related to arcs are stored in this excel file.

Header

Description

Origin Node

Origin node of arc

Destination Node

Destination node of arc

Fixed Cost

Fixed cost of utilizing arc

Variable Cost

Relief transportation cost through this arc

Capacity

Capacity of arc

Distance

Origin-destination distance of arc

 

We use the following counties given in the figure below, to construct the shelter and DC zones respectively. 

Detailed information about these regions is given in the following table.

Supply Region

Shelter Region

County

Population

County

Population

Coke

3,285

Angelina

86,396

Coleman

7,684

Atascosa

48,981

Concho

3,303

Bell

370,647

Cooke

41,668

Bexar

2,009,324

Crockett

3,098

Frio

18,385

Jack

8,472

Gonzales

19,653

Shackelford

3,105

Houston

22,066

Stephans

9,101

Kendall

44,279

Sutton

3,372

La Salle

50,088

Val Verde

47,586

Robertson

16,757

Wise

68,632

Smith

233,479

 

 

Travis

1,290,188

 

 

Walker

76,400

 

 

Washington

35,805

 

 

Webb

267,114

 

Candidate DCs and shelters are considered in centroid of selected regions, respectively.