A national catalog and the internet retailer has three warehouses and three major distribution centers located around the country. Normally, items are shipped directly from the warehouses to the distribution centers; however, each of the distribution centers can also be used as an intermediate transshipment point. The transportation cost $($dollars per unit$)$ between warehouses and distribution centers, the supply at the warehouses $(100$ units$),$ and the demand at the distribution centers $(100$ units$)$ for a specific week are shown in the following table.

The transportation cost $($dollar per unit$)$ between the distribution centers are:

Develop a network representation of this problem.

Formulate the problem as a Linear Programming model to determine the optimal shipments between warehouses and distribution centers to minimize total transportation cost. solve the question using linear programming. same question solved using excel solver state the decision variables and constarints for the solution