Introduction to Management Science (10th Edition)

This example will demonstrate the procedure for solving a transportation problem.

Problem Statement

A concrete company transports concrete from three plants to three construction sites. The supply capacities of the three plants, the demand requirements at the three sites, and the transportation costs per ton are as follows :

Determine the linear programming model formulation for this problem and solve it by using Excel.

Solution