An electronics firm located near Phoenix, Arizona, is considering where to locate a new phone switch that will link five buildings. The buildings are located at (0,0), (2,6), (10,2), (3,9) and (0,4). The objective is to locate the switch to minimize the cabling required to those five buildings, for which the gravity solution needs to be determined. Concept Introduction: In a gravity modeling, locations are determined that minimizes the cost of transportation of raw materials from the supplier as well as manufactured goods to the market.

Question

Design a spreadsheet to compute the total rectilinear distance from a set of up to10 existing locations to any other location. Assume that existing locations areplaced in Columns A and B and the new location in cells D1 and E1. Initializecolumn A with the value of cell D1 and column B with the value of cell E1, so thatthe total distance will be computed correctly when there are fewer than10 locations.a. Suppose that existing facilities are located at (0, 0), (5, 15), (110, 120), (35, 25),(80, 10), (75, 20), (8, 38), (50, 65), (22, 95), and (44, 70), and the new facility is tobe located at (50, 50). Determine the total rectilinear distance of the new facilityto the existing facilities.b. Suppose the new facility in part (a) can be located only at x =0, 5, 10, . . . , 100and y = 0, 10, 20, . . . , 100. By systematically varying the x and y coordinates,find the optimal location of the new facility

Answer 1

Question

Chapter 11, Problem 54AP

(a)

Summary Introduction

Interpretation: An electronics firm located near Phoenix, Arizona, is considering where to locate a new phone switch that will link five buildings. The buildings are located at (0,0), (2,6), (10,2), (3,9) and (0,4). The objective is to locate the switch to minimize the cabling required to those five buildings, for which the gravity solution needs to be determined.

Concept Introduction: In a gravity modeling, locations are determined that minimizes the cost of transportation of raw materials from the supplier as well as manufactured goods to the market.

(b)

Summary Introduction

Interpretation: An electronics firm located near Phoenix, Arizona, is considering where to locate a new phone switch that will link five buildings. The buildings are located at (0,0), (2,6), (3,9) and (0,4). The objective is to locate the switch to minimize the cabling required to those five buildings. Assuming a straight line distance measurement and if the problem is solved by hand, the appropriate equations needs to be iterated at least five times, and the optimal location needs to be determined.

Concept Introduction: The simple measurement of distance in a straight line between two facilities is called Euclidean Distance.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Design a spreadsheet to compute the total rectilinear distance from a set of up to10 existing locations to any other location. Assume that existing locations areplaced in Columns A and B and the new location in cells D1 and E1. Initializecolumn A with the value of cell D1 and column B with the value of cell E1, so thatthe total distance will be computed correctly when there are fewer than10 locations.a. Suppose that existing facilities are located at (0, 0), (5, 15), (110, 120), (35, 25),(80, 10), (75, 20), (8, 38), (50, 65), (22, 95), and (44, 70), and the new facility is tobe located at (50, 50). Determine the total rectilinear distance of the new facilityto the existing facilities.b. Suppose the new facility in part (a) can be located only at x =0, 5, 10, . . . , 100and y = 0, 10, 20, . . . , 100. By systematically varying the x and y coordinates,find the optimal location of the new facility

An electronics firm located near Phoenix, Arizona, is considering where to locate a new phone switch that will link five buildings. The buildings are located at (0, 0), (2, 6), (10, 2), (3, 9), and (0, 4). The objective is to locate the switch to minimize the cabling required to those five buildings.a. Determine the gravity solution.b. Determine the optimal location assuming a straight-line distance measure. (If you are solving this problem by hand, iterate the appropriate equations at least five times and estimate the optimal solution.)

A chain of home health care firms in Louisiana needs to locate a central office from which to conduct internal audits and other periodic reviews of its facilities. These facilities are scattered throughout the state, as detailed in the following table. Each site, except for Houma, will be visited three times each year by a team of workers, who will drive from the central office to the site. Houma will be visited five times a year. Which coordinates represent a good central location for this office? What other factorsmight influence the office location decision? Where would youplace this office? Explain.