A Decision Support System for Municipal Budget Plan Decisions

  • Hugo RegoEmail author
  • Armando B. Mendes
  • Hélia Guerra
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 354)


This paper describes a Decision Support System to provide indicators to support budget plan decisions, in a local government organization, the municipality of Lagoa - S. Miguel, Azores. The work includes system modeling, using the UML notation, the development of a MySQL relational database, algorithms for data collection using PHP, and forecasting models using R functions, such as exponential smoothing, classical decomposition with linear trend, and ARIMA models. Users have access to predictions made by different models for several indicators, being suggested to use the models with closest to zero errors. From the analysis performed considering 12 years data, it is concluded that for most of indicators, the classical decomposition model is the most successful. However, for some indicators, it was found that the two error measures used are not consistent. In these cases, the final decision is left to the decision-maker, taking advantage of his domain knowledge.


DSS UML economic indicators prediction models 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Valacich, J., Schneider, C.: Information Systems Today. Prentice Hall (2013)Google Scholar
  2. 2.
    Burstein, F., Holsapple, C.: Handbook on Decision Support Systems. Springer (2008)Google Scholar
  3. 3.
    Power, D.J.: Decision Support Systems: Concepts and Resources for Managers. Greenwood/Quorum, Westport (2002)Google Scholar
  4. 4.
    Mendes, A., Alfaro, P., Ferreira, A.: Business Intelligence no suporte a decisão sobre comunicações: descrição de um caso. Revista de Ciências da Computação (2008)Google Scholar
  5. 5.
    Lopes, F., Morais, M., Carvalho, A.: Desenvolvimento de Sistemas de informação. FCA (2009)Google Scholar
  6. 6.
    Mendes, A.B., Themido, I.H.: Multi-outlet retail site location assessment. International Transactions in Operational Research 11(1), 1–18 (2004)CrossRefzbMATHGoogle Scholar
  7. 7.
    Ramos, P.: Desenhar Bases de dados com UML. Edições Sílabo (2012)Google Scholar
  8. 8.
    Hyndman, R.: Forecast: Forecasting functions for time series and linear models. Repositório CRAN (2014)Google Scholar
  9. 9.
    Armstrong, J.: Principles of forecasting. Kluwer Academic Publishers (2001)Google Scholar
  10. 10.
    Hyndman, R., Maxwell, L., Pitrun, I., Billah, B.: Local linear forecasts using cubic smoothing splines, University of Australia – Department of Economics (2002)Google Scholar
  11. 11.
    Hyndman, R.J., Kostenko, A.V.: Minimum Sample Size requirements for Seasonal Forecasting Models. Foresight: The International Journal of Applied Forecasting, International Institute of Forecasters 6, 12–15 (2007)Google Scholar
  12. 12.
    Schapire, R.E.: The Strength of Weak Learnability. Machine Learning 5(2), 197–227 (1990)Google Scholar
  13. 13.
    Cortes, B.: Sistemas de Suporte à Decisão. FCA (2005)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  • Hugo Rego
    • 1
    Email author
  • Armando B. Mendes
    • 2
    • 4
  • Hélia Guerra
    • 3
    • 4
  1. 1.Câmara Municipal da Lagoa, AçoresLagoaPortugal
  2. 2.CEEAplA, Universidade dos AçoresPonta DelgadaPortugal
  3. 3.ALGORITMI, Universidade do MinhoGuimarãesPortugal
  4. 4.Depart. de MatemáticaUniversidade dos AçoresPonta DelgadaPortugal

Personalised recommendations