For more than a year, COVID-19 has changed societies all over the world and put massive strains on its healthcare systems. In an attempt to aid in prioritizing medical resources, this thesis uses dynamic regression with ARIMA errors to forecast the number of hospitalizations related to COVID-19 two weeks ahead in Uppsala County. For this purpose, 100 models are created and their ability to forecast hospitalizations two weeks ahead for weeks 15-17 of 2021 for the different municipalities in Uppsala County is evaluated using root mean squared error (RMSE), mean absolute error (MAE), and mean absolute percentage error (MAPE). The best performing models are then utilized to forecast hospitalizations for weeks 19-22. The results show that the models perform well during periods of increasing numbers of hospitalizations during early 2021, while they perform less well during the last weeks of May 2021 where hospitalizations numbers have been falling dramatically. This recent decrease in forecasting performance is believed to be caused by an increase in vaccination coverage, which is not accounted for in the models.

Background Forecasts are used as a basis for decision making and they mainly affect decisions at strategic and tactical levels in a company or organization. There are two different methods to perform forecasts. The first one is a qualitative method where a n expert or group of experts tell about the future. The second one is a quantitative method where forecast are produced by mathematical and statistical models. This study used a quantitative method to build a forecast model and took into account external f actors in forecasting the sales volume of Bosch Rexroth’s hydraulic motors. There is a very wide range of external factors and only a limited selection had been analyzed in this study. The selection of the variables was based on the markets where Bosch Rexroth products are used, such as mining. Purpose This study aimed to develop five predictive models: one model for the global sales volume, one model each for sales volume in USA and China and one model each for sales volume of CA engine and Viking engine. By identifying external factors that showed significant relationship in various time lags with Bosch Rexroth’s sales volume, the forecasts 2016 and 2017 were produced. Methods The study used a combination of multiple linear regression and a Box - Jenkins AR MA errors to analyze the association of external factors and to produce forecasts. Externa l factors such as commodity prices, inflation and exchange rates between different currencies were taken into account. By using a cross - correlation function between external factors and the sales volume, significant external factors in different time lags were identified and then put into the model. The forecasting method used is a Causal forecasting model. Conclusions The global sales volume of Bosch Rexroth turned out to be affected by the historical price of copper in three different time lags , one, six and seven months . From 2010 to 2015, the copper price have been continuously dropping which explain s the downward trend of the sales volume. The sales volume in The U SA showed a significant association by the price of coal with three and four time lags. This means that the change of coal price takes three and four months before it affects the sales volume in the USA. The market in China showed to be affected by the development of the price of silver. The volume of sales is affected by the price of silver by four and six time lags. CA engine also displayed association with the price of copper at the same time lags as in the global sales volume. On the other hand, Viking engine showed no significant association at all with any of the external factors that were analyzed in this study. The forecast for global mean sales volume will be between 253 to 309 units a month for May 2016 – December 2017. Mean sales volume in USA projected to be in between 24 to 32 units per month. China's mean sales volume is expected to be in between 42 to 81 units a month. Mean sales volume of CA engine has a forecast of 175 to 212 units a month. While the mean s ales of Viking engine projected to stay in a constant volume of 25 units per month.

[pt] O transporte marítimo de petróleo e derivados é componente fundamental da cadeia de suprimento da indústria do petróleo, integrando fornecedores e clientes localizados em regiões geográficas distintas. Neste contexto, os valores de fretes praticados possuem grande impacto no comércio internacional destes bens. O objetivo deste trabalho é verificar o desempenho de modelos de Regressão Dinâmica em previsões de frete marítimo de curto prazo do mercado spot de uma rota de exportação de petróleo do oeste da África para a China, comparar a capacidade preditiva do modelo com métodos tradicionais, vastamente discutidos na literatura, como Amortecimento Exponencial e modelos ARIMA e projetar cenários para avaliar como as variáveis explicativas presentes no modelo de Regressão Dinâmica proposto neste estudo afetam o frete marítimo. O produto desenvolvido nesta dissertação mostrou a viabilidade de os modelos univariados e causais serem utilizados como ferramenta de previsão da taxa frete de navios petroleiros. Como forma de validação, os resultados foram comparados aos obtidos com a metodologia vigente em uma grande empresa de petróleo do Brasil. O protótipo de sistema de previsão proposto, via Regressão Dinâmica, apresentou resultados satisfatórios e desempenho superior ao obtido através da metodologia da empresa de petróleo. / [en] Crude oil and oil products seaborne transportation is a key component of the petroleum industry supply chain, integrating suppliers and customers located in different geographic regions. In this context, the freight rates practiced have a great impact on the international trade of these goods. This work aims to verify the performance of Dynamic Regression models in short-term maritime freight forecasts of the spot market of an oil export route from West Africa to China, to compare the predictive capacity of the model with traditional methods, widely discussed in the literature, such as Exponential Smoothing and ARIMA models and to design scenarios to evaluate how the explanatory variables present in the Dynamic Regression model proposed in this study affect freight rate. The product developed in this dissertation showed the viability of the univariate and causal models being used as a forecasting tool for the oil tankers freight rate. As a form of validation, the results were compared to those obtained with the methodology of a large Brazilian oil company. The proposed prediction system prototype, through Dynamic Regression model, presented satisfactory results and performance superior to that obtained through the methodology of the oil company.

[pt] O mercado de smartphones é muito sensível a preços devido à alta competitividade comercial e à constante evolução tecnológica. A elasticidade de preços e a elasticidade cruzada são fundamentais para ajustes de previsões de vendas para evitar rupturas e/ou altos volumes de estoques. Este trabalho apresenta uma proposta de modelagem para cálculo de elasticidade de preços e elasticidade cruzada utilizando variáveis causais abordando aspectos internos e externos de uma empresa operadora de serviços de telecomunicações com várias lojas próprias. A escolha das variáveis é resultante da parceria entre profissionais de Logística, Marketing e Vendas fornecendo apoio técnico aos Planejadores de Demanda. Para se calcular a elasticidade de preços, a modelagem baseada em Regressão Dinâmica indicou utilização das variáveis: preços de concorrentes internos (representando a canibalização), disponibilidade (para lançamento e phase-out de produtos), loja aberta (diferenciando dos dias de lojas fechadas com vendas nula) e fator diário (cadenciando as vendas diárias), proporcionando resultados satisfatórios e demonstrando aplicabilidade comercial do modelo proposto. / [en] The smartphone market is very price sensitive due to high commercial competitiveness and constant technological evolution. Price elasticity and cross-elasticity are critical for adjusting sales forecasts to avoid disruptions and / or high inventory volumes. This work presents a modeling proposal for calculation of price elasticity and cross elasticity using causal variables, addressing the internal and external aspects of a telecommunications service operator with several own stores. The variable s choice is the result of a partnership between professionals in Logistics, Marketing and Sales providing technical support to Demand Planners. In order to calculate price elasticity, modeling based on dynamic regression indicated the use of variables: internal competitors prices (typifying cannibalization), availability (for launching and phase-out of products), open store (differentiating from the days of closed stores with zero sales) and daily factor (daily sales rhythm), providing satisfactory results and demonstrating commercial applicability of the proposed model.

This thesis aims to fit and compare different time series models namely the ARIMA-model, conditional heteroscedastic models and lastly a dynamic regression model with ARIMA error to Bitcoin closing price data that spans over 5 consecutive years. The purpose is to evaluate if the sanction on Russia had any effect on the cryptocurrency Bitcoin. After giving a very brief introduction to time series models and the nature of the error term, we describe the models that we want to compare. Quite early in on, autocorrelation was detected and that the time series were nonstationary. Additionally, as we are dealing with financial data, we found that the best alternative was to transform the data into logarithmic return and we then took the first difference. As we then detected a very large outlier, we decided to replace the extreme value with the mean of the two adjacent observations as we suspected it would affect the forecast interval. The dataset with first differenced log-returns was used in the ARIMA model but it turned out that there was no autocorrelation which indicated that returns in financial assets are uncorrelated across time and therefore unpredictable. The conditional heteroscedastic models, the ARCH and the GARCH models turned out to be best suitable for our data, as there was an ARCH-effect present. We could conclude that the GARCH(1,1) model using student t-distribution had the best fit, which had the lowest AIC and the highest log likelihood. In order to study the effect of the sanctions on Bitcoin volatility a dynamic regression model was used by allowing the error term to contain autocorrelation and include an independent dummy variable. The model showed that the Russian invasion of Ukraine did not, surprisingly, have any effect on the Bitcoin closing price.

[pt] O objetivo do presente trabalho é a geração de uma série mensal de carga elétrica livre das variações de calendário e de temperatura. Para tal, foram comparadas duas abordagens, uma totalmente empírica e outra híbrida com métodos empíricos e modelagens de regressão dinâmica, para identificar a mais adequada para a retirada desses ofensores. Os dados utilizados são provenientes de observações diárias de cada um dos quatro subsistemas que integram o Sistema Interligado Nacional (SIN), porém a ideia é produzir séries mensais do SIN e não apenas de cada um dos subsistemas. A série trimestral do PIB foi utilizada para decidir qual abordagem melhor ajustou os dados de Carga. A série mensal de carga ajustada do SIN será utilizada para subsidiar decisões, de compra e venda de energia nos leilões, das empresas distribuidoras de energia elétrica. / [en] This thesis proposes a method to generate monthly load series free of variations coming from two sources: calendar and temperature. Two approaches were considered, one totally empirical and another one called hybrid, as it use empirical procedure to remove the calendar effect and a dynamic regression type of model to remove the temperature effects. The data set used comes found to daily observations from each one of the four subsystems that form the SIN (Brazilian Integrated Grid). However the final task is to obtain a unique monthly series for the SIN and not only the four subsystems monthly series. The quarterly PIB series was used to check the performance of the two proposed methods. Such adjusted series are quite important tools to hold on the decision of acquisitions and dailes of energy in the energy audits.

[pt] Esta dissertação tem como objetivo principal a proposição de modelos para previsão, em um curto prazo, do número de processos que são ajuizados em desfavor de uma empresa do setor elétrico. A metodologia utilizada consiste em, a partir de uma análise exploratória dos dados, construir modelos usando uma estratégia bottom-up, ou seja, parte-se de um modelo simples e processa-se seu refinamento até encontrar um modelo apropriado que mais se adeque à realidade. Partiu-se então de um modelo auto projetivo indo até uma formulação de um modelo de regressão dinâmica. Os modelos são então comparados segundo alguns critérios, basicamente no que tange à sua eficiência preditiva. Conclui-se ao final sobre a eficiência de se utilizar modelos de regressão dinâmica para este tipo de previsão tendo em vista a presença de correlação serial dos resíduos, comumente presentes nas séries econômicas. Propõe-se, ao final, uma ferramenta para, a partir dos valores estimados, analisar a viabilidade econômica de estimular ou desestimular as medidas responsáveis pela geração de processos contra a empresa. / [en] The aim of this dissertation is to develop short term models to forecast the number of judicial process in electric sector companies. From the methodology point of view, data is analyzed and models using bottom-up strategy is developed. In other words, a simple model is improved step by step until a proper model that fits well the reality is found. From a univariate model it ends up in a dynamic regression model. The models obtained in this study are compared according to some criterion, mainly forecast accuracy. In the end the conclusion is about the efficiency of dynamic regression models for this kind of forecast, which one presents data with serial correlation of residues, commonly present in economic series. In the end, from the estimated values, it´s proposed a mechanism to analyze the economic viability, to encourage or not, actions which are responsible for instigating judicial processes against the company.

The scarce resources of public health makes the administrator manage the destination of resources, aiming to rationalize and optimize its collection, in order to improve the assistance to patients because the hospital is a public institution and does not get profits but promotes the community well-being. Thus, the hospital infection is acquired after the patient comes to the hospital of after he goes home and might be associated with his staying in hospital or with hospital procedures. This cost must be avoided. Once the complete eradication is not impossible, it is necessary to analyze and to control the monthly cost of the main antibiotics used for its treatment so that there is enough knowledge to foresee the resource collection to buy them. In this context, the main reason of this research is to carry out a forecast of the monthly cost and of the resource collection needed to purchase those medicine used in the treatment of hospital infections at the University Hospital of Santa Maria. To do so, a methodology for forecast by dynamic and multiple linear regressions was used. They were combined with to a multivariate technique by principal components. The technique of principal components was used to eliminate the multiple linearity existing among the original variants so, the resulting principal components were used as variables in the construction of the model of multiple linear regression and of dynamic regression. Therefore, these methodologies are applied to a case study of public health, in order to foresee and to conclude about which model is more suitable to forecast the monthly cost of antibiotics in hospital infections. The results obtained from the two models were considered satisfactory but the model of dynamic regression was chosen to be more suitable because it presented a mean absolute percentage error (MAPE). Finally, the findings might be a managerial tool for hospital administration when they offer subsides for the budget of planning and of the resource finances, especially in a time when resources are globally scarce, making health even more expensive. / Os escassos recursos da saúde pública impõem ao administrador gerenciar a destinação dos recursos buscando racionalizar e otimizar sua alocação, permitindo, desta forma, melhorar o atendimento aos pacientes, pois o hospital, sendo uma entidade pública, não tem por objetivo o lucro, mas sim promover o bem estar da comunidade. Com isso, a infecção hospitalar que é adquirida após a internação do paciente e se manifesta durante a internação ou mesmo após a alta, podendo ser relacionada com a internação ou procedimentos hospitalares, deve ser evitada. Uma vez que sua total erradicação não é possível, se faz necessário analisar e controlar o custo mensal dos principais antibióticos utilizados no seu tratamento a fim de se ter embasamento suficiente para prever a alocação de recursos para sua aquisição. Nesse contexto, o principal objetivo desta pesquisa é realizar a previsão do custo mensal e de alocação de recursos necessários para aquisição de medicamentos utilizados no tratamento de infecções hospitalares no Hospital Universitário de Santa Maria. Para isso, utilizou-se a metodologia de previsão por regressão linear múltipla e de regressão dinâmica combinada com a técnica multivariada de componentes principais que foi utilizada para eliminar a multicolinearidade existente entre as variáveis originais. Com isso, as componentes principais resultantes foram utilizadas como variáveis independentes na construção do modelo de regressão linear múltipla e de regressão dinâmica. Portanto, essas metodologias são aplicadas a um estudo de caso na saúde pública, a fim de fazer previsões e tirar conclusões a respeito de qual modelo é mais adequado para realizar a previsão do custo mensal dos antibióticos em infecções hospitalares. Os resultados obtidos nos dois modelos foram considerados satisfatórios, mas foi escolhido, como modelo mais adequado para realizar as previsões, o modelo de regressão dinâmica, porque apresentou o menor erro percentual absoluto médio (MAPE). Por fim, as previsões encontradas, podem se constituir em uma ferramenta gerencial para a administração hospitalar ao fornecer subsídios para o planejamento orçamentário e financeiro dos recursos, especialmente em uma época em que há escassez de recursos em escala global, com reflexos muito intensos nos custos da saúde.

Submitted by Renata Lopes (renatasil82@gmail.com) on 2016-10-13T13:49:58Z No. of bitstreams: 1 eduardodessupoiomoreiradias.pdf: 568521 bytes, checksum: c10ad96e85dfa6ce7e0e40283959ac29 (MD5) / Approved for entry into archive by Adriana Oliveira (adriana.oliveira@ufjf.edu.br) on 2016-10-22T12:56:13Z (GMT) No. of bitstreams: 1 eduardodessupoiomoreiradias.pdf: 568521 bytes, checksum: c10ad96e85dfa6ce7e0e40283959ac29 (MD5) / Made available in DSpace on 2016-10-22T12:56:14Z (GMT). No. of bitstreams: 1 eduardodessupoiomoreiradias.pdf: 568521 bytes, checksum: c10ad96e85dfa6ce7e0e40283959ac29 (MD5) Previous issue date: 2008-02-29 / O objetivo principal desta dissertação é estimar um modelo para a previsão mensal do consumo de energia elétrica no Brasil. Foi utilizada na construção do modelo uma estratégia bottom-up, ou seja, inicialmente, com o uso da metodologia Box & Jenkins, estimou-se um modelo simples auto-projetivo que pudesse fornecer informações sobre o comportamento da série em questão. Num segundo momento, estimou-se um modelo de regressão dinâmica, onde se procurou relacionar o consumo de energia elétrica no país com outras possíveis variáveis causais. Nesta dissertação também é feito um estudo sobre a evolução do setor elétrico no Brasil, enfatizando-se as reformas ocorridas em meados dos anos 1990, o que deu origem ao chamado “novíssimo” modelo institucional do setor elétrico brasileiro. Com a metodologia Box & Jenkins, foi encontrado um modelo SARIMA (0,1,0) x (1,0,0)12 e o modelo de regressão dinâmica indicou que o consumo de energia elétrica no Brasil está relacionado, dentre outros fatores, ao nível de atividade econômica do país. Por fim, foram feitos testes dentro e fora da amostra, com o objetivo de comparar os modelos obtidos, e projeções de consumo para os meses do ano de 2008. / The main point of this dissertation is to find a monthly forecasting model to the Brazilian of electric energy consumption. The methodology consists of the construction of a model using a buttom-up strategy. In other words, it was first adjusted a Box & Jenkins model; i.e., a simple univariate model that could give information about the behavior of the series. Then, a dynamic regression model was fitted which relates brazilian electric energy consumption to all possible explanatory variable. In this dissertation, it was also carried out a study of the Brazilian electricity sector evolution, emphasizing the changes occurred in the nineties, that originated the so called “brand new” institutional model of the Brazilian electricity sector. By mean of the Box & Jenkins method, a SARIMA model (0,1,0) X (1,0,0)12 was found, and the dynamic regression model shows that the consumption of electricity in Brazil is related, among others factors, to the level of the economic activities in the country. Finally, tests in and out of sample were made, with the objective of comparing the obtained models, and the monthly forecasts for the 2008 months were produced by the selected model.

[pt] A crescente produção de petróleo em águas brasileiras torna cada vez mais importante a gestão logística de alívios das plataformas produtoras. A programação de alívios das plataformas deve ser realizada de forma antecipativa, evitando a parada de produção por falta de espaço disponível para armazenagem. Uma interrupção da produção de petróleo, por menor que seja, causa uma perda direta de receita para a empresa produtora. Alívios realizados muito próximos ao completo enchimento de todos os tanques da plataforma representam risco iminente de perda de produção e são denominados alívios críticos. Este trabalho tem como objetivo realizar um estudo estatístico com dados históricos de 2016 a 2019 para criar um modelo multivariado de previsão dos alívios críticos em uma grande empresa de petróleo brasileira. O modelo de regressão dinâmica foi utilizado para avaliar como as variáveis presentes no processo de programação de alívios se relacionam com o percentual mensal de alívios críticos. A partir do modelo gerado foram identificadas que as variáveis de produção mensal, estoque médio, previsão do tempo, lote médio e exportações mensais impactam no percentual de alívios críticos do mês. Foi realizada uma análise de sensibilidade, a partir da qual foi possível concluir que a gestão de estoques da empresa é o fator fundamental para a redução dos alívios críticos e consequentemente a redução das chances de perda de produção. / [en] The growing oil production in Brazilian waters makes the logistic management of offloadings from the platforms increasingly important. The platform offloading schedule must be carried out in advance, avoiding production stoppage due to lack of available storage space. An interruption in oil production, however small, causes a direct revenue loss for the producing company. Offloadings performed very close to the complete filling of all the platform tanks represent an imminent loss of production risk and are called critical offloadings. This work aims to carry out a statistical study with historical data from 2016 to 2019 to create a multivariate model for forecasting critical offloadings in a large Brazilian oil company. The dynamic regression model was used to evaluate how the variables present in the offloading scheduling process are related to the monthly percentage of critical offloadings. From the developed model, it was identified that the variables of monthly production, average stock, weather forecast, average batch and monthly exports impact the percentage of critical offloadings of the month. A sensitivity analysis was carried out, from which it was possible to conclude that the company s inventory management is the fundamental factor for the reduction of critical offloadings and, consequently, the reduction of the chances of production loss.