Question

In: Operations Management

ONLY PART B REQUIRED: Question 1 The towns in Kent with their corresponding x and y...

ONLY PART B REQUIRED:


Question 1

The towns in Kent with their corresponding x and y coordinates as well as their population are given overleaf. This data is also in an excel file that can be downloaded from Moodle under the name “Kent-Towns”.

(a) Using Excel Solver, or otherwise, establish a location in the plane, that minimises:

(i) the sum of distances to all Kent towns,

(ii) the sum of weighted distances to all Kent towns, with populations as weights,

(iii) the maximum distance to any Kent town, and

(iv) the maximum weighted distance to any Kent town.

(b) Assume from now on that facilities can only be established at the given towns, rather than anywhere in the plane.

(i) Establish at which town a single facility should be built, if the aim is to minimise the sum of distances from the facility to all Kent towns.

(ii) Having established this facility, use the ADD heuristic to find the location of a second facility. Allocate every town to its nearest facility. Explain why these two facilities are not necessarily the optimal solution to the p-facility discrete location problem (p=2). Can you find (using your own heuristic thinking) a pair of locations that gives a better result?

In your answers to the above, clearly explain how you have arrived at your results.

TOWN/CITY

X

Y

POPULATION

Ashford

600985

142805

58,178

Broadstairs

639320

167760

24,370

Canterbury

614880

157830

42,249

Chatham

575785

167920

70,540

Dartford

554200

174325

50,000

Deal

637510

152745

29,248

Dover

631650

141835

39,078

Faversham

601530

161425

18,000

Folkestone

622765

135915

53,411

Gillingham

577350

168385

99,773

Gravesend

564730

174170

51,150

Herne Bay

617900

167945

31,000

Maidstone

576150

155705

75,000

Margate

635460

170580

58,465

Northfleet

562235

174310

13,590

Ramsgate

638365

165180

37,967

Rochester

574375

168475

25,000

Royal Tunbridge Wells

558360

139265

45,000

Sevenoaks

552375

155295

18,588

Sheerness

591955

174725

20,000

Sittingbourne

590740

163660

55,000

Tonbridge

559080

146600

31,600

Whitstable

610670

166740

30,000

Solutions

Expert Solution

Excel Model was made as shown above.

a) i)Hence, facility location in this case should be at 591388,163105.

The formula sheet is given below :-

a) ii) The formula sheet for the above excel is

Hence, facility location, in this case, should be at 588642,162573

a) iii)

Hence, facility location, in this case, should be at 595734,162316.

a) iv)

Hence, facility location, in this case, should be at 597844,168222.

Formula Sheet for the above step is given below:-

Part B

The formula sheet is given below:-

Part b -2

The formula sheet is given below


Related Solutions

Question The towns in Kent with their corresponding x and y coordinates as well as their...
Question The towns in Kent with their corresponding x and y coordinates as well as their population are given overleaf. This data is also in an excel file that can be downloaded from Moodle under the name “Kent-Towns”. (a) Using Excel Solver, or otherwise, establish a location in the plane, that minimises: (i) the sum of distances to all Kent towns, (ii) the sum of weighted distances to all Kent towns, with populations as weights, (iii) the maximum distance to...
1. (a) Throughout Question 1 part (a), let f be the function given by f(x, y)...
1. (a) Throughout Question 1 part (a), let f be the function given by f(x, y) = 6+x^3+y^3−3xy. (i) At the point (0, 1), in what direction does the function f have the largest directional derivative? (ii) Find the directional derivative of the function f at the point (0, 1) in the direction of the vector [3, 4] . (iii) The function f has critical points at (0, 0) and at (1, 1). Classify the natures of these critical points...
Answer Question 1, each part of the question has a corresponding point value seen in ()...
Answer Question 1, each part of the question has a corresponding point value seen in () 1A company that manufactures military hats reports that the mean head circumference of all men in the military is 22.05 inches with a standard deviation of 0.68 inches. Suppose the distribution of head circumference is approximately normal, and one man in the military is selected at random. a.Find the probability that the man’s head circumference is less than 21 inches (2 pts) b.Find the...
AND( OR(OR(X,Y), AND(OR(X,Y), OR(NOT(X), NOT(Y)))), OR(OR(X,Y), AND(OR(X,Y), NAND(X,Y))) ) is equivalent to: A. OR(X,Y) B. AND(X,Y)...
AND( OR(OR(X,Y), AND(OR(X,Y), OR(NOT(X), NOT(Y)))), OR(OR(X,Y), AND(OR(X,Y), NAND(X,Y))) ) is equivalent to: A. OR(X,Y) B. AND(X,Y) C. NOR(X,Y) D. XOR(X,Y) E. NAND(X,Y) F. XNOR(X,Y) How do I simplify this with the Idempotence, De morgan, absorbtion law, etc and waht are the steps to break it down?
f(x,y)=3(x+y) 0<x+y<1, 0<x<1, 0<y<1 (a) E(xy|x)=? (b) Cov(x,y)=? (c) x and y is independent? thank you!
f(x,y)=3(x+y) 0<x+y<1, 0<x<1, 0<y<1 (a) E(xy|x)=? (b) Cov(x,y)=? (c) x and y is independent? thank you!
For the following u(x, y), show that it is harmonic and then find a corresponding v(x,...
For the following u(x, y), show that it is harmonic and then find a corresponding v(x, y) such that f(z)=u+iv is analytic. u(x, y)=(x^2-y^2) cos(y)e^x-2xysin(y)ex
Three materials X, Y, and Z are required to produce two products A and B. The...
Three materials X, Y, and Z are required to produce two products A and B. The profit function of each product is nonlinear. The total profit function for Product A is 80A - A2 and the total profit function for Product B is 72B - 0.8B2. Thus, the total profit for producing A and B together is 80A - A2 + 72B - 0.8B2. (These two profit functions are independent.) a. Use the Nonlinear Solver (GRG Nonlinear) to solve the...
Let X and Y have joint pdf f(x,y)=k(x+y), for 0<=x<=1 and 0<=y<=1. a) Find k. b)...
Let X and Y have joint pdf f(x,y)=k(x+y), for 0<=x<=1 and 0<=y<=1. a) Find k. b) Find the joint cumulative density function of (X,Y) c) Find the marginal pdf of X and Y. d) Find Pr[Y<X2] and Pr[X+Y>0.5]
1) Suppose that E(Y∣X)=X^2. Then E(Y/X) is equal to which of the following? a) 1 b)...
1) Suppose that E(Y∣X)=X^2. Then E(Y/X) is equal to which of the following? a) 1 b) E(X) c) E(X^2) d) E(Y) 2)Var(Y∣X=x) is less than or equal to Var(Y) unless Var(Y)=0. True or False?
Prove that The OR operation is closed for all x, y ∈ B x + y ∈ B
Boolean AlgebraProve that The OR operation is closed for all x, y ∈ B x + y ∈ BandProve that The And operation is closed for all x, y ∈ B x . y ∈ B
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT