Hi I M Having Issues Creating The Excel File For The Below Problem

Hi,

I’m having issues creating the excel file for the below problem:

16. 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 in Figure 5.36 along with the unit cost of shipping along each possible arc.

**Within my book this info goes with Figure 5.36 but I don’t have an option to attach this figure for you to review.

Here is a link that reflects this Figure 5.36-hope you can access it.

a. I have to try to set up 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?

Ragsdale, Cliff. Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (Page 230). Cengage Learning. Kindle Edition. 

Can you help me by starting me off in the right direction?

Thanks!

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"