A movie distributor has the task of locating cinema rooms in the city to serve customers that are located in 10 districts. Tables 1 and Table 2 display the distances between the districts and the expected demand for each district, respectively. The problem requires finding where to locate three cinema rooms. 1) Explain why the problem boils down to a p-median problem. 2) Use Excel Solver for finding the best locations Table 2-Distances between districts 1 2 3 Distances 1 4 5 7 8 9 10 0 11 4 2 6 5 11 4 9 6 5 2 11 9 20 0 8 4 12 5 8 14 8 14 3 9 6 14 6 5 14 0 14 10 6 4 4 8 3 9 4 4 olm 5 2 4 3 0 7 11 6 13 15 17 18 11 5 5 6 7 vo 11 12 7 6 10 5 14 14 0 13 5 8 4 9 6 0 8 8 12 8 5 4 5 8 0 9 8 20 9 9 15 11 17 11 18 8 9 0 11 10 5 8 14 4 5 8 12 11 0 Table 3 - Expected demand 1 2 3 4 5 6 7 00 8 9 10 Expected demand 20 15 8 11 17 6 6 4 14 19 4 A movie distributor has the task of locating cinema rooms in the city to serve customers that are located in 10 districts. Tables 1 and Table 2 display the distances between the districts and the expected demand for each district, respectively. The problem requires finding where to locate three cinema rooms. 1) Explain why the problem boils down to a p-median problem. 2) Use Excel Solver for finding the best locations Table 2-Distances between districts 1 2 3 Distances 1 4 5 7 8 9 10 0 11 4 2 6 5 11 4 9 6 5 2 11 9 20 0 8 4 12 5 8 14 8 14 3 9 6 14 6 5 14 0 14 10 6 4 4 8 3 9 4 4 olm 5 2 4 3 0 7 11 6 13 15 17 18 11 5 5 6 7 vo 11 12 7 6 10 5 14 14 0 13 5 8 4 9 6 0 8 8 12 8 5 4 5 8 0 9 8 20 9 9 15 11 17 11 18 8 9 0 11 10 5 8 14 4 5 8 12 11 0 Table 3 - Expected demand 1 2 3 4 5 6 7 00 8 9 10 Expected demand 20 15 8 11 17 6 6 4 14 19 4