A soft drink manufacturing company has 3 factories set up one in each of the thr

Question

A soft drink manufacturing company has 3 factories set up one in each of the three cities - Orland, Tampa, and Port St. Lucie and it supplies the produced soft drink bottles to 3 warehouses located in the city of Miami. The associated per-unit transportation cost table is provided below: The factory at Orlando has a capacity of 15,000 units. The factory at Tampa has a capacity of 18,000 units. The factory at Port St. Lucie has a capacity of 8,000 units. The requirements of the warehouses are: 1. What is the optimal minimum cost for this problem? Use Excel Solver to find your solution. 2. What is the optimal value for the route Orlando - W1 that is how many units should sent from Orlando to location W1 in order to minimize the total transportation cost? 3. What is the optimal value for the route Orlando - W2 that is how many units should be sent from Orlando to location W2 in order to minimize the total transportation cost? 4. What is the optimal value for the route Tampa - W1 that is how many units should be sent from Tampa to location W1 in order to minimize the total transportation cost?

Explanation / Answer

The question is about Transportation problem. Formulation of the problem is as follows:

Solution using excel solver is as follows:

Warehouses Factories W1 W2 W3 Capacity Orlando 4 3 7 15000 Tampa 7 6 4 18000 Port St. Lucie 3 6 6 8000 Requirement 18000 12000 5000 Warehouses Factories W1 W2 W3 Sum Orlando 0 0 0 0 Tampa 0 0 0 0 Port St. Lucie 0 0 0 0 Sum 0 0 0 Objective-Minimum TotalTransportation Cost 0

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.