Implantación de un ERP en una compañía de apuestas por Internet

Aquest projecte intenta cobrir les necessitats que genera una empresa nova que vol vendre loteria a Internet. Es necessita tenir ben definits els circuits de compra, de venda, de facturació, de control d'existències, de cobraments i de pagaments, entre d'altres. Per gestionar tota aquesta activitat, s’ha fet servir el ERP Navision amb SQL Server, adaptant-lo i creant noves funcionalitats. L'aplicació Web ha estat integrada amb Navision i s'ha desenvolupat la seva funcionalitat, tenint sessions per a usuari amb comptes propis que permeten la consulta i la compra dels productes que ofereix l'empresa.

Estudio para la implantación de un ERP en una empresa de fabricación de depósitos

Aquest projecte intenta proporcionar les bases per la selecció i implantació d’un ERP a una empresa mitjana. S’analitzen des dels primers passos a realitzar per l’empresa que adquirirà l’ERP fins els que realitza el proveïdor per garantir l’èxit de la implantació. Primerament, i des del punt de vista del client, es realitza una anàlisi interna per detectar la necessitat d’un canvi de sistema i es detalla una metodologia a seguir per a l’elecció de l’ERP i del proveïdor d’aquest, minimitzant el risc d’error. Des del punt de vista del proveïdor es seguirà una metodologia d’implantació pas per pas, ja què un canvi de sistema és una tasca molt complexa. He intentat aportar la meva experiència al realitzar aquest projecte ja que he tingut l'oportunitat de viure una implantació des de les dues òptiques i he aprofitat per indagar en les tasques que s’hi realitzen.

The Design and efficiency of loyalty rewards

The goal of this paper is to reexamine the optimal design and efficiency of loyalty rewards in markets for final consumption goods. While the literature has emphasized the role of loyalty rewards as endogenous switching costs (which distort the efficient allocation of consumers), in this paper I analyze the ability of alternative designs to foster consumer participation and increase total surplus. First, the efficiency of loyalty rewards depend on their specific design. A commitment to the price of repeat purchases can involve substantial efficiency gains by reducing price-cost margins. However, discount policies imply higher future regular prices and are likely to reduce total surplus. Second, firms may prefer to set up inefficient rewards (discounts), especially in those circumstances where a commitment to the price of repeat purchases triggers Coasian dynamics.

Biblioteca Digital de Catalunya: 10 anys d'activitats

El Consorci de Biblioteques Universitàries de Catalunya (CBUC) va ser creat el 1996 amb l'objectiu de fer i mantenir el catàleg col·lectiu de les universitats de Catalunya (CCUC) però aviat va ampliar les seves activitats amb el préstec interbibliotecari i les compres conjuntes d'informació electrònica. Aquesta darrera activitat va iniciar-se a finals de 1997 quan el CBUC va presentar als vicerectors de recerca de les universitats públiques de Catalunya el projecte de comprar bases de dades de manera consorciada. Aquests van estar-hi d'acord i van manifestar el seu interès de que en les compres conjuntes també s'incloguessin revistes electròniques. El CBUC va decidir englobar aquestes activitats sota el nom Biblioteca Digital de Catalunya (BDC) la qual naixia amb la "finalitat de proporcionar un conjunt nuclear comú d'informació electrònica per a la totalitat dels usuaris de les biblioteques del CBUC". A finals de 1998 el projecte de la BDC es va presentar a la Generalitat de Catalunya i es va obtenir un finançament per al projecte que cobria el període 1999-2001. Des de llavors la BDC ha passat per almenys tres fases: Una de formació, 1999-2001, que es va iniciar amb un ajut del llavors Departament d'Universitats, Recerca i Societat de la Informació (DURSI) de la Generalitat de Catalunya, ajut que es va traduir en una inversió de 180.000€/any i que va permetre l'inici de subscripcions conjuntes, principalment bases de dades. Una de creixement, 2002-2004, realitzada a partir d'un increment de l'ajut del DURSI, ajut que s'usa com a "capital llavor" per subscriure de forma especial revistes. En aquest moment la BDC s'amplia a universitats no membres del CBUC. Una d'estabilització, 2005-2009, en la que s'han fet algunes compres per a una part de les universitats (i no per a totes com fins llavors) i s'han iniciat alguns intents d'estendre la BDC a altres institucions de recerca. L'article caracteritza les diferents fases i mostra les causes de la seva evolució. Finalment, s'exposen els principals assoliments de la BDC així com els reptes de futur més immediats.

Dynamic product diversity

The goal of this paper is to study the frequency of new product introductions in monopoly markets where demand is subject to transitory saturation. We focus on those types of goods for which consumers purchase at most one unit of each variety, but repeat purchases in the same product category. The model considers infinitely-lived, forward-looking consumers and firms. We show that the share of potential surplus that a monopolist is able to appropriate increases with the frequency of introduction of new products and the intensity of transitory saturation. If the latter is sufficiently strong then the rate of introduction of new products is higher than socially desirable (excessive dynamic product diversity.)

Life-Cycle Effects on Household Expenditures: A Latent-Variable Approach

Using data from the Spanish household budget survey, we investigate life- cycle effects on several product expenditures. A latent-variable model approach is adopted to evaluate the impact of income on expenditures, controlling for the number of members in the family. Two latent factors underlying repeated measures of monetary and non-monetary income are used as explanatory variables in the expenditure regression equations, thus avoiding possible bias associated to the measurement error in income. The proposed methodology also takes care of the case in which product expenditures exhibit a pattern of infrequent purchases. Multiple-group analysis is used to assess the variation of key parameters of the model across various household life-cycle typologies. The analysis discloses significant life-cycle effects on the mean levels of expenditures; it also detects significant life-cycle effects on the way expenditures are affected by income and family size. Asymptotic robust methods are used to account for possible non-normality of the data.

Lyfe-cycle effects on household expenditures: A latent-variable approach

Using data from the Spanish household budget survey, we investigate life-cycle effects on several product expenditures. A latent-variable model approach is adopted to evaluate the impact of income on expenditures, controlling for the number of members in the family. Two latent factors underlying repeated measures of monetary and non-monetary income are used as explanatory variables in the expenditure regression equations, thus avoiding possible bias associated to the measurement error in income. The proposed methodology also takes care of the case in which product expenditures exhibit a pattern of infrequent purchases. Multiple-group analysis is used to assess the variation of key parameters of the model across various household life-cycle typologies. The analysis discloses significant life-cycle effects on the mean levels of expenditures; it also detects significant life-cycle effects on the way expenditures are affected by income and family size. Asymptotic robust methods are used to account for possible non-normality of the data.

Optimal second-degree price discrimination and arbitrage: On the role of asymetric information among buyers

The traditional theory of monopolistic screening tackles individualself-selection but does not address the possibility that buyers couldform a coalition to coordinate their purchases and to reallocate thegoods. In this paper, we design the optimal sale mechanism which takesinto account both individual and coalition incentive compatibilityfocusing on the role of asymmetric information among buyers. We showthat when a coalition of buyers is formed under asymmetric information,the monopolist can do as well as when there is no coalition. Although inthe optimal sale mechanism marginal rates of substitution are notequalized across buyers (hence there exists room for arbitrage), theyfail to realize the gains from arbitrage because of the transaction costsin coalition formation generated by asymmetric information.

The dog that did not bark: Insider trading and crashes

This paper documents that at the individual stock level insiders sales peak many months before a large drop in the stock price, while insiders purchases peak only the month before a large jump. We provide a theoretical explanation for this phenomenon based on trading constraints and asymmetric information. We test our hypothesis against competing stories such as patterns of insider trading driven by earnings announcement dates, or insiders timing their trades to evade prosecution. Finally we provide new evidence regarding crashes and the degree of information asymmetry.

Proving the performance of a new revenue management system

Revenue management (RM) is a complicated business process that can best be described ascontrol of sales (using prices, restrictions, or capacity), usually using software as a tool to aiddecisions. RM software can play a mere informative role, supplying analysts with formatted andsummarized data who use it to make control decisions (setting a price or allocating capacity fora price point), or, play a deeper role, automating the decisions process completely, at the otherextreme. The RM models and algorithms in the academic literature by and large concentrateon the latter, completely automated, level of functionality.A firm considering using a new RM model or RM system needs to evaluate its performance.Academic papers justify the performance of their models using simulations, where customerbooking requests are simulated according to some process and model, and the revenue perfor-mance of the algorithm compared to an alternate set of algorithms. Such simulations, whilean accepted part of the academic literature, and indeed providing research insight, often lackcredibility with management. Even methodologically, they are usually awed, as the simula-tions only test \within-model" performance, and say nothing as to the appropriateness of themodel in the first place. Even simulations that test against alternate models or competition arelimited by their inherent necessity on fixing some model as the universe for their testing. Theseproblems are exacerbated with RM models that attempt to model customer purchase behav-ior or competition, as the right models for competitive actions or customer purchases remainsomewhat of a mystery, or at least with no consensus on their validity.How then to validate a model? Putting it another way, we want to show that a particularmodel or algorithm is the cause of a certain improvement to the RM process compared to theexisting process. We take care to emphasize that we want to prove the said model as the causeof performance, and to compare against a (incumbent) process rather than against an alternatemodel.In this paper we describe a \live" testing experiment that we conducted at Iberia Airlineson a set of flights. A set of competing algorithms control a set of flights during adjacentweeks, and their behavior and results are observed over a relatively long period of time (9months). In parallel, a group of control flights were managed using the traditional mix of manualand algorithmic control (incumbent system). Such \sandbox" testing, while common at manylarge internet search and e-commerce companies is relatively rare in the revenue managementarea. Sandbox testing has an undisputable model of customer behavior but the experimentaldesign and analysis of results is less clear. In this paper we describe the philosophy behind theexperiment, the organizational challenges, the design and setup of the experiment, and outlinethe analysis of the results. This paper is a complement to a (more technical) related paper thatdescribes the econometrics and statistical analysis of the results.

The dot-com bubble, the Bush deficits and the US current account

Over the past decade the US has experienced widening current account deficits and a steady deterioration of its net foreign asset position. During the second half of the 1990s, this deterioration was fueled by foreign investment in a booming US stock market. During the first half of the 2000s, this deterioration has been fuelled by foreign purchases of rapidly increasing US government debt. A somewhat surprising aspect of the current debate is thatstock market movements and fiscal policy choices have been largely treated as unrelated events. Stock market movements are usually interpreted as reflecting exogenous changes in perceived or real productivity, while budget deficits are usually understood as a mainly political decision. We challenge this view here and develop two alternative interpretations. Both are based on the notion that a bubble (the dot-com bubble) has been driving the stock market, but differ in their assumptions about the interactions between this bubble and fiscal policy (the Bush deficits). The benevolent view holds that a change in investorsentiment led to the collapse of the dot-com bubble and the Bush deficits were a welfare-improving policy response to this event. The cynical view holds instead that the Bush deficits led to the collapse of the dot-com bubble as the new administration tried to appropriate rents from foreign investors. We discuss the implications of each of these views for the future evolution of the US economy and, in particular, its net foreign asset position.

How well do individuals predict the selling prices of their homes?

Self-reported home values are widely used as a measure of housing wealth by researchers employing a variety of data sets and studying a number of different individual and household level decisions. The accuracy of this measure is an open empirical question, and requires some type of market assessment of the values reported. In this research, we study the predictive power of self-reported housing wealth when estimating sales prices utilizing the Health and Retirement Study. We find that homeowners, on average, overestimate the value of their properties by between 5% and 10%. More importantly, we are the first to document a strong correlation between accuracy and the economic conditions at the time of the purchase of the property (measured by the prevalent interest rate, the growth of household income, and the growth of median housing prices). While most individuals overestimate the value of their properties, those who bought during more difficult economic times tend to be more accurate, and in some cases even underestimate the value of their house. These results establish a surprisingly strong, likely permanent, and in many cases long-lived, effect of the initial conditions surrounding the purchases of properties, on how individuals value them. This cyclicality of the overestimation of house prices can provide some explanations for the difficulties currently faced by many homeowners, who were expecting large appreciations in home value to rescue them in case of increases in interest rates which could jeopardize their ability to live up to their financial commitments.

Stable sunspot equilibria in a cash-in-advance economy

We analyze a monetary model with flexible labor supply, cash-inadvance constraints and seigniorage-financed government deficits. If the intertemporal elasticity of substitution of labor is greater than one, there are two steady states, one determinate and the other indeterminate. If the elasticity is less than one, there is a unique steady state, which can be indeterminate. Only in the latter case do there exist sunspot equilibria that are stable under adaptive learning. A sufficient reduction in government purchases can in many cases eliminate the sunspot equilibria while raising consumption/labor taxes even enough to balance the budget may fail to achieve determinacy.

Firms vs. insiders as traders of last resort

We explore the role of corporate insiders vs. firms as traders of last resort. We develop a simple model of insider trading in which insiders provide price support, as well as liquidity, in security markets. Consistent with the model predictions we find that in the US markets insiders trading activities have a clear impact on return distributions. Furthermore, we provide empirical evidence on insiders transactions and firm transactions affecting returns in a different manner. In particular, while insiders transactions (both purchases and sales) have a strong impact on skewness in the short run and to a lesser extent in short run volatility, company repurchases only have a clear impact on volatility, both in the short and the long run. We provide explanations for this asymmetry.

A finite-population revenue management model and a risk-ratio procedure for the joint estimation of population size and parameters

Many dynamic revenue management models divide the sale period into a finite number of periods T and assume, invoking a fine-enough grid of time, that each period sees at most one booking request. These Poisson-type assumptions restrict the variability of the demand in the model, but researchers and practitioners were willing to overlook this for the benefit of tractability of the models. In this paper, we criticize this model from another angle. Estimating the discrete finite-period model poses problems of indeterminacy and non-robustness: Arbitrarily fixing T leads to arbitrary control values and on the other hand estimating T from data adds an additional layer of indeterminacy. To counter this, we first propose an alternate finite-population model that avoids this problem of fixing T and allows a wider range of demand distributions, while retaining the useful marginal-value properties of the finite-period model. The finite-population model still requires jointly estimating market size and the parameters of the customer purchase model without observing no-purchases. Estimation of market-size when no-purchases are unobservable has rarely been attempted in the marketing or revenue management literature. Indeed, we point out that it is akin to the classical statistical problem of estimating the parameters of a binomial distribution with unknown population size and success probability, and hence likely to be challenging. However, when the purchase probabilities are given by a functional form such as a multinomial-logit model, we propose an estimation heuristic that exploits the specification of the functional form, the variety of the offer sets in a typical RM setting, and qualitative knowledge of arrival rates. Finally we perform simulations to show that the estimator is very promising in obtaining unbiased estimates of population size and the model parameters.