IDEAS home Printed from https://ideas.repec.org/p/cor/louvco/2014034.html

A conic optimization approach for SKU rationalization

Author

Listed:
  • KEGELART, Tanguy

    (Universitécatholique de Louvain, Louvain School of Management, Belgium)

  • VAN VYVE, Mathieu

    (Université catholique de Louvain, CORE, Belgium)

Abstract

Expanding variety and the number of offered products is attractive for a firm to fit customer needs. Nevertheless, the greater complexity and the proliferation of stock-keeping units (SKUs) without substantial differentiation may not substantially improve customer satisfaction while raising costs. Based on the principle that the product-line size involves operational implications and particularly manufacturing and holding costs, this paper develops a mixed-integer nonlinear mathematical program (MINLP) to support efficient product portfolio reductions. Basically, the fixed costs elimination and the risk-pooling effects must balance the demand contraction due to customer dissatisfaction. Off-the-shelve Mixed-Integer Quadratic Problem (MIQP) solver provides optimal solution to the proposed conic quadratic reformulation, and a real-life industrial case illustrates the program and the algorithm efficiency. Findings show that our mathematical programming subject to various assumptions and estimations is efficient to rationalize portfolios up to at least 400 SKUs.

Suggested Citation

  • KEGELART, Tanguy & VAN VYVE, Mathieu, 2014. "A conic optimization approach for SKU rationalization," LIDAM Discussion Papers CORE 2014034, Université catholique de Louvain, Center for Operations Research and Econometrics (CORE).
    • Handle: RePEc:cor:louvco:2014034
    as

    Download full text from publisher

    File URL: https://sites.uclouvain.be/core/publications/coredp/coredp2014.html
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Gregory Dobson & Shlomo Kalish, 1988. "Positioning and Pricing a Product Line," Marketing Science, INFORMS, vol. 7(2), pages 107-125.
    2. Mark Daskin & Collette Coullard & Zuo-Jun Shen, 2002. "An Inventory-Location Model: Formulation, Solution Algorithm and Computational Results," Annals of Operations Research, Springer, vol. 110(1), pages 83-106, February.
    3. Marshall Fisher, 2009. "OR FORUM--Rocket Science Retailing: The 2006 Philip McCord Morse Lecture," Operations Research, INFORMS, vol. 57(3), pages 527-540, June.
    4. Richard D. McBride & Fred S. Zufryden, 1988. "An Integer Programming Approach to the Optimal Product Line Selection Problem," Marketing Science, INFORMS, vol. 7(2), pages 126-140.
    5. Zuo-Jun Max Shen & Mark S. Daskin, 2005. "Trade-offs Between Customer Service and Cost in Integrated Supply Chain Design," Manufacturing & Service Operations Management, INFORMS, vol. 7(3), pages 188-207, September.
    6. Snyder, Lawrence V. & Daskin, Mark S. & Teo, Chung-Piaw, 2007. "The stochastic location model with risk pooling," European Journal of Operational Research, Elsevier, vol. 179(3), pages 1221-1238, June.
    7. Charles J. Corbett & Kumar Rajaram, 2006. "A Generalization of the Inventory Pooling Effect to Nonnormal Dependent Demand," Manufacturing & Service Operations Management, INFORMS, vol. 8(4), pages 351-358, August.
    8. Alper Atamtürk & Gemma Berenguer & Zuo-Jun (Max) Shen, 2012. "A Conic Integer Programming Approach to Stochastic Joint Location-Inventory Problems," Operations Research, INFORMS, vol. 60(2), pages 366-381, April.
    9. Gregory Dobson & Shlomo Kalish, 1993. "Heuristics for Pricing and Positioning a Product-Line Using Conjoint and Cost Data," Management Science, INFORMS, vol. 39(2), pages 160-175, February.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Wenjun Ni & Jia Shu & Miao Song & Dachuan Xu & Kaike Zhang, 2021. "A Branch-and-Price Algorithm for Facility Location with General Facility Cost Functions," INFORMS Journal on Computing, INFORMS, vol. 33(1), pages 86-104, January.
    2. Escalona, P. & Ordóñez, F. & Marianov, V., 2015. "Joint location-inventory problem with differentiated service levels using critical level policy," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 83(C), pages 141-157.
    3. Aaron Guerrero Campanur & Elias Olivares-Benitez & Pablo A. Miranda & Rodolfo Eleazar Perez-Loaiza & Jose Humberto Ablanedo-Rosas, 2018. "Design of a Logistics Nonlinear System for a Complex, Multiechelon, Supply Chain Network with Uncertain Demands," Complexity, Hindawi, vol. 2018, pages 1-16, November.
    4. Winfried Steiner & Harald Hruschka, 2002. "A Probabilistic One-Step Approach to the Optimal Product Line Design Problem Using Conjoint and Cost Data," Review of Marketing Science Working Papers 1-4-1003, Berkeley Electronic Press.
    5. Wilhelm, Wilbert E. & Xu, Kaihong, 2002. "Prescribing product upgrades, prices and production levels over time in a stochastic environment," European Journal of Operational Research, Elsevier, vol. 138(3), pages 601-621, May.
    6. Berman, Oded & Krass, Dmitry & Menezes, Mozart B.C., 2016. "Directed assignment vs. customer choice in location inventory models," International Journal of Production Economics, Elsevier, vol. 179(C), pages 179-191.
    7. Xinfang (Jocelyn) Wang & Jeffrey D. Camm & David J. Curry, 2009. "A Branch-and-Price Approach to the Share-of-Choice Product Line Design Problem," Management Science, INFORMS, vol. 55(10), pages 1718-1728, October.
    8. Bechler, Georg & Steinhardt, Claudius & Mackert, Jochen & Klein, Robert, 2021. "Product line optimization in the presence of preferences for compromise alternatives," European Journal of Operational Research, Elsevier, vol. 288(3), pages 902-917.
    9. Kamalini Ramdas & Mohanbir S. Sawhney, 2001. "A Cross-Functional Approach to Evaluating Multiple Line Extensions for Assembled Products," Management Science, INFORMS, vol. 47(1), pages 22-36, January.
    10. Dimitris Bertsimas & Velibor V. Mišić, 2017. "Robust Product Line Design," Operations Research, INFORMS, vol. 65(1), pages 19-37, February.
    11. Zhang, Zhi-Hai & Unnikrishnan, Avinash, 2016. "A coordinated location-inventory problem in closed-loop supply chain," Transportation Research Part B: Methodological, Elsevier, vol. 89(C), pages 127-148.
    12. Escalona, P. & Marianov, V. & Ordóñez, F. & Stegmaier, R., 2018. "On the effect of inventory policies on distribution network design with several demand classes," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 111(C), pages 229-240.
    13. Emilio Carrizosa & Alba V. Olivares-Nadal & Pepa Ramírez-Cobo, 2020. "Embedding the production policy in location-allocation decisions," 4OR, Springer, vol. 18(3), pages 357-380, September.
    14. Yao, Zhishuang & Lee, Loo Hay & Jaruphongsa, Wikrom & Tan, Vicky & Hui, Chen Fei, 2010. "Multi-source facility location-allocation and inventory problem," European Journal of Operational Research, Elsevier, vol. 207(2), pages 750-762, December.
    15. Alper Atamtürk & Gemma Berenguer & Zuo-Jun (Max) Shen, 2012. "A Conic Integer Programming Approach to Stochastic Joint Location-Inventory Problems," Operations Research, INFORMS, vol. 60(2), pages 366-381, April.
    16. Andrade, Xavier & Guimarães, Luís & Figueira, Gonçalo, 2021. "Product line selection of fast-moving consumer goods," Omega, Elsevier, vol. 102(C).
    17. Hongmin Li & Scott Webster & Gwangjae Yu, 2020. "Product Design Under Multinomial Logit Choices: Optimization of Quality and Prices in an Evolving Product Line," Manufacturing & Service Operations Management, INFORMS, vol. 22(5), pages 1011-1025, September.
    18. Mehrdad Shahabi & Shirin Akbarinasaji & Avinash Unnikrishnan & Rachel James, 2013. "Integrated Inventory Control and Facility Location Decisions in a Multi-Echelon Supply Chain Network with Hubs," Networks and Spatial Economics, Springer, vol. 13(4), pages 497-514, December.
    19. Baier, Daniel & Gaul, Wolfgang, 1998. "Optimal product positioning based on paired comparison data," Journal of Econometrics, Elsevier, vol. 89(1-2), pages 365-392, November.
    20. Candas, Mehmet Ferhat & Kutanoglu, Erhan, 2020. "Integrated location and inventory planning in service parts logistics with customer-based service levels," European Journal of Operational Research, Elsevier, vol. 285(1), pages 279-295.

    More about this item

    Keywords

    ;
    ;
    ;
    ;

    JEL classification:

    • C61 - Mathematical and Quantitative Methods - - Mathematical Methods; Programming Models; Mathematical and Simulation Modeling - - - Optimization Techniques; Programming Models; Dynamic Analysis
    • M11 - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics - - Business Administration - - - Production Management

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:cor:louvco:2014034. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Alain GILLIS (email available below). General contact details of provider: https://edirc.repec.org/data/coreebe.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.