Location problem in the plane, Managerial Economics

Assignment Help:

Location problem in the plane:

In Kent, the council to respond to the people and government needs, it decided to establish 3 community care homes. The towns are recorded with their corresponding x and y coordinates as well as their population, see Table 1.

(i)Use Excel to solve this location problem in the plane. (Hint: As the problem is not convex and not linear, you cannot use the Simplex but the other 2 approaches shown in Solver (Evolutionary approach and GRG Non Linear)). Also you may need to use several starting points as poor local minima may be found instead, Try both approaches before you finalise your decision and comment on the way you attempted it.

(ii) What do you expect the solution quality will be if you had to solve the discrete version of the problem using all the town locations as potential sites? Which weaknesses you may be faced with when implementing the optimal solution of (i) if it exists.

(iii) Now consider that any facility built cannot serve more than 350000 in total. Use the locations found in (i) and determine the new allocation (This is now a TP which can be solved using Simplex LP in solver). Express in % the extra cost incurred due to such a restriction.

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

Table 1: Coordinates and population of Kent Towns


Related Discussions:- Location problem in the plane

Range of alternative uses of a commodity, Broader the range of other uses o...

Broader the range of other uses of a commodity, higher the price elasticity of its demand intended for the fall in price though less elastic for the increase in price. As price of

Search and matching model, Search and Matching Model It  should  be  c...

Search and Matching Model It  should  be  clear  to  you  fiom  the  earlier section  that  there  are  a  variety  of models under the rubric of  search theory.  In  this sec

Economies and diseconomies of scale, Economies and diseconomies of scale ar...

Economies and diseconomies of scale are of two types- external andinternal. Internal economies and diseconomies are those which a firm reaps as a result of its own expansion. Conve

Assumptions of monopolistic competition, Assumptions of Monopolistic Compet...

Assumptions of Monopolistic Competition Monopolistic competition as the name implies, combines features from both perfect competition and monopoly.  It has the following featu

What is the efficient level of the public good, Consider an economy with tw...

Consider an economy with two individuals. Individual 1 has (inverse) demand curve for a public good given by P1=60-2Q1, While individual 2 has (inverse) demand curve for the public

Coefficient on education, Let Consider the following (familiar) equation wh...

Let Consider the following (familiar) equation which estimates the number of hours of sleep / year  that someone gets as a function of hours worked / year (total work), education (

Quantity demanded and supplied , a.  A major freeze destroys a large number...

a.  A major freeze destroys a large number of orange trees in Florida Ans- Since the freeze destroyed a large number of orange trees in Florida the number of oranges the selle

Dumping - reason for protection, Dumping If goods are sold on a foreig...

Dumping If goods are sold on a foreign market below their cost of production this is referred to as dumping.  This may be undertaken either by a foreign monopolist, using high

Explain the confidence interval, 1.  According to an article in San Luis Ob...

1.  According to an article in San Luis Obispo Tribune July 21, 2006 37% of the college freshman and 48% of the college seniors carry a credit balance from month to month. Suppose

Determine the theory of consumer behaviour, Theory of consumer behaviour ...

Theory of consumer behaviour The role of customers in an economy is of significant importance because consumers spend most of their incomes on services and goods produced by fi

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd