8.20 The following table gives the map coordinates and theshipping loads for a set of cities that we wish to connect through acentral hub.s.Citybne cmedelShipping LoadMap Coordinate (x, y)(5, 10)(6, 8)(4, 9)(9, 5)(7, 9)(3, 2)10151510G(2, 6)a) Near which map coordinates should the hub be located?b) If the shipments from city A triple, how does this change thecoordinates? PxABCDE

Answered: 8.20 The following table gives the map…

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

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
1. For the following problems, provide your written solutions within this template. Do not create a new file. Show all steps used in arriving at the final answers. Incomolete solutions will receive partial credit. 3. Provide formulas using Equation Editor and diagrems using Drawing Tool. 4. Use the Solver to obiain computer solutions in an Excel workbook. 5. Submit the Word and Excel workbook(s) separately as attachments. 2. Problern 1 The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow}. Sources (Supplies) Destinations (Demands) 2500 2900 4 A000 3800 8. 3800 .... **.** 9. R. at 2700 12 3700 oce D. a) Write the mathematical formulation of the problem. b} Use the Excel Solver to solve the problem. Generate the answer and sensitivity…
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?
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 chart Vendor V1 V2 V3 V4 Customer C1 C2 C3 C4 Rate $ per Ton Mile $ $ $ $ 4.75 3.75 3.15 4.75 Rate $ per Ton Mile $ $ $ $ 3.50 3.75 4.25 5.00 Volume in Tons 1000 1000 1600 1400 Volume in Tons 760 640 800 500 Vendor Location Coordinates (miles) Horizontal 525 600 412.5 300 Vertical 300 750 750 630 Customer Location Coordinates(miles) Vertical 450 900 1050 975 Horizontal 900 900 825 1050
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.)
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.
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 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) 4 (4, 6) (8, 4) (3, 14) (6, 10) (12, 11) (13, 5) (13, 6) (14, 10) 2 1 11 5 7 6 7 3 M 8 a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) The center of gravity "X" coordinate = 9 The center of gravity "Y" coordinate = 8. b. Compare the load-distance scores for the…
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 4 (4, 6) 7 (8, 4) (3, 14) (6, 10) (12, 11) (13, 5) (13, 6) (14, 10) 3 1 4 11 7 3 7 3 M 8 a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) The center of gravity "X" coordinate = The center of gravity "Y" coordinate =
Consider the transportation table below for answering question number 21-25. From To Quezon city Bataan Php 7 Visayas Mindanao Php 10 Php 6 Demand 100 Manila Taguig Supply Php 5 Php 9 Php 12|Php 10 150 200 Php 3 Php 14 50 80 220 400 21. Using Northwest Corner Rule, how many must be supplied from Visayas to Taguig? (a) 170 (b) 180 (c) 190 (d) 200 22. Using Northwest Corner Rule, how many must be supplied from Mindanao to Taguig? (a) 45 (b) 50 (c) 55 (d) 60 23. Using Minimum Cost Method, how many must be supplied from Visayas to QC? (a) 200 (b) 210 (c) 220 (d) 230 24. Using Minimum Cost Method, how many must be supplied from Mindanao to Manila? (a) 35 (b) 40 (c) 50 (d) 55 25. Using Vogel's Approximation Method, how many must be supplied from Bataan to Taguig? (a)20 (b) 25 (c) 30 (d) 40
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.
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. a) Near which map coordinates should the hub be located?b) If the shipments from city A triple, how does this change the coordinates?

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