Sistema de Informação de Apoio à Detecção de Perdas de Energia Eléctrica – O Caso da Electra

A realidade mundial é preocupante no que diz respeito ao aumento de ocorrências de perdas e fraudes em redes de distribuição de energia eléctrica. Em Cabo Verde, mas precisamente na Cidade da Praia a realidade é ainda mais preocupante devido ao número de ocorrências e a gravidade dos mesmos. Propõe-se um trabalho de investigação sobre perdas e fraudes de energia eléctrica baseado na análise dos dados relativos aos registos dos clientes na Base de Dados da Electra (Cabo Verde), com o intuito de nortear as tomadas de decisões de gestão estratégica no que diz respeito às políticas de controlo e prevenção de perdas e fraudes de energia eléctrica. O trabalho baseia-se na recolha e selecção de dados a organizar numa Data Warehouse para depois aplicar as tecnologias OLAP para a identificação de perdas nos Postos de Transformação e zonas geográficas da Cidade da Praia em Cabo Verde e posteriormente identificar possíveis fraudes de energia eléctrica nos clientes finais utilizando Data Mining. Os resultados principais consistiram na identificação de situações de perdas de energia eléctrica nos Postos de Transformação, a identificação de áreas críticas seleccionadas para inspecção dos seus clientes finais e a detecção de padrões de anomalias associadas ao perfil dos clientes.

Análise da performance organizacional: Proposta de um modelo do balanced scorecard para a avaliação do desempenho do comando da 1ª região militar

Esta pesquisa gira à volta da avaliação do desempenho organizacional com enfoque no sistema denominado Balanced Scorecard. Esta ferramenta, criada no início da década de noventa, por David Norton e Robert Kaplan, tem vindo a contagiar os gestores, e nos dias de hoje várias são as organizações que beneficiam dela para obter excelência. A primeira metodologia foi apresentada em mil novecentos e noventa e três (1993), constituída por oito etapas. No ano de mil novecentos e noventa e seis (1996), os autores desenvolveram uma nova metodologia, melhorada, composta por dez etapas. Começámos por fazer um levantamento teórico dos conceitos ligados a esta ferramenta, as suas vantagens e desvantagens, as fases da sua execução, os possíveis obstáculos ao seu sucesso e os frutos que poderão ser colhidos com a sua implementação. Através de uma proposta de implementação, escolhemos o Comando da 1ª Região Militar, para verificar quais serão os impactos na gestão desta organização. Do diagnóstico situacional efectuado com base em entrevistas, análise documental e observação, verificámos que a organização possui algumas insuficiências ao nível do desempenho de gestão, derivadas sobretudo da situação logística e financeira. Na construção do mapa estratégico, principal componente do Balanced scorecard, vimo-nos na necessidade de deslocar a perspectiva do cliente ou de mercado para o topo de configuração, devido à natureza do objecto negocial da organização em estudo. O modelo de avaliação de desempenho desenvolvido evidenciou a importância que a utilização deste sistema poderá ter na melhoria das actividades castrenses, sobretudo pelo aumento do nível de comunicação entre os subgrupos e a gestão de topo, neste caso, o Pessoal de Comando e as Pequenas Unidades, devido à natureza e qualidade das informações fornecidas pelo mapa estratégico. The aim of this study is to look at the organizational performance measurement system, with a special emphasis upon the so called Balanced Scorecard System. This tool, created at the beginning of the 1990’s by David Norton and Robert Kaplan, has been gaining the enthusiasm of administrator, and at the present time, several organizations are using it in the search for excellence. The first methodology was presented in 1993 and was formed by eight steps. In 1996, however, its creators developed an improved version of this methodology, now composed by ten steps. We start by doing a research of the theoretical concepts related to this tool, its advantages and disadvantages, the stages of its implementation, possible obstacles to its success, and the benefits that can come from its use. Based on an implementation proposal, we chose the First Military Command Region of Cape Verde to study the possible impacts of this system on the management of that Institution. From an investigation on the existent situation, based on interviews, analysis of documents and “in locus” observation, we realised that the institution shows some administrative insufficiencies, mainly due to its logistics and financial situation. In the building of the strategic map, the main component of the Balanced Scorecard System, we were obliged to move the perspective of the client or the market to the top of the configuration, because of the nature of the trading object of the institution being studied. The performance measurement model developed, clearly showed the importance that the implementation of this system might have on the improvement of the Military activities, mainly because of the improvement on the type of communication that can be established between the subgroups and the higher hierarchical levels, in this case, the Commander Staff and the lower Units, due to the type and quality of the information provided by the strategic map.

Disseny i implementació de la base de dades d'un sistema de gestió d'informació de jugadors de bàsquet

Disseny i implementació d'una base de dades relacional per a la gestió d'informació de jugadors de bàsquet. Implementació de les consultes més habituals del model de negoci. Disseny i implementació del mòdul estadístic per realitzar consultes en temps constant.

Bases de dades

Este proyecto final de carrera ha consistido principalmente en la planificación y ejecución del diseño e implementación de una base de datos (BD) relacional para la gestión sanitaria. El sistema resultante permite tanto la gestión de las consultas externas de los centros hospitalarios como la de los pacientes atendidos. Toda la gestión y acceso a los datos de las tablas se ha hecho mediante procedimientos almacenados creados en la propia base de datos. También se ha definido un almacén de datos que permite realizar un análisis de los datos almacenados en dicha BD.

Supply chain management implementation in the Spanish grocery sector: An exploratory study

This paper explores the integration process that firms follow to implementSupply Chain Management (SCM) and the main barriers and benefits relatedto this strategy. This study has been inspired in the SCM literature,especially in the logistics integration model by Stevens [1]. Due to theexploratory nature of this paper and the need to obtain an in depthknowledge of the SCM development in the Spanish grocery sector, we used thecase study methodology. A multiple case study analysis based on interviewswith leading manufacturers and retailers was conducted.The results of this analysis suggest that firms seem to follow the integration process proposed by Stevens, integrating internally first, andthen, extending this integration to other supply chain members. The casesalso show that Spanish manufacturers, in general, seem to have a higherlevel of SCM development than Spanish retailers. Regarding the benefitsthat SCM can bring, most of the companies identify the general objectivesof cost and stock reductions and service improvements. However, withrespect to the barriers found in its implementation, retailers andmanufacturers are not coincident: manufacturers seem to see more barrierswith respect to aspects related to the other party, such as distrust and alack of culture of sharing information, while retailers find as mainbarriers the need of a know-how , the company culture and the historyand habits.

Supply chain management: An opportunity for metaheuristics

In today s highly competitive and global marketplace the pressure onorganizations to find new ways to create and deliver value to customersgrows ever stronger. In the last two decades, logistics and supply chainhas moved to the center stage. There has been a growing recognition thatit is through an effective management of the logistics function and thesupply chain that the goal of cost reduction and service enhancement canbe achieved. The key to success in Supply Chain Management (SCM) requireheavy emphasis on integration of activities, cooperation, coordination andinformation sharing throughout the entire supply chain, from suppliers tocustomers. To be able to respond to the challenge of integration there isthe need of sophisticated decision support systems based on powerfulmathematical models and solution techniques, together with the advancesin information and communication technologies. The industry and the academiahave become increasingly interested in SCM to be able to respond to theproblems and issues posed by the changes in the logistics and supply chain.We present a brief discussion on the important issues in SCM. We then arguethat metaheuristics can play an important role in solving complex supplychain related problems derived by the importance of designing and managingthe entire supply chain as a single entity. We will focus specially on theIterated Local Search, Tabu Search and Scatter Search as the ones, but notlimited to, with great potential to be used on solving the SCM relatedproblems. We will present briefly some successful applications.

Strategies for an integrated distribution problem

The problems arising in the logistics of commercial distribution are complexand involve several players and decision levels. One important decision isrelated with the design of the routes to distribute the products, in anefficient and inexpensive way.This article explores three different distribution strategies: the firststrategy corresponds to the classical vehicle routing problem; the second isa master route strategy with daily adaptations and the third is a strategythat takes into account the cross-functional planning through amulti-objective model with two objectives. All strategies are analyzed ina multi-period scenario. A metaheuristic based on the Iteratetd Local Search,is used to solve the models related with each strategy. A computationalexperiment is performed to evaluate the three strategies with respect to thetwo objectives. The cross functional planning strategy leads to solutions thatput in practice the coordination between functional areas and better meetbusiness objectives.

E-supply chain management: Review, implications and directions for future research

This paper analyses the interaction of two topics: Supply Chain Management (SCM) andInternet. Merging these two fields is a key area of concern for contemporary managers andresearchers. They have realized that Internet can enhance SCM by making real timeinformation available and enabling collaboration between trading partners. The aim of thispaper is to define e-SCM, analyze how research in this area has evolved during the period1995-2003 and identify some lines of further research. To do that a literature review inprestigious academic journals in Operations Management and Logistics has beenconducted.

Management of major accidents with on-site 144 dispatcher

Introduction: An excellent coordination between firefighters, policemen and medical rescue is the key to success in the management of major accidents. In order to improve and assist the medical teams engaged on site, the Swiss "medical command and control system" for rescue operations is based on a binomial set up involving one head emergency doctor and one head rescue paramedic, both trained in disaster medicine. We have recently experimented an innovative on-site "medical command and control system", based on the binomial team, supported by a dedicated 144 dispatcher. Methods: A major road traffic accident took place on the highway between Lausanne and Vevey on April 9th 2008. We have retrospectively collected all data concerning the victims as well as the logistics and dedicated structures, reported by the 144, the Hospitals, the Authority of the State and the Police and Fire Departments. Results: The 72-car pileup caused one death and 26 slightly injured patients. The management on the accident site was organized around a tripartite system, gathering together the medical command and control team with the police and fire departments. On the medical side, 16 ambulances, 2 medical response teams (SMUR), the Rega crew and the medical command and control team were dispatched by the 144. On that occasion an advanced medical command car equipped with communication devices and staffed with a 144 dispatcher was also engaged, allowing efficient medical regulation directly from the site. Discussion: The specific skills of one doctor and one paramedic both trained for disaster's management proved to be perfectly complementary. The presence of a dispatcher on site with a medical command car also proved to be useful, improving orders transmission from the medical command team to all other on- and off-site partners. It relieved the need of repeated back-and-forth communication with the 144, allowing both paramedic and doctor to focus on strategy and tactics rather than communication and logistics.

Multi-period vendor managed inventory systems

In this paper we develop two models for an inventory system in which the distributormanages the inventory at the retailers location. These type of systems correspondto the Vendor Managed Inventory (VMI) systems described ib the literature. Thesesystems are very common in many different types of industries, such as retailingand manufacturing, although assuming different characteristics.The objective of our model is to minimize total inventory cost for the distributorin a multi-period multi-retailer setting. The inventory system includes holdingand stock-out costs and we study the case whre an additional fixed setup cost ischarged per delivery.We construct a numerical experiment to analyze the model bahavior and observe theimpact of the characteristics of the model on the solutions.

Inventory-routing model, for a multi-period problem with stochastic and deterministic demand

The need for integration in the supply chain management leads us to considerthe coordination of two logistic planning functions: transportation andinventory. The coordination of these activities can be an extremely importantsource of competitive advantage in the supply chain management. The battle forcost reduction can pass through the equilibrium of transportation versusinventory managing costs. In this work, we study the specific case of aninventory-routing problem for a week planning period with different types ofdemand. A heuristic methodology, based on the Iterated Local Search, isproposed to solve the Multi-Period Inventory Routing Problem with stochasticand deterministic demand.

Supply chain management as a competitive advantage in the Spanish grocery sector

Adversarial relationships have long dominated business relationships,but Supply Chain Management (SCM) entails a new perspective. SCM requiresa movement away from arms-length relationships toward partnership stylerelations. SCM involves integration, co-ordination and collaborationacross organisations and throughout the supply chain. It means that SCMrequires internal (intraorganisational) and external (interorganisational)integration. This paper analyses the relationship between internal andexternal integration processes, their effect on firms performance andtheir contribution to the achievement of a competitive advantage.Performance improvements are analysed through costs, stock out and leadtime reductions. And, the achievement of a better competitive positionis measured by comparing the firm s performance with its competitors performance. To analyse this, an empirical study has been conducted inthe Spanish grocery sector.

Sistema de Informação de Apoio à Detecção de Perdas de Energia Eléctrica – O Caso da Electra

A realidade mundial é preocupante no que diz respeito ao aumento de ocorrências de perdas e fraudes em redes de distribuição de energia eléctrica. Em Cabo Verde, mas precisamente na Cidade da Praia a realidade é ainda mais preocupante devido ao número de ocorrências e a gravidade dos mesmos. Propõe-se um trabalho de investigação sobre perdas e fraudes de energia eléctrica baseado na análise dos dados relativos aos registos dos clientes na Base de Dados da Electra (Cabo Verde), com o intuito de nortear as tomadas de decisões de gestão estratégica no que diz respeito às políticas de controlo e prevenção de perdas e fraudes de energia eléctrica. O trabalho baseia-se na recolha e selecção de dados a organizar numa Data Warehouse para depois aplicar as tecnologias OLAP para a identificação de perdas nos Postos de Transformação e zonas geográficas da Cidade da Praia em Cabo Verde e posteriormente identificar possíveis fraudes de energia eléctrica nos clientes finais utilizando Data Mining. Os resultados principais consistiram na identificação de situações de perdas de energia eléctrica nos Postos de Transformação, a identificação de áreas críticas seleccionadas para inspecção dos seus clientes finais e a detecção de padrões de anomalias associadas ao perfil dos clientes.

A recoverable production planning model

Aware of the importance of developing new alternatives to improve the performance of the companies, our purpose in this paper is to develop a medium term production planning model that deals with the concepts of Partnership and Reverse Logistics. Our model takes advantage of the synergies of integration, developing a model for global production planning that generates the optimal production and purchasing schedule for all the companies integrating a logistic chain. In a second part of the paper we incorporate products returns to the first model proposed, and analyze the implications they have over this model. We use some examples with different configurations of supply chains varying the number of production plants, distribution centers and recovery plants. To solve the model we have combined optimization and simulation procedures.

Business Intelligence Auxílio às organizações no processo da tomada de decisão

O presente trabalho destinada para o complemento de grau de licenciatura tem como objectivo principal analisar o auxílio de Business Intelligence (BI) às organizações na sua melhoria contínua no desempenho e qualidade de serviços, sobretudo no processo de tomada de decisão e estudo da sua existência na Cabo Verde Telecom. As tecnologias associadas a ele, nomeadamente, data warehouse, data mining e olap são primordiais para a tomada de decisão sobre as actividades estratégicas no mercado de negócios. Essas tecnologias permitem uma análise cuidada dos dados, transformando-os em informações pertinentes para a tomada de decisão nas empresas, garantindo com isto o seu crescimento no mercado.