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

Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in the coming year. He has four locations in mind. The costs information for these locations is in the following table. locations fixed costs variable costs/units A 60,000 30 B 80,000 20 C 100,000 15 D 130,000 10 i. Draw the total costs lines for each location on the same axes. (Use output ranges of 200, 400, 600, 800 etc. and intervals of $50,000 on the Y axis. ii. Over what range of output is location A the most preferred location? iii. Over what range of output is location B the most preferred location? iv. Over what range of output is location C the most preferred location?
What kinds of location decisions are appropriate for the use of locational cost-volume analysis?
Give your idea break even method of location.
Brian Trump has obtained fixed- and variable-cost information for four potential sites for his professional wrestling school and summarized it in tabular form below. All values are in dollars. Site Fixed Cost Variable Cost A 10,000 24 B 12,000 20 C 14,000 18 D 16,000 17 Brian plans to charge the same amount for tuition regardless of where he decides to establish his school. If he believes that 700 students will matriculate each year, which site will result in the lowest total cost?
who needs to be involve in facility location decisions?
What are the steps of the general procedure for making location decisions usually?
A company that is developing a strategy that entails obtaining location advantages for several of its different inputs A) would have each value chain activity replicated in each of its host country locations. B) would be pursuing a low cost strategy with economies of scale. C) would concentrate each value chain activity in the country in which can be performed most efficiently or effectively. D) would concentrate most of its value chain activities in its home country, where it is most familiar with the location. E) would implement a multi-domestic or multinational strategy.
Identify and clarify seven key factors affecting decision on the location?
How center of gravity method is used to determine the right location for the facility placement? Benefits of using this method?
Please assist with the attached,
Fruit Centre Ice Cream Parlor is deciding where to locate a new facility. The annual fixed costs, initial fixed costs and variable costs for each site have been estimated as follows; Location Annual Fixed Costs (shs) Initial Fixed costs selling price (shs) Variable costs(shs) Namugongo 35,000 400,000 200/unit 200/unit Kireka 19,000 250,000 400/unit 45/unit Banda 15,000 200,000 600/unit 2500/unit Ntinda 95,000 170,000 100/unit 360/unit If demand is expected to be 2000 units, which location is best? and Forecasting is a key component in operations management. Identify and describe any three methods of forecasting that you would recommend to a service industry.
What major issues should be considered when determining a retail site location?

SEE MORE QUESTIONS

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.