Four hospitals (1, 2, 3, 4) have their requirements for blood met through a central blood distribution office that coordinates deliveries from three blood banks (A, B, and C) on a weekly basis. The costs to ship a standard pouch of blood from each blood bank to each hospital are reported in the table below. The table also provides, for an upcoming week, the weekly number of pouches available at each blood bank and the number of pouches required, i.e. the demand, at each hospital. Blood Bank A B с Demand Hospital 1 2 3 $4 $6.5 $4.9 $6.9 $5.1 $4.5 4 $5.5 $2 $2.5 $3.4 $6 $5.5 80 240 100 190 Pouches Available 150 200 320 Develop the optimization model that obtains an optimal shipment plan that ensures that capacities at warehouses are not violated and demands are met exactly. Compute the optimal shipment cost by solving the model using an optimizer such as EXCEL's Solver. (Specify as a whole number)
Four hospitals (1, 2, 3, 4) have their requirements for blood met through a central blood distribution office that coordinates deliveries from three blood banks (A, B, and C) on a weekly basis. The costs to ship a standard pouch of blood from each blood bank to each hospital are reported in the table below. The table also provides, for an upcoming week, the weekly number of pouches available at each blood bank and the number of pouches required, i.e. the demand, at each hospital. Blood Bank A B с Demand Hospital 1 2 3 $4 $6.5 $4.9 $6.9 $5.1 $4.5 4 $5.5 $2 $2.5 $3.4 $6 $5.5 80 240 100 190 Pouches Available 150 200 320 Develop the optimization model that obtains an optimal shipment plan that ensures that capacities at warehouses are not violated and demands are met exactly. Compute the optimal shipment cost by solving the model using an optimizer such as EXCEL's Solver. (Specify as a whole number)
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 7 images
Recommended textbooks for you
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
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