A Decision Support System for Municipal Budget Plan Decisions
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.
KeywordsDSS UML economic indicators R prediction models
Unable to display preview. Download preview PDF.
- 1.Valacich, J., Schneider, C.: Information Systems Today. Prentice Hall (2013)Google Scholar
- 2.Burstein, F., Holsapple, C.: Handbook on Decision Support Systems. Springer (2008)Google Scholar
- 3.Power, D.J.: Decision Support Systems: Concepts and Resources for Managers. Greenwood/Quorum, Westport (2002)Google Scholar
- 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.Lopes, F., Morais, M., Carvalho, A.: Desenvolvimento de Sistemas de informação. FCA (2009)Google Scholar
- 7.Ramos, P.: Desenhar Bases de dados com UML. Edições Sílabo (2012)Google Scholar
- 8.Hyndman, R.: Forecast: Forecasting functions for time series and linear models. Repositório CRAN (2014)Google Scholar
- 9.Armstrong, J.: Principles of forecasting. Kluwer Academic Publishers (2001)Google Scholar
- 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.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.Schapire, R.E.: The Strength of Weak Learnability. Machine Learning 5(2), 197–227 (1990)Google Scholar
- 13.Cortes, B.: Sistemas de Suporte à Decisão. FCA (2005)Google Scholar