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

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: Location Market Coordinates Number of Segment x y Customers 1 5 22 2,200 2 17 20 300 3 5 3 1,400 4 10 3 3,000 Find the best location using the Center of Gravity Excel template. Round your answers to two decimal places. Cx: ____________Cy: ______________
A toy manufacturer produces toys in five locations throughout the country. Raw materials (primarily barrels of powdered plastic) will be shipped from a new, centralized warehouse whose location is to be determined. The monthly quantities to be shipped to each location are the same. A coordinate system has been established, and the coordinates of each location have been determined as shown. Determine the coordinates of the centralized warehouse.Location (x,y)A 3,7B 8,2C 4,6D 4,1E 6,4
Suppose that you are an engineer tasked with finding a new location for your distribution center (let's say you work as an industrial engineer at a cosmetics company). You have a good idea of who your customers are and how many tons of cosmetics you must ship per week. Using your company headquarters as the origin, you plot out the following table: Customer x-location (miles) y-location (miles) Quantity (tons/week) JC Penney 10 280 3 BB&B 70 180 7 Target 80 160 4 Bath&Body Works 170 20 5 Walmart…
The Walgreen 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: Find the best location using the Center of Gravity Excel template. Market Segment Location Coordinates Number of Customers x y 1 4 15 3300 2 10 13 900 3 5 2 1250 4 9 6 3500
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 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:
Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup its distribution centre. 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.
CVS 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: Market Segment Location Coordinates Number of Customers x y 1 8 13 2000 2 10 16 800 3 4 8 1600 4 12 4 3200 Find the best location using the Center of Gravity Excel template
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.
Mean and Median are two representative measures for identifying central location. What are the pros and cons of using these two measures? Which one is more vulnerable to outliers and why?
If there are five factories in the district, with locations and size given in the following table, use the center-of-gravity method to determine at which factory the central office should be placed to minimize the average distance between the office and employees. Location A B C D E (X,Y) (5,5) (0,5) (0,0) (5,0) (2,1) Size (Employees) 2500 1000 10000 4500 7500
Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup itsdistribution centre.Setup a numerical example that can be used to demonstrate to the owner of thecompany how the center of gravity technique can be used.

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