DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT DISTRIBUTIONS
Product distribution is a complex process as it involves meeting requirements from several stake holders including the distributors and customers. The primary objective of product distribution process is meeting the customers’ demand as well as minimizing the cost incurred by the distributor. For...
Saved in:
Main Authors: | , , |
---|---|
Format: | Conference or Workshop Item |
Published: |
2009
|
Subjects: | |
Online Access: | http://eprints.utp.edu.my/1805/1/493-498.pdf http://eprints.utp.edu.my/1805/ |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.utp.eprints.1805 |
---|---|
record_format |
eprints |
spelling |
my.utp.eprints.18052017-01-19T08:25:14Z DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT DISTRIBUTIONS Mokhtar, Ainul Akmar Muhammad, Masdi A Majid, M Amin T Technology (General) Product distribution is a complex process as it involves meeting requirements from several stake holders including the distributors and customers. The primary objective of product distribution process is meeting the customers’ demand as well as minimizing the cost incurred by the distributor. For distributor that supports large number of customers, the available commercial softwares for optimizing and scheduling of product distribution are typically being used. However, these systems are complex, costly and require long processing time on a dedicated computer system. Thus, these commercial softwares are not practical for distributors that support small number of customers and as such the optimization and scheduling activities are usually done manually based on rule-of-thumb. This process is time consuming and the results may not be optimal. This paper presents a decision support system employing a two-step sequential approach for product deliveries. First is to determine the optimum carrier required to meet customers demand utilizing linear programming with the objective function to minimize the total distribution cost. Premium Solver Platform (PSP) is utilized to model the optimization problem. Second is to use multi-criteria decision making approach applying various physical and logistic rules to generate the carrier assignment and scheduling. Both approaches are developed using spreadsheet due to its ease of implementation and lowest cost of ownership. The outcome indicates that this decision support system gives a better result compared to the manual assignment of carrier while minimizing the distribution cost. Furthermore, the system requires only a few minutes to generate the results and thus can be applied to practical usage. It is also shown that the system could be used as a viable planning tool for strategic decision concerning investment on the number of carrier required to meet future demand. 2009-09 Conference or Workshop Item PeerReviewed application/pdf http://eprints.utp.edu.my/1805/1/493-498.pdf Mokhtar, Ainul Akmar and Muhammad, Masdi and A Majid, M Amin (2009) DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT DISTRIBUTIONS. In: Proceedings of the 4th World Congress on Engineering Asset Management, 28-30 September, Athens, Greece. http://eprints.utp.edu.my/1805/ |
institution |
Universiti Teknologi Petronas |
building |
UTP Resource Centre |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Teknologi Petronas |
content_source |
UTP Institutional Repository |
url_provider |
http://eprints.utp.edu.my/ |
topic |
T Technology (General) |
spellingShingle |
T Technology (General) Mokhtar, Ainul Akmar Muhammad, Masdi A Majid, M Amin DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT DISTRIBUTIONS |
description |
Product distribution is a complex process as it involves meeting requirements from several stake holders including
the distributors and customers. The primary objective of product distribution process is meeting the customers’
demand as well as minimizing the cost incurred by the distributor. For distributor that supports large number of
customers, the available commercial softwares for optimizing and scheduling of product distribution are typically
being used. However, these systems are complex, costly and require long processing time on a dedicated computer
system. Thus, these commercial softwares are not practical for distributors that support small number of customers
and as such the optimization and scheduling activities are usually done manually based on rule-of-thumb. This
process is time consuming and the results may not be optimal. This paper presents a decision support system
employing a two-step sequential approach for product deliveries. First is to determine the optimum carrier required
to meet customers demand utilizing linear programming with the objective function to minimize the total distribution
cost. Premium Solver Platform (PSP) is utilized to model the optimization problem. Second is to use multi-criteria
decision making approach applying various physical and logistic rules to generate the carrier assignment and
scheduling. Both approaches are developed using spreadsheet due to its ease of implementation and lowest cost of
ownership. The outcome indicates that this decision support system gives a better result compared to the manual
assignment of carrier while minimizing the distribution cost. Furthermore, the system requires only a few minutes to
generate the results and thus can be applied to practical usage. It is also shown that the system could be used as a
viable planning tool for strategic decision concerning investment on the number of carrier required to meet future
demand. |
format |
Conference or Workshop Item |
author |
Mokhtar, Ainul Akmar Muhammad, Masdi A Majid, M Amin |
author_facet |
Mokhtar, Ainul Akmar Muhammad, Masdi A Majid, M Amin |
author_sort |
Mokhtar, Ainul Akmar |
title |
DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT
DISTRIBUTIONS |
title_short |
DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT
DISTRIBUTIONS |
title_full |
DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT
DISTRIBUTIONS |
title_fullStr |
DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT
DISTRIBUTIONS |
title_full_unstemmed |
DEVELOPMENT OF SPREADSHEET BASED DECISION SUPPORT SYSTEM FOR PRODUCT
DISTRIBUTIONS |
title_sort |
development of spreadsheet based decision support system for product
distributions |
publishDate |
2009 |
url |
http://eprints.utp.edu.my/1805/1/493-498.pdf http://eprints.utp.edu.my/1805/ |
_version_ |
1738655154432901120 |
score |
13.160551 |