Improving organizational decision support: Detection of outliers and sales prediction for a pharmaceutical distribution company

Beitrag in Konferenzband



Es wurden keine entsprechenden Inhalte gefunden.

Details zur Publikation

Autorenliste: Ribeiro A, Seruca I, Durao N
Verlag: Elsevier: Creative Commons Attribution Non-Commercial No-Derivatives License
Jahr der Veröffentlichung: 2017
Bandnummer: 121
Erste Seite: 282
Letzte Seite: 290
Seitenumfang: 9
ISSN: 1877-0509
Sprachen: Englisch-Vereinigtes Königreich (EN-GB)


Stock unavailability in the supply of medicines to pharmacies can be caused by several factors including manufacturing problems, lack of raw materials, end of product selling, disease and epidemics outbreaks. Furthermore, the sale of medicines by some pharmacies to foreign markets has increased in recent years, and is considered one of the main causes of medicine supply failures in Portugal. This paper depicts the case study of a pharmaceutical distribution company in Portugal and aims to address two main research issues. The first one consisted in detecting customers (pharmacies) and products (medicines) which may be considered outliers and perform stock proration when these outliers are detected, in order to avoid abnormal sales and out-of stocks in pharmacies. The second one targeted the sales prediction for the pharmaceutical distribution company, in order to better control and manage the levels of stock of medicines, so as to avoid excessive inventory costs while guaranteeing customer demand satisfaction, and thus decreasing the possibility of loss of customers due to stock outages. In outliers detection (customers and products) we used the Box-plot method as well as the SPSS statistical software. For sales prediction, the time series data mining method smoothed Pegels was used, while the implementation was done in SQL and the analyzed data was stored in an Oracle database. (C) 2017 The Authors. Published by Elsevier B.V.


Es wurden keine entsprechenden Inhalte gefunden.


Es wurden keine entsprechenden Inhalte gefunden.

Zuletzt aktualisiert 2019-23-08 um 11:15