a result they have set up in 5 warehouses in the lower parts of Ontario. From these warehouses they will ship the products to the 7 stores they have throughout the area. The tables below indicate the supply, demand and shipping costs per product from each warehouse to each store. Warehouse | Supply | Store | Demand Store 1 Store 2 Store 3 Store 4 Store 5 Store 6 Store 7 A 550 625 B 725 300 850 225 D E 900 425 400 650 750 450 with shipping costs per unit of Warehouse\Store | 1| 2 | 3 | 4 | 5 3 21 6. A 11 8. 6. 11 6. B C D 18 12 10 13 7 25 4| 22 5 30 15 | 11 12 14 14 7 10 6. 10 15 11 11 12

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

Solving this problem using the transportation simplex method (i.e. Chapter 19) to min-imize the transportation costs can take numerous iterations. Clearly show with expla-nations between steps (this is not a small problem) the first 5 iterations of this method. Clearly state your delivery answer between iterations and the final costs. What do you observe about these costs.

1. A local shipping company D.G.H.M. Inc. has recently acquired the a large supply of PS5's. As
a result they have set up in 5 warehouses in the lower parts of Ontario. From these warehouses
they will ship the products to the 7 stores they have throughout the area. The tables below
indicate the supply, demand and shipping costs per product from each warehouse to each store.
Warehouse | Supply
Store
Demand
A.
550
Store 1
625
В
725
Store 2
300
C
850
Store 3
225
900
Store 4
425
E
400
Store 5
650
Store 6
750
Store 7
450
with shipping costs per unit of
Warehouse\Store | 1| 2
3
6
7
4
3 | 21
7 18
A
11
6
11
В
12
10
13
7 25
15
11
12
14
14
4 | 22
9
7
10
6
10
E
5
30
15
11
11
8
12
Transcribed Image Text:1. A local shipping company D.G.H.M. Inc. has recently acquired the a large supply of PS5's. As a result they have set up in 5 warehouses in the lower parts of Ontario. From these warehouses they will ship the products to the 7 stores they have throughout the area. The tables below indicate the supply, demand and shipping costs per product from each warehouse to each store. Warehouse | Supply Store Demand A. 550 Store 1 625 В 725 Store 2 300 C 850 Store 3 225 900 Store 4 425 E 400 Store 5 650 Store 6 750 Store 7 450 with shipping costs per unit of Warehouse\Store | 1| 2 3 6 7 4 3 | 21 7 18 A 11 6 11 В 12 10 13 7 25 15 11 12 14 14 4 | 22 9 7 10 6 10 E 5 30 15 11 11 8 12
Expert Solution
steps

Step by step

Solved in 3 steps with 12 images

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
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.