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

Consider you are an owner of one IT organization with 200 employees and youwant to keep track of the location information of each employee. You know thatnone of the employees will go out from the city and the radius of the city is 50km. What kind of location measure technique will be appropriate for you to keeptrack of continuous location information? Explain with proper justification. Also,show how your chosen location measurement is better than the other ones.
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
AER Sales Representative Problem 1: RRR Distributors Corporation has four sales territories, each of which must be assigned a sales representative. From past experience the firm's sales manager has estimated the sales volume for each sale representative in each territory. Find the sales representative territory assignments that will maximize sales (data given in millions). Emmalou Geraldine Aubrey Margareth A. B. C Problem 2: A 56 66 49 37 Immediato Predecessor B 44 45 53 36 Determine a set of assignments that will minimize the total cost? What is the total cost? Provide the linear programming/algebraic expression that will satisfy the objective of the analyst. Time AN 4 District rat, qui OPEC-20 Normal cost C 56 49 58 39 5. Crash Duration D 55 71 49 45 Crash Cost
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.
Design a spreadsheet to compute the total rectilinear distance from a set of up to10 existing locations to any other location. Assume that existing locations areplaced in Columns A and B and the new location in cells D1 and E1. Initializecolumn A with the value of cell D1 and column B with the value of cell E1, so thatthe total distance will be computed correctly when there are fewer than10 locations.a. Suppose that existing facilities are located at (0, 0), (5, 15), (110, 120), (35, 25),(80, 10), (75, 20), (8, 38), (50, 65), (22, 95), and (44, 70), and the new facility is tobe located at (50, 50). Determine the total rectilinear distance of the new facilityto the existing facilities.b. Suppose the new facility in part (a) can be located only at x =0, 5, 10, . . . , 100and y = 0, 10, 20, . . . , 100. By systematically varying the x and y coordinates,find the optimal location of the new facility
kindly solve
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.

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