Conference Proceeding Article
We consider a two-echelon beer supply distribution network with the brewer replenishing the dealers and the dealers serving the outlet zones directly, for multiple product types. The allocation of the outlet zones to the dealers will determine the quantity of products the brewer replenishes each dealer, which will in turn impact the total warehousing and transportation costs. The non-linear optimization model formulated is difficult to solve to optimality, and the model itself does not include practical business considerations in the distribution business. A heuristics algorithm is designed and easily implemented using spreadsheets with Visual Basic programming to effectively and efficiently allocate the outlet zones to the dealers. The spreadsheets model serves as a strategic decision support system that allows the user to play with “What-if” scenarios by flexibly setting the decision to open or close a dealer and assigning outlet zones to several potential dealers. taking into account the practical business considerations. The algorithm will determine the best allocation of the outlet zones, among the potential dealers, to achieve minimum total network costs. With several “What-if” scenarios and their corresponding allocation results, the user can make the strategic decision to select the most suitable scenario.
Supply network, heuristic algorithm, spreadsheets, strategic DSS
Artificial Intelligence and Robotics | Business | Operations Research, Systems Engineering and Industrial Engineering
Intelligent Systems and Decision Analytics
Proceedings of the 2014 International Conference on Industrial Engineering and Operations Management, Bali, Indonesia, January 7-9, 2014
City or Country
CHEONG, Michelle Lee Fong.
Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network. (2014). Proceedings of the 2014 International Conference on Industrial Engineering and Operations Management, Bali, Indonesia, January 7-9, 2014. 1720-1731. Research Collection School Of Information Systems.
Available at: http://ink.library.smu.edu.sg/sis_research/2117
Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.