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

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
i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products
Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup its distribution centre. What is the main objective of using this technique? What information will be needed in order to use this technique? Setup a numerical example that can be used to demonstrate to the owner of the company how the technique can be used Use the numerical example set up above to demonstrate how the centre of gravity location technique is used.
A clothing manufacturer produces women’s clothes at four locations in Mexico. Relative locationshave been determined, as shown in the table below. The location of a central shipping pointfor bolts of cloth must now be determined. Weekly quantities to be shipped to each location arealso shown in the table. Determine the coordinates of the location that will minimize distributioncosts. Location (x,y) WeeklyQuantityA 5,7 15B 6,9 20C 3,9 25D 9,4 30
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.
how to setup an example of a numerical centre of gravity location technique (for production and operations management) that can be used to demonstrate how the technique is used for a distribution centre?
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.
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…
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.
Which of the following techniques works for location analysis for both service/retail/professional organizations as well as goods-producing organizations? A. Transportation method B. Traffic counts C. Factor-rating method D. Demographic analysis of drawing area.
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
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.

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