استخدام الإكسل في حل مشكلة النقل ذات الطلبات العشوائية

Abstract EN

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.