Loading...
Publication
Modelo de TransferĂȘncia de Produtos Descontinuados
| Name: | Description: | Size: | Format: | |
|---|---|---|---|---|
| 2.12 MB | Adobe PDF |
Authors
Advisor(s)
Abstract(s)
A Sonae MC, enquanto maior retalhista nacional, trabalha como um todo para garantir
que o produto certo, Ă© disponibilizado no local certo, no momento certo, de forma a
continuamente superar as expectativas do cliente.
Perante os desafios do mercado, as diferentes tipologias de lojas da companhia, o
nĂșmero de açÔes promocionais e a oscilação das vendas ao longo do ano, Ă© fundamental um
correto alinhamento entre as equipas Comercial, Gestão de Stocks e OperaçÔes, de forma
a garantir um fluxo otimizado de informação e mercadoria.
No entanto, observa-se que em determinados momentos, existe uma elevada
quantidade de artigos que saĂram da gama loja e necessitam de ser escoados.
Com esta tese, pretende-se definir um modelo de transferĂȘncia de artigos
descontinuados em loja, que permita reduzir as necessidades de compra a fornecedores.
Assim, foi desenvolvida uma anĂĄlise exploratĂłria, de forma a quantificar o valor dos
artigos descontinuados na companhia, identificar a sua localização e analisar as suas vendas
em outras lojas.
Para tal, foi extraĂda informação dos sistemas de informação da companhia, relativa
aos artigos descontinuados em loja e compras dos mesmos efetuadas a fornecedores, tendo
sido depois trabalhada com recurso a ferramentas de produtividade Microsoft e a python.
Como resultado deste trabalho, com base nos dados de 2021, foi possĂvel identificar
uma redução de compra a fornecedores superior a 300KâŹ.
As a major national retailer, Sonae MC works as a whole to guarantee that the right product is available in the right place at the right time and so that clientsâ expectations are continually overcome. Faced with the market challenges, the different company storesâ typologies, the number of promotional campaigns and the sales fluctuations during the year, a correct alignment between the Commercial, Stock Management and Operations teams is fundamental to guarantee optimized information and goods flow. However, it is observed that at certain times, a large number of items are no longer in the store range and need to be disposed of. This thesis intends to define a transference model of discontinued items in store, that allows the reduction of purchases from suppliers. Therefore, an exploratory analysis was developed to quantify the value of discontinued items in the company, identify their location and analyze their sales in other stores. With that in mind, information was extracted from the company's information systems, regarding discontinued items in store and purchases made from suppliers and was then developed with Microsoft productivity tools and python. As a result, it was possible to identify a purchase reduction from suppliers of more than 300KâŹ, based on 2021 data.
As a major national retailer, Sonae MC works as a whole to guarantee that the right product is available in the right place at the right time and so that clientsâ expectations are continually overcome. Faced with the market challenges, the different company storesâ typologies, the number of promotional campaigns and the sales fluctuations during the year, a correct alignment between the Commercial, Stock Management and Operations teams is fundamental to guarantee optimized information and goods flow. However, it is observed that at certain times, a large number of items are no longer in the store range and need to be disposed of. This thesis intends to define a transference model of discontinued items in store, that allows the reduction of purchases from suppliers. Therefore, an exploratory analysis was developed to quantify the value of discontinued items in the company, identify their location and analyze their sales in other stores. With that in mind, information was extracted from the company's information systems, regarding discontinued items in store and purchases made from suppliers and was then developed with Microsoft productivity tools and python. As a result, it was possible to identify a purchase reduction from suppliers of more than 300KâŹ, based on 2021 data.
Description
Keywords
Artigos Descontinuados Gama ativa TransferĂȘncia Lojas Products Discontinued Active range of products Transfer Stores