solve this using solver in excel sheet The blood bank wants

solve this using solver in excel sheet!

The blood bank wants to determine The least expensive way to transport available blood donations from Pittsburg and Staunton to hospitals in Charleston, Roanoke, Richmond, Norfolk, and Suffolk. The supply and demand for donated blood is shown along with The unit cost of shipping along each possible arc. What is The optimal solution? Suppose that no more than 1000 units of blood can be transported over any one arc. What is The optimal solution to this revised problem?

Solution

This is special type of transportation problem. There are main supply centres at Pittsburgh (capacity 1300) and Staunton (capacity 1200) and five demand centres which are also used for tran-sshipments/ intermediaries,

The cost matrix is constructed as follows:

For excel solver, the data is given in the following table

I do not have solver so you can try with the above format to be keyed in excel sheet for solver

xij represents movement from ith node to jth node

From\\ To	3	4	5	6	7
1	3	4	12	7
2
3
4
5
6
7