PLAFIR: web application for rural financial planning

Authors

  • Luciano Lizzoni Universidade Estadual do Oeste do Paraná - Unioeste http://orcid.org/0000-0003-0657-0234
  • Aldi Feiden Universidade Estadual do Oeste do Paraná - Unioeste
  • Armin Feiden Universidade Estadual do Oeste do Paraná - Unioeste

DOI:

https://doi.org/10.5195/biblios.2018.451

Keywords:

Brazil, Budget, Decision making, Family farming, Information system, Rural diversification

Abstract

Objective. The rural diversification is a way for family farmers to prosper or even to perish. However, deciding a new rural activity can become hard work. The objective of this work is creating an Information System that helps the farmer in decision making, through financial indicators.

Method. A questionnaire was applied to 20 family farmers of Oeste Paranaense with a quantitative approach, and a bibliographical and documentary research was carried out to verify Information Systems available. Subsequently, a software project was developed using UML elements and the ASP.NET Core MVC 1.1 development framework with PostgreSQL 9.5 database. The IDE used for development was the Microsoft Visual Studio 2015 Community Edition. The tests were performed in a Linux environment with Ubuntu 14.04, Apache 2, and Chrome 55 browser.

Results. The implementation of the software project resulted in the nominated application of Rural Financial Planning (Plafir). Plafir is a web application that assists in decision making when the farmer decides to invest in a new rural activity. Based on financial models pre-registered in the system by agricultural technicians, and a table of inputs with updated prices, the farmer can select a particular model, simulate the production, and check the financial results.

Conclusions. Family farming is lacking Information Systems for decision making, and the application Plafir meets the objective proposed in this study, contributing to the decision making of a new rural activity.

Author Biographies

Luciano Lizzoni, Universidade Estadual do Oeste do Paraná - Unioeste

Mestre em Desenvolvimento Rural Sustentável pela Unioeste (2017). Especialista em Tecnologia Java pela União Pan-Americana de Ensino (2008). Graduado em Sistemas de Informação pela Faculdade Sul Brasil (2006).

Aldi Feiden, Universidade Estadual do Oeste do Paraná - Unioeste

Doutor em Ecologia de Ambientes Aquáticos Continentais pela Universidade Estadual de Maringá (2003). Mestre em Ecologia de Ambientes Aquáticos Continentais pela Universidade Estadual de Maringá (1999). Graduado em Agronomia pela Universidade Estadual de Maringá (1989).

Armin Feiden, Universidade Estadual do Oeste do Paraná - Unioeste

Doutor em Agronomia (Energia na Agricultura) pela Universidade Estadual Paulista Júlio de Mesquita Filho (2001). Mestre em Engenharia Florestal (Conservação da Natureza) pela Universidade Federal do Paraná (1994). Graduado em Agronomia pela Universidade Federal do Paraná (1986). Graduado em Zootecnia pela Universidade Estadual de Maringá (1981).

References

AIAF. Agricultura familiar: por um sistema alimentar sustentável. Disponível em <http://www.aiaf2014.gov.br/sitemda/sites/site_aiaf/files/argumentos_e_dados_af_no_mundo_-_aiaf_2014.pdf> Acesso em: 15 out. 2014.

BEZERRA, Eduardo. Princípios de Análise e Projeto de Sistema com UML. 3. ed. Rio de Janeiro: Elsevier, 2015.

CHAMBERS, James; PAQUETTE, David; TIMMS, Simon. ASP.NET core application development: building an application in four sprints. Redmond, Washington: Microsoft Press, 2017.

COMPANHIA NACIONAL DE ABASTECIMENTO (CONAB). Custos de produção agrícola: a metodologia da Conab. Brasília: CONAB, 2010. Disponível em: http://www.conab.gov.br/conabweb/download/safra/custos.pdf . Acessoem: 16 jan. 2017.

CORONEL, Carlos; MORRIS, Steven. Database systems: design, implementation, and management. 12. ed. Boston, MA, USA: Cengage Learning, 2017.

ELLIS, Frank. Rural livelihoods and diversity in developing countries. Oxford: Oxford University Press, 2000.

FAO. Agricultura familiar. Disponível em: http://www.fao.org/family-farming-2014/pt/ . Acesso em: 20 out. 2014.

FOWLER, Martin. UML Essencial: um breve guia para linguagem-padrão de modelagem de objetos. 3. ed. Porto Alegre: Bookman, 2007.

FREEMAN, Adam. Pro ASP.NET Core MVC. 6. ed. Berkeley, CA: Apress, 2016.

GUANZIROLI, Carlos; ROMEIRO, Ademar; BUAINAIN, Antonio M.; DI SABBATO, Alberto; BITTENCOURT, Gilson. Agricultura familiar e reforma agrária no século XXI. Rio de Janeiro: Garamond, 2001.

GUEDES, Gilleanes T. A. UML 2: guia prático. 2. ed. São Paulo: Novatec, 2014.

GUZMÁN, Eduardo Sevilla. Origem, evolução e perspectivas do desenvolvimento sustentável. In: ALMEIDA, Jalcione; NAVARRO, Zander (orgs.) Reconstruindo a agricultura: idéias e ideais na perspectiva de um desenvolvimento rural sustentável. Porto Alegre: Editora da Universidade - UFRGS, 1998.

IAP. Módulos fiscais do município do estado do paraná. Governo do Paraná. Disponível em: http://www.iap.pr.gov.br/pagina-1328.html . Acesso em: 15 jul. 2016.

IBGE. Censo agropecuário 2006: resultados preliminares. IBGE, 2006.

IBGE. Pesquisa nacional por amostra de domicílios: síntese de indicadores 2014. Rio de Janeiro: IBGE, 2015.

LAUDON, Kenneth; LAUDON, Jane. Sistemas de informação gerenciais. 9. ed. São Paulo: Pearson Prentice Hall, 2010.

MARION, José Carlos. Contabilidade rural: contabilidade agrícola, contabilidade da pecuária. 14. ed. São Paulo: Atlas, 2014.

MENDES, Cássia Isabel Costa; OLIVEIRA, Deise R. M. dos Santos; SANTOS, Anderson Rodrigo dos. Estudo do mercado brasileiro de software para o agronegócio. Campinas: Embrapa Informática Agropecuária, 2011.

NAGEL, Christian. Professional C# 6 and .NET Core 1.0. Indianapolis, IN: Wiley, 2016.

O'BRIEN, James A. Sistemas de informação e as decisões gerenciais na era da internet.2. ed. São Paulo: Saraiva, 2004.

OBE, Regina O.; HSU, Leo S. PostgreSQL: up and running: a practical introduction to the advanced open source database. 2. ed. Sebastopol, CA: O'Reilly Media, 2014.

PRICE, Mark J. C# 6 and .NET Core 1.0 modern cross-platform development: create powerful cross-platform applications using C# 6, Net Core 1.0 ASP.NET Core 1.0 and Visual Studio 2015. Birmingham, UK: Packt Publishing, 2016.

RIGGS, Simon et al. PostgreSQL 9 administration cookbook: over 150 recipes to help you run an efficient PostgreSQL database in the cloud. 2. ed. Birmingham, UK: PacktPublishing, 2015.

SACHS, Ignacy. Estratégias de transição para o século XXI: desenvolvimento e meio ambiente. São Paulo: Studio Nobel, 1993.

SANTOS, Gilberto José dos; MARION, José Carlos; SEGATTI, Sonia. Administração de custos na agropecuária. 4. ed. São Paulo: Atlas, 2009.

SCHNEIDER, Sergio. Rural development through rural livelihood diversification: an overview of Brazilian experience. In: International Conference Dynamics of Rural Transformations in Emerging Economies. 2010. p. 14-16.

SORDI, José Osvaldo de; MEIRELES, Manuel. Administração de sistemas de informação: uma abordagem interativa. São Paulo: Saraiva, 2010.

WAZLAWICK, Raul Sidnei. Análise e design orientados a objetos para sistemas de informação: Modelagem com UML, OCL e IFML. 3.ed. Rio de Janeiro: Elsevier, 2015.

Downloads

Published

2019-02-05

How to Cite

Lizzoni, L., Feiden, A., & Feiden, A. (2019). PLAFIR: web application for rural financial planning. Biblios Journal of Librarianship and Information Science, (73), 91–104. https://doi.org/10.5195/biblios.2018.451

Issue

No. 73 (2018)

Section

Case report

License

Authors who publish with this journal agree to the following terms:

  1. The Author retains copyright in the Work, where the term “Work” shall include all digital objects that may result in subsequent electronic publication or distribution.
  2. Upon acceptance of the Work, the author shall grant to the Publisher the right of first publication of the Work.
  3. The Author shall grant to the Publisher and its agents the nonexclusive perpetual right and license to publish, archive, and make accessible the Work in whole or in part in all forms of media now or hereafter known under a Creative Commons Attribution 4.0 International License or its equivalent, which, for the avoidance of doubt, allows others to copy, distribute, and transmit the Work under the following conditions:
    1. Attribution—other users must attribute the Work in the manner specified by the author as indicated on the journal Web site;
    with the understanding that the above condition can be waived with permission from the Author and that where the Work or any of its elements is in the public domain under applicable law, that status is in no way affected by the license.
  4. The Author is able to enter into separate, additional contractual arrangements for the nonexclusive distribution of the journal's published version of the Work (e.g., post it to an institutional repository or publish it in a book), as long as there is provided in the document an acknowledgement of its initial publication in this journal.
  5. Authors are permitted and encouraged to post online a prepublication manuscript (but not the Publisher’s final formatted PDF version of the Work) in institutional repositories or on their Websites prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work. Any such posting made before acceptance and publication of the Work shall be updated upon publication to include a reference to the Publisher-assigned DOI (Digital Object Identifier) and a link to the online abstract for the final published Work in the Journal.
  6. Upon Publisher’s request, the Author agrees to furnish promptly to Publisher, at the Author’s own expense, written evidence of the permissions, licenses, and consents for use of third-party material included within the Work, except as determined by Publisher to be covered by the principles of Fair Use.
  7. The Author represents and warrants that:
    1. the Work is the Author’s original work;
    2. the Author has not transferred, and will not transfer, exclusive rights in the Work to any third party;
    3. the Work is not pending review or under consideration by another publisher;
    4. the Work has not previously been published;
    5. the Work contains no misrepresentation or infringement of the Work or property of other authors or third parties; and
    6. the Work contains no libel, invasion of privacy, or other unlawful matter.
  8. The Author agrees to indemnify and hold Publisher harmless from Author’s breach of the representations and warranties contained in Paragraph 6 above, as well as any claim or proceeding relating to Publisher’s use and publication of any content contained in the Work, including third-party content.

Revised 7/16/2018. Revision Description: Removed outdated link.