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

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.

[1]  Bruce A. Babcock,et al.  The impact of US biofuel policies on agricultural price levels and volatility , 2012 .

[2]  Sandra Duni Eksioglu,et al.  Analyzing the design and management of biomass-to-biorefinery supply chain , 2009, Comput. Ind. Eng..

[3]  Amit Kumar,et al.  Development and implementation of integrated biomass supply analysis and logistics model (IBSAL) , 2006 .

[4]  Bryce J. Stokes,et al.  Biomass as Feedstock for A Bioenergy and Bioproducts Industry: The Technical Feasibility of a Billion-Ton Annual Supply , 2005 .

[5]  Andrew J. McAloon,et al.  Feasibility study for co-locating and integrating ethanol production plants from corn starch and lignocellulosic feedstocks , 2005 .

[6]  Mohammad Mahdian,et al.  Improved Approximation Algorithms for Metric Facility Location Problems , 2002, APPROX.

[7]  Sudipto Guha,et al.  A constant-factor approximation algorithm for the k-median problem (extended abstract) , 1999, STOC '99.

[8]  Christer Carlsson,et al.  Past, present, and future of decision support technology , 2002, Decis. Support Syst..

[9]  Kelly N. Ibsen,et al.  Lignocellulosic Biomass to Ethanol Process Design and Economics Utilizing Co-Current Dilute Acid Prehydrolysis and Enzymatic Hydrolysis for Corn Stover , 2002 .

[10]  Amin Saberi,et al.  A new greedy approach for facility location problems , 2002, STOC '02.

[11]  Kamesh Munagala,et al.  Local search heuristic for k-median and facility location problems , 2001, STOC '01.

[12]  Vijay V. Vazirani,et al.  Approximation algorithms for metric facility location and k-Median problems using the primal-dual schema and Lagrangian relaxation , 2001, JACM.

[13]  Sudipto Guha,et al.  Improved combinatorial algorithms for the facility location and k-median problems , 1999, 40th Annual Symposium on Foundations of Computer Science (Cat. No.99CB37039).

[14]  David P. Williamson,et al.  Improved approximation algorithms for capacitated facility location problems , 1999, IPCO.

[15]  Sudipto Guha,et al.  A constant-factor approximation algorithm for the k-median problem (extended abstract) , 1999, STOC '99.

[16]  Daniel Nilsson,et al.  SHAM—a simulation model for designing straw fuel delivery systems. Part 1: model description , 1999 .

[17]  Sean B. Eom,et al.  A survey of decision support system applications (1988–1994) , 1998, J. Oper. Res. Soc..

[18]  Samir Khuller,et al.  Greedy strikes back: improved facility location algorithms , 1998, SODA '98.

[19]  R. M. Mol,et al.  Simulation and optimization of the logistics of biomass fuel collection , 1997 .

[20]  Éva Tardos,et al.  Approximation algorithms for facility location problems (extended abstract) , 1997, STOC '97.

[21]  Sean B. Eom,et al.  Decision support systems applications , 1997 .

[22]  Jeffrey Scott Vitter,et al.  Approximation Algorithms for Geometric Median Problems , 1992, Inf. Process. Lett..

[23]  Magid A. Dagher,et al.  Grain export elevators: An economies of size analysis , 1987 .

[24]  Dorit S. Hochbaum,et al.  Heuristics for the fixed cost median problem , 1982, Math. Program..

[25]  Steven L. Alter,et al.  Decision support systems : current practice and continuing challenges , 1980 .

[26]  Robert M. Nauss,et al.  An Improved Algorithm for the Capacitated Facility Location Problem , 1978 .

[27]  Donald Erlenkotter,et al.  A Dual-Based Procedure for Uncapacitated Facility Location , 1978, Oper. Res..

[28]  G. Ross,et al.  Modeling Facility Location Problems as Generalized Assignment Problems , 1977 .

[29]  Alfred A. Kuehn,et al.  A Heuristic Program for Locating Warehouses , 1963 .