Q) A discount store chain wants to build a new superstore in an area in Melbourne near four small towns withpopulations between 10,000 and 40,000. The coordinates (in miles) of these four towns and the market populationin each are as follows:CoordinatesCarltonSt KildaBallaratFrankston121830322012825Population18,00017,00010,30010,000a) Determine the best site using the center-of-gravity technique.b) Suppose the store is limited to two possible sites for locating a new superstore. The coordinates (in miles) ofthese two potential sites are site 1 (10, 30) and site 2 (20, 10). Using the load-distance technique, determinethe best site for the new super store.c) Plot the four small towns and the proposed new distribution centers according to center of gravity methodand load-distance method on a grid map. Give your own opinion about it.

Given- Location X Y Population Carlton 12 20 18000 St Kilda 18 12 17000 Ballarat 30 8 10300…

Answered: Q) A discount store chain wants to…

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
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
A food manufacturer wants to locate a warehouse to serve its major customers. 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 centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
A company is constructing a new hostel facility. The company has hired you as part of the team to identify the best potential sites for the new facility. Your team identified four sites and have rated the important location factors for each site as follows: LOCATION FACTOR SCORES (out of 100) WEIGHT A B C D Proximity to Campus 0.23 70 90 65 85 Student traffic 0.22 75 80 60 85 Parking availability 0.16 90 60 80 70 Plot size, terrain 0.12 80 70 90 75 Infrastructure 0.10 50 60 40 60 Off-campus accessibility 0.06 90 70 70 70 Proximity to dining facilities 0.05 60 80 70 90 Visitor traffic 0.04 70 80 65 55 Landscape/aesthetics 0.02 50 40 60 70 Required: c) If the location C has its score for infrastructure to be 80. Will the choice in (b) be the same? d) Explain two (2) benefits for the best location selected for the hostel in…
A company is constructing a new hostel facility. The company has hired you as part of the team to identify the best potential sites for the new facility. Your team identified four sites and have rated the important location factors for each site as follows: LOCATION FACTOR SCORES (out of 100) WEIGHT A B C D Proximity to Campus 0.23 70 90 65 85 Student traffic 0.22 75 80 60 85 Parking availability 0.16 90 60 80 70 Plot size, terrain 0.12 80 70 90 75 Infrastructure 0.10 50 60 40 60 Off-campus accessibility 0.06 90 70 70 70Proximity to dining facilities 0.05 60 80 70 90 Visitor traffic 0.04 70 80 65 55 Landscape/aesthetics 0.02 50 40 60 70 Required: a) What is the weighted score for the each location? b) Which location will you recommend for the new hostel? Justify your choice. c) If the location C has its score for infrastructure to be 80. Will the choice in (b) be the same? d) Explain two (2) benefits for the best location selected for the hostel in (b).
A company is constructing a new hostel facility. The company has hired you as part of the team to identify the best potential sites for the new facility. Your team identified four sites and have rated the important location factors for each site as follows: LOCATION FACTOR SCORES (out of 100) WEIGHT A B C D Proximity to Campus 0.23 70 90 65 85 Student traffic 0.22 75 80 60 85 Parking availability 0.16 90 60 80 70 Plot size, terrain 0.12 80 70 90 75 Infrastructure 0.10 50 60 40 60 Off-campus accessibility 0.06 90 70 70 70 Proximity to dining facilities 0.05 60 80 70 90 Visitor traffic 0.04 70 80 65 55 Landscape/aesthetics 0.02 50 40 60 70 Required: a) What is the weighted score for the each location? b) Which location will you recommend for the new hostel? Justify your choice.
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: ______________
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 Coordinates Market Segment 1 2 3 4 Find 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. 25 20 15 -10 5 Center of Gravity y- Coordinate L 5 10 15 20 x- Coordinate 25 B. 25+ 20+ 15 -10- 5- Center of Gravity y- Coordinate 5 8 10 15 20 x- Coordinate X 1 13 1 11 25 Y 14 21 1 1 Number of Customers 1,600 400 1,200 3,700
Select all of the examples of companies locating a facility because of market асcess. O A company that supplies products to the US and European markets locates their production facility in southeast Asia. A major retailer is located in several major cities across the country. O A company locates a processing facility adjacent to the supplier's mining operations. O A business management consulting firm locates in the same cities as prestigious universities.
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?
A company desires to locate a new facility. Based on preliminary analysis, thechoice has been reduced to four locations: A, B, C, and D. These four locationswere rated on a scale from 1 worst to 10 best on each of four criteria. Eachcriterion was also weighted to indicate its importance (i.e., the higher theweight, the more important). The list of ratings and weights follows THE TABLE ATTACHED b- If the wights of weather and regulation be divided that the weatherwould be double of the regulations, what would be the best location. Please can you give me an answer with explanation.
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Judy inc. Zac Supermarket Harry Inc. Sky Productions Annual Volume X-Coordinate Y-Coordinate 3 7 5 2 8 4 1 5 25 13 6 4 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.

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