1. Using the center-of-gravity method, compute the centralized coordinates among the followinglocations, which are indicated via black cells with white text in LOCATION.xlsx:7,110,14,22,56,69,62,86,102. Using the weighted average center-of-gravity, which accounts for quantities to be shippedfrom locations, compute the centralized coordinates among the following locations:7,110,14,22,56,69,62,86,10*Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units)in LOCATION.xlsx

Note: We are allowed to do one question only. The center of gravity method is a technique for…

Answered: 1. Using the center-of-gravity method,…

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

Determine the placement of departments for a newly designed facility that will minimize total transportation costs using the data in the following tables. Assume that reverse distances are the same. The locations are shown in the grid. Use a cost of $1 per trip yard.
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?
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
A small manufacturing facility is being planned that will feed parts to three heavy manufacturing facilities. The locations of the current plats with their coordinates and volume requirements are given in the following table Plant location Coordination (x,y) Volume (parts per yr.) Peoria 292,295 3,800 Decatur 384,474 5,800 Joliet 480,181 2,800 Use the centroid method to determine the best location for this new facility (round 1 decimal pt.) please. thank you
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 Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
Suppose a business owner has a choice of 5 locations in which to establish her business. She decides to rank each locations according to certain criteria, such as price of the store and parking facilities. How many different ways can she rank the 5 location?
b. An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 6 8 10 14 16 18 20 0 (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
Use the centroid method to determine the best location for this new facility.
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.)
Location Problem with Two Sites. Oliveira Office Supply has a large retail system consisting of twelve stores spread around the country, often in direct competition with Kilroy. However, managers at Oliveira have decided to use two national distribution centers. When Oliveira's stores are mapped on the same grid as Kilroy's, the store locations occur at the coordinates listed in the following table. As in the previous exercise, there are also data to indicate how many trips are made annually to each store:Coordinates TripsSite (k) xk yk nk 1 2 96 21 2 5 41 12 3 20 10 20 4 44 48 15 5 60 58 27 6 100 4 8 7 122 94 21 8 138 80 16 9 150 40 1010 170 18 1811 182 2 2512 190 56 14A)Find the optimal location for Oliveira's two distribution centers in this expanded version of the problem.b) What is the optimal value of the objective function?
Xun Xu Health and Fitness has several productionfacilities scattered around the central and northern pa rt ofIowa. It would be desirable to have a distribution center fromwhich to send product to retailers such as Sears, WaiMart,Kmart, and large sporting equipment re tailers. Using the datain the following table, calculate the center of gravity locationfor the proposed new facility.

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

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