The blood bank wants to determine the least expensive way to transport available blood donations from Pittsburg

Question:

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 in Figure 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 1000 units of blood can be transported over any one arc. What is the optimal solution to this revisedproblem?

The blood bank wants to determine the least expensive way

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

ISBN: 978-0324656633

5th edition

Authors: Cliff T. Ragsdale

See More Books

Question Posted: Oct 06, 2012 06:35 AM

See More Questions

A 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. Figure...
A quality standard says that no more than 2 percent of the eggs sold in a store may be cracked (not broken, just cracked). In 3 cartons (12 eggs each carton), 2 eggs are cracked. (a) At the .10 level...
A state weights-and-measures standard requires that no more than 5 percent of bags of Halloween candy be underweight. A random sample of 200 bags showed that 16 were under- weight. (a) At = .025, is...
dentify a true statement about penetration pricing. It emphasizes a company's current performance but can sacrifice long-term performance. It requires a company to price goods to cover variable costs...
Let L: V ( W be an isomorphism of vector space V onto vector space W. (a) Prove that L(0V) =0W. (b) Show that L(v - w) = L(v) - L(w).
In Exercises the derivative of the function has the same sign for all x in its domain, but the function is not one-to-one. Explain. f(x) = tan x
During the COVID19 pandemic, local governments in the United States ordered some businesses, including restaurants, gyms, and movie theaters, to close, and as a result, those businesses laid off...
Kari Downs, an auditor with Wheeler CPAs, is performing a review of Depue Companys inventory account. Depue did not have a good year, and top management is under pressure to boost reported income....
11. If dy + 2y tan x = sin x, 0
According to the website of the American Association for Justice,11 Stella Liebeck of Albuquerque, New Mexico, was severely burned by McDonalds coffee in February 1992. Liebeck, who re-ceived third-...
A cotton grower in south Georgia produces cotton on farms in Statesboro and Brooklet, ships it to cotton gins in Claxton and Millen, where it is processed, and then sends it to distribution centers...
A furniture manufacturer has warehouses in cities represented by nodes 1, 2, and 3 in Figure. The values on the arcs indicate the per unit shipping costs required to transport living room suites...
What is the allowable exemption for the alternative minimum tax assuming that a married couple has alternative minimum taxable income of $\$ 1,200,000$ ?
Charlotte, a single taxpayer, operates a restaurant as a sole proprietor. In 2022, her business generates income of $160,000, and incurs expenses of $50,000, and $4,000 of qualified dividend income....
1) How adequate is Australian law in addressing online abhorrent violent material? 2) What is the role and regulatory power of the e-Safety Commissioner? In what ways is this position a departure...
If there are 400 vacant units on the market, of which you own 40, what is your anticipated capture rate? (Assume no other units come available within this time frame.)
Pat Leif owned an apartment house that he bought in 2006. Depreciation was taken on a straight-line basis. When Pat's adjusted basis for this property was $200,000, he traded it for an office...
Diana and Charles are MFJ in 2022. Their taxable income before QBI deduction is $500,000, and they have $400,000 in QBI from the restaurant they own. They paid their five employees $220,000 in W-2...
When adding a comment to a variable declaration, always begin the comment one space after the end of the declaration. (T / F)
Use integration by parts to evaluate the following. Check your answer by taking the derivative. x2e-xdx
Writing: Establishing Your Credibility; Microblogging Skills , Chapter 8 Search LinkedIn for the profile of an expert in any industry or profession. Now imagine that you are going to introduce this...
Use Solver to create a Sensitivity Report for question 17 at the end of Chapter 3, and answer the following questions: a. Is the solution degenerate? b. Would the solution change if the price of...
Refer to question 44 in Chapter 3, and answer the following questions: a. Create a Spider Plot to summarize what happens to the optimal total profit as the total storage capacity increases from...
As rush coordinator for the Alpha Beta Chi (ABC) sorority, Kim Grant asked each pledge to identify five existing members of ABC whom she would most like to have as a big sister. Kim then asked the...
Read"Why Race Isn't as"Black"and White"as We Think"by Brent Staples. What can you find out about your own racial,religious,and cultural heritage? Search the Gateway library database: Ancestry Library...
Describe the classic steps for identifying an endocrine gland. Are these steps practical for identifying the sources of all the hormones we know of today? Explain.
Assuming Jeff has a mild chronic disease, and he has a private hospital health insurance. His salary before tax is $170,000. And assuming he has sold $30,000 of mutual fund units after he bought them...

The blood bank wants to determine the least expensive way to transport available blood donations from Pittsburg

Question:

Pittsburgh 300 800 Charleston Richmond -1300 135 Suffolk 7 400 Staunton 1200 246 Roanoke 200 Norfolk 700

Step by Step Answer:

a b and c Ship From To Unit Cost Nodes Net Flow SupplyDemand 0 1 Pittsburgh 3 Charleston 3 1 Pittsbu...View the full answer

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

Students also viewed these Management Leadership questions