Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Managerial Economics Expert

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

Managerial Economics, Economics

  • Category:- Managerial Economics
  • Reference No.:- M9521512

Have any Question?


Related Questions in Managerial Economics

I have long thought subway made a monster mistake in their

I have long thought Subway made a MONSTER mistake in their "$5 footlong" campaign, that showed the whole country that they could sell footlong subs for just $5. I think this decreased the value of their brand, and made t ...

Question read three 3 academically reviewed articles on

Question: Read three (3) academically reviewed articles on managerial economics and complete the following activities: (500 words) 1. Summarize all three (3) articles. Please use your own words. No copy-and-paste 2. Disc ...

Assignment - portfolio project for the final project you

Assignment - Portfolio Project For the final project, you will create a case study based on a company of your choice. The case study should include at least 5 of the concepts that we have discussed. The case study should ...

Geographic information systems gisassignment short paper

Geographic Information Systems (GIS) Assignment: Short Paper: GIS In the early years of Geographic Information Systems (GIS) technology, mapping was largely limited to public works, and then in the 1990s and early 2000s, ...

Queuing theory in the public sectordiscussion queuing

Queuing Theory in the Public Sector Discussion: Queuing Theory and Wait Times For this Discussion, you dive deeper into the topic of queuing. To prepare: Review the Learning Resources for the week as they relate to the t ...

Topic - cost benefit analysis cba discussion benefits and

Topic - Cost Benefit Analysis (CBA) Discussion: Benefits and Shortcomings of Cost Benefit Analysis As mentioned in the Weekly Introduction, cost benefit analysis is one of the most widely used of all public-sector manage ...

Simulation and agent-based modeling schelling t c 1971

Simulation and Agent-Based Modeling Schelling, T. C. (1971). Dynamic models of segregation. Journal of Mathematical Sociology, 1(2), 143-186. Seminal Retrieved from the Walden Library databases. Discussion: Agent-Based M ...

Discussion explore applications of pert and cpm in the

Discussion: Explore Applications of PERT and CPM in the Public or Non-Profit Organizations PERT is typically used to manage very large projects. In terms of scale, think weapons systems, the development of interstate tra ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As