b Determine the optimum location for the new plant such that the distance move is minimum (use SimpleMedian Model). Show your complete solution.Existing PlantLocation (x,y) of existing plantLoads to be shifted from new plant toexisting plantsF1(20,30)F2(10,40)F3(30,50)F4(40,60)755900450500

Answered: Image /qna-images/answer/9122292c-e076-493e-ae56-840a8aada50c.jpg

Answered: Determine the optimum location for the…

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

For each of the location problems described, discuss which of the seven assumptions listed in this section are likely to be violated:d. Locating spare parts depots to support a field repair organization.
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
Mitch just built 4 franchise locations for his newest pizzerias and wants to decide where to put his headquarters. He makes 1 weekly visit to his Northside store (X = 3, Y = 10), 2 visits to his Eastside store (X = 4, Y = 6), 3 visits to his Southside store (X = 2, Y = 5) & 4 visits to his Westside store (X = 1, Y = 4). __________ 1. Using the store visits as weights, compute the coordinates of the center of gravity to help him with his location decision.
Consider above problem. Suppose that the weight of facility 2 is 20. Applying the median method, it can be verified that the optimal location is (10, 10) - the centroid of department 2, where immovable structures exist. It is now desired to find a feasible and “near-optimal” location using the contour line method.
Consider you are an owner of one IT organization with 200 employees and youwant to keep track of the location information of each employee. You know thatnone of the employees will go out from the city and the radius of the city is 50km. What kind of location measure technique will be appropriate for you to keeptrack of continuous location information? Explain with proper justification. Also,show how your chosen location measurement is better than the other ones.
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.)
Consider the following apportionment problem, table[]North, 18, 400, East: 17,400 (South: 12,200, West: 14,000, Use the apportionment plan requested below assuming that there must be zs representatives. Jefferson's plan North South East West
A chain of home health care firms in Louisiana needsto locate a central office from which to conduct internal audits and other periodic reviews of its facilities. These facilities are scat-tered throughout the state, as detailed in the following table. Each site, except for Houma, will be visited three times each year by ateam of workers, who will drive from the central office to the site. Houma will be visited five times a year. Which coordinates rep-resent a good central location for this office? What other factors might influence the office location decision? Where would youplace this office? Explain. PXCITY MAP COORDINATESx yCovington 9.2 3.5Donaldsonville 7.3 2.5Houma 7.8 1.4Monroe 5.0 8.4Natchitoches 2.8 6.5New Iberia 5.5 2.4Opelousas 5.0 3.6Ruston 3.8 8.5
For the the Clayton County Rescue Squad and Ambulance Service (Facility Location Nonlinear Model) example from Lecture 6, the number of estimated trips to Dunning has changed to 15. Which one of the options below, best represents the new optimal point (x,y) - best location to place the facility? Group of answer choices (19.24,16.30) (12.24,8.30) (20.24,21.30) (18.24,15.30) None of the above
What is the major difference in focus between location decisions in the service sector and in the manufacturing sector?a) There is no difference in focus.b) The focus in manufacturing is revenue maximization,while the focus in service is cost minimization.c) The focus in service is revenue maximization, while thefocus in manufacturing is cost minimization.d) The focus in manufacturing is on raw materials, whilethe focus in service is on labor.
Three existing facilities are located at (0, 0), (5, 5), and (10, 10). The weights applied to these facilities are 1, 2, and 3, respectively. Find the location of a new facility that minimizes the weighted Euclidean distance to the existing facilities.
Consider you are an owner of one IT organization with 200 employees and youwant to keep track of the location information of each employee. You know thatnone of the employees will go out from the city and the radius of the city is 50 km.What kind of location measure technique will be appropriate for you to keep trackcontinuous location information?

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