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 the figure below along with the unit cost of shipping along each possible arc. The goal is to meet the expected demand at the lowest possiblecost. (Let X;; represent the number of units that flow from node i to node j.)Pittsburgh-1,3001Staunton-1,200 2LOCharleston35Roanoke30037 7200LORichmond5(X13X14 X231 X24¹ X34¹ X35¹ X36¹ X43¹ X46¹ X47, X56, X67) =6=Norfolk800(a) Create a spreadsheet model for this problem. What is the optimal solution?5637002Suffolk7400(b) 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?(X13, X14¹ X23¹ X241 X341 X351 X361 X431 X46¹ X47, X56, X67)

The supply node of Pittsburgh is producing 1300 units and that of Staunton is producing 1200 units.…

Answered: The blood bank wants to determine the…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

solve the following LP MODELS
Answer correctly on excel and show workings
The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?
Please refer to the attached file:
a company's business model was to operate through its facilities- Vancouver, Calgary, Winnipeg, Toronto(ontario), ottawa, Montreal and Halifax. Supply comes from South America, southeast Asia, and Florida. the company was shipping first to Toronto and then to each facility at a total cost of $23095.5 per week. The company is considering the possibility of opening a logistics facility in Miami. Toronto and Vancouver were already available as transshipment centres. What would be the cost savings if Miami centre was opened and what would be the optimal shipment plan?
Explain along with examples related to Freight Traffic Assignment Problems and vehicle routing problem in the logistics activities of manufacturing and service companies! Solve the following case study using the transportation method: Suppose there is a manufacturing company that produces and distributes its products to various customer locations across the country. This company has three production plants (Plant A, Plant B, and Plant C) located in different locations, and there are also five distribution centers (DC 1, DC 2, DC 3, DC 4, and DC 5) scattered across various regions. The company's goal is to determine the most efficient transportation routes for delivering products from the plants to the distribution centers, considering transportation costs and available capacities.
The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning their long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B 1 $1.70 $1.90 $1.60 $1.70 2 $1.40 $1.90 $1.60 $1.70 3 $1.60 $1.50 $1.80 $1.40 a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? O A. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center needed, O B. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. C. The sum of supply capacities…
The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning their long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B D $1.90 $1.90 $1.70 $1.60 $1.70 2 $1.40 $1.60 $1.70 3 $1.60 $1.50 $1.80 $1.40 a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? O A. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. O B. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. O C. The sum of supply capacities…
The Rae Mischel Company expanded its shipping capacity and the additional cost of doing this from each warehouse to terminal is highlighted in the following table. Determine theminimum cost to ship from each warehouse to terminal.
A bank has its head office in the financial district in the middle ofa city. A bank has six branches, three in the north of the city and threein the south all 5 km from the centre and spaced 3 km apart. The bankwishes to link all its branches via private leased lines but mustdecide between providing an individual line to each branch via anumber of inter-branch links and a smaller number of multiplexed linesto the centre. If a modem costs £100, a multiplexer/demultiplexercosts £200 and leased lines cost £100 per km per year to rent, suggesta design that will yield the most cost effective solution if theinstallation is to remain in operation for four years. 1st option is - link all branches by providing individual line to each branch via a number of inter branch links to the centre. 2nd option is - link all branches by providing smaller number of multiplexed lines to the centre Please calculate both options and choose the most cost effective solution for four years?
The prices for traveling between five cities in Colorado by bus are given in the table below. Use the edge-picking algorithm to find a low-cost bus route that starts and ends in Boulder and visits each city. Colorado Springs Grand Junction $48 $24 $21 $44 $57 Boulder Denver Boulder $15 Colorado Springs $24 Grand Junction $48 Durango $73 Denver $15 $21 $44 $71 O Boulder-Denver-Colorado Springs-Grand Junction-Durango-Boulder O Boulder-Colorado Springs-Denver-Durango-Grand Junction-Boulder O Boulder-Colorado Springs-Denver-Grand Junction-Durango-Boulder O Boulder-Denver-Colorado Springs-Durango-Grand Junction-Boulder O Boulder-Grand Junction-Colorado Springs-Denver-Durango-Boulder $57 $58 -- $31 Durango $73 $71 $58 $31

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS