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
How does economic theory contribute to managerial decisions?
bargaining power of customer for a cement company
determine points in units and reorder quantity normal sales=2 month; reorder time=15days; max stock=6 units; safety stock=1 unit ( based on 95% customer''s satisfaction )
Q10000-50p
Q. Describe Managerial and behavioural theories? It was only in 1960s that neo-classical theory of firm was disputed by alternatives like behavioural and managerial theories. M
Market research operations to obtain reliable and relevant information about the trends in market. A data analysing and processing system to estimate as well as evaluate the s
Determine the concepts of demand Demand always mentions to demand at price. The term 'demand' has no meaning unless it is related to price. For example, the statement, 'the
OBJECTIVES OF CREDIT CONTROL The old objective of controlling credit creation by the commercial banks in the country was dictated by considerations of maintaining stability of
Marginal Cost This is the increase in total cost resulting from the production of an extra unit of output. Thus, if TC n is the total cost of producing n
Use the data set cd costs2010 to estimate the marginal cost of one more CD. (Regress costs on the number of CDS.) Test the hypothesis that the marginal cost equals 75 cents. How wo
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd