Given the dataset of a supply network in the following table:LocationX co-ordinatesY co-ordinatesSupply or demandSite 1614440Site 21216Site 3382676Site 462272632254Supplier 1Supplier 226877186237Supplier 3Supplier 486543Supplier 5433626Supplier 684168a. Calculate the Euclidean distance from every potential site to every supplierb. Calculate the load-distance value for every potential site.c. Conclude on the best site with the lowest load-distance value.

Distance between 2 points :- Using above formula we can calculate below Distance Matrix

Answered: a. Calculate the Euclidean distance…

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

See similar textbooks

Similar questions

PetSmart and PetCo are two major competitors offering pet supplies and pet food. Given the location decisions of PetSmart and PetCo in this city, you conclude that: a. PetSmart focuses on raising its quantity sold rather than raising its profit margin on each unit. b. PetSmart and Petco engage in intense price undercutting. c. PetSmart and PetCo differentiate themselves by location. d. PetCo chose its location primarily using demand side considerations.
Describe Strategic Importance of Location Decisions?
Discuss what are the people that are involved in facility location decisions?
Problem 8-9 (Static) Location Score Factor (100 points each) Weight A B Convenience 0.15 80 70 Parking facilities 0.20 72 76 Display area 0.18 88 90 90 Shopper traffic 0.27 94 86 Operating costs 0.10 98 90 Neighborhood 0.10 96 85 182820 C 60 92 80 82 75 1.00 Click here for the Excel Data File a. Using the above factor ratings, calculate the composite score for each location. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Location Composite Score A B 0
Sweet World Limited is considering building a Super-Pop facility in one of the European countries. The locations and quantities shipped to major European countries are shown in the table below. Location England France Spain Germany Italy X 4 4 277 Y 753 6 63 Quantity 2,000 1,100 500 3,000 600 Required 1. Using the centre-of-gravity method, where should the new Super-Pop facility be located? 2.Explain two major disadvantages associated with the method in (i) above.
To what extent is it possible for a companys production system to be impacted by its location decisions.
snip

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

a. Calculate the Euclidean distance from every potential site to every supplier b. Calculate the load-distance value for every potential site. c. Conclude on the best site with the lowest load-distance value.