Center of GravityEnter data only in yellow cells. The template is designed for up to 10 locations.NameHamiltonKingsportChicagoPittsburghNew YorkAtlantaCenter of Gravityx-Coordinate y-Coordinate Volume588030901276576.2996701201101304098.14400300200100300100y-Coordinate140120100806040200020ⒸCengage LearningNot for commercial use.Center of Gravity406080x-Coordinate100120140 The Davis national drugstore chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment along with the coordinates are as follows:LocationCoordinatesMarketSegment1234Find the best location using the Center-of-Gravity Excel template. Round your answers to two decimal places.Cx:Cy:Choose the correct graph representing the center of gravity.The correct graph is-Select-A.252015-105Center of Gravityy- CoordinateL51015 20x- Coordinate25B.25+20+15-10-5-Center of Gravityy- Coordinate581015 20x- CoordinateX11311125Y142111Number ofCustomers1,6004001,2003,700

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

Answered: The Davis national drugstore chain…

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

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 =
Use the centroid method to determine the best location for this new facility.
A manager received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Factor Business services Community services Real estate cost Construction costs Cost of living Taxes Transportation A с Thus, Location Score A A B с Thus, 17 17 17 8 6 4 3 2 8 9 B 6 6 Click here for the Excel Data File a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? 8 7 7 19 19 19 5 7 is/are the best. C 6 7 7 6 8 b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up? is/are best and 4 8 is/are least desirable.
Careful selection of location is significant in the success of a business. Which among the following is a technique or model used for location decisions O a. Enterprise Resource Planning O b. Linear Regression Method Oc Weighted Factor Comparison Method O d. Historic Method
When households want to consume coffee and fruit juice at home, they behave rather differently. Coffee is normally brewed in the home while fruit juice is purchased in bottles and transported to the home. Please discuss how location theory explains this difference in behavior.
Identify the factors when choosing a business location from the statements below.
I have two locations where I will be delivering goods. Vaalbara is located at coordinates (10,0) and I have 10 truckloads going to it. Kenorland is located at coordinates (20,20) and I have 40 truckloads going to it. What is the center of gravity's X coordinate? Round to the nearest whole number (e.g. 33.2 -> 33). I have two locations where I will be delivering goods. Vaalbara is located at coordinates (10,0) and I have 10 truckloads going to it. Kenorland is located at coordinates (20,20) and I have 40 truckloads going to it. What is the center of gravity's Y coordinate? Round to the nearest whole number (e.g. 33.2 -> 33). 0*10 + 20*40 = 800. Sum of loads = 50. Y coordinate = 16
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…
Please explain theory of location developed by Alfred Weber by giving examples.
Consider you are an owner of one IT organization with 200 employees and you want to keep track of the location information of each employee. You know that none 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 rack of continuous location information? Explain with proper justification. Also, show how your chosen location measurement is better than the other ones.
What information do you need in order to give the absolute location of a place
(A) Determine the total number of future trips generated in all zone? This table shows Number of currant Household and currant trips Zone A Zone B Zone C No. of No. of No. of person/Household = person/Household = person/Household = Auto/ Household 1 2-3 >3 No. of No. of No. of No. of No. of No. of Н.Н trips Н.Н trips Н.Н trips 1100 220 1500 600 1800 1080 1 950 380 1200 600 120 90 >1 80 100 200 300 50 80 This table shows Number of future Household Zone A Zone B Zone CTH No. of No. of No. of Auto/ Household person/Household = person/Household = person/Household 1 2-3 >3 3000 5000 6000 1 1500 4000 800 >1 300 700 200

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