Question

Develop an Excel model for the following LP transportation problem. Solve the problem using Solver and match the correct answer to the questions. Warehouse City E City F City G City H Warehouse Supply A 0.53 0.21 0.52 0.41 4500 B 0.31 0.37 0.41 0.28 5000 C 0.56 0.32 0.56 0.33 4000 D 0.41 0.54 0.34 0.52 5500 City Demand 4,400 3,500 5,500 5,600 Match the correct answer to the following questions: 1. What is the value of the objective function

Answer 1

The objective function is:

Minimization (Z) = 0.53Xae + 0.21Xaf + 0.52Xag + 0.41Xah + 0.31Xbe + 0.37Xbf + 0.41Xbg + 0.28Xbh + 0.56Xce + 0.32Xcf + 0.56Xcg + 0.33Xch + 0.41Xde + 0.54Xdf + 0.34Xdg + 0.52Xdh

Step-by-step explanation:

Solution:

We are asked to find the value of the objective function in this data given.

So,

Let Xae be the number of units shipping from warehouse A to city E.

Similarly, we have Xaf, Xag, Xah

Let Xbe be the number of units shipping from warehouse B to city E .

Similarly, we have Xbf, Xbg, Xbh

Let Xce be the number of units shipping from warehouse C to city E .

Similarly, we have Xcf, Xcg, Xch

Let Xde be the number of units shipping from warehouse D to city E .

Similarly, we have Xdf, Xdg, Xdh

Furthermore,

0.53 is the shipping cost of 1 unit from warehouse A to City E.

So, the shipping cost of Xae units from warehouse A to City E is 0.53Xae.

Similarly, we have other corresponding costs.

Hence,

The objective function is:

Minimization (Z) = 0.53Xae + 0.21Xaf + 0.52Xag + 0.41Xah + 0.31Xbe + 0.37Xbf + 0.41Xbg + 0.28Xbh + 0.56Xce + 0.32Xcf + 0.56Xcg + 0.33Xch + 0.41Xde + 0.54Xdf + 0.34Xdg + 0.52Xdh