Question 39 ABC company has five (5) factories. They send their products through five (5) distribution centers (DCs) that serve a specific market. To use full truckloads and to have the economy of scale in transportation, they also use two cross-dock centers as transshipment points. All the required data are represented in the following tables. Transportation cost($) Crossdock Factory Crossdock 1 Crossdock 2 Factory 1 15 40 Factory 2 Factory 3 Factory 4 19 52 29 16 60 15 Factory 5 50 63 Transportation cost($) Distribution Center Crossdock DC1 DC2 DC3 DC4 DC5 Crossdock 1 10 20 14 35 36 Crossdock 2 40 10 13 17 70 Capacity of Factory (units) Factory 1 Factory 2 Factory 3 Factory 4 Factory 5 150 320 80 170 200 Demand for each DC (units) DC 1 140 DC 2 130 DC 3 180 DC 4 250 DC 5 150 (b) How many units of products are transshipped to DCs through cross-docks 1 and 2? (c) Which DC's will be served by each cross-dock center? (d) What is the minimum total distribution 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
Question 3y
ABC company has five (5) factories. They send their products through five (5) distribution centers
(DCs) that serve a specific market. To use full truckloads and to have the economy of scale in
transportation, they also use two cross-dock centers as transshipment points. All the required data are
represented in the following tables.
Transportation cost($)
Crossdock
Factory
Crossdock 1
Crossdock 2
Factory 1
Factory 2
Factory 3
Factory 4
15
40
19
52
29
16
60
15
Factory 5
50
63
Transportation cost($)
Distribution Center
Crossdock
DC1
DC2
DC3
DC4
DC5
Crossdock 1
10
20
14
35
36
Crossdock 2
40
10
13
17
70
Capacity of Factory (units)
Factory 1
Factory 2
150
320
Factory 3
80
Factory 4
Factory 5
170
200
Demand for each DC (units)
DC 1
140
DC 2
130
DC 3
180
DC 4
250
DC 5
150
(b) How many units of products are transshipped to DCs through cross-docks 1 and 2?
(c) Which DC's will be served by each cross-dock center?
(d) What is the minimum total distribution cost?
Transcribed Image Text:Question 3y ABC company has five (5) factories. They send their products through five (5) distribution centers (DCs) that serve a specific market. To use full truckloads and to have the economy of scale in transportation, they also use two cross-dock centers as transshipment points. All the required data are represented in the following tables. Transportation cost($) Crossdock Factory Crossdock 1 Crossdock 2 Factory 1 Factory 2 Factory 3 Factory 4 15 40 19 52 29 16 60 15 Factory 5 50 63 Transportation cost($) Distribution Center Crossdock DC1 DC2 DC3 DC4 DC5 Crossdock 1 10 20 14 35 36 Crossdock 2 40 10 13 17 70 Capacity of Factory (units) Factory 1 Factory 2 150 320 Factory 3 80 Factory 4 Factory 5 170 200 Demand for each DC (units) DC 1 140 DC 2 130 DC 3 180 DC 4 250 DC 5 150 (b) How many units of products are transshipped to DCs through cross-docks 1 and 2? (c) Which DC's will be served by each cross-dock center? (d) What is the minimum total distribution cost?
Expert 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,
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.