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




Introduction to Management Science
Introduction to Management Science (10th Edition)
ISBN: 0136064361
EAN: 2147483647
Year: 2006
Pages: 358

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net