Question: topic: Non-linear Programming Problem a Location Problem with Two Sites. By using Excel Solve, solve this problem: Oliveira Office Supply has a large retail system

topic: Non-linear Programming Problem a Location Problem with Two Sites.

By using Excel Solve, solve this problem: Oliveira Office Supply has a large retail system consisting of twelve stores spread around the country, often in direct competition with Kilroy. However, managers at Oliveira have decided to use two national distribution centers. When Oliveira's stores are mapped on the same grid as Kilroy's, the store locations occur at the coordinates listed in the following table.

Coordinates

Trips

Site (k)

xk

yk

nk

1

2

96

21

2

5

41

12

3

20

10

20

4

44

48

15

5

60

58

27

6

100

4

8

7

122

94

21

8

138

80

16

9

150

40

10

10

170

18

18

11

182

2

25

12

190

56

14

A. Find the optimal location for Oliveira's two distribution centers in this expanded version of the problem.

B. What is the optimal value of the objective function?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!