Consider the transportation problem having the following data: E. Destination: Source 1 2 3 Demand 1 32 2 4 3 Unit Cost (S) 2 7 4 3 3 3 638 8 2 4 2 5 2 Supply 523 3 a. Draw the network representation of this problem. b. Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimal solution.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter6: Optimization Models With Integer Variables
Section6.5: Set-covering And Location-assignment Models
Problem 34P
icon
Related questions
Question
Consider the transportation problem having the following data:
Destination:
Source
1
2
3
Demand
1
3
324
3
Unit Cost (S)
2
743
3
3
839
6
2
4
2
5
2
Supply
523
2
3
a. Draw the network representation of this problem.
b. Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimal
solution.
Transcribed Image Text:Consider the transportation problem having the following data: Destination: Source 1 2 3 Demand 1 3 324 3 Unit Cost (S) 2 743 3 3 839 6 2 4 2 5 2 Supply 523 2 3 a. Draw the network representation of this problem. b. Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimal solution.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 7 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,