1. A local shipping company D.G.H.M. Inc. han recently acquired the a large wupply of PS5'n. As result they have wet up in 5 warehousen in the kower parta of Ontario. From these warehousen they will ahip the producta to the 7 wtores they have throughout the area. The tables below indicate the mupply, demand and shipping costa per product from each warehouse to each store. Warehouse Supply Store Demand 550 Store 1 625 725 Store 2 Store 3 300 C 850 225 900 Store 4 Store 5 425 650 E 400 Store 6 750 Store 7 450 with shipping costs per unit of Warehouse\Store 1 2. 3 4. 5 6. 7 3 21 11 7 18 12 7 25 15 11 4 22 8. 11 6. 6. 10 13 12 14 14 10 6. 10 E 5 30 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
icon
Concept explainers
Topic Video
Question
100%

I would like you to help me with this question.

please include the steps that you are dong

Supply and Demand, inequality, feasible Region, Graphical LP

1. A local shipping company D.G.H.M. Inc. has recently acquired the a large rupply of PS5'n. 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
B
725
Store 2
300
C
850
Store 3
225
D
900
Store 4
425
E
400
Store 5
650
Store 6
750
Store 7
450
with shipping oosts per unit of
Warehouse\Store 1
3
5
6
21
11
8.
6
11
7 18 12
7 25 15
4 22
5 30 15
B
10
13
C
11
12 | 14 14
9
7
10
6
10
E
11
11
12
For this problem complete the following:
• 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 smnall 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.
For this problem clearly derive the Lincar program which would solve this problem.
Clearly label your constraints.
Implement solver in Excel to confirm the answer found above is not yet optimal. What is
the optimal solution and final cost.
• Assume there was a restriction on cach warehouse that no truck could carry more that 200
units and that cach route can only accommodate one truck maximum due to regulations.
What new constraints would you add to your linear program. Add these in Excel and
determine your new delivery solution and cost. How does this regulation impact the costs
for D.G.H.M. Ine?
Transcribed Image Text:1. A local shipping company D.G.H.M. Inc. has recently acquired the a large rupply of PS5'n. 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 B 725 Store 2 300 C 850 Store 3 225 D 900 Store 4 425 E 400 Store 5 650 Store 6 750 Store 7 450 with shipping oosts per unit of Warehouse\Store 1 3 5 6 21 11 8. 6 11 7 18 12 7 25 15 4 22 5 30 15 B 10 13 C 11 12 | 14 14 9 7 10 6 10 E 11 11 12 For this problem complete the following: • 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 smnall 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. For this problem clearly derive the Lincar program which would solve this problem. Clearly label your constraints. Implement solver in Excel to confirm the answer found above is not yet optimal. What is the optimal solution and final cost. • Assume there was a restriction on cach warehouse that no truck could carry more that 200 units and that cach route can only accommodate one truck maximum due to regulations. What new constraints would you add to your linear program. Add these in Excel and determine your new delivery solution and cost. How does this regulation impact the costs for D.G.H.M. Ine?
• All constraints and lincar programs should be derived with explanation and hand written.
Linear programs (when asked for) should then be written in COMPLETE PROPER FORM
(ALL constraints, organized order and clear identification of variable meanings).
• All diagrams and graphics should be presented (repeated) enough times to clearly demonstrate
the work process that was followed in carrying out your work. Legibility is necessary.
• Excel can be used for calculations, but the pdf of this work must be "hand" augmented with
clear indications of what was being carried out
Excel sheets involving solver must be fully explained and the solver window itself should be
screen capped and submitted as part of your presentation to show the linear program you
asked excel to solve.
• Excel sheets should be printed using the print to PDF. Do not micro print your pages all
on one page. Printing in excel in landsape is advised and modifying your column widths
appropriately is encouraged.
Transcribed Image Text:• All constraints and lincar programs should be derived with explanation and hand written. Linear programs (when asked for) should then be written in COMPLETE PROPER FORM (ALL constraints, organized order and clear identification of variable meanings). • All diagrams and graphics should be presented (repeated) enough times to clearly demonstrate the work process that was followed in carrying out your work. Legibility is necessary. • Excel can be used for calculations, but the pdf of this work must be "hand" augmented with clear indications of what was being carried out Excel sheets involving solver must be fully explained and the solver window itself should be screen capped and submitted as part of your presentation to show the linear program you asked excel to solve. • Excel sheets should be printed using the print to PDF. Do not micro print your pages all on one page. Printing in excel in landsape is advised and modifying your column widths appropriately is encouraged.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Inventory management
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.