None A hardware distributor has regional warehouses at the locations shown below. The companywants to locate a new central distribution center to serve this warehouse network.Location1(xy)2,3123413,75,57,38,7Weekly shipments to each warehouse will be: WH1, 100; WH2, 150; WH3, 120; WH4, 150;and WH5, 120. What is the optimal location of the distribution center?5.1, 4.2O 5.2, 4.05.1, 5.1O 4.2, 5.1O 4.9, 5.2

The weighted average of the warehouse coordinates, where the weights are the weekly shipments to…

Answered: A hardware distributor has regional…

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

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
a. A farmers' cooperative association plans to build a new sugar mill in Georgetown. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane 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). Village Barney Valley Blue Pasture Congo Valley Bower Rabacca Salem Miles East of Miles North of Sugar Cane Browns Town Browns Town 90 140 20 50 100 10 10 60 70 20 80 120 tonnage 240,000 320,000 450,000 120,000 60,000 140,000
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 thetable below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc. 25 3 7Zac Supermarket 13 5 2Harry Inc. 6 8 4Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the locationcoordinates that will minimize the transportation costs for their family ofproducts
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
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.
An operations manager wants to use gravity location approximation to decide the location of a warehouse. The x and y coordinates of three customer locations, demand (D) at those locations, and transportation costs per unit per mile (F) are presented in the table below. Help the operations manager by finding the approximate location of the warehouse. Customers y F 1 10 20 1 10 2 20 1 20 3 10 10 2 10 x=20, y=10 x=14, y=10 x=10, y=14 x=13.3, y=11.7 O x=10, y=15
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.
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.
We have four major customers, and want to find the location that minimizes the average distance traveled to deliver products to them. Customer X coord Y coord Demand A 10 10 100 B 15 40 20 C 35 12 20 D 38 40 150 What is the optimal X coordinate for our location?
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 company that handles hazardous waste wants to minimize the shipping cost for shipments to a disposal center from five receiving stations it operates. Given the locations of the receiving stations and the volumes to be shipped daily, determine the location of the disposal center.
A single facility is needed to meet the demands of four markets. The locations and demands ofthese four markets are shown below. Market Coordinates Demand A (8,6) 10 B (4,12) 15 C (3,2) 10 D (9,6) 6 1.Using the data in the table above, identify an optimal location for the new facility. 2. A manufacturing firm is considering three potential locations for a new parts manufacturing facility. Aconsulting firm has assessed three sites based on the four factors supplied by management as critical tothe location's success. Management-supplied the factor weights and the consultant team scores as seen as in the table below. Scores are based on 50 = best. Location Factor Weight A B C Labour climate 10 35 45 20 taxes 30 30 40 40 utilities 20 25 20 45 wages 40 10 25 25 Which location should be selected and why?

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