The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub. City ABCDEFG Map Coordinates (x,y) (4,10) (6,7) (5,8) Shipping Load 6 9 16 (7,4) (8,8) (3,1) (2,7) a) For the location of the proposed new central hub, the coordinates should be near: x= 5.35 (round your response to two decimal places). 5 15 10 5 D y = 6.61 (round your response to two decimal places). b) If the shipments from city A triple, for the location of the proposed new central hub, the coordinates should be near: x = 5.14 (round your response to two decimal places).' y = (round your response to two decimal places). ncorrec

The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub. City ABCDEFG Map Coordinates (x,y) (4,10) (6,7) (5,8) Shipping Load 6 9 16 (7,4) (8,8) (3,1) (2,7) a) For the location of the proposed new central hub, the coordinates should be near: x= 5.35 (round your response to two decimal places). 5 15 10 5 D y = 6.61 (round your response to two decimal places). b) If the shipments from city A triple, for the location of the proposed new central hub, the coordinates should be near: x = 5.14 (round your response to two decimal places).' y = (round your response to two decimal places). ncorrec

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

Rauschenberg Manufacturing is investigating which locations would best position its new plant relative to three important customers (located in cities A, B, and C). As shown in the table below, all three customers require multiple daily deliveries. Management limited the search for this plant to those three locations and compiled the following information: Location Coordinates (miles) Deliveries per day (200,100) (300,100) (300,300) A 9 B 5 7 a. Which of these three locations yields the smallest load-distance score, based on Euclidean distances? Location V yields the smallest load-distance score of : (Enter your response rounded to one decimal place.)
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
Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup itsdistribution centre.I. What is the main objective of using this technique? II. What information will be needed in order to use this technique? III. Setup a numerical example that can be used to demonstrate to the owner of thecompany how the technique can be used. IV. Use the numerical example set up above to demonstrate how the centre of gravitylocation technique is used.
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.
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.
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) 4 (4, 6) (8, 4) (3, 14) (6, 10) (12, 11) (13, 5) (13, 6) (14, 10) 2 1 11 5 7 6 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 = 9 The center of gravity "Y" coordinate = 8. b. Compare the load-distance scores for the…
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 =
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…
The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub. Using the Center of Gravity method, near which map coordinates should the hub be located? STORE LOCATION CONTAINERS SHIPPED PER MONTH X Y Chicago 2,000 50 120 Pittsburgh 1,000 110 100 New York 3,000 160 130 Atlanta 2,000 120 40
J 2 An electronics store 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 a model to find the best location, assuming that straight-line distances can be used between the locations. Experiment with the model by testing each of the possible best solutions, included, to find the best location. Click here to view the data for the store locations and annual numbers of truckloads. Click here to view some possible best solutions. The best location is at____. (Type an ordered pair. Round each coordinate to the nearest integer as needed.)
Rauschenberg Manufacturing is investigating which locations would best position its new plant relative to three important customers (located in cities A, B, and C). As shown in the table below, all three customers require multiple daily deliveries. Management limited the search for this plant to those three locations and compiled the following information: Location Coordinates (miles) Deliveries per day A (300,100) 4 В (400,200) 8 (200,400) 6 a. Which of these three locations yields the smallest load-distance score, based on Euclidean distances? Location V yields the smallest load-distance score of. (Enter your response rounded to one decimal place.) b. Which of these locations is best, based on rectilinear distances? Location V is the best, yielding a load-distance score of (Enter your response as a whole number.) c. What are the coordinates of the center of gravity? The center of gravity is x = miles, y miles. (Enter your responses rounded to one decimal place.)