Question

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

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

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
Using solver find out the solution to the the Philips Drug Company. This company has three wareho...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Deliverables Excel file with Solver solution Screen shot with the solution to the Philips Drug Co...

    Deliverables Excel file with Solver solution Screen shot with the solution to the Philips Drug Company. Solver Project 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...

  • Jones company has two manufacturing plants A and B, and three warehouses, W1, W2, W3. Each...

    Jones company has two manufacturing plants A and B, and three warehouses, W1, W2, W3. Each week Jones ships product from the plants to the warehouses. The system is balanced: A produces 500 units of product and B produces 300 units of product. Warehouse W1 needs 200 units of product, W2 needs 300 units of product, and W3 needs 300 units of product. Thus, over the entire system, there are 800 units produced by the two plants and 800 units...

  • 3. A Makonsel company is a fully integrated company that both produces goods and sells them...

    3. A Makonsel company is a fully integrated company that both produces goods and sells them at its retail outlets. After production, the goods are stored in the company's two warehouse until needed by the retail outlet. Trucks are used to transport the goods from the two plants to the warehouses, and then from the warehouses to the three retail outlets. Using units of full truckloads, the following table shows each plants monthly output, its shipping cost per truckload send...

  • The Distribution Unlimited Co. has two factories producing a product that needs to be shipped to...

    The Distribution Unlimited Co. has two factories producing a product that needs to be shipped to two warehouses • Factory 1 produces 85 units. • Factory 2 produces 65 units. • Warehouse I needs 55 units. • Warehouse 2 needs 95 units. There are rail links directly from Factory 1 to Warehouse 1 and Factory 2 to Warehouse 2. • Independent truckers are available to ship up to so unlts from each factory to the distribution center, and then 50...

  • . The Distribution Unlimited Co. has two factories producing a product that needs to be shipped...

    . The Distribution Unlimited Co. has two factories producing a product that needs to be shipped to two warehouses Factory 1 produces 85 units. Factory 2 produces 65 units. • Warehouse 1 needs 55 units. • Warehouse 2 needs 95 units. There are rail links directly from Factory 1 to Warehouse 1 and Factory 2 to Warehouse 2. Independent truckers are available to ship up to 50 units from each factory to the distribution center, and then 50 units from...

  • A company that manufactures compressors has plants in three locations: Cleveland, Chicago, and Boston. During a...

    A company that manufactures compressors has plants in three locations: Cleveland, Chicago, and Boston. During a week, the total capacity of each plant to produce one type of special compressor is 25, 45, and 35 units, respectively. The company wants to ship at least 40, 10, 20 and 30 units to distribution centers in Dallas, Atlanta, San Francisco, and Philadelphia respectively. The unit production and distribution costs from each plant to each distribution center are given in the table below....

  • 2. A company that manufactures compressors has plants in three locations: Cleveland, Chicago, and Boston. During...

    2. A company that manufactures compressors has plants in three locations: Cleveland, Chicago, and Boston. During a week, the total capacity of each plant to produce one type of special compressor is 25, 45, and 35 units, respectively. The company wants to ship at least 40, 10, 20 and 30 units to distribution centers in Dallas, Atlanta, San Francisco, and Philadelphia respectively. The unit production and distribution costs from each plant to each distribution center are given in the table...

  • Discussion Questions: 1. What is the purpose of a distribution center? 2. Why does Cameron have...

    Discussion Questions: 1. What is the purpose of a distribution center? 2. Why does Cameron have eight warehouses? Why do you think Kelly believes six warehouses is better than eight? 3. What is the cost of holding inventory at Cameron? 4. Why should the decision to invest in inventory be different from investing in capital? 5. Do you think it is prudent to evaluate the future of the Atlanta warehouse independently from consideration of the other seven warehouses in the...

  • Solve the following LP problems using the Solver in MS Excel. Q1.      A candy manufacturer has...

    Solve the following LP problems using the Solver in MS Excel. Q1.      A candy manufacturer has 130 pounds of chocolate-covered cherries and 170 pounds of chocolate-covered mints in stock. He decides to sell them in the form of two different mixtures. One mixture will contain half cherries and half mints by weight and will sell for $2.00 per pound. The other mixture will contain one-third cherries and two-thirds mints by weight and will sell for $1.25 per pound. How many...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT