Location of a Logistics Facilities Using MS Excel Solver Multistart GRG and Evolutionary Methods

• Autorzy: Zaręba M.
• Języki publikacji: EN

Abstrakty

EN

The aim of this article is to determine the logistics facility localization by using generalized reduced gradient (GRG) nonlinear and evolutionary methods, both available in Solver Addin for MS Excel. The goal of supply chain configuration strategy is to minimize logistics expenses and to optimize customer service. The article presents three approaches for determining the optimal location of a logistics facility. The first method is to determine the optimal location of a short-haul routes logistics facility, without taking into account the curvature of the Earth, using the GRG nonlinear method. The second is an extension of the previous method and utilizes the built-in Multistart option, which allows to determine the optimal position of the logistics facility in the case of many local extremes in the goal function. The third approach applies the evolutionary method which allows to locate the logistics facility in the case where the goal function is in the non-smooth form. For each of the aforementioned approaches, the location of the logistics facility was determined. Based on the obtained results both GRG Multistart nonlinear and evolutionary methods correctly calculated the optimal location of the logistics facility for short-haul routes.

Słowa kluczowe

EN

generalized reduced gradient (GRG); multistart nonlinear method; evolutionary method; optimal location of logistics facility

• Wydawca: Oficyna Wydawnicza Politechniki Warszawskiej
• Czasopismo: Machine Dynamics Research
• Rocznik: 2018
• Tom: Vol. 42, No. 4
• Strony: 73--91
• Opis fizyczny: Bibliogr. 9 poz., rys., tab., wykr.

Twórcy

autor

Zaręba M.

• Polish Air Force University

Bibliografia

• 1. Bendkowski J. (2002): Logistyka stosowana, Wydawnictwo Politechniki Śląskiej.
• 2. Coyle J., Bardi E., Langley Jr. J. (2002): Zarządzanie logistyczne, Polskie Wydawnictwo Ekonomiczne.
• 3. Dyrda J. (1981). Geodezja wyższa. Trygonometria sferyczna, Wydawnictwo Wojskowej Akademii Technicznej.
• 4. Gołembska E. (2015): Eurologistyka, Wydawnictwo Naukowe PWN.
• 5. Gołembska E. (2013): Kompendium wiedzy o logistyce, Wydawnictwo Naukowe PWN.
• 6. Gołembska E. (2017): Logistyka międzynarodowa, Wydawnictwo Naukowe PWN.
• 7. Szymczak M. (2011): Decyzje logistyczne z Excelem. Difin.
• 8. Winston W. (2017): Microsoft Excel 2016. Analiza i modelowanie danych biznesowych, APN Promise.
• 9. Holland J. H. (1992): Adaptation in natural and artificial systems: an introductory analysis with applications to biology, control, and artificial intelligence, MIT Press.