Using the information about customer vehicle traffic to and from a proposed new sports stadium (not built yet), find the best location for the stadium that minimizes totaldistance travelled using the center-of-gravity method.Zip CodeLocation Options234Coordinates of LocationX291213y45612Vehicles perStadium Event4,3004,7001,1002,000Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places.Cx:Cy:

Here, for each location option, I am given the x and y coordinates and vehicles per stadium event, I…

Answered: Using the information about customer…

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

The ABC Company plans to locate a warehouse using the center-of-gravity model to serve four different customers. Find the coordinates for the warehouse given the following information:
A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. Mail Source Point Round trips per day x, y, Coordinates (miles) 4 (4, 6) (8, 4) (3, 14) (6, 10) (12, 11) (13, 5) (13, 6) (14, 10) 2 1 11 5 7 6 7 3 M 8 a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) The center of gravity "X" coordinate = 9 The center of gravity "Y" coordinate = 8. b. Compare the load-distance scores for the…
A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. Mail Source Point Round trips per day x, y, Coordinates (miles) 1 4 (4, 6) 7 (8, 4) (3, 14) (6, 10) (12, 11) (13, 5) (13, 6) (14, 10) 3 1 4 11 7 3 7 3 M 8 a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) The center of gravity "X" coordinate = The center of gravity "Y" coordinate =
A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. Mail Source Point Round trips per day x, y, Coordinates (miles) 1 8 2 2 1 6 3 4 6 7 M 2 4 8 The center of gravity "X" coordinate = 10 The center of gravity "Y" coordinate = 6 (11,5) (15,5) (1, 13) (2, 1) (4, 14) (16, 12) (15,5) (14,2) a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) b. Compare the load-distance scores for the…
The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub. Using the Center of Gravity method, near which map coordinates should the hub be located? STORE LOCATION CONTAINERS SHIPPED PER MONTH X Y Chicago 2,000 50 120 Pittsburgh 1,000 110 100 New York 3,000 160 130 Atlanta 2,000 120 40
A company that handles hazardous waste wants to minimize the shipping cost for shipments to a disposal center from five receiving stations it operates. Given the locations of the receiving stations and the volumes to be shipped daily, determine the location of the disposal center.
Explain the relationship between the number of facilities and transportation cost and draw the graph
A farmers' cooperative association plans to build a new sugar mill in Southwestern Louisiana. The primary objective of the mill is to provide the farmers with a place to take their crop for processing and then transport the processed crop to their customers. While there are over 200 sugar cane farms in the region, they are tightly clustered around a few villages. Using the data below, calculate the coordinates of the best location for this mill. All mileage references use the city of Lake Charles as (0,0). Sources/Markets Transportation Quantity Xn Yn Cost $/ton mile in Tons (Fn) (Dn) Supply Arceneaux Boudreaux Cancienne Market Darbonne Evangeline Fontenot 4.3 240,000 90 140 20 10 60 70 4.8 320,000 120,000 4.1 5.25 3.95 4.85 450,000 90,000 140,000 50 20 100 80 120 10 a) What is the cost to transport 10000 tons of material between Arceneaux and Darbonne locations? b) What is the optimal location for the mill? c) What is the minimal shipping cost that satisfies all requirements?
A larger and more modern post office is to be constructed at a new location in Sally Spring Georgia. Growing suburbs caused a shift in the population density from where it was 30 years ago when the current facility was built. Andy Browne, the postmaster asked his assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office are shown in the table below. Calculate the centre of gravity as a possible location for the new facility.
Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup its distribution centre. What is the main objective of using this technique? What information will be needed in order to use this technique? Setup a numerical example that can be used to demonstrate to the owner of the company how the technique can be used Use the numerical example set up above to demonstrate how the centre of gravity location technique is used.
Identify three important factors that a location planner may consider with respect to each of the following: A super-specialty intensive care unit An automobile manufacturing unit
Determine the suitable location of a distribution centre with the below data, minimizing the transportation dollars spent on managing inbound and outbound shipments. Plot the location of the Vendors, Customers and the location of the new DC in a chart Vendor V1 V2 V3 V4 Customer C1 C2 C3 C4 Rate $ per Ton Mile $ $ $ $ 4.75 3.75 3.15 4.75 Rate $ per Ton Mile $ $ $ $ 3.50 3.75 4.25 5.00 Volume in Tons 1000 1000 1600 1400 Volume in Tons 760 640 800 500 Vendor Location Coordinates (miles) Horizontal 525 600 412.5 300 Vertical 300 750 750 630 Customer Location Coordinates(miles) Vertical 450 900 1050 975 Horizontal 900 900 825 1050

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