please solve it by Excel solver and get a like
We want to open three new big shops and add them to the 4 existing ones. It is planned that these new big shops support the existing ones with some shares of their product requirements. In doing so, maybe they need to share some of their products as well. The required information including the location of the existing shops and the planned weight of relationships (cost) among the existing shops and the new ones, and among the new ones are given in below: P1(6,3) P2(11,15) P3(12,10) P4(21,3) P4(21,3) V12=3 V13-7 V234 W11-2 W12=3 W 225 W13=6 W33-2 W2=1 W31-4 W41-2 W42-3 We need to specify the coordinates of new shops? Write a mathematical programming model for this problem and then linearize it to make it easier to be solved. No need to solve the developed linear model. (You can consider the distances are as rectilinear distances) (100 points) Bonus Mark: Code your mathematical programming model in Gams or even Excel Solver. Solve the problem and find the locations of the new shops and illustrate the location of the shops (new and existing ones) in a plot (coordinate plane). (100 points) We want to open three new big shops and add them to the 4 existing ones. It is planned that these new big shops support the existing ones with some shares of their product requirements. In doing so, maybe they need to share some of their products as well. The required information including the location of the existing shops and the planned weight of relationships (cost) among the existing shops and the new ones, and among the new ones are given in below: P1(6,3) P2(11,15) P3(12,10) P4(21,3) P4(21,3) V12=3 V13-7 V234 W11-2 W12=3 W 225 W13=6 W33-2 W2=1 W31-4 W41-2 W42-3 We need to specify the coordinates of new shops? Write a mathematical programming model for this problem and then linearize it to make it easier to be solved. No need to solve the developed linear model. (You can consider the distances are as rectilinear distances) (100 points) Bonus Mark: Code your mathematical programming model in Gams or even Excel Solver. Solve the problem and find the locations of the new shops and illustrate the location of the shops (new and existing ones) in a plot (coordinate plane). (100 points)