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

Author(s):  
Ambarish M. Acharya ◽  
Daniela S. Gonzales ◽  
Sandra D. Eksioglu ◽  
Sumesh Arora

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.

2018 ◽  
Vol 7 (2.28) ◽  
pp. 157
Author(s):  
Desmond D.K. Attadjei ◽  
Yash Madhwal ◽  
Dr Peter B. Panfilov

A powerful and effective store network administration sires, a smooth running of a business, quality items or potential benefits, consequently escalating client trust and business picks up. To land at this phase in an association's business outgrowth, all rely upon the best choices that must be taken to move the correct way. These choices are normally aftereffects of past events and outside information that have been incorporated to give data or learning. For this reason, a decision support system is hereby proposed to be able to pool data from the 3 main decision phases of a Supply Chain Management, namely: (1) supply chain design (Strategy) phase, (2) decision in supply chain management (Planning) phase, and (3) operational level (Operation) phase. This proposed framework is pointed and boosting basic leadership process, by giving brought together data to help the hierarchical basic leadership process. 


2017 ◽  
Vol 56 (4) ◽  
pp. 1458-1485 ◽  
Author(s):  
Gabriella Dellino ◽  
Teresa Laudadio ◽  
Renato Mari ◽  
Nicola Mastronardi ◽  
Carlo Meloni

2019 ◽  
Vol 18 ◽  
pp. 19-32 ◽  
Author(s):  
Bhaskar B. Gardas ◽  
Rakesh D. Raut ◽  
Naoufel Cheikhrouhou ◽  
Balkrishna E. Narkhede

Author(s):  
R. A. Malairajan ◽  
K. Ganesh ◽  
M. Punnniyamoorthy ◽  
S. P. Anbuudayasankar

In today’s highly competitive and demanding environment, the pressure on both public and private organizations is to achieve a better way to deliver values to end customers. There has been a growing recognition that the two goals, cost reduction and customer service are achieved through Logistics and Supply Chain Management (SCM). Transportation of goods continues an important part of in-bound as well as outbound logistics of Supply Chain Management (SCM). Efficient distribution of goods and services is of great importance in today’s competitive market, because transportation constitutes a considerable portion of the purchase price of most products or services. Vehicle routing is considered as an important resource in a distribution logistics management system. Effective plan and control of vehicle operation can significantly reduce the cost of physical distribution system. To overcome the challenges of changing environment, the scheme of vehicle control of a physical distribution system should be dynamic. Thus India has become the top milk producing country in the world. This study addresses the vehicle routing aspect of distribution logistics in Sangam dairy supply chain of Guntur district in Andhra Pradesh. The problem is viewed as Vehicle Routing Problem with Backhauls (VRPB) and a mathematical model is developed with the consideration of various practical constraints. Moreover, a decision support system is developed for dynamic VRPB, which would help the manager in making operational and tactical decisions.


Sign in / Sign up

Export Citation Format

Share Document