The following table is a transportation matrix showing the cost ($) per unit of shipping from Plant i to Distributor j. The objective is to minimize shipping costs while meeting the demand placed by each Distributor. There is no shipment between Plant 2 and Distributor 1. Plant 1 Plant 2 Plant 3 Demand x11 X21 Let xij = number units shipped from Planti to Distributor j solve the transportation problem and use the result to fill the boxes below. All answers are equally weighted. a) At optimal solution: || || Distributor 1 Distributor 2 16 15 26 20 390 X31 = --- 1 11 530 00 Minimum Cost X12 X22 X32 || 1000 Distributor 3 Supply 23 510 14 590 21 410 540 = x13 = X23 = X33 = 000

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

1

The following table is a transportation matrix showing the cost ($) per unit of shipping
from Plant i to Distributor j. The objective is to minimize shipping costs while meeting
the demand placed by each Distributor. There is no shipment between Plant 2 and
Distributor 1.
Plant 1
Plant 2
Plant 3
Demand
=
x11 I
Distributor 1 Distributor 2 Distributor 3 Supply
16
23
510
14
590
21
410
540
x21
---
a) At optimal solution:
11
530
Let j = number units shipped from Plant i to Distributor j
Solve the transportation problem and use the result to fill the boxes
below.
All answers are equally weighted.
x31 =
||
000
x12 =
X22
=
Minimum Cost $
=
X32 =
15
26
20
390
€13
X23
x 33
=
=
--
=
000
Transcribed Image Text:The following table is a transportation matrix showing the cost ($) per unit of shipping from Plant i to Distributor j. The objective is to minimize shipping costs while meeting the demand placed by each Distributor. There is no shipment between Plant 2 and Distributor 1. Plant 1 Plant 2 Plant 3 Demand = x11 I Distributor 1 Distributor 2 Distributor 3 Supply 16 23 510 14 590 21 410 540 x21 --- a) At optimal solution: 11 530 Let j = number units shipped from Plant i to Distributor j Solve the transportation problem and use the result to fill the boxes below. All answers are equally weighted. x31 = || 000 x12 = X22 = Minimum Cost $ = X32 = 15 26 20 390 €13 X23 x 33 = = -- = 000
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
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.