The Red Cross owns four blood banks in a large metropolitan area and makes weekly shipments of blood containers to five area hospitals.
You need to help them develop a sourcing plan which minimizes transportation costs.
The tables below show (1) how many containers of blood can be supplied be each bank, (2) the weekly demand for each hospital, and (3) the cost per container of transporting from each bank to each hospital.
|
Source
|
Supply
|
|
Bank 1
|
80
|
|
Bank 2
|
80
|
|
Bank 3
|
110
|
|
Bank 4
|
100
|
|
Hospital 1
|
Hospital 2
|
Hospital 3
|
Hospital 4
|
Hospital 5
|
|
95
|
65
|
75
|
80
|
45
|
|
From \ To
|
Hospital 1
|
Hospital 2
|
Hospital 3
|
Hospital 4
|
Hospital 5
|
|
Bank 1
|
23
|
29
|
40
|
30
|
38
|
|
Bank 2
|
34
|
44
|
26
|
25
|
39
|
|
Bank 3
|
26
|
43
|
24
|
35
|
35
|
|
Bank 4
|
38
|
26
|
41
|
44
|
43
|
Create a Solver model to assign the shipment of blood to the hospitals. What is the lowest cost for transporting blood to the four hospitals?
R=