Improvement on the sales forecast accuracy for a fast growing company by the best combination of historical data usage and clients segmentation

Industrial companies in developing countries are facing rapid growths, and this requires having in place the best organizational processes to cope with the market demand. Sales forecasting, as a tool aligned with the general strategy of the company, needs to be as much accurate as possible, in order to achieve the sales targets by making available the right information for purchasing, planning and control of production areas, and finally attending in time and form the demand generated. The present dissertation uses a single case study from the subsidiary of an international explosives company based in Brazil, Maxam, experiencing high growth in sales, and therefore facing the challenge to adequate its structure and processes properly for the rapid growth expected. Diverse sales forecast techniques have been analyzed to compare the actual monthly sales forecast, based on the sales force representatives’ market knowledge, with forecasts based on the analysis of historical sales data. The dissertation findings show how the combination of both qualitative and quantitative forecasts, by the creation of a combined forecast that considers both client´s demand knowledge from the sales workforce with time series analysis, leads to the improvement on the accuracy of the company´s sales forecast.

Effect of price and in-store promotion on sales: a study of distinct regions in an emerging market

Increasing competition caused by globalization, high growth of some emerging markets and stagnation of developed economies motivate Consumer Packaged Goods (CPGs) manufacturers to drive their attention to emerging markets. These companies are expected to adapt their marketing activities to the particularities of these markets in order to succeed. In a country classified as emerging market, regions are not alike and some contrasts can be identified. In addition, divergences of marketing variables effect can also be observed in the different retail formats. The retail formats in emerging markets can be segregated in chain self-service and traditional full-service. Thus, understanding the effectiveness of marketing mix not only in country aggregated level data can be an important contribution. Inasmuch as companies aim to generate profits from emerging markets, price is an important marketing variable in the process of creating competitive advantage. Along with price, promotional variables such as in-store displays and price cut are often viewed as temporary incentives to increase short-term sales. Managers defend the usage of promotions as being the most reliable and fastest manner to increase sales and then short-term profits. However, some authors alert about sales promotions disadvantages; mainly in the long-term. This study investigates the effect of price and in-store promotions on sales volume in different regions within an emerging market. The database used is at SKU level for juice, being segregated in the Brazilian northeast and southeast regions and corresponding to the period from January 2011 to January 2013. The methodological approach is descriptive quantitative involving validation tests, application of multivariate and temporal series analysis method. The Vector-Autoregressive (VAR) model was used to perform the analysis. Results suggest similar price sensitivity in the northeast and southeast region and greater in-store promotion sensitivity in the northeast. Price reductions show negative results in the long-term (persistent sales in six months) and in-store promotion, positive results. In-store promotion shows no significant influence on sales in chain self-service stores while price demonstrates no relevant impact on sales in traditional full-service stores. Hence, this study contributes to the business environment for companies wishing to manage price and sales promotions for consumer brands in regions with different features within an emerging market. As a theoretical contribution, this study fills an academic gap providing a dedicated price and sales promotion study to contrast regions in an emerging market.

Derechos aduaneros vigentes en los países centroamericanos sobre las principales materias primas y productos terminados de ácidos alquilaril sulfónicos, alquilaril sulfonatos y otras sales de ácidos de alquilaril sulfónicos y lustradores-limpiadores para zapatos

Incluye Bibliografía

A New Method to Predict the Epidemiology of Fungal Keratitis by Monitoring the Sales Distribution of Antifungal Eye Drops in Brazil

Purpose: Fungi are a major cause of keratitis, although few medications are licensed for their treatment. The aim of this study is to observe the variation in commercialisation of antifungal eye drops, and to predict the seasonal distribution of fungal keratitis in Brazil. Methods: Data from a retrospective study of antifungal eye drops sales from the only pharmaceutical ophthalmologic laboratory, authorized to dispense them in Brazil (Opthalmos) were gathered. These data were correlated with geographic and seasonal distribution of fungal keratitis in Brazil between July 2002 and June 2008. Results: A total of 26,087 antifungal eye drop units were sold, with a mean of 2.3 per patient. There was significant variation in antifungal sales during the year (p < 0.01). A linear regression model displayed a significant association between reduced relative humidity and antifungal drug sales (R-2 = 0.17, p < 0.01). Conclusions: Antifungal eye drops sales suggest that there is a seasonal distribution of fungal keratitis. A possible interpretation is that the third quarter of the year (a period when the climate is drier), when agricultural activity is more intense in Brazil, suggests a correlation with a higher incidence of fungal keratitis. A similar model could be applied to other diseases, that are managed with unique, or few, and monitorable medications to predict epidemiological aspects.

Customer Evolution in Sales Channel Migration

This research has been triggered by an emergent trend in customer behavior: customers have rapidly expanded their channel experiences and preferences beyond traditional channels (such as stores) and they expect the company with which they do business to have a presence on all these channels. This evidence has produced an increasing interest in multichannel customer behavior and it has motivated several researchers to study the customers’ channel choices dynamics in multichannel environment. We study how the consumer decision process for channel choice and response to marketing communications evolves for a cohort of new customers. We assume a newly acquired customer’s decisions are described by a “trial” model, but the customer’s choice process evolves to a “post-trial” model as the customer learns his or her preferences and becomes familiar with the firm’s marketing efforts. The trial and post-trial decision processes are each described by different multinomial logit choice models, and the evolution from the trial to post-trial model is determined by a customer-level geometric distribution that captures the time it takes for the customer to make the transition. We utilize data for a major retailer who sells in three channels – retail store, the Internet, and via catalog. The model is estimated using Bayesian methods that allow for cross-customer heterogeneity. This allows us to have distinct parameters estimates for a trial and an after trial stages and to estimate the quickness of this transit at the individual level. The results show for example that the customer decision process indeed does evolve over time. Customers differ in the duration of the trial period and marketing has a different impact on channel choice in the trial and post-trial stages. Furthermore, we show that some people switch channel decision processes while others don’t and we found that several factors have an impact on the probability to switch decision process. Insights from this study can help managers tailor their marketing communication strategy as customers gain channel choice experience. Managers may also have insights on the timing of the direct marketing communications. They can predict the duration of the trial phase at individual level detecting the customers with a quick, long or even absent trial phase. They can even predict if the customer will change or not his decision process over time, and they can influence the switching process using specific marketing tools

Aggregazione delle query per sistemi pub/sub: il progetto SALES

I sistemi mobili rappresentano una classe di sistemi distribuiti caratterizzata dalla presenza di dispositivi portatili eterogenei quali PDA, laptop e telefoni cellulari che interagiscono tra loro mediante una rete di interconnessione wireless. Una classe di sistemi mobili di particolare interesse è costituita dai sistemi basati sul modello di interazione publish/subscribe. Secondo tale schema, i nodi all'interno di una rete possono assumere due ruoli differenti: i produttori di informazione, chiamati publisher, ed i consumatori di informazione, chiamati subscriber. Tipicamente, l'interazione tra essi è mediata da un gestore di eventi che indirizza correttamente le informazioni ricevute dai publisher verso i subscriber interessati, sulla base degli interessi espressi da questi ultimi tramite sottoscrizioni. Nella progettazione di sistemi mobili, a differenza di quelli tradizionali basati su nodi fissi, bisogna tenere conto di problemi quali la scarsa capacità computazionale dei dispositivi e la limitata larghezza di banda delle reti wireless. All'interno di tale ambito, stanno recentemente assumendo sempre maggiore importanza i sistemi context-aware, ovvero sistemi mobili che sfruttano i dati provenienti dall'ambiente circostante e dai dispositivi stessi per adattare il proprio comportamento e notificare agli utenti la presenza di informazioni potenzialmente utili. Nello studio di questi sistemi, si è notato che i nodi che si trovano nella stessa area geografica generano tipicamente delle sottoscrizioni che presentano tra loro un certo grado di similarità e coperture parziali o totali. Il gruppo di ricerca del DEIS dell’Università di Bologna ha sviluppato un'infrastruttura di supporto per sistemi mobili context-aware, chiamata SALES. Attualmente il sistema progettato non considera le similarità delle sottoscrizioni e quindi non sfrutta opportunamente tale informazione. In questo contesto si rende necessario l'adozione di opportune tecniche di aggregazione delle sottoscrizioni atte ad alleggerire la computazione dei nodi mobili e le comunicazioni tra loro. Il lavoro presentato in questa tesi sarà finalizzato alla ricerca, all'adattamento ed all'implementazione di una tecnica di aggregazione delle sottoscrizioni. Tale tecnica avrà lo scopo di rilevare e sfruttare le similarità delle sottoscrizioni ricevute dal sistema al fine di ridurne il numero; in questo modo, quando un nodo riceverà un dato, il processo di confronto tra l'insieme delle sottoscrizioni memorizzate e il dato ricevuto sarà più leggero, consentendo un risparmio di risorse computazionali. Inoltre, adattando tali tecniche, sarà possibile modulare anche il traffico dati scaturito dalle risposte alle sottoscrizioni. La struttura di questa tesi prevede un primo capitolo sui sistemi context-aware, descrivendone le principali caratteristiche e mettendo in luce le problematiche ad essi associate. Il secondo capitolo illustra il modello di comunicazione Publish/Subscribe, modello di riferimento per i moderni sistemi context-aware e per i sistemi mobili in generale. Il terzo capitolo descrive l'infrastruttura SALES sulla quale si è progettata, implementata e testata la soluzione proposta in questa tesi. Il quarto capitolo presenta le principali tecniche di aggregazione delle sottoscrizioni e spiega come possono essere adattate al contesto di questa tesi. Il quinto capitolo effettua l'analisi dei requisiti per comprendere meglio il comportamento della soluzione; seguono la progettazione e l’implementazione della soluzione su SALES. Infine, il sesto capitolo riporta in dettaglio i risultati ottenuti da alcuni degli esperimenti effettuati e vengono messi a confronto con quelli rilevati dal sistema di partenza.

« … Quatre sales enfants métisses ... » - Colonisation par adaptation ? Le cas de Yaoundé.

The article wants to describe, how far colonial administration accepted to adopt local policies of colonized societies. The case study is about the early years of the Jaunde station in German Kamerun. / Le présent article pose la question de savoir jusqu’à quel niveau le pouvoir colonial allemand a été prêt à s'adapter à la situation sociale qu'il a trouvé sur place. La question est traitée à l'exemple de l'histoire du poste de Jaunde (Yaoundé) au Kamerun allemand. // Cameroun (1884-1916), Yaoundé, Georg August Zenker (1855-1922), Richard Kund (1852–1904), Hans Tappenbeck (1861-1889), Kurt von Morgen (1858-1928), Hans Dominik (1870-1910), Essono Ela, Omgba Bisogo, Jaunde, Kamerun, Colonisation allemande

Meeting the nutritional requirements of hospitalized patients: an interdisciplinary approach to hospital catering

The study served to assure the quality of our catering, to locate problems, and to define further optimization measures at the Bern University Hospital. The main objective was to investigate whether the macronutrient and energy content of the hospital food complies with the nutritional value calculated from recipes as well as with the recommendations issued by the German Nutrition Society (DGE).