Master's Dissertation
DOI
10.11606/D.11.2008.tde-17072008-152340
Document
Author
Full name
Carlos Eduardo Osório Xavier
E-mail
Institute/School/College
Knowledge Area
Date of Defense
Published
Piracicaba, 2008
Supervisor
Committee
Caixeta Filho, Jose Vicente (President)
Gameiro, Augusto Hauber
Moraes, Márcia Azanha Ferraz Dias de
Title in Portuguese
Localização de tanques de armazenagem de álcool combustível no Brasil: aplicação de um modelo matemático de otimização
Keywords in Portuguese
Álcool como combustível
Logística - Estatística
Modelos matemáticos
Otimização matemática
Programação inteira e fluxos em rede
Tanque.
Abstract in Portuguese
Title in English
Ethanol storage tanks location in Brazil: a mixed integer program model application
Keywords in English
Ethanol
Logistics
MIP.
Optimal location
Stocks
Tanks
Abstract in English
The main purpose of this research is to develop a mathematical model intended for strategic analysis of the optimal location and considering suitable volumes for storage ethanol (anhydrous and hydrous) tanks. The Mixed Integer Program - MIP model was based on Brazilian ethanol distribution system. The model considered market parameters as supply, demand, and infrastructure parameters on transportation, storage values as well as their expenses. New construction ethanol tanks expenses also were considered. The months along the sugarcane crop year period of 2006/2007 were referred into the modeling formulation. This formulation allows a seasonal storage, production and demand patterns analysis. Transportation model is the main concern in the total logistics cost minimization from producers to consumers. The model stochastic formulation was elaborated by creating two simulated scenarios and developing a sensitivity analysis. The purpose of the first scenario was to check the model consistency and explore the current ethanol transport and storage infrastructure without considering the possibility of new tank installation. Based on these results, a sensitivity analysis regarding transportation expenses and storage restrictions was elaborated in order to make a comparison with current market practices. In the second scenario, it was considered the construction of new ethanol tanks and the identification of the most suitable places bearing in mind volume capacities. Based on these results, a sensitivity analysis regarding transportation expenses and storage restrictions was elaborated in order to check each location consistency. Results indicated that mills are mostly responsible for ethanol (anhydrous and hydrous) storages maintenance types and that the existing geographic organization of terminals and fuel distributors is inappropriate for ethanol distribution in Brazil. Transportation low flows among terminals and fuel distributors also indicated lack of a better infrastructure for ethanol distribution. The model indicated that main location results for installation of new tanks would be located especially in the countryside of the centersouth states, where allocation and distribution of ethanol from mills to the consumer market would be more competitive. In relation to the new hydrous ethanol tanks, the model indicated appropriated locations for the cities of: Cascavel - PR, Umuarama - PR, Maringá - PR, Lages - SC, Sinop - MT, Limeira - SP e Sorocaba - SP. In the other hand, for anhydrous ethanol, new investments suggested in: Londrina - PR, Cascavel - PR, Guarapuava - PR, Lajes - SC, Santa Maria - RS, Araçatuba - SP, Sinop - MT, Vilhena - RO, Montes Claros - MT, Dourados - MS, Gurupi - TO e Teresina - PI. Finally, the model indicated that the best locations for the establishment of new ethanol tanks would be located in fuel distributors' bases, once results confirmed that mills have enough storage capacity.