Sistema de apoio à decis?o via planilha eletr?nica para o planejamento de interconex?o de erbs em cenários de aluguel com demanda e custo fuzzy

摘要

The growing demand for new data transmission combined with the demand growth inaccuracies services results in the expansion of Mobile Access Systems, requiring intense planning activity with a variety of technical-marketing options. This paper presents a Decision Support System for the design of the Base Transceiver Station - Control and Switching Station interconnection in a mobile telecommunications network developed in a spreadsheet. The main objective is that the Decision Support System can help in choosing the most economically feasible network topology, assuming imprecise forecasts of demand and cost and based on the concept of trapezoidal fuzzy numbers. The methodology allows a high degree of interactivity with the planner, making it easier to analyze scenarios of rent contracts for a small network.? The use of the solver allowed to improve the use of an easy-to-use computational tool by the end user of the system, since the mathematical model of the Decision Support System used proved to be a facilitator to evaluate how the network behavior for the most varied possibilities.