Determine the suitable location of a distribution centre with the below data, minimizing the transportation dollars spent on managing inbound and outbound shipments.Plot the location of the Vendors, Customers and the location of the new DC in a chartVendorV1V2V3V4CustomerC1C2C3C4Rate $ perTon Mile$$$$4.753.753.154.75Rate $ perTon Mile$$$$3.503.754.255.00Volume inTons1000100016001400Volume inTons760640800500Vendor Location Coordinates (miles)Horizontal525600412.5300Vertical300750750630Customer Location Coordinates(miles)Vertical4509001050975Horizontal9009008251050

Find the given details below:Here we can follow the Euclidean distance method to find the optimal…

Answered: Determine the suitable location of a…

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

Using the information about customer vehicle traffic to and from a proposed new sports stadium (not built yet), find the best location for the stadium that minimizes total distance travelled using the center-of-gravity method. Zip Code Location Options 2 3 4 Coordinates of Location X 2 9 12 13 y 4 5 6 12 Vehicles per Stadium Event 4,300 4,700 1,100 2,000 Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places. Cx: Cy:
Suppose that you are an engineer tasked with finding a new location for your distribution center (let's say you work as an industrial engineer at a cosmetics company). You have a good idea of who your customers are and how many tons of cosmetics you must ship per week. Using your company headquarters as the origin, you plot out the following table: Customer x-location (miles) y-location (miles) Quantity (tons/week) JC Penney 10 280 3 BB&B 70 180 7 Target 80 160 4 Bath&Body Works 170 20 5 Walmart…
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
3. Figure 1 Daily Subway and Bus Use in Five Major Cities 0.75 0.5 0.25 Subway OBus London Tokyo Singapore Hong Kong Figure 2 Subway vs. Bus Ridership, New York City OBus Subway 1970 1980 1990 2000 2010 Information in figure I suggests that public transportation users in London Information in Figure I supports the author's point that buses are growing in popularity as a means of urban transport by indicating that A) take subways and buses at similar rates. B) are unusually reliant on buses. C) take at least one subway trip daily. D) take subways at about the same rate as people A) many people around the world take at least one bus trip every day. B) bus ridership surpasses subway ridership in some major cities. C) people in Tokyo make far more trips by bus daily than they do trips by subway. D) the number of bus trips taken by people in major cities has substantially increased. in New York. 2 Which of the following statements about bus use in New York City is best supported by…
Explain the relationship between the number of facilities and transportation cost and draw the graph
Using the “Transportation Matrix”, solve the transportation problem below using the Northwest Corner and Intuitive Lowest-Cost methods. Use the Northwest Corner method result as the starting point and solve for the optimal solution using the Stepping-Stone method. Show all steps and all calculations when doing the Stepping-Stone method. Plants Supply Destination Demand Kansas City 35 Chicago 30 Omaha 50 St louis 65 Des Moines 50 Cincinnati 40 Total 135 Tons Total 135 Tons transport cost form Plants to Destinations ($/Ton) Plants Chicago St louis Cincinnati Kansas city $ 4.00 $ 3.00 $ 3.00 Omaha $ 6.00 $ 7.00 $ 6.00 Des Moines $ 8.00 $ 2.00 $ 5.00 A. Northwest Corner method B. Intuitive Lowest-Cost method C. Stepping-Stone method
The new Health-Watch facility is targeted to serve seven census tracts in Erie, Pennsylvania, whose latitudes and longitudes are shown in Table, along with the population in each census tract (in thousands). Customers will travel from the seven census-tract centers to the new facility when they need health care. What is the target area’s center of gravity for the Health-Watch medical facility?
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?
Contrast the location of a food distributor and a supermar-ket. (The distributor sends truckloads of food, meat, produce, etc., to the supermarket.) Show the relevant considerations(factors) they share; show those where they differ.
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
The new Health-Watch facility is targeted to serve seven census tracts in Erie, Pennsylvania, whose lati-tudes and longitudes are shown in Table 13.1, along with the population in each census tract (in thou-sands). Customers will travel from the seven census-tract centers to the new facility when they needhealth care. What is the target area’s center of gravity for the Health-Watch medical facility?
Q3) The Cure medical distribution center distributes urgent medical equipment for five local hospitals in Washington DC metropolitan area. Cure Medical distribution would like to invest in a new warehouse in Washington DC to minimize the total distance from five major hospitals. The coordinate of the five hospitals is given below: ( (2) 3 Great Fall (C) (47) 122 (121) Fairfax 10 We W Bu (645) -D (-20, 30)- -E (-40, -30) Colesville Fairland Calpen A (10,60) -B (10,-10) Ⓡ South Lourel stuxent search Refuge (MA A (14) tille (214) pha Bowit (00 X -C (45, -20) 201 C a) Use Solver to determine where the new warehouse should be in to minimize the total distance from 5 hospitals. What are the coordinates of the new warehouse? b) Solve your problem again to minimize the maximum distance between hospitals and the new warehouse. What are the coordinates of the new warehouse?

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