How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out
Autor(a) principal: | |
---|---|
Data de Publicação: | 2018 |
Tipo de documento: | Dissertação |
Idioma: | eng |
Título da fonte: | Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
Texto Completo: | http://hdl.handle.net/10362/36385 |
Resumo: | Until the present date, the Pharmaceutical Division of L’Oréal in Portugal did not have any tool to analyze the gap between Sell-In - the products sold by L’Oréal to its customers (Pharmacies and Parapharmacies) -, and Sell-Out - the quantity sold by L’Oréal customers to consumers. The main objective of this Work Project was to develop a model to analyze such gap. Subsequently, we conducted an investigation of the insights inferred from the analysis of the gap between Sell-In and Sell-Out. This investigation contributed to help the Pharmaceutical Division of L’Oréal - Active Cosmetics Division -, to better predict the level of stock they should establish with their customers (Pharmacies and Parapharmacies). Additionally, the methodology used for the model involves using data from January 2015 until September 2017. Analyzing the model, we conclude that only 20% of the Sell-In needs to be adjusted in the next sales prevision. With this rearrangement of units, we were able to predict that 7% of the Sell-In has a high risk of not being sold and 4.3% still has an improvement margin. |
id |
RCAP_cafa2940691ebcdc50fd4e1b1511413d |
---|---|
oai_identifier_str |
oai:run.unl.pt:10362/36385 |
network_acronym_str |
RCAP |
network_name_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository_id_str |
7160 |
spelling |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-outSell-inSell-outSales’ previsionActive cosmetics divisionL’OréalDomínio/Área Científica::Ciências Sociais::Economia e GestãoUntil the present date, the Pharmaceutical Division of L’Oréal in Portugal did not have any tool to analyze the gap between Sell-In - the products sold by L’Oréal to its customers (Pharmacies and Parapharmacies) -, and Sell-Out - the quantity sold by L’Oréal customers to consumers. The main objective of this Work Project was to develop a model to analyze such gap. Subsequently, we conducted an investigation of the insights inferred from the analysis of the gap between Sell-In and Sell-Out. This investigation contributed to help the Pharmaceutical Division of L’Oréal - Active Cosmetics Division -, to better predict the level of stock they should establish with their customers (Pharmacies and Parapharmacies). Additionally, the methodology used for the model involves using data from January 2015 until September 2017. Analyzing the model, we conclude that only 20% of the Sell-In needs to be adjusted in the next sales prevision. With this rearrangement of units, we were able to predict that 7% of the Sell-In has a high risk of not being sold and 4.3% still has an improvement margin.Silveira, Catherine daRUNAlmeida, João Manuel Lopes de2021-01-20T01:30:20Z2018-01-202018-01-20T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10362/36385TID:201861712enginfo:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2024-03-11T04:19:46Zoai:run.unl.pt:10362/36385Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-20T03:30:27.795987Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse |
dc.title.none.fl_str_mv |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out |
title |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out |
spellingShingle |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out Almeida, João Manuel Lopes de Sell-in Sell-out Sales’ prevision Active cosmetics division L’Oréal Domínio/Área Científica::Ciências Sociais::Economia e Gestão |
title_short |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out |
title_full |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out |
title_fullStr |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out |
title_full_unstemmed |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out |
title_sort |
How to improve the process of sales’ prevision for the pharmaceutical division of L’Oréal? Development of a new model to analyze the gap betweensell-In and sell-out |
author |
Almeida, João Manuel Lopes de |
author_facet |
Almeida, João Manuel Lopes de |
author_role |
author |
dc.contributor.none.fl_str_mv |
Silveira, Catherine da RUN |
dc.contributor.author.fl_str_mv |
Almeida, João Manuel Lopes de |
dc.subject.por.fl_str_mv |
Sell-in Sell-out Sales’ prevision Active cosmetics division L’Oréal Domínio/Área Científica::Ciências Sociais::Economia e Gestão |
topic |
Sell-in Sell-out Sales’ prevision Active cosmetics division L’Oréal Domínio/Área Científica::Ciências Sociais::Economia e Gestão |
description |
Until the present date, the Pharmaceutical Division of L’Oréal in Portugal did not have any tool to analyze the gap between Sell-In - the products sold by L’Oréal to its customers (Pharmacies and Parapharmacies) -, and Sell-Out - the quantity sold by L’Oréal customers to consumers. The main objective of this Work Project was to develop a model to analyze such gap. Subsequently, we conducted an investigation of the insights inferred from the analysis of the gap between Sell-In and Sell-Out. This investigation contributed to help the Pharmaceutical Division of L’Oréal - Active Cosmetics Division -, to better predict the level of stock they should establish with their customers (Pharmacies and Parapharmacies). Additionally, the methodology used for the model involves using data from January 2015 until September 2017. Analyzing the model, we conclude that only 20% of the Sell-In needs to be adjusted in the next sales prevision. With this rearrangement of units, we were able to predict that 7% of the Sell-In has a high risk of not being sold and 4.3% still has an improvement margin. |
publishDate |
2018 |
dc.date.none.fl_str_mv |
2018-01-20 2018-01-20T00:00:00Z 2021-01-20T01:30:20Z |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/masterThesis |
format |
masterThesis |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://hdl.handle.net/10362/36385 TID:201861712 |
url |
http://hdl.handle.net/10362/36385 |
identifier_str_mv |
TID:201861712 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.source.none.fl_str_mv |
reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação instacron:RCAAP |
instname_str |
Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
instacron_str |
RCAAP |
institution |
RCAAP |
reponame_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
collection |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository.name.fl_str_mv |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
repository.mail.fl_str_mv |
|
_version_ |
1799137929079029760 |