1 answer

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


Answers

Gaten tha -find out t Soluton to tHha phips Dug (ca Compan has hnehouedenoled by cara da, Dq - Th dterent model 04 Avans potaehatto Calculate o th laHa i 22 62 2.0 26. 00 2 39 5 0 U325 L6 25 203O 2.0 0o them hae asams than cal ctat o ond 6 2to Calculoto thim o Conclu son Cost 4000 Di 5 000 02 μ-8000 16.3 OK100 03 3 22 K20x 100 Dy 193000

.

Similar Solved Questions

1 answer
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 ...
1 answer
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...
1 answer
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...
1 answer
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...
1 answer
Your older brother turned 35 today, and he is planning to save $90,000 per year for...
Your older brother turned 35 today, and he is planning to save $90,000 per year for retirement, with the first deposit to be made one year from today. He will invest in a mutual fund that's expected to provide a return of 7.5% per year. He plans to retire 30 years from today, when he turns 65, a...
1 answer
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...
1 answer
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?...
1 answer
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 ...
1 answer
The following transactions occur for Cardinal Music Academy during the month of October: a. Provide music...
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%...
1 answer
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...
1 answer
Air is a gas mixture, and consists of approximately 78% nitrogen and 21% oxygen. Calculate the...
Air is a gas mixture, and consists of approximately 78% nitrogen and 21% oxygen. Calculate the mass concentrations of the gas species at standard ambient temperature and pressure....
1 answer
Last guy got it wrong please only answer if you're 100% sure. Constants | Periodic Table...
last guy got it wrong please only answer if you're 100% sure. Constants | Periodic Table Part A Coulomb's law for the magnitude of the force F between two particles with charges Q and Q separated by a distance d is What is the net force exerted by these two charges on a third charge ga 54 5 ...
1 answer
Question 17 Which of the following is the best definition of unsystematic risk A risk that...
Question 17 Which of the following is the best definition of unsystematic risk A risk that influences a large number of assets. Also called market risk. A theory showing that the expected return on any risky asset is a linear combination of various factors. Positively sloped straight line displaying...
1 answer
This Question: 1 pt 5 of 5 (0 complete) Let the functions f, g, and h...
This Question: 1 pt 5 of 5 (0 complete) Let the functions f, g, and h be defined by the equations on the right. Evaluate the indicated function without finding equation for the function. f(x) 4x-3 an g(x) = 3x-4 gifh(2) h(x) 2+5x+1 9h(2)]) = [] Enter your answer in the answer box 91 Type here to sea...