Inter-American Development Bank
facebook
twitter
youtube
linkedin
instagram
Abierto al públicoBeyond BordersCaribbean Development TrendsCiudades SosteniblesEnergía para el FuturoEnfoque EducaciónFactor TrabajoGente SaludableGestión fiscalGobernarteIdeas MatterIdeas que CuentanIdeaçãoImpactoIndustrias CreativasLa Maleta AbiertaMoviliblogMás Allá de las FronterasNegocios SosteniblesPrimeros PasosPuntos sobre la iSeguridad CiudadanaSostenibilidadVolvamos a la fuente¿Y si hablamos de igualdad?Home
Citizen Security and Justice Creative Industries Development Effectiveness Early Childhood Development Education Energy Envirnment. Climate Change and Safeguards Fiscal policy and management Gender and Diversity Health Labor and pensions Open Knowledge Public management Science, Technology and Innovation  Trade and Regional Integration Urban Development and Housing Water and Sanitation
  • Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer

Moviliblog

Blog del BID sobre Transporte

  • HOME
  • CATEGORIES
  • authors
  • English
bidding data analysis

Smart BIDding: unlocking the potential of Data Analysis

April 29, 2020 by Alejandra Caldo - Lauramaría Pedraza - Juan Miguel Villamil Santamaría - Felipe Bedoya Maya - Paola Rodríguez Leave a Comment


More than a dozen countries in Latin America and the Caribbean (LAC) have paralyzed public works to tackle the spread of the COVID-19, while others have continued with the works, complying, with the necessary sanitary protocols, such as social distancing and rotation of employees shifts, to mitigate the risks of contagion and virus spread, as announced by the governments. The Transport experts at the Interamerican Development Bank recognize the importance of the road infrastructure in the logistic activities for the continuous and efficient transportation of priority cargo such as health and food supplies, for the urban and interurban population. Therefore, ensuring the maintenance of the infrastructure stock is important in the current COVID-19[1] pandemic scenario. In that sense the transport experts have been working the last weeks in actions to tackle the expected economic impacts in the construction sector due to the current crisis. Specially to print revitalization of resources and operations to ongoing infrastructure projects, taking advantage of their immediate availability to act as reactivators of the economy, with an emphasis on countries where the construction industry constitutes a relevant economic sector, and in regions with low economic development, such is the case of LAC.

Some of the expected consequences of the pandemic in the development of infrastructure includes:

  1. the generalized economic recession scenarios affecting the development of the infrastructure, some estimates establish a contraction of the GDP in 5.3%  of LAC due to the COVID-19 according to CEPAL, aggravating pre-existing unfavorable economic conditions;
  2. due to the suspension of projects the dynamism in the development of infrastructure will be affected;
  3. increase in the unemployment rate due to the deacceleration in the infrastructure development;
  4. increase in project prices;
  5. bankruptcy of some construction companies and renegotiation of contracts in execution
  6. as a result of the previously mentioned the legal actions will be rise as result of over costs and delays in works.

As a result, the bank transporte experts have been working in actions to reactivate the infrastructure sector to tackle this consequences, amongst these measures it can be found: (a) revitalization of resources and operations to ongoing infrastructure projects; (b) institutional strengthening mechanisms; (c)  develop infrastructure maintenance programs in the event of a decrease in new investments in the sector; (d) promotion of programs aimed at stimulating and support employment; (e) develop contingency plans and risk identification and mitigation mechanisms; (f) identification of priority logistics corridors through an adequate planning; and (g) mechanisms of conciliation in case of claims. In this sense different DRP (Diálogos Regionales de Política) have been carried out by the Transport Division to discuss with representatives of some of the most important infrastructure chambers of LAC (Infraestructura en tiempos de COVID-19: manos a la obra) and with ministers of public works and transport from different countries (Retos para reactivar la construcción de infraestructura pública) on how to reactivate the construction of infrastructure works during the pandemic and the conditions required for the resumption of works to be carried out safely and efficiently while coexisting with COVID-19. In addition, these dialogues seek to identify the profile of the projects with the greatest potential for economic reactivation to be implemented in “The Day After” and to support the economic reactivation of the region.

Since the beginning of the crisis, technologies such as Artificial Intelligence (AI) and Big Data have been key to support the three types of actions to face the crisis caused by the virus:

  1.  increase early detection mechanisms;
  2. minimize the risk of contagion and consequent spread of the virus; and
  3. take measures to mitigate the health crisis, especially because we live in a data-driven world where 2.5 quintillion bytes of data is produced every day. These huge quantities of information provide the basis for an unprecedent richness of knowledge if structured and processed. In this line, the transport experts of the Bank foresee the potential to gather, process and analyze data from multiple road biddings in different countries of the region to make decision based on real data, especially in time of crisis, where fast decision has to be made to avoid over cost and delays in the construction sector. One of the products of this initiative is a statistical model to explain the incidence of the unit prices of the inputs that have greater representativeness in the total budget of a civil works in a specific country of LAC.

The data used for the statistical analysis, originally consisted of a sample of approximately 150 tenders for the construction of highways launched in that country between February 2010 and November 2018, both with Bank financing and with other sources of financing, from which the information on 73 works awarded in 40 tenders were finally selected, to create a database with 578 proposals received, an average of 8 bids per awarded work with an average cost of US$8,182,262, a median of US$4,826,014 and a significative standard deviation of  $14,100,000 with an important number of outliers in the sample.

Subsequently, a selection of some construction items was carried out, removing those whose unit price was disproportionate or had measurement anomalies, as a result the exercise was carried out based on 11 inputs, for the analysis a linear regression with fixed effects by groups of tenders was estimated to predict the incidence of the unit prices of the inputs that have greater weight in the variation of the total value of the work. Considering the existence of offers with an atypical final value, it was decided to specify the model both in levels and in logarithm, which allows to have an analysis in monetary values and in percentual variation.

The result in the analysis had two main outcomes:

With the price of the 11 selected inputs, it is possible to predict between 60% and 94% of the variation in the final value (based on the R-square measure) of the 73 works analyzed in the highway tenders; and among the 11 inputs considered, there were four inputs whose price variations best predict, individually, the variations in the final value of the offers in the 73 tenders. These inputs are the Embankment, the Asphalt Concrete Binder, the Asphalt Base, and the Asphalt Primer. In this sense, a variation in the unit price of these inputs explains a relevant variation in the total value of the tender.

Table 1: Descriptive statistics of the inputs in the analysis

Regarding the monetary evaluation, for the Embankment a variation of 1% in its price translates into a variation in the same sense of 0.389% in the final value of the offer.

If we consider the average offer, a variation of US$3.01 in the price of the Embankment (standard deviation of this input) translates into an average change of US$1,408,874.78 in the final value of the offer. In the same analysis, a price difference of 1% of the Asphalt Concrete Binder, the Asphalt Base, and the Asphalt Primer, translates into a variation in the price of 0.23%, 0.39%, and 0.51%, respectively, in the final value of the offer.

Table 2: General results of the linear regression

 

Table 3: Equivalence of percentage variation in the price of the main inputs related to the average bidding offer

These exercise shows the importance of the availability and consolidation of big amounts of public data sets regarding bidding process, to carrying out these data analyses in different countries of the region, to validate the official budgets for new tenders and improve the planning of projects with the greatest potential for economic reactivation to be implemented in “The Day After”, to support the economic reactivation of the region. This can be achieved in the meantime by influence the Institutions to fully automate its tenders, analyses and comparison of proposals, as well as definition of the winner, along with the support of the Bank for future projects with the use of Big Data and Artificial Intelligence tools that allows a better monitor and control of the results of the tenders.

[1]   Emerged in Wuhan, China in late 2019, COVID-19 has spread rapidly globally (New respiratory disease, produced by the SARS-CoV-2 virus. It has now spread to 209 countries in the world, with more than 1.5 million infected and almost 95,000 deaths [Worldometer, 2020]).

Filed Under: covid-19

Alejandra Caldo

Alejandra Caldo es Especialista de Transporte del Banco Interamericano de Desarrollo (BID) desde junio de 2018. Anteriormente trabajó 6 años como consultora de la División de Transporte del BID y 10 años en el Gobierno de la Provincia de Córdoba, Argentina, en unidades ejecutoras de programas financiados por el BID y el Banco Mundial. Alejandra es Contadora Pública egresada de la Universidad Nacional de Córdoba y posee una Maestría en Dirección de Negocios de la misma Universidad y un Micromaster en Logística del Massachusetts Institute of Technology.

Lauramaría Pedraza

A Lauramaría é o ponto focal para a inclusão, diversidade e equidade no Transporte para a Divisão de Transportes do BID. Lauramaría trabalha na concepção de programas multisetoriais, diálogo com governos, pesquisa e geração de conhecimento nesta área. Ela também fornece apoio técnico para a estratégia de mobilidade urbana e projetos da carteira da Divisão com foco em transporte e dinâmica de uso do solo. Anteriormente, Lauramaría trabalhou como Planejadora de Transportes para a Cidade de Austin, TX, no desenvolvimento de planos diretores de mobilidade e como pesquisadora da Universidade dos Andes em transporte público, planejamento do uso do solo e design urbano. Lauramaría é arquiteta pela Universidad de los Andes e tem mestrado em planejamento urbano pela Universidade do Texas, Austin.

Juan Miguel Villamil Santamaría

Ingeniero Civil de la Universidad Javeriana de Bogotá, MSc en Regional and Urban Planning Studies del London School of Economics and Political Science. Gerente Técnico de Empresas Constructoras por 25 años. Ha participado en la estructuración y ejecución de proyectos de construcciòn en Bogotá, Medellín y Barranquilla y en la reconstrucción física post-terremoto del eje cafetero en Colombia con el programa de USAID y del FOREC. Consultor de la Divisiòn de Transporte del BID en el área de diseño y monitoreo de proyectos viales.

Felipe Bedoya Maya

Felipe Bedoya Maya se desempeña como asistente de investigación en la División de Transporte del Banco Interamericano de Desarrollo. Su trabajo se enfoca en la evaluación de impacto de intervenciones en la movilidad, la congestión de tráfico y la logística urbana en los países de América Latina y el Caribe. Tiene maestría y pregrado en economía de la Universidad EAFIT de Medellín.

Paola Rodríguez

Paola es consultora de la Division de Transporte del BID desde marzo de 2018. En la División ha apoyado en la estructuración de programas de inversión, hace parte del grupo de tecnología, y ha realizado actividades de investigación y de diseminación de conocimiento en torno a la infraestructura y servicios transporte. Paola es Ingeniera Civil de la Pontificia Universidad Javeriana de Bogotá (Colombia) y tiene una Maestría en Transporte y Planeación con énfasis en uso de vehículos autónomos de la Universidad Técnica de Delft (Países Bajos). Antes de unirse al equipo de trabajo en el BID, Paola trabajó para TransMilenio S. A. y Antea Group en Colombia y fue pasante en Antea Group Nederland en Países Bajos.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

FOLLOW US

Subscribe

Search

About the blog

Desde BID Transporte mejoramos vidas en América Latina y el Caribe promoviendo una movilidad más eficiente, accesible y segura.

Descubre nuestro espacio de intercambio de ideas y conocimiento y forma parte de él. Desde Moviliblog, queremos compartir lo último en movilidad y transporte en América Latina y el Caribe e invitarlos a conocer nuestras áreas temáticas: ITS, seguridad vial, grandes proyectos, logística y transporte urbano, así como nuestras temáticas transversales de evaluación de impacto, género y transporte sostenible.

Recent Posts

  • Investing more and better to achieve a Sustainable and inclusive infrastructure
  • Ensuring Food Security through Better Transport and Logistics
  • How can South Korea and Belize work together for better public transport? 
  • This is how the Trinidad and Tobago kids solve congestion problems using the Metaverse
  • Sector Framework: The IDB Transportation Roadmap

Archives

Footer

Banco Interamericano de Desarrollo
facebook
twitter
youtube
youtube
youtube

Blog posts written by Bank employees:

Copyright © Inter-American Development Bank ("IDB"). This work is licensed under a Creative Commons IGO 3.0 Attribution-NonCommercial-NoDerivatives. (CC-IGO 3.0 BY-NC-ND) license and may be reproduced with attribution to the IDB and for any non-commercial purpose. No derivative work is allowed. Any dispute related to the use of the works of the IDB that cannot be settled amicably shall be submitted to arbitration pursuant to the UNCITRAL rules. The use of the IDB's name for any purpose other than for attribution, and the use of IDB's logo shall be subject to a separate written license agreement between the IDB and the user and is not authorized as part of this CC- IGO license. Note that link provided above includes additional terms and conditions of the license.


For blogs written by external parties:

For questions concerning copyright for authors that are not IADB employees please complete the contact form for this blog.

The opinions expressed in this blog are those of the authors and do not necessarily reflect the views of the IDB, its Board of Directors, or the countries they represent.

Attribution: in addition to giving attribution to the respective author and copyright owner, as appropriate, we would appreciate if you could include a link that remits back the IDB Blogs website.



Privacy Policy

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in

Banco Interamericano de Desarrollo

Aviso Legal

Las opiniones expresadas en estos blogs son las de los autores y no necesariamente reflejan las opiniones del Banco Interamericano de Desarrollo, sus directivas, la Asamblea de Gobernadores o sus países miembros.

facebook
twitter
youtube
This site uses cookies to optimize functionality and give you the best possible experience. If you continue to navigate this website beyond this page, cookies will be placed on your browser.
To learn more about cookies, click here
x
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT