An Excel-Based Decision Support System for Supply Chain Design and Management of Biofuels

Ambarish M. Acharya, Daniela S. Gonzales, Sandra D. Eksioglu and Sumesh Arora
Additional contact information
Ambarish M. Acharya: Mississippi State University, Starkville, MS, USA
Daniela S. Gonzales: Department of Industrial and Systems Engineering, Mississippi State University, Starkville, MS, USA
Sandra D. Eksioglu: Department of Industrial and Systems Engineering, Mississippi State University, Starkville, MS, USA
Sumesh Arora: Mississippi Technology Alliances, Ridgeland, MS, USA

International Journal of Operations Research and Information Systems (IJORIS), 2014, vol. 5, issue 4, 26-43

Abstract: This article presents a Decision Support System (DSS) to aid managers with supply chain (SC) design and logistics management of biomass-for-biofuel production. These tools play a very important role in efficiently managing biomass-for-biofuel SCs and have the potential to reduce the cost of biofuels. The proposed model coordinates the long-term decisions of designing a SC with the medium term decisions of logistics management. This system has the ability to (a) identify locations and capacities for biorefineries, given the availability of biomass and costs; (b) estimate the minimum cost of delivering biofuels, which include transportation, investment, and processing costs; and (c) perform sensitivity analyses with respect to a number of parameters. Visual Basic for Applications (VBA) is used to create the interface of the DSS, and Excel's CPLEX Add-In is used to solve the mathematical models.

Date: 2014
References: Add references at CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 18/ijoris.2014100102 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:joris0:v:5:y:2014:i:4:p:26-43

Access Statistics for this article

International Journal of Operations Research and Information Systems (IJORIS) is currently edited by John Wang

More articles in International Journal of Operations Research and Information Systems (IJORIS) from IGI Global
Bibliographic data for series maintained by Journal Editor ().