Suppose that there are three suppliers S1, S2, and S3 in a distribution system t

Question

Suppose that there are three suppliers S1, S2, and S3 in a distribution system that can supply 5, 5, and 6 units, respectively, of the company's good. The distribution system contains five demand centers, that require 2, 2, 4, 4, and 3 units each of the good. The transportation costs, in dollars per unit, are as follows:

Compute an optimum shipping schedule. Is the optimal solution unique?

I need someone to show me how to model this in excel please.

D1 D2 D3 D4 D5 S1 2 1 2 3 3 S2 2 2 2 1 -1 S3 3 3 2 1 2

Explanation / Answer

final matrix

least cost: 15

this is done by using solver (excell)

first allot the cost matrix as shown above

later evalute the cost function by alloting iitial values equal to zero

then allot the function (cost) as product of corresponding cells

then use solver and add constraints for demnds and supply by setting values

i will mail u the excell file , comment ur mail id in comment box

cost matrix d1 d2 d3 d4 d5 s1 2 1 2 3 3 5 s2 2 2 2 1 -1 5 s3 3 3 2 1 2 6 2 2 4 4 3

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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