Less is more: Harnessing product substitution information to rationalize SKUs at intcomex

Patxi J. Bernales, Yongtao Guan, Harihara Prasad Natarajan, Patricia Souza Gimenez, Mario Xavier Alvarez Tajes

Research output: Contribution to journalArticle

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 profitbased 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 demandwas served; in addition, revenues increased because of the better match between supply and demand.

Original languageEnglish (US)
Pages (from-to)230-243
Number of pages14
JournalInterfaces
Volume47
Issue number3
DOIs
StatePublished - May 1 2017

Fingerprint

Substitution reactions
Industry
Profitability
Composite materials
Supply chains
Information technology
Life cycle
Product substitution
Costs

Keywords

  • Decision support
  • Optimization
  • Product substitution
  • Structural estimation

ASJC Scopus subject areas

  • Strategy and Management
  • Management Science and Operations Research
  • Management of Technology and Innovation

Cite this

Less is more : Harnessing product substitution information to rationalize SKUs at intcomex. / Bernales, Patxi J.; Guan, Yongtao; Natarajan, Harihara Prasad; Gimenez, Patricia Souza; Tajes, Mario Xavier Alvarez.

In: Interfaces, Vol. 47, No. 3, 01.05.2017, p. 230-243.

Research output: Contribution to journalArticle

Bernales, Patxi J. ; Guan, Yongtao ; Natarajan, Harihara Prasad ; Gimenez, Patricia Souza ; Tajes, Mario Xavier Alvarez. / Less is more : Harnessing product substitution information to rationalize SKUs at intcomex. In: Interfaces. 2017 ; Vol. 47, No. 3. pp. 230-243.
@article{a5b813c7021d4e45a9eec65a544b313e,
title = "Less is more: Harnessing product substitution information to rationalize SKUs at intcomex",
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 profitbased 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 demandwas served; in addition, revenues increased because of the better match between supply and demand.",
keywords = "Decision support, Optimization, Product substitution, Structural estimation",
author = "Bernales, {Patxi J.} and Yongtao Guan and Natarajan, {Harihara Prasad} and Gimenez, {Patricia Souza} and Tajes, {Mario Xavier Alvarez}",
year = "2017",
month = "5",
day = "1",
doi = "10.1287/inte.2017.0889",
language = "English (US)",
volume = "47",
pages = "230--243",
journal = "Interfaces",
issn = "0092-2102",
publisher = "INFORMS Inst.for Operations Res.and the Management Sciences",
number = "3",

}

TY - JOUR

T1 - Less is more

T2 - Harnessing product substitution information to rationalize SKUs at intcomex

AU - Bernales, Patxi J.

AU - Guan, Yongtao

AU - Natarajan, Harihara Prasad

AU - Gimenez, Patricia Souza

AU - Tajes, Mario Xavier Alvarez

PY - 2017/5/1

Y1 - 2017/5/1

N2 - 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 profitbased 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 demandwas served; in addition, revenues increased because of the better match between supply and demand.

AB - 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 profitbased 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 demandwas served; in addition, revenues increased because of the better match between supply and demand.

KW - Decision support

KW - Optimization

KW - Product substitution

KW - Structural estimation

UR - http://www.scopus.com/inward/record.url?scp=85019553291&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85019553291&partnerID=8YFLogxK

U2 - 10.1287/inte.2017.0889

DO - 10.1287/inte.2017.0889

M3 - Article

AN - SCOPUS:85019553291

VL - 47

SP - 230

EP - 243

JO - Interfaces

JF - Interfaces

SN - 0092-2102

IS - 3

ER -