A Transportation Problem with 5 supply and 6 demand points (Unbalanced) TO (Destination) FROM(source) S1 S2 S3 S4 S5 Demand D1 D2 D3 D4 50 50 45 29 29 26 47 45 44 50 46 21 49 25 48 47 43 40 39 560 580 459 700 668 D5 44 28 D6 20 23 30 40 30 416 Supply 721 620 450 587 690 a) Find out the optimal solution that minimizes the total cost (Use Excel Solver)

Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 3.8A
icon
Related questions
Question
A Transportation Problem with 5 supply and 6 demand points (Unbalanced)
TO (Destination)
FROM(source)
S1
S2
S3
S4
S5
Demand
D1
D2 D3 D4
50
50 45 29
29 26
47
45
44
50
46 21 49
25
48 47 43
40 39
560 580 459 700 668
D5
44
28
D6
20
23
30
40
30
416
Supply
721
620
450
587
690
a) Find out the optimal solution that minimizes the total cost (Use Excel Solver)
Transcribed Image Text:A Transportation Problem with 5 supply and 6 demand points (Unbalanced) TO (Destination) FROM(source) S1 S2 S3 S4 S5 Demand D1 D2 D3 D4 50 50 45 29 29 26 47 45 44 50 46 21 49 25 48 47 43 40 39 560 580 459 700 668 D5 44 28 D6 20 23 30 40 30 416 Supply 721 620 450 587 690 a) Find out the optimal solution that minimizes the total cost (Use Excel Solver)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning