Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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
Question: i) If X and Y are different processes producing the same commodity and the joint total cost (TC) is given by: TC = X 2 + 2Y 2 - 3XY Using Lagrange Multiplier,
Define Williamson''s Model of Managerial Discretion practice?
Relevance of The Law of Diminishing Returns The law of diminishing returns is important in that it is seen to operate in practical situations where its conditions are fulfille
Gold Although currently no country uses gold as its national currency, gold has a long history of use as commodity money and has almost universal acceptability. Gold is still
what is the theory of firm?
Q. What do you mean by Market Structure? Market economy pricing is conditioned by market structure. There are various forms of market structures. Perfect competition is accorde
Q. What is Data mining? Data mining: Data mining is the process of extracting patterns from data. Data mining is seen as an increasingly important tool by modern business to
I was given a few spreadsheets and asked to do an income, balance and cash flow statement. It''s a lot of info and I have no idea what I''m doing
Supply and Demand Discuss and analyze following statement: The Wall Street Journal reported that recent law school graduates were having a very difficult time obtaining jo
Policy conflicts In their attempts to achieve the policy objectives, governments often face what are called conflict of objectives. These arise partly because unlike private
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd