# Using solver find out the solution to the the Philips Drug Company. This company has three wareho...

###### Question:

Using solver find out the solution to the the Philips Drug Company. This company has three warehouses, denoted by W1, W2, and W3. The first W1, is in Chicago, W2 is in Mississippi, and W3 is in New York. It sells primary to four major distributors: D1, D2, D3, and D4. Located in Washington, Ohio, Texas, and Canada, respectively. Due to the different modes of Transportation and the different distances involved, the costs of shipping a truckload of drugs from the different warehoused to the different markets vary, and they are given in the following table (the costs are on hundreds):

 From/to D1 D2 D3 D4 W1 22 36 24 23 W2 31 19 32 26 W3 25 25 16 22

This is, to ship a truckload of goods from warehouse W 1 to distributor D2 costs $3600. To ship a truckload of goods from warehouse W3 to distributor D4 costs$2200. Given that W1, W2, and W3 have respectively 20, 30 and 50 truckloads of drugs to be shipped and that D1, D2, D3, and D4 need respectively 20, 30, 30, and 20 truckloads of drugs. What is the cheapest way of shipping the drugs so as to meet all the demands?

***Use Microsoft Excel solver for this problem

#### Similar Solved Questions

##### Please answer all 3 photos f () = sin 2 - 2 ) + 3 a)...
please answer all 3 photos f () = sin 2 - 2 ) + 3 a) Give the period of the function b) Give the phase shift of the function c) Give the amplitude of the function d) Give the equation of the mid-line for the function e) What is the maximum value this function will have? 2 Daylight hours in New ...
##### I got a 70 on last case study. I answered all questions correctly, I asked teacher...
I got a 70 on last case study. I answered all questions correctly, I asked teacher what she wanted she said answer questions. Chapter Ten Case Surdy: Pain Assessment: The Fifth Vital Sign J.P. is a 15 year-old African American adolescent who was diagnosed with sickle cell disease 3 years ago. J.P. p...
##### Question 11 What is the best choice of sent to achieve the following reaction OH 2...
Question 11 What is the best choice of sent to achieve the following reaction OH 2 OH a. LIATHA b. H2SO4 | ( NaOH, H20 d. 12:04 Moving to another question will save this response...
##### Write down reflective journal on political power. i will give you reading article name is Morgenthau...
write down reflective journal on political power. i will give you reading article name is Morgenthau - Excerpt from Politics Among Nations these are instructions for reflective jounal :- All you need to do it write 300 words for each week on the weekly theme. So for week #1 on the politics of pandem...
##### Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard cost system to help control costs and has established the following standards for the Maze toy: Direct materials: 7 microns per toy at $0.34 per micron Direct labor: 1.3 hours per toy at$7.50 per hour...
##### 48. What volume of a 0.65 M solution of glucose (C6H12O6) contains 12.5 g of glucose?
48. What volume of a 0.65 M solution of glucose (C6H12O6) contains 12.5 g of glucose?...
##### The area of a typical eardrum is about 5.1 × 10?5 m2 a) Find the sound...
The area of a typical eardrum is about 5.1 × 10?5 m2 a) Find the sound power (the energy per second) incident on an eardrum at the threshold of hearing 1 × 10?12 W/m2 . Answer in units of W. b) Find the sound power incident on an eardrum at the threshold of pain 1 W/m2 . Answer in units ...
The following transactions occur for Cardinal Music Academy during the month of October: a. Provide music lessons to students for $14,500 cash. b. Purchase prepaid insurance to protect musical equipment over the next year for$3,900 cash. c. Purchase musical equipment for $17,500 cash. d. Obtain a l... 1 answer ##### A 350 MW coal-burning power plant consumes 4478 tons of coal per day when it operates at full load. Given the energy content of the coal used in this power plant 21 million Btu/ton, what is the heat... A 350 MW coal-burning power plant consumes 4478 tons of coal per day when it operates at full load. Given the energy content of the coal used in this power plant 21 million Btu/ton, what is the heat rate of this power generation plant? A 350 MW coal-burning power plant consumes 4478 tons of coal pe... 1 answer ##### There are 70 lamb snacks in a pack of "Doggy Meat Snacks". The total number of... There are 70 lamb snacks in a pack of "Doggy Meat Snacks". The total number of snacks in the bag is confidence interal for a population proportion of lamb snacks. 100 . We wish to calculate 90% a. (3%) Which distribution should you use for this problem? (pick one) b. (3%) The sample proporti... 1 answer ##### What is the yield to maturity of a eight-year,$10,000 bond with a 4.6% coupon rate...
What is the yield to maturity of a eight-year, $10,000 bond with a 4.6% coupon rate and semiannual coupons if this bond is currently trading for a price of$9,572? O A. 6.31% OB. 7.37% OC. 2.63% OD. 5.26%...
##### Question 3 0/1 pts Consider the circuit shown. The switch is initially open and the capacitor...
Question 3 0/1 pts Consider the circuit shown. The switch is initially open and the capacitor completely discharged. All resistors have a resistance R and the capacitor has a capacitance C. The battery is ideal and provides a potential V The switch is closed at time 0, allowing current to flow. Whic...