S7.12. The Federal Parcel Service wants to build a new distribution cen- ter in Charlotte, North Carolina. The center needs to be in the vicinity of uncongested Interstate-77 and Interstate-85 interchanges and the Char- lotte-Douglas International Airport. The coordinates of these three sites and the number of weekly packages that flow to each are as follows: 1-77 1-85 Airport X= 14 X= 20 X= 30 y = 30 y = 8 ソ=14 w = 17,000 w = 12,000 w = 9000 Determine the best site location using the center-of-gravity technique.

S7.12. The Federal Parcel Service wants to build a new distribution cen- ter in Charlotte, North Carolina. The center needs to be in the vicinity of uncongested Interstate-77 and Interstate-85 interchanges and the Char- lotte-Douglas International Airport. The coordinates of these three sites and the number of weekly packages that flow to each are as follows: 1-77 1-85 Airport X= 14 X= 20 X= 30 y = 30 y = 8 ソ=14 w = 17,000 w = 12,000 w = 9000 Determine the best site location using the center-of-gravity technique.

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

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…
Problem 4
Consider you are an owner of one IT organization with 200 employees and you want to keep track of the location information of each employee. You know that none of the employees will go out from the city and the radius of the city is 50 km. What kind of location measure technique will be appropriate for you to keep rack of continuous location information? Explain with proper justification. Also, show how your chosen location measurement is better than the other ones.
What information do you need in order to give the absolute location of a place
(A) Determine the total number of future trips generated in all zone? This table shows Number of currant Household and currant trips Zone A Zone B Zone C No. of No. of No. of person/Household = person/Household = person/Household = Auto/ Household 1 2-3 >3 No. of No. of No. of No. of No. of No. of Н.Н trips Н.Н trips Н.Н trips 1100 220 1500 600 1800 1080 1 950 380 1200 600 120 90 >1 80 100 200 300 50 80 This table shows Number of future Household Zone A Zone B Zone CTH No. of No. of No. of Auto/ Household person/Household = person/Household = person/Household 1 2-3 >3 3000 5000 6000 1 1500 4000 800 >1 300 700 200
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 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 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products
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.)
True or False If the term of the sale is FOB destination point, the Seller will shoulder the cost of the transportation in delivering the goods to the buyer.
Prescott Industries transports sand and stone extracted fromits open-pit mines located in Odessa and Bryan to its con-crete block manufacturing facilities in Abilene, Tyler, and SanAngelo. For the capacities, locations, and shipment costs pertruckload shown in the Figure 13.13, determine the shippingpattern that will minimize transportation costs. What are theestimated transportation costs associated with this optimalallocation pattern?
2 For a destination region with which you are familiar, conduct a critical analysis of VIC provision. . Consider the location (s) involved, the appropriateness of the buildings, the level of staffing, the services available and the hours of operation. What improvements would you suggest?
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 larger and more modern post office is to be constructed at a new location in Sally Spring Georgia. Growing suburbs caused a shift in the population density from where it was 30 years ago when the current facility was built. Andy Browne, the postmaster, asked his 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 are shown in the table below. Mail Source Point Round Trips per day X coordinate Y coordinate 1 6 2 8 2 3 6 1 3 3 8 5 4 3 13 3 5 2 15 10 6 7 6 14 Calculate the center of gravity as a possible location for the new facility. Can you please show me how you arrived at the answer?