Find the preferred coordinates of the new store

Assignment Help Operation Management

Reference no: EM131931717

QUESTION - Center of Gravity (COG)

An electronics retailer considers setting up a new store to serve four nearby cities. The retailer needs to find a good location which can attract the most customers.

City populations can represent the number of potential customers. City councils are situated roughly in the center of the cities. City populations and geographical coordinates of the four city councils are as follows:

city	Council x-coordinate	Council y-coordinate	Population
1	3	20	19000
2	14	17	17500
3	5	6	15500
4'	12	3	16000

(a) Using the center-of-gravity method, find the preferred coordinates of the new store.

(b) Use the scatter diagram function in Excel to draw an area map of the four city councils and the preferred store location.

Your map should have 5 points with x-coordinates on the horizontal axis and y-coordinates on the vertical axis. Give an Excel printout of the map.

Reference no: EM131931717

Questions Cloud

Who would be the organizations target audience : Who would be the organization's target audience? What value would the SMIS provide to visitors?

Why decision making is central to the role of the manager : Discuss why decision making is central to the role of the manager. Illustrate your answer by referring to at least two different types of managers.

What is the maximum interest rate for the life of mortgage : You have obtained a 25-year adjustable rate mortgage at 5.89% with a principal of $452,205. What is the maximum interest rate for the life of the mortgage?

What do you think are the key challenges and exposures : What would you identify as some of the key strategic initiatives that firms in the tourism space, such as Ardent Leisure, should be considering?

Find the preferred coordinates of the new store : Your map should have 5 points with x-coordinates on the horizontal axis and y-coordinates on the vertical axis. Give an Excel printout of the map.

Prepare the journal entry to record the payment of interest : Prepare the journal entry to record the payment of interest on October 1, 2017. Prepare the journal entry to record the issuance of the bonds.

What is jailai cost of equity : JaiLai Cos. stock has a beta of 0.7, the current risk-free rate is 5.7 percent, and the expected return on the market is 12 percent.

Give reasons for your choice of measures : Discuss what measures you would use - both qualitative and quantitative - to assess the effectiveness of a manager.

Minimize the risk involved with buying real estate : What are some of the ways to minimize the risk involved with buying real estate?

User Account

All Pages