Sistema de reserves hoteleres on-line, basat en el protocol de comunicació OTA

L’origen d’aquest projecte neix en la necessitat de crear un sistema de reserves hoteleres on-line integral i amb connectivitat amb altres sistemes de reserves. S'ha optat pel protocol de comunicació OTA(Open Travel Alliance), es tracta d'un protocol de comunicació XML ideat per empreses del sector turístic dels Estats Units per la necessitat comuna d’unes especificacions tècniques que permetessin la comunicació electrònica de la informació

Proyecto final carrera ETIG Hotel SPA

El proyecto consiste en desarrollar un software para la gestión de los servicios que ofrece un Hotel Spa.Por un lado, un software con el que los clientes podrán interactuar para la petición de servicios al hotel. Estas peticiones de servicios son: -Peticiones servicios de habitaciones (incidencias, peticiones de material, servicio despertador, servicio limpieza, etc.) -Reservar un recurso (salas de reunión, pistas de deportes, etc.) -Planificar actividades realizadas en el recinto del hotel (gimnasio, masajista, conferencias, audiciones, espectáculos musicales, etc.)Y por otro lado el software necesario para gestionar estas peticiones que estará a la disposición de los encargados del hotel.El nombre de la aplicación es: eHotelSPANet.Para el desarrollo del software se utilizarán las herramientas de Microsoft usando la tecnología .NET, concretamente: -WPF (Windows Presentation Foundation). -WCF (Windows Communications Foundation) SQL Server 2008

The customer valuations game as a basis for revenue management

I describe the customer valuations game, a simple intuitive game that can serve as a foundation for teaching revenue management. The game requires little or no preparation, props or software, takes around two hours (and hence can be finished in one session), and illustrates the formation of classical (airline and hotel) revenue management mechanisms such as advanced purchase discounts, booking limits and fixed multiple prices. I normally use the game as a base to introduce RM and to develop RM forecasting and optimization concepts off it. The game is particularly suited for non-technical audiences.

Equivalence of piecewise-linear approximation and Lagrangian relaxation for network revenue management

The network revenue management (RM) problem arises in airline, hotel, media,and other industries where the sale products use multiple resources. It can be formulatedas a stochastic dynamic program but the dynamic program is computationallyintractable because of an exponentially large state space, and a number of heuristicshave been proposed to approximate it. Notable amongst these -both for their revenueperformance, as well as their theoretically sound basis- are approximate dynamic programmingmethods that approximate the value function by basis functions (both affinefunctions as well as piecewise-linear functions have been proposed for network RM)and decomposition methods that relax the constraints of the dynamic program to solvesimpler dynamic programs (such as the Lagrangian relaxation methods). In this paperwe show that these two seemingly distinct approaches coincide for the network RMdynamic program, i.e., the piecewise-linear approximation method and the Lagrangianrelaxation method are one and the same.

A new compact linear programming formulation for choice network revenue management

The choice network revenue management model incorporates customer purchase behavioras a function of the offered products, and is the appropriate model for airline and hotel networkrevenue management, dynamic sales of bundles, and dynamic assortment optimization.The optimization problem is a stochastic dynamic program and is intractable. A certainty-equivalencerelaxation of the dynamic program, called the choice deterministic linear program(CDLP) is usually used to generate dyamic controls. Recently, a compact linear programmingformulation of this linear program was given for the multi-segment multinomial-logit (MNL)model of customer choice with non-overlapping consideration sets. Our objective is to obtaina tighter bound than this formulation while retaining the appealing properties of a compactlinear programming representation. To this end, it is natural to consider the affine relaxationof the dynamic program. We first show that the affine relaxation is NP-complete even for asingle-segment MNL model. Nevertheless, by analyzing the affine relaxation we derive a newcompact linear program that approximates the dynamic programming value function betterthan CDLP, provably between the CDLP value and the affine relaxation, and often comingclose to the latter in our numerical experiments. When the segment consideration sets overlap,we show that some strong equalities called product cuts developed for the CDLP remain validfor our new formulation. Finally we perform extensive numerical comparisons on the variousbounds to evaluate their performance.

On the tractability of the piecewise-linear approximation for general discrete-choice network revenue management

The choice network revenue management (RM) model incorporates customer purchase behavioras customers purchasing products with certain probabilities that are a function of the offeredassortment of products, and is the appropriate model for airline and hotel network revenuemanagement, dynamic sales of bundles, and dynamic assortment optimization. The underlyingstochastic dynamic program is intractable and even its certainty-equivalence approximation, inthe form of a linear program called Choice Deterministic Linear Program (CDLP) is difficultto solve in most cases. The separation problem for CDLP is NP-complete for MNL with justtwo segments when their consideration sets overlap; the affine approximation of the dynamicprogram is NP-complete for even a single-segment MNL. This is in contrast to the independentclass(perfect-segmentation) case where even the piecewise-linear approximation has been shownto be tractable. In this paper we investigate the piecewise-linear approximation for network RMunder a general discrete-choice model of demand. We show that the gap between the CDLP andthe piecewise-linear bounds is within a factor of at most 2. We then show that the piecewiselinearapproximation is polynomially-time solvable for a fixed consideration set size, bringing itinto the realm of tractability for small consideration sets; small consideration sets are a reasonablemodeling tradeoff in many practical applications. Our solution relies on showing that forany discrete-choice model the separation problem for the linear program of the piecewise-linearapproximation can be solved exactly by a Lagrangian relaxation. We give modeling extensionsand show by numerical experiments the improvements from using piecewise-linear approximationfunctions.

Evaluación y plan de actuación en materia de Prevención de Riesgos Laborales del Hotel Tanit (Benidorm)

El presente documento es un proyecto de intervención en el marco de la prevención de riesgos laborales en un hotel de tres estrellas de la localidad turística de Benidorm. A partir de un análisis exhaustivo de las necesidades de la organización, sus características intrínsecas, su modelo de gestión de la prevención de riesgos laborales, y una evaluación específica de cuatro puestos de trabajo, se pretende comprobar el funcionamiento de la gestión de la prevención, con el objetivo de proponer aquellas actuaciones que puedan mejorarlo. Para llevar a cabo dicha labor, se empleará una metodología analítica extraída de las guías técnicas del Instituto Nacional de Seguridad e Higiene en el trabajo (INSHT en adelante), que contemplan modelos y metodologías de evaluación ampliamente contrastados como el modelo de demanda-control-apoyo social de Robert Karasek, desarrollado por la metodología ISTAS21 de la NTP 604 del INSHT, o la Guía Técnica de pantallas de visualización de datos (PVD) del INSHT desarrolladora del RD 488/1997.El proyecto pretende de esta manera alcanzar unas conclusiones acordes a la fiabilidad de la metodología empleada, y de esta forma proponer actuaciones preventivas correctoras para los factores de riesgo hallados durante la evaluación de los puestos de trabajo, y que se ajusten en todo momento a los requerimientos legales vigentes en materia de prevención de riesgos laborales.Finalmente, el proyecto propondrá a modo de conclusiones la actualización del Plan preventivo con el que cuenta la empresa, en base a los descubrimientos hallados durante la investigación, así como una serie de acciones dirigidas a la satisfactoria integración de la actividad preventiva dentro del modelo de gestión de la empresa.

Efficiency and quality in local government management: the case of Spanish local authorities

This study analyses efficiency levels in Spanish local governments and their determining factors through the application of DEA (Data Envelopment Analysis) methodology. It aims to find out to what extent inefficiency arises from external factors beyond the control of the entity, or on the other hand, how much it is due to inadequate management of productive resources. The results show that on the whole, there is still a wide margin within which managers could increase local government efficiency levels, although it is revealed that a great deal of inefficiency is due to exogenous factors. It is specifically found that the size of the entity, per capita tax revenue, the per capita grants or the amount of commercial activity are some of the factors determining local government inefficiency.

Access as a motivational device: implications for human resource management

This paper analyzes the employment relationship on the basis of the notion of access. We argue that the degree of access provided by a job is an incentive to activate the employee’s self-actualization needs. We investigate the effect of access on the workers’ performance through an agency model and provide a number of propositions with practical implications for personnel policies. Our results are consistent with the intuition emerged from the real business practice as well as with many of the arguments on the substitutive role between monetary and non-monetary incentives frequently reported in the literature.

Environmental management problems, future generations and social decisions

The decisions of many individuals and social groups, taking according to well-defined objectives, are causing serious social and environmental problems, in spite of following the dictates of economic rationality. There are many examples of serious problems for which there are not yet appropriate solutions, such as management of scarce natural resources including aquifer water or the distribution of space among incompatible uses. In order to solve these problems, the paper first characterizes the resources and goods involved from an economic perspective. Then, for each case, the paper notes that there is a serious divergence between individual and collective interests and, where possible, it designs the procedure for solving the conflict of interests. With this procedure, the real opportunities for the application of economic theory are shown, and especially the theory on collective goods and externalities. The limitations of conventional economic analysis are shown and the opportunity to correct the shortfalls is examined. Many environmental problems, such as climate change, have an impact on different generations that do not participate in present decisions. The paper shows that for these cases, the solutions suggested by economic theory are not valid. Furthermore, conventional methods of economic valuation (which usually help decision-makers) are unable to account for the existence of different generations and tend to obviate long-term impacts. The paper analyzes how economic valuation methods could account for the costs and benefits enjoyed by present and future generations. The paper studies an appropriate consideration of preferences for future consumption and the incorporation of sustainability as a requirement in social decisions, which implies not only more efficiency but also a fairer distribution between generations than the one implied by conventional economic analysis.

Entrepreneurship, management services and economic growth

We model the joint production of entrepreneurs and workers where the former provide both entrepreneurial (strategic) and managerial (coordination, motivation) services, and management services are shared with individual workers in an output maximizing way. The static equilibrium of the model determines the endogenous share of entrepreneurs in the economy in a given moment of time. The time dynamics of the solution implies that a given growth rate in quality of entrepreneurial services contributes to productivity growth proportionally to the share of entrepreneurs at the start of the period and improvement in quality of entrepreneurial services is convergence enhancing. Model predictions are tested with data from OECD countries in the period 1970-2002. We find that improvements in quality of entrepreneurial services over time explain up to 100% of observed average productivity growth in these countries.