Performance of state space and ARIMA models for consumer retail sales forecasting

Forecasting future sales is one of the most important issues that is beyond all strategic and planning decisions in effective operations of retail businesses. For profitable retail businesses, accurate demand forecasting is crucial in organizing and planning production, purchasing, transportation and labor force. Retail sales series belong to a special type of time series that typically contain trend and seasonal patterns, presenting challenges in developing effective forecasting models. This work compares the forecasting performance of state space models and ARIMA models. The forecasting performance is demonstrated through a case study of retail sales of five different categories of women footwear: Boots, Booties, Flats, Sandals and Shoes. On both methodologies the model with the minimum value of Akaike's Information Criteria for the in-sample period was selected from all admissible models for further evaluation in the out-of-sample. Both one-step and multiple-step forecasts were produced. The results show that when an automatic algorithm the overall out-of-sample forecasting performance of state space and ARIMA models evaluated via RMSE, MAE and MAPE is quite similar on both one-step and multi-step forecasts. We also conclude that state space and ARIMA produce coverage probabilities that are close to the nominal rates for both one-step and multi-step forecasts.

Modelação e previsão de vendas no setor do retalho de calçado

Dissertação apresentada ao Instituto Politécnico do Porto para obtenção do Grau de Mestre em Logística Orientada por: Professora Doutora Patrícia Alexandra Gregório Ramos

Survey of trace elements (Al, As, Cd, Cr, Co, Hg, Mn, Ni, Pb, Se, and Si) in retail samples of flavoured and bottled waters

Concentrations of eleven trace elements (Al, As, Cd, Cr, Co, Hg, Mn, Ni, Pb, Se, and Si) were measured in 39 (natural and flavoured) water samples. Determinations were performed using graphite furnace electrothermetry for almost all elements (Al, As, Cd, Cr, Co, Mn, Ni, Pb, and Si). For Se determination hydride generation was used, and cold vapour generation for Hg. These techniques were coupled to atomic absorption spectrophotometry. The trace element content of still or sparkling natural waters changed from brand to brand. Significant differences between natural still and natural sparkling waters (p<0.001) were only apparent for Mn. The Mann–Whitney U-test was used to search for significant differences between flavoured and natural waters. The concentration of each element was compared with the presence of flavours, preservatives, acidifying agents, fruit juice and/or sweeteners, according to the labelled composition. It was shown that flavoured waters generally increase the trace element content. The addition of preservatives and acidifying regulators had a significant influence on Mn, Co, As and Si contents (p<0.05). Fruit juice can also be correlated to the increase of Co and As. Sweeteners did not provide any significant difference in Mn, Co, Se and Si content.

Re-use assessment of thermoset composite wastes as aggregate and filler replacement for concrete-polymer composite materials: a case study regarding GFRP pultrusion wastes

Glass fibre-reinforced plastics (GFRP), nowadays commonly used in the construction, transportation and automobile sectors, have been considered inherently difficult to recycle due to both the cross-linked nature of thermoset resins, which cannot be remoulded, and the complex composition of the composite itself, which includes glass fibres, polymer matrix and different types of inorganic fillers. Hence, to date, most of the thermoset based GFRP waste is being incinerated or landfilled leading to negative environmental impacts and additional costs to producers and suppliers. With an increasing awareness of environmental matters and the subsequent desire to save resources, recycling would convert an expensive waste disposal into a profitable reusable material. In this study, the effect of the incorporation of mechanically recycled GFRP pultrusion wastes on flexural and compressive behaviour of polyester polymer mortars (PM) was assessed. For this purpose, different contents of GFRP recyclates (0%, 4%, 8% and 12%, w/w), with distinct size grades (coarse fibrous mixture and fine powdered mixture), were incorporated into polyester PM as sand aggregates and filler replacements. The effect of the incorporation of a silane coupling agent was also assessed. Experimental results revealed that GFRP waste filled polymer mortars show improved mechanical behaviour over unmodified polyester based mortars, thus indicating the feasibility of GFRP waste reuse as raw material in concrete-polymer composites.

Efficient aggregate computations in large-scale dense WSN

We focus on large-scale and dense deeply embedded systems where, due to the large amount of information generated by all nodes, even simple aggregate computations such as the minimum value (MIN) of the sensor readings become notoriously expensive to obtain. Recent research has exploited a dominance-based medium access control(MAC) protocol, the CAN bus, for computing aggregated quantities in wired systems. For example, MIN can be computed efficiently and an interpolation function which approximates sensor data in an area can be obtained efficiently as well. Dominance-based MAC protocols have recently been proposed for wireless channels and these protocols can be expected to be used for achieving highly scalable aggregate computations in wireless systems. But no experimental demonstration is currently available in the research literature. In this paper, we demonstrate that highly scalable aggregate computations in wireless networks are possible. We do so by (i) building a new wireless hardware platform with appropriate characteristics for making dominance-based MAC protocols efficient, (ii) implementing dominance-based MAC protocols on this platform, (iii) implementing distributed algorithms for aggregate computations (MIN, MAX, Interpolation) using the new implementation of the dominance-based MAC protocol and (iv) performing experiments to prove that such highly scalable aggregate computations in wireless networks are possible.

Highly scalable aggregate computations in cyber-physical systems: physical environment meets communication protocols

In this paper, we focus on large-scale and dense Cyber- Physical Systems, and discuss methods that tightly integrate communication and computing with the underlying physical environment. We present Physical Dynamic Priority Dominance ((PD)2) protocol that exemplifies a key mechanism to devise low time-complexity communication protocols for large-scale networked sensor systems. We show that using this mechanism, one can compute aggregate quantities such as the maximum or minimum of sensor readings in a time-complexity that is equivalent to essentially one message exchange. We also illustrate the use of this mechanism in a more complex task of computing the interpolation of smooth as well as non-smooth sensor data in very low timecomplexity.

Gestão da cadeia de abastecimento de bens de consumo baseada em modelos de previsão lineares

Dissertação apresentada ao Instituto Politécnico do Porto para obtenção do Grau de Mestre em Logística

Osteoporotic hip fractures: Bisphosphonates sales and observed turning point in trend. A population-based retrospective study

The aim is to examine the temporal trends of hip fracture incidence in Portugal by sex and age groups, and explore the relation with anti-osteoporotic medication. From the National Hospital Discharge Database, we selected from 1st January 2000 to 31st December 2008, 77,083 hospital admissions (77.4% women) caused by osteoporotic hip fractures (low energy, patients over 49 years-age), with diagnosis codes 820.x of ICD 9-CM. The 2001 Portuguese population was used as standard to calculate direct age-standardized incidence rates (ASIR) (100,000 inhabitants). Generalized additive and linear models were used to evaluate and quantify temporal trends of age specific rates (AR), by sex. We identified 2003 as a turning point in the trend of ASIR of hip fractures in women. After 2003, the ASIR in women decreased on average by 10.3 cases/100,000 inhabitants, 95% CI (− 15.7 to − 4.8), per 100,000 anti-osteoporotic medication packages sold. For women aged 65–69 and 75–79 we identified the same turning point. However, for women aged over 80, the year 2004 marked a change in the trend, from an increase to a decrease. Among the population aged 70–74 a linear decrease of incidence rate (95% CI) was observed in both sexes, higher for women: − 28.0% (− 36.2 to − 19.5) change vs − 18.8%, (− 32.6 to − 2.3). The abrupt turning point in the trend of ASIR of hip fractures in women is compatible with an intervention, such as a medication. The trends were different according to gender and age group, but compatible with the pattern of bisphosphonates sales.

Re-Use Assessment of Thermoset Composite Wastes as Aggregate and Filler Replacement for Concrete-Polymer Composite Materials: A case study regarding GFRP pultrusion wastes

Glass fibre-reinforced plastics (GFRP), nowadays commonly used in the construction, transportation and automobile sectors, have been considered inherently difficult to recycle due to both the cross-linked nature of thermoset resins, which cannot be remoulded, and the complex composition of the composite itself, which includes glass fibres, polymer matrix and different types of inorganic fillers. Hence, to date, most of the thermoset based GFRP waste is being incinerated or landfilled leading to negative environmental impacts and additional costs to producers and suppliers. With an increasing awareness of environmental matters and the subsequent desire to save resources, recycling would convert an expensive waste disposal into a profitable reusable material. In this study, the effect of the incorporation of mechanically recycled GFRP pultrusion wastes on flexural and compressive behaviour of polyester polymer mortars (PM) was assessed. For this purpose, different contents of GFRP recyclates (0%, 4%, 8% and 12%, w/w), with distinct size grades (coarse fibrous mixture and fine powdered mixture), were incorporated into polyester PM as sand aggregates and filler replacements. The effect of the incorporation of a silane coupling agent was also assessed. Experimental results revealed that GFRP waste filled polymer mortars show improved mechanical behaviour over unmodified polyester based mortars, thus indicating the feasibility of GFRP waste reuse as raw material in concrete-polymer composites.

Significance of Biogenic Amines in Cold-Smoked Fish and Their Relation to Microbiological Characteristics of Products Available in Portuguese Retail Markets

Studies on microbial characterization of cold-smoked salmon and salmon trout during cold storage were performed on samples available in the Portuguese market. Samples were also classified microbiologically according to guidelines for ready-to-eat (RTE) products. Further investigations on sample variability and microbial abilities to produce tyramine and histamine were also performed. The coefficient of variation for viable counts of different groups of microorganisms of samples collected at retail market point was high in the first 2 wk of storage, mainly in the Enterobacteriaceae group and aerobic plate count (APC), suggesting that microbiological characteristics of samples were different in numbers, even within the same batch from the same producer. This variation seemed to be decreased when storage and temperature were controlled under lab conditions. The numbers of Enterobacteriaceae were influenced by storage temperature, as indicated by low microbial numbers in samples from controlled refrigeration. Lactic acid bacteria (LAB) and Enterobacteriaceae were predominant in commercial products, a significant percentage of which were tyramine and less histamine producers. These results might be influenced by (1) the technological processes in the early stages of production, (2) contamination during the smoking process, and (3) conditions and temperature fluctuations during cold storage at retail market point of sale.

Criação e atualização de aplicações para área de retalho por MDA

Nos últimos anos tem-se verificado a constante evolução dos mercados em plataformas na Internet como forma de melhoria não só dos serviços prestados, mas também para o aumento de vendas de produtos e respetiva internacionalização dos mesmos. Este aumento da procura por este tipo de softwares, assim como a constante evolução e atualização dos mesmos tem contribuído para que estas aplicações evoluam em termos de funcionalidades e complexidade. Isto contribui cada vez para a dificuldade de formar equipas capazes de manter e desenvolver estes sistemas sem que comprometa em grandes custos para as organizações. Neste sentido surgiram diversas ferramentas que permitem criar soluções pré desenvolvidas de aplicações na Internet denominadas de "E-commerce applications". Estas plataformas, apesar do utilizador não ter obrigatoriamente que deter conhecimentos de programação para proceder à sua instalação, são bastante restritas tanto aos serviços que podem ser usados, e na sua escalabilidade, visto que normalmente correm em servidores específicos e por vezes as configurações necessárias para instalação tornam-se bastante complexas de ser efetuadas. Pretende-se no âmbito desta dissertação de mestrado propor um modelo de uma arquitetura de um sistema baseado em mecanismos MDA para a área de retalho, particularmente em ambientes de e-commerce. Serão inicialmente sistematizados os principais tipos de ecommerce numa perspetiva de evolução histórica. Será igualmente enquadrado o MDA no desenvolvimento de um sistema de e-commerce. Neste sentido, serão equacionadas as diferenças entre o modelo típico de desenvolvimento de software e o desenvolvimento de software orientado pelas metodologias do MDA. No processo de especificação e desenvolvimento do modelo proposto será realizada uma análise de requisitos, assim como, a proposta do modelo da arquitetura de um sistema baseado em mecanismos MDA, tendo como orientação os requisitos e arquitetura definida na fase de análise. Finalmente no sentido de analisar o resultado esperado para um sistema orientado por metodologias definidas por MDA, serão realizado alguns testes no sistema desenvolvido de forma a analisar o seu desempenho e validar a sua adequabilidade no âmbito do processo de desenvolvimento de sistemas e-commerce

Análise e implementação de melhorias no serviço Pós-Venda na área automóvel

No âmbito da unidade curricular de Dissertação/Projeto/Estágio, pertencente ao segundo ano do Mestrado em Engenharia Mecânica – Ramo de Gestão Industrial do Instituto Superior de Engenharia do Porto, o presente trabalho foi desenvolvido no Grupo JAP, Grupo do setor automóvel, desenvolvido especificamente no serviço pós-venda. Numa realidade bastante diferente de outros tempos onde havia grandes margens com a venda de produtos, hoje a realidade é bem diferente. Num contexto de competição global onde as margens são mais reduzidas, o serviço pós-venda, onde o cliente é acompanhado desde da compra até o fim de vida do produto, constitui uma fonte de receitas relevante bem como um diferenciador chave dentre as empresas de revenda automóvel. Por estas razões, são cada vez mais as empresas que seguem a filosofia Lean, orientando toda a sua estrutura produtiva no sentido de atingir zero desperdícios, sem interferir com a qualidade do produto final. A realização deste projeto teve como objetivo o desenvolvimento e adequação de ferramentas de melhoria e apoio ao serviço pós-venda no Grupo. Com a elaboração deste trabalho, pretende-se fazer uma análise a todo o processo do serviço pós-venda, identificando os problemas que ocorrem ao longo do processo e desenvolver um plano de ações de melhoria, utilizando para isso as ferramentas da metodologia Lean. Em primeiro lugar, fez-se uma análise do processo do serviço pós-venda e do serviço do armazém de peças, onde foram identificados alguns pontos de melhoria e recolhidos as primeiras informações para uma análise mais aprofundada de cada problema. Posteriormente, estabeleceu-se um plano de ações para eliminar ou minimizar os desperdícios encontrados no processo, aumentar a produtividade e a qualidade do serviço prestado ao cliente, e procedeu-se à implementação das melhorias. Após a implementação das melhorias, fez-se uma avaliação das mesmas e constatou-se um aumento de produtividade, uma redução de desperdícios e um aumento dos índices de qualidade. Em suma uma melhoria no serviço prestado ao cliente.

Sistema de apoio à decisão para o reaprovisionamento intercontinental

Este estudo foi desenvolvido em contexto empresarial e apresenta o levantamento de uma oportunidade de melhoria conjunta nos processos de gestão de stocks, compras e logística com o objetivo de otimizar a seleção e envio dos artigos com necessidade de reposição. O caso de estudo apresentado neste documento retrata o circuito logístico entre uma empresa sediada em Angola e outra em Portugal. A primeira dedica-se à venda por grosso e a retalho que é fornecida pela segunda, onde também está concentrada a gestão de aprovisionamento. Integrando uma sociedade menos desenvolvida como Angola, a delicadeza e complexidade dos problemas associam-se à incerteza, tornando um ambiente propício para a identificação e implantação de melhorias nos processos de decisão, colmatando a dependência de apoio em sistemas e serviços externos. Com uma logística de abastecimento intercontinental, a seleção e envio de mercadoria é uma preocupação dos gestores, uma vez que o tempo de fornecimento é longo e poderá afetar a performance das vendas caso seja uma decisão não sustentada. Com o foco no apoio à decisão, desenvolveu-se uma ferramenta que incorpora os detalhes da atividade empresarial que permite selecionar os artigos para reposição, maximizando o seu potencial valor de vendas.