Microserve provides computer repair service on a contract basis to customers in five sections of the city. The five sections, the number of service contracts in each section, and the x and y coordinates of each section are asfollows:SectionParkviewMt. AiryValleyNorwoodSouthgateNo. ofContracts90220603.414.229017.716014.0Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places.Cx:Cy:Choose the correct graph representing the center of gravity.The correct graph is -Select- vA.C.Center of Gravity20 Y- Coordinatey-16-12-84+20-16-12●●•12x- CoordinateCenter of Gravityy- Coordinate:16●B.D.-20+-16-128+2016-12Center of Gravityy- Coordinate812x- CoordinateCenter of Gravityy- Coordinate●16CoordinatesXY6.2 11.94.25.34.410.9

The location needs to be determined using the Centre of Gravity Method.

Answered: Microserve provides computer repair…

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

1. Using the center-of-gravity method, compute the centralized coordinates among the following locations, which are indicated via black cells with white text in LOCATION.xlsx: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 2. Using the weighted average center-of-gravity, which accounts for quantities to be shipped from locations, compute the centralized coordinates among the following locations: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 *Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units) in LOCATION.xlsx
The Times-Picayune is searching for an ideal spotting station for the morning paper. The table below shows potential neighborhoods, their location on an XY grid of the city, and typical morning volume. What is the location that will minimize the transportation costs for the newspaper? Customer Annual Volume X-Coordinate Y-Coordinate Florida 255 6 4 Desire 150 7 6 Lafitte 235 2 4 Iberville 450 2 6 Guste 175 2 6 CJ Peete 255 1 4 Group of answer choices Near (3.0, 5.0) Near (2.8, 4.8) Near (2.5, 5.4) Near (2.8, 5.2)
Microserve provides computer repair service on a contract basis to customers in five sections of the city. The five sections, the number of service contracts in each section, and the x and y coordinates of each section are as follows: No. of Coordinates Section Contracts x y Parkview 70 5.2 8.3 Mt. Airy 200 3.6 3.0 Valley 70 13.6 7.2 Norwood 300 15.1 4.0 Southgate 170 13.8 8.7 Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places. Cx: ____________Cy: ____________ A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect the importance of the criteria. Location Criteria Weight 1 2 3 4 Raw material availability 0.06 P VG OK VG Infrastructute 0.07 P G VG OK Transportation costs 0.33 G P OK P Labor relations 0.25 VG G…
a. A farmers' cooperative association plans to build a new sugar mill in Georgetown. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane farms in the region, they are tightly clustered around six villages. Using the data below, use the center-of-gravity method to calculate the coordinates of the best location for this mill. All mileage references use Browns Town as (0,0). Village Barney Valley Blue Pasture Congo Valley Bower Rabacca Salem Miles East of Miles North of Sugar Cane Browns Town Browns Town 90 140 20 50 100 10 10 60 70 20 80 120 tonnage 240,000 320,000 450,000 120,000 60,000 140,000
A food manufacturer wants to locate a warehouse to serve its major The customers, annual volume, and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc. 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 Using the center of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
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 total distance travelled using the center-of-gravity method. Zip Code Location Options 2 3 4 Coordinates of Location X 2 9 12 13 y 4 5 6 12 Vehicles per Stadium Event 4,300 4,700 1,100 2,000 Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places. Cx: Cy:
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…
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. Mail Source Point Round Trips per day X coordinate Y coordinate 1 6 2 8 2 3 6 1 3 3 8 5 4 3 13 3 5 2 15 10 6 7 6 14 Calculate the centre of gravity as a possible location for the new facility. 2. A clothing chain is considering two different locations for a new retail outlet. The organization has identified the four factors listed in the following table as the basis for evaluation, and it has…
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:
An operations manager wants to use gravity location approximation to decide the location of a warehouse. The x and y coordinates of three customer locations, demand (D) at those locations, and transportation costs per unit per mile (F) are presented in the table below. Help the operations manager by finding the approximate location of the warehouse. Customers y F 1 10 20 1 10 2 20 1 20 3 10 10 2 10 x=20, y=10 x=14, y=10 x=10, y=14 x=13.3, y=11.7 O x=10, y=15

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