Less Is More: Harnessing Product Substitution Information to Rationalize SKUs at Intcomex

Patxi J. Bernales (), Yongtao Guan (), Harihara Prasad Natarajan (), Patricia Souza Gimenez () and Mario Xavier Alvarez Tajes ()
Additional contact information
Patxi J. Bernales: Intcomex Panama, Panama City, Panama
Yongtao Guan: School of Business Administration, University of Miami, Coral Gables, Florida 33146
Harihara Prasad Natarajan: School of Business Administration, University of Miami, Coral Gables, Florida 33146
Patricia Souza Gimenez: Teva Pharmaceutical Industries, Miami, Florida 33137
Mario Xavier Alvarez Tajes: Intcomex Uruguay, Montevideo, 11800 Uruguay

Interfaces, 2017, vol. 47, issue 3, 230-243

Abstract: Intcomex, a large global distributor of information technology products, was experiencing severe stress in its supply chain from a rapidly expanding set of products in its catalog. The company proactively partnered with an academic team to develop a data-driven approach to address this issue. Rather than adopt potentially suboptimal rules of thumb for product selection (and exclusion), the project team developed a composite method for rationalizing stock-keeping units (SKUs). This approach allows the company to statistically estimate product demand and product substitution using profit-based optimization of the product selection decision. Intuitively, the approach seeks to leverage the company’s ability to substitute products by eliminating low-profit SKUs for which substitutes are available. It accounts for all costs incurred over a product’s life cycle, incorporates other important contextual considerations, and delivers tailored recommendations for each product category and geographical market. We implemented the composite method as two software modules—one for statistical estimation and one for assortment optimization. Using the software tools of the composite method on a product category in the company’s Uruguay operations, we generated an 18 percent increase in profits from rationalizing the company’s product catalog. Despite the streamlined catalog, more than 97.5 percent of the product demand was served; in addition, revenues increased because of the better match between supply and demand.

Keywords: decision support; product substitution; structural estimation; optimization (search for similar items in EconPapers)
Date: 2017
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (3)

Downloads: (external link)
https://doi.org/10.1287/inte.2017.0889 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:47:y:2017:i:3:p:230-243

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().