Example Problem Solution

[Page 239 ( continued )]

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 :

	Construction Site
Plant	A	B	C	Supply (tons)
1	$ 8	$ 5	$ 6	120
2	15	10	12	80
3	3	9	10	80
Demand (tons)	150	70	100	280

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

Solution

Step  1.

The Linear Programming Model Formulation

---

[Page 240]

Step  2.

Excel Solution