Solve this using both the conventional LP spreadsheet model in Excel and also with the sThe 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 in Figure $5\mathrm{.}36$

FIGURE $5\mathrm{.}36$

Network flow

model for the blood

bank problem

along with the unit cost of shipping along each possible arc.

a$.$ Create a spreadsheet model for this problem.

b$.$ What is the optimal solution?

c$.$ Suppose that no more than $1,000$ units of blood can be transported over any one arc.

What is the optimal solution to this revised problem?olution layout presented in BMC evolved