Question: Assume that we have a transportation map that includes three origin points, two transshipment points, and three destination points as in the figure below.

Assume that we have a transportation map that includes three origin points,  

Assume that we have a transportation map that includes three origin points, two transshipment points, and three destination points as in the figure below. You can also find the capacity and demand values of each point on the figure. These values represent product amounts in units of kg. 500 450 650 Adana Diyarbakr O O O Gaziantep 400 from- Adana Adana Diyarbakr Diyarbakr Gaziantep Gaziantep Ankara Ankara Ankara Konya Konya Konya Ankara Konya to Ankara Konya Ankara Konya Ankara As a special case, Ankara is a transshipment point but also has its own demand (400 kg). You can find transportation costs between each node in the table below. Konya Bursa Istanbul Izmir Bursa istanbul Izmir Cost ($ per kg) 5 4 8 4 7 6 5 9 7 8 Bursa 10 7 300 Istanbul 500 temir 400 Please, develop a mathematical model which aims to minimize the total cost of the transshipment problem. Then, solve the model by using MS Excel Solver. Enter all related data about the problem into a new Excel sheet clearly as possible. Write the required Excel formulas to the related cells. Use Solver to solve your optimization problem. In the solution, optimal values of all decision variables, objective function, and left-hand side of constraints must be visible. o Interpret your solution,

Step by Step Solution

3.42 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To develop a mathematical model for the transshipment problem and solve it using MS Excel Solver we need to define decision variables objective functi... View full answer

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 Mathematics Questions!