Kilroy Paper Company distributes specialty papers to big-box stores in ten major U.S. metropolitan areas and plans to consolidate its warehouses into one national distribution center (DC). To identify a suitable location, Kilroy’s distribution manager first maps the ten stores on a two-dimensional grid, so that coordinates (xk, yk) can be associated with each site. These values are shown in the following table:

Site K	Xk	Yk
1	5	41
2	20	10
3	44	48
4	60	58
5	100	4
6	138	80
7	150	40
8	170	18
9	182	2
10	190	56

a- Build the Spreadsheet for the case “Location Problem-The Kilroy Paper Company”.        

b- Find the optimal location for Kilroy’s distribution centre in this version of the problem.

c-What is the optimal value of the objective function?

Answer rating: 100% (QA)

a Excel Model The excel model for the above problem is shown below Solver parameters 1573 F G H K 55... View the full answer