Using Excel to Solve the Transportation Problem with Random Demands

doi:10.33899/iqjoss.2011.028396

	Using Excel to Solve the Transportation Problem with Random Demands
IRAQI JOURNAL OF STATISTICAL SCIENCES
Article 17, Volume 11, Issue 1, 2011, Pages 309-330 PDF (0 K)
DOI: 10.33899/iqjoss.2011.028396
Abstract
The use of the Excel program is not only limited to the usual functions and to formulate and solve linear programming models, but beyond that it can be used in the applications of operations research, such as transport problems of the qualities of random in the needs dialing locations in some cases because they are not known for sure, especially when accompanied by imposition of additional constraints for the supplier to impose sanctions when processing more or less than needed. This paper reviews the architecture of the mathematical model of the problem of transport and indicate the method of random use Excel in a possible solution to the problem to reach the optimal solution quickly and accurately through the property Solver in this program, where the proposed method has been applied to several different examples in the numbers of offer sites and demand sites.

Statistics Article View: 436 PDF Download: 435