Four hospitals (1, 2, 3, 4) have their requirements for blood met through a central blood...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 2 3 $4 $6.5 4 $5.5 1 $2 $4.9 $6.9 $5.1 $4.5 $5.5 $2.5 $3.4 $6 100 245 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 2 3 $4 $6.5 4 $5.5 1 $2 $4.9 $6.9 $5.1 $4.5 $5.5 $2.5 $3.4 $6 100 245 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)
Expert Answer:
Answer rating: 100% (QA)
It appears theres an image provided with data and instructions to develop an optimization model for a blood shipment plan This seems to be a typical t... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
(7%) Problem 4: Consider a 575 nm light falling on a single slit of width 1.1 m. Randomized Variables 2=575 nm w= 1.1 m CA At what angle (in degrees) is the first minimum for the light?
-
. A vertical pole that is 2 meters tall casts a shadow that is 1.5 meters long. Nearby, at the same time, another vertical pole casts a shadow that is 6.5 meters long. How tall is this pole? a. Make...
-
The earnings per share (in dollars) for a company can be approximated by the function f(x) = -5.9 +3.57 In x, where x=7 corresponds to the year 2007. (a) Find the earnings per share for the year...
-
Use the test of your choice to determine whether the following series converge. 1 1! + 4 2! + 9 16 + 3! 4!
-
The scene is a conference room on the 10th floor of an office building on Wall Street, occupied by Anthes Enterprises, a small, rapidly growing manufacturer of electronic trading systems for...
-
Which of the following is not a common oxidation number for sulfur in its compounds? (a) 2 (b) +6 (c) +3 (d) +4
-
Refer to problem 7-43. Assume Tullis could use the manufacturing facilities which are no longer needed to make the VI valves to produce a new line of small pumps. The small pumps would provide a...
-
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Since both forklifts perform the same function, the firm will choose...
-
Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The company's planning budget for May appears below. Puget Sound...
-
Company A is a global company based in the United States that operates in the financial industry. Company A serves its customers with financial products, such as checking accounts, bank cards, and...
-
The components of comprehensive income can be presented in which of the folowing formats? A single continuous statement or two separate, but consecutive statements. A single continuous statement....
-
Answer the questions below. (If necessary, consult a list of formulas.) (a) A company that makes crayons is trying to decide which 4 colors to include in a promotional mini-box of 4 crayons. The...
-
An insurance company is trying to determine if there is a significant difference in the mean approval based on education level. The accompanying approval data comes from a sample of customer....
-
REQUIRED: From David Green's perspective, develop an analysis which explains your performance for the year ended December 31, 2013. Case 14-1: Pet Groom & Clean (PG&C) (no author), In: Blocher, E.,...
-
At the end of 2017, Spotify, the music streaming service, ran a humorous campaign to encourage its users to share their data on what they listened to. The campaign was created entirely in-house, with...
-
1. (10 points.) A random sample of 25 customers is taken and their yearly value to the company is calculated. The calculated average value from the sample is $10 and the standard deviation calculated...
-
1 . What is the present value of $1000 paid at the end of each of the next 100 years if the interest rate is 7% per year? 2 . Assume that your parents wanted to have $160,000 saved for college by...
-
A fuel pump sends gasoline from a car's fuel tank to the engine at a rate of 5.88 10-2 kg/s. The density of the gasoline is 735 kg/m3, and the radius of the fuel line is 3.18 10-3 m. What is the...
-
William sold Section 1245 property for $25,000 in 2012. The property cost $35,000 when it was purchased 5 years ago. The depreciation claimed on the property was $16,000. a. Calculate the adjusted...
-
Skyler is covered by his company's health insurance plan. The health insurance costs his company $3,500 a year. During the year, Skyler is diagnosed with a serious illness and the health insurance...
-
Dr. George E. Beeper is a single taxpayer. He lives at 45 Mountain View Dr., Apt. 321, Spokane, WA 99210. Dr. Beeper's Social Security number is 775-88-9531. Dr. Beeper works for the Pine Medical...
-
The market interest rate is 15 percent. What is the price of a consol bond that pays \($120\) annually?
-
Assuming an interest rate of 10 percent, calculate the present value of the following streams of yearly payments: a. \($1,000\) per year forever, with the first payment one year from today. b....
-
World Transportation, Inc., is expected to initiate its quarterly dividend of \($1\) five years from today and the dividend is expected to remain constant permanently. What is the price of World...
Study smarter with the SolutionInn App