C.1. Supply Chain Manager Gabriela Valdez wishes the find the lowest cost shipping routes to ship from three source cities to three destination cities. Unit costs for each shipping route are in dollars. To From Mexico City Los Angeles Calgary Panama City Supply $6 $18 $8 100 Detroit $17 $13 $19 60 Ottawa $20 $10 $24 40 Demand 50 80 70 Find the optimal solution to the transportation problem. Compute the total cost.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Answer C.1 and C.2

C.1. Supply Chain Manager Gabriela Valdez wishes the find the lowest cost shipping routes to ship from
three source cities to three destination cities. Unit costs for each shipping route are in dollars.
To
From
Mexico City
Detroit
Los Angeles
$6
Calgary
$18
Panama City
Supply
$8
100
$17
$13
$19
60
Ottawa
$20
$10
$24
40
Demand
50
80
70
Find the optimal solution to the transportation problem. Compute the total cost.
C.2. Consider the following transportation table:
Destination
Source
A
B
C
D
E
Supply
1
$12
$8
$5
$10
$4
18
2
$6
$11
$3
$7
$9
14
Demand
6
8
12
4
2
Find the optimal solution of amounts from sources to destinations. Compute the total cost.
C.8. The Donna Mosier Clothing Group owns factories in three towns (W, Y, Z) which distributes to three
retail other cities (A, B, C). The following table summarizes factory availabilities, project store demand,
and unit shipping costs:
From To
Dress Shop A
Dress Shop B
Dress Shop C
Factory
Availability
Factory W
$4
$3
$3
35
Factory Y
$6
$7
$6
50
Factory Z
$8
$2
$5
50
Store demand
30
65
40
135
Determine the optimal solution for shipping at the Mosier Clothing Group.
C.15. For the following Gregory Bier Corp. data, find the optimal solution of amounts from sources to
destinations and the total costs.
From To
W
X
Y
Z
Supply
A
$132
$116
$250
$110
220
B
$220
$230
$180
$178
300
C
$152
$173
$196
$164
435
Demand
160
120
200
230
Transcribed Image Text:C.1. Supply Chain Manager Gabriela Valdez wishes the find the lowest cost shipping routes to ship from three source cities to three destination cities. Unit costs for each shipping route are in dollars. To From Mexico City Detroit Los Angeles $6 Calgary $18 Panama City Supply $8 100 $17 $13 $19 60 Ottawa $20 $10 $24 40 Demand 50 80 70 Find the optimal solution to the transportation problem. Compute the total cost. C.2. Consider the following transportation table: Destination Source A B C D E Supply 1 $12 $8 $5 $10 $4 18 2 $6 $11 $3 $7 $9 14 Demand 6 8 12 4 2 Find the optimal solution of amounts from sources to destinations. Compute the total cost. C.8. The Donna Mosier Clothing Group owns factories in three towns (W, Y, Z) which distributes to three retail other cities (A, B, C). The following table summarizes factory availabilities, project store demand, and unit shipping costs: From To Dress Shop A Dress Shop B Dress Shop C Factory Availability Factory W $4 $3 $3 35 Factory Y $6 $7 $6 50 Factory Z $8 $2 $5 50 Store demand 30 65 40 135 Determine the optimal solution for shipping at the Mosier Clothing Group. C.15. For the following Gregory Bier Corp. data, find the optimal solution of amounts from sources to destinations and the total costs. From To W X Y Z Supply A $132 $116 $250 $110 220 B $220 $230 $180 $178 300 C $152 $173 $196 $164 435 Demand 160 120 200 230
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 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,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
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
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.