Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network

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 dea...

Full description

Saved in:
Bibliographic Details
Main Author: CHEONG, Michelle Lee Fong
Format: text
Language:English
Published: Institutional Knowledge at Singapore Management University 2014
Subjects:
Online Access:https://ink.library.smu.edu.sg/sis_research/2117
https://ink.library.smu.edu.sg/context/sis_research/article/3116/viewcontent/auto_convert.pdf
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Singapore Management University
Language: English
id sg-smu-ink.sis_research-3116
record_format dspace
spelling sg-smu-ink.sis_research-31162015-12-05T08:06:51Z Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network CHEONG, Michelle Lee Fong 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. 2014-01-01T08:00:00Z text application/pdf https://ink.library.smu.edu.sg/sis_research/2117 https://ink.library.smu.edu.sg/context/sis_research/article/3116/viewcontent/auto_convert.pdf http://creativecommons.org/licenses/by-nc-nd/4.0/ Research Collection School Of Computing and Information Systems eng Institutional Knowledge at Singapore Management University Supply network heuristic algorithm spreadsheets strategic DSS Artificial Intelligence and Robotics Business Operations Research, Systems Engineering and Industrial Engineering
institution Singapore Management University
building SMU Libraries
continent Asia
country Singapore
Singapore
content_provider SMU Libraries
collection InK@SMU
language English
topic Supply network
heuristic algorithm
spreadsheets
strategic DSS
Artificial Intelligence and Robotics
Business
Operations Research, Systems Engineering and Industrial Engineering
spellingShingle Supply network
heuristic algorithm
spreadsheets
strategic DSS
Artificial Intelligence and Robotics
Business
Operations Research, Systems Engineering and Industrial Engineering
CHEONG, Michelle Lee Fong
Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network
description 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.
format text
author CHEONG, Michelle Lee Fong
author_facet CHEONG, Michelle Lee Fong
author_sort CHEONG, Michelle Lee Fong
title Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network
title_short Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network
title_full Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network
title_fullStr Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network
title_full_unstemmed Strategic Decision Support System using Heuristic Algorithm for Practical Outlet Zones Allocation to Dealers in a Beer Supply Distribution Network
title_sort strategic decision support system using heuristic algorithm for practical outlet zones allocation to dealers in a beer supply distribution network
publisher Institutional Knowledge at Singapore Management University
publishDate 2014
url https://ink.library.smu.edu.sg/sis_research/2117
https://ink.library.smu.edu.sg/context/sis_research/article/3116/viewcontent/auto_convert.pdf
_version_ 1770571800609030144