A method to rationalize the product portfolio in retail stores

Retail store operations face a variety of challenges and complexities. Determining the best assortment is the main problem in the retail store. This re-search presents a practical methodology for the analysis of products in the assortment with the goal of reducing the excess items and improve sales and profit margin of a retail store without affecting customer satisfaction. The methodology integrates 6 steps that allow to optimize products of a portfolio in categories, sub categories and segments, through Pareto analysis and clustering analysis using the BCG matrix. The methodology was applied in an independent supermarket. The results in the case of the application for non-perishable products, allowed to identify a set of different products (n = 152), of which they were prioritized in a subcategory (oils) in which 90 products were prioritized. In the example, it shows how 21 products have significant results in the variety of products. The combination of the global and local category of the product, the net profit, the inventory rotation and the participation of the growth provides a multifactorial analysis in the decision-making to supply with products a retail store seeking to increase the level of service and maximizing profits

Implementation of an e.r.p. Inventory module in a small colombian metalworking company

This paper aims to analyze the effect of implementing an inventory module of ERP Openbravo for the reduction of information flow time and customer response time, in a Colombian metalworking company. The processes structure and inventory management practices of the company were characterized and information flow time and customer response time were tested before and after implementing the inventory module. The main results were the reduction of 36% of information flow time and 41% of customer response time, so it can be concluded that obtained success is related to the active involvement of manager and workers’ willingness to change