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

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

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 100P

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: ______________
Oscar’s Bowling, Inc., wants to break into the Phoenix metropolitan market with one of its super-sized 200 lane, 24-hour bowling alleys. It, however, only has enough capital to build one facility. Oscar wants it to be centered by population, as determined by the center of gravity method. The following information is given: City Population x coordinate y coordinate Tempe Scottsdale Chandler Mesa Glendale 250,000 400,000 300,000 700,000 350,000 5 5 5 10 1 5 10 0 1 10 a. Where should Oscar build? b. If Oscar wanted to relocate to the closest city near his new facility, where would he live?
ElectroMart wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given in the accompanying table. Develop and solve a model to find the best location, assuming that straight-line distances can be used between the locations The best location for the warehouse is at X....... and Y......... (Round to two decimal places as needed.)
East Texas Seasonings is preparing to build one processing center to serve its four sources of seasonings. The four source locations are at coordinates shown below. Also, the volume from each source is provided. Calculate the volume-weighted center of gravity. X-coordinate Y-coordinate Volume Athens, Texas 30 40 100 Beaumont, Texas 20 15 400 Carthage, Texas 55 60 150 Denton, Texas 20 70 250
Oscar's Bowling, Inc., wants to break into the Phoenix metropolitan market with one of its super-sized 200 lane, 24-hour bowling alleys. It, however, only has enough capital to build one facility. Oscar wants it to be centered by population, as determined by the center of gravity method. The following information is given: City Population x coordinate y coordinate Tempe 275,000 5 5 Scottsdale 415,000 5 10 Chandler 310,000 5 0 Mesa 660,000 10 1 Glendale 335,000 1 10 a. Where should Oscar build? Oscar should build at an x coordinate of nothing and a y coordinate of nothing. b. If Oscar wanted to relocate to the closest city near his new facility, where would he live? (Enter your responses rounded to one decimal place.)
A farmers' cooperative association plans to build a new sugar mill in Georgetown. Theprimary objective of the mill is to provide the farmers with a place to take their crop forprocessing that will reduce their transportation costs. The members of the co-op believe thatthe center-of-gravity method is appropriate for this objective. While there are over 200 sugarcane 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).VillageMiles East ofBrowns TownMiles North ofBrowns TownSugar CanetonnageBarney Valley 90 10 240,000Blue Pasture 140 60 320,000Congo Valley 20 70 450,000Bower 50 20 120,000Rabacca 100 80 60,000Salem 10 120 140,000
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)
A single facility is needed to meet the demands of four markets. The locations and demands of these four markets are shown below. Using the data in the table below, identify an optimal location for the new facility. Please show the formula used. Market Coordinates Demand A (8,6) 10 B (4,12) 15 C (3,2) 10 D (9,6) 6
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 P OK Quality of life 0.29 G OK P VG VG = Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts ; P = Poor 1 pt. Using this information, determine the best and the worst location. Round your answers to two decimal places. Location Total Points 1 2 3 4 ______ is the best location and _______ is the worst location.
A manufacturer has decided to locate a new factory in northwestern United States to serve growing demand in that market. They have narrowed the potential sites down to two finalists, City A and City B. They have developed a list of important factors to consider in selecting a site, and rated each as shown in the following table. FACTOR CITY A CITY B Utility rates 98 114 Availability of skilled labor 82 75 Tax rates 38 38 Transportation 44 38 Proximity to suppliers 35 30 Quality of life 20 16 Based on this data, which city appears to be the better choice? multiple choice City A City B They are equally attractive There is insufficient information provided to answer this question
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.
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.