Predicting Exports Using Time Series and Regression Trend Lines: Brazil and Germany Competition in Green and Roasted Coffee Industry | SpringerLink
Skip to main content

Predicting Exports Using Time Series and Regression Trend Lines: Brazil and Germany Competition in Green and Roasted Coffee Industry

  • Conference paper
  • First Online:
Advances in Production Management Systems. Artificial Intelligence for Sustainable and Resilient Production Systems (APMS 2021)

Abstract

Trade is essential for countries development. In Brazil, coffee has been one of the most important export items and by large is commercialized as a green or roasted bean. The aim of this article is to establish a prediction mode for coffee exports using time series and trend lines. To do so, we collected the exportation volume from the two main export countries in each segment: Brazil and Germany. A five-year forecasting was produced using regression curves provided by Microsoft Excel. Our results indicated that polynomial fits best and this function is consistent with agricultural production that is conditioned to edaphoclimatic factors.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Subscribe and save

Springer+ Basic
¥17,985 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
JPY 3498
Price includes VAT (Japan)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
JPY 17159
Price includes VAT (Japan)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
JPY 21449
Price includes VAT (Japan)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
JPY 21449
Price includes VAT (Japan)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. Ortigoza, S.A.G.: Paisagens do Consumo: São Paulo, Lisboa, Dubai e Seul. Editora UNESP, São Paulo (2010)

    Book  Google Scholar 

  2. Secretaria Municipal de Educação e Esporte de Goiânia. https://sme.goiania.go.gov.br/conexaoescola/ensino_fundamental/historia-do-comercio-escambo/

  3. World Trade Organization: WTO Data. https://data.wto.org/

  4. Maranhão, R.L.A., Vieira Filho, J.E.R.: Inserção Internacional do Agronegócio Brasileiro. IPEA, Brasília (2017)

    Google Scholar 

  5. Food and Agriculture Organization of the United Nations. http://www.fao.org/home/en/

  6. International Coffee Organization. http://www.ico.org/

  7. Food and Agriculture Organization of the United Nations (2021). http://www.fao.org/faostat/en/#data/TP

  8. Lee, Y., Bateman, A.: The competitiveness of fair trade and organic versus conventional coffee based on consumer panel data. Ecol. Econo. 184, 106986 (2021)

    Article  Google Scholar 

  9. Naegele, H.: Where does the Fair Trade money go? How much consumers pay extra for Fair Trade coffee and how this value is split along the value chain. World Dev. 133, 105006 (2020)

    Article  Google Scholar 

  10. Vogt, M.A.B.: Developing stronger association between market value of coffee and functional biodiversity. J. Environ. Manag. 269, 110777 (2020)

    Article  Google Scholar 

  11. Conceição, J.C.P.d., Ellery Junior, R.G.d., Conceição, P.H.Z.: Cadeia agroindustrial do café no brasil: Agregação de valor e exportação. Boletim de Economia e Política Internacional (24), 37–47 (2019)

    Google Scholar 

  12. Mc Fredries, P.: Fórmulas e Funçães no Microsoft Excel. Ciência Moderna, Rio de Janeiro (2005)

    Google Scholar 

  13. Abraham, E.R., et al.: Time series prediction with artificial neural networks: an analysis using Brazilian soybean production. Agriculture 10(10), 475 (2020)

    Article  Google Scholar 

  14. Escolano, N.R., Espin, J.J.L.: Econometría: Series temporales y modelos de ecuaciones simultáneas. Editorial UMH, Alicante (2016)

    Google Scholar 

  15. Pecar, B., Davis, G.: Time series based predictive analytics modelling: using MS excel, Gloucestershire (2016)

    Google Scholar 

  16. Angeloni, G., et al.: What kind of coffee do you drink? An investigation on effects of eight different extraction methods. Food Res. Int. 116, 1327–1335 (2019)

    Article  Google Scholar 

  17. Conselho dos Exportadores de Café do Brasil. https://www.cecafe.com.br/publicacoes/

  18. Mendonça, V.U.V.M.: Caracterização da Atividade de Exportação de Commodities Agrícolas no Brasil, São Paulo (2015)

    Google Scholar 

  19. Kleemann, J., et al.: Quantifying interregional flows of multiple ecosystem services - a case study for Germany. Glob. Environ. Change 61, 102051 (2020)

    Article  Google Scholar 

  20. Badmos, S., Fu, M., Granato, D., Kuhnert, N.: Classification of Brazilian roasted coffees from different geographical origins and farming practices based on chlorogenic acid profiles. Food Res. Int. 134, 109218 (2020)

    Article  Google Scholar 

  21. Läderach, P., et al.: Systematic agronomic farm management for improved coffee quality. Field Crop Res 120(3), 321–329 (2011)

    Article  Google Scholar 

  22. World Intellectual Property Organization: World intellectual property report 2017: intangible capital in global value chains. World Intellectual Property Organization, Geneva (2017)

    Google Scholar 

  23. Hindsley, P., McEvoy, D.M., Morgan, O.A.: Consumer demand for ethical products and the role of cultural worldviews: the case of direct-trade coffee. Ecol. Econ. 177, 106776 (2020)

    Article  Google Scholar 

Download references

Acknowledgments

This study was financed in part by the Coordenação de Aperfeioamento de Pessoal de Nível Superior Brasil (CAPES). Finance Code 001.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Paula Ferreira da Cruz Correia .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2021 IFIP International Federation for Information Processing

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

da Cruz Correia, P.F., dos Reis, J.G.M., Abraham, E.R., da Costa, J.S. (2021). Predicting Exports Using Time Series and Regression Trend Lines: Brazil and Germany Competition in Green and Roasted Coffee Industry. In: Dolgui, A., Bernard, A., Lemoine, D., von Cieminski, G., Romero, D. (eds) Advances in Production Management Systems. Artificial Intelligence for Sustainable and Resilient Production Systems. APMS 2021. IFIP Advances in Information and Communication Technology, vol 631. Springer, Cham. https://doi.org/10.1007/978-3-030-85902-2_67

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-85902-2_67

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-85901-5

  • Online ISBN: 978-3-030-85902-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics