Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

please solve it by Excel solver and get a like image text in transcribed
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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Analysis Part 1 Facts Of Auditing

Authors: Dr. L. KAILASAM

1st Edition

1670149455, 978-1670149459

More Books

Students also viewed these Accounting questions