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
Using solver find out the solution to the the Philips Drug Company. This company has three wareho...
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 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 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 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 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 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 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 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 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...