Q3) The Cure medical distribution center distributes urgent medical equipment for five localhospitals in Washington DC metropolitan area. Cure Medical distribution would like to invest ina new warehouse in Washington DC to minimize the total distance from five major hospitals.The coordinate of the five hospitals is given below:((2)3Great Fall(C)(47)122(121)Fairfax10WeWBu(645)-D (-20, 30)--E (-40, -30)Colesville FairlandCalpenA (10,60)-B (10,-10)ⓇSouth LourelstuxentsearchRefuge(MAA(14)tille(214)phaBowit(00X-C (45, -20)201Ca) Use Solver to determine where the new warehouse should be in to minimize the totaldistance 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 newwarehouse. What are the coordinates of the new warehouse?

Operation management is performed in each manufacturing organization. It all deals with the…

Answered: a) Use Solver to determine where the…

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

None
A single facility is needed to meet the demands of four markets. The locations and demands of these four markets are shown below. Using the data in the table below, identify an optimal location for the new facility. Please show the formula used. Market Coordinates Demand A (8,6) 10 B (4,12) 15 C (3,2) 10 D (9,6) 6
please solve manually
The Green Cab Company has a taxi waiting at each of four cabstands in Evanston, Illinois. Four customers have calledand requested service. The distances, in miles, from the waiting taxis to the customers a re given in the following table. Find the optimal assignment of taxis to customers so as to minimize total driving distances to the customers.
b
7. The BD restaurant chain purchases materials from four different food suppliers. The company wants to construct a new central distribution center to process and package the materials before shipping them to their various restaurants. The suppliers transport items in 40-foot truck trailers, each with a capacity of 38,000 lbs. The locations of the four suppliers and the annual number of trailer loads that will be transported to the distribution center are shown in the following table (distance in miles). Using the center-of-gravity method, determine a possible location for the distribution center. A B с D X Y 200 200 100 500 250 600 500 300 Load 75 105 135 60 BD wants to evaluate three different sites it has identified for its new distribution center relative to the four suppliers identified. The coordinates of the three sites under consideration are as follows: Site 1: x1 = 360, y₁ = 180 Site 2: X2 = 420, y2 = 450 Site 3: X3 = 250, y3 = 400
Task 1: An oil refining company ships the following gasoline volumes from its refining plant in Long beach to its major distributors: Coordinates (x, y) 400, 150 450, 350 350, 400 25, 450 Distributor Gallons (in millions) Anaheim 150 LaHabra 350 Glendale 250 Thousand Oaks 450 The location coordinates of the refining plant in Long Beach are: (325, 75). Under a new proposed distribution setting, the company wants to setup an intermediate holding facility, such that gasoline will first get transported to this holding facility, and then, from there, to the distributors. What will be the ideal location (coordinates) for the intermediate holding facility? (Round to 2 decimal places.)
Using NETWORK and ASSIGNMENT MODEL for Operation Management/Research please solve the attached problem. Show Solution.
Given the following network, with the indicated flow capacities of each branch, determine the maximum flow from source node 1 to destination node 6 and the flow along each branch:
snip
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 A B C Coordinates (miles) (200,100) (400,200) (300,100) a. Which of these three locations yields the smallest load-distance score, based on Euclidean distances? Location one decimal place.) b. Which of these locations is best, based on rectilinear distances? yields the smallest load-distance score of Location whole number.) c. What are the coordinates of the center of gravity? is the best, yielding a load-distance score of * The center of gravity is x = decimal place.) * Deliveries per day miles, y = 5 7 9 (Enter your response rounded to (Enter your response as a miles. (Enter your responses rounded to one
excel format and show steps

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