IDEAS home Printed from https://ideas.repec.org/a/spr/operea/v23y2023i1d10.1007_s12351-023-00748-y.html
   My bibliography  Save this article

Stock control analytics: a data-driven approach to compute the fill rate considering undershoots

Author

Listed:
  • Eugenia Babiloni

    (Universitat Politècnica de València)

  • Ester Guijarro

    (Universitat Politècnica de València)

  • Juan R. Trapero

    (Universidad de Castilla-La Mancha)

Abstract

One of the most frequently used inventory policies is the order-point, order-up-to-level (s, S) system. In this system, the inventory is continuously reviewed and a replenishment request is placed whenever the inventory position drops to or below the order point, s. The variable replenishment order quantity and the variable replenishment cycle characterize the system by the use of complex mathematical computations. Different methodological approaches diminish the mathematical complexity by neglecting the undershoots, i.e., the quantity that the inventory position is below the order point when it is reached. In this paper, we conceptually and empirically analyse the bias that neglecting the undershoots introduces into the estimation of the fill rate. After that, we suggest a new methodology developed under a data-driven perspective that uses a state-dependent parameter algorithm to correct such a bias. As a result, we propose two new methods, one parametric and the other nonparametric, to enhance the fill rate estimate. Both methods, named analytics fill rate methods, remove the bias that neglecting the undershoots introduces and are used to illustrate the practical implications of this hypothesis on the performance and design of the (s, S) system. This research is developed in a lost sales context with simulated stochastic and i.i.d. discrete demands as well as actual sales data.

Suggested Citation

  • Eugenia Babiloni & Ester Guijarro & Juan R. Trapero, 2023. "Stock control analytics: a data-driven approach to compute the fill rate considering undershoots," Operational Research, Springer, vol. 23(1), pages 1-25, March.
  • Handle: RePEc:spr:operea:v:23:y:2023:i:1:d:10.1007_s12351-023-00748-y
    DOI: 10.1007/s12351-023-00748-y
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1007/s12351-023-00748-y
    File Function: Abstract
    Download Restriction: Access to the full text of the articles in this series is restricted.

    File URL: https://libkey.io/10.1007/s12351-023-00748-y?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Wang, Gang & Gunasekaran, Angappa & Ngai, Eric W.T. & Papadopoulos, Thanos, 2016. "Big data analytics in logistics and supply chain management: Certain investigations for research and applications," International Journal of Production Economics, Elsevier, vol. 176(C), pages 98-110.
    2. A A Syntetos & J E Boylan & J D Croston, 2005. "On the categorization of demand patterns," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 56(5), pages 495-503, May.
    3. Jana Luisa Diels & Nicole Wiebach, 2011. "Customer Reactions in Out-of-Stock Situations – Do promotion-induced phantom positions alleviate the similarity substitution hypothesis?," SFB 649 Discussion Papers SFB649DP2011-021, Sonderforschungsbereich 649, Humboldt University, Berlin, Germany.
    4. L W G Strijbosch & R M J Heuts & E H M van der Schoot, 2000. "A combined forecast—inventory control procedure for spare parts," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 51(10), pages 1184-1192, October.
    5. Bijvank, Marco & Vis, Iris F.A., 2011. "Lost-sales inventory theory: A review," European Journal of Operational Research, Elsevier, vol. 215(1), pages 1-13, November.
    6. J J A Moors & L W G Strijbosch, 2002. "Exact fill rates for (R, s, S) inventory control with gamma distributed demand," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 53(11), pages 1268-1274, November.
    7. Johansen, Soren Glud & Hill, Roger M., 2000. "The (r,Q) control of a periodic-review inventory system with continuous demand and lost sales," International Journal of Production Economics, Elsevier, vol. 68(3), pages 279-286, December.
    8. Guijarro, Ester & Cardós, Manuel & Babiloni, Eugenia, 2012. "On the exact calculation of the fill rate in a periodic review inventory policy under discrete demand patterns," European Journal of Operational Research, Elsevier, vol. 218(2), pages 442-447.
    9. Zied Jemai & Chaaben Kouki & Y. Dallery & Evren Sahin, 2009. "Consideration of the Undershoot in an (r,Q) Inventory Model for Perishables," Post-Print hal-01672438, HAL.
    10. Gandomi, Amir & Haider, Murtaza, 2015. "Beyond the hype: Big data concepts, methods, and analytics," International Journal of Information Management, Elsevier, vol. 35(2), pages 137-144.
    11. Barrow, Devon K. & Kourentzes, Nikolaos, 2016. "Distributions of forecasting errors of forecast combinations: Implications for inventory management," International Journal of Production Economics, Elsevier, vol. 177(C), pages 24-33.
    12. E A Silver & D P Bischak & T de Kok, 2012. "Determining the reorder point and order-up-to level to satisfy two constraints in a periodic review system under negative binomial demand," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 63(7), pages 941-949, July.
    13. Huber, Jakob & Müller, Sebastian & Fleischmann, Moritz & Stuckenschmidt, Heiner, 2019. "A data-driven newsvendor problem: From data to decision," European Journal of Operational Research, Elsevier, vol. 278(3), pages 904-915.
    14. Bijvank, Marco & Bhulai, Sandjai & Tim Huh, Woonghee, 2015. "Parametric replenishment policies for inventory systems with lost sales and fixed order cost," European Journal of Operational Research, Elsevier, vol. 241(2), pages 381-390.
    15. Johansen, Soren Glud, 2001. "Pure and modified base-stock policies for the lost sales inventory system with negligible set-up costs and constant lead times," International Journal of Production Economics, Elsevier, vol. 71(1-3), pages 391-399, May.
    16. Vipul Agrawal & Sridhar Seshadri, 2000. "Distribution free bounds for service constrained (Q, r) inventory systems," Naval Research Logistics (NRL), John Wiley & Sons, vol. 47(8), pages 635-656, December.
    17. Eugenia Babiloni & Ester Guijarro, 2020. "Fill rate: from its definition to its calculation for the continuous (s, Q) inventory system with discrete demands and lost sales," Central European Journal of Operations Research, Springer;Slovak Society for Operations Research;Hungarian Operational Research Society;Czech Society for Operations Research;Österr. Gesellschaft für Operations Research (ÖGOR);Slovenian Society Informatika - Section for Operational Research;Croatian Operational Research Society, vol. 28(1), pages 35-43, March.
    18. Manuel Cardós & Ester Guijarro & Eugenia Babiloni, 2017. "On the estimation of on-hand stocks for base-stock policies and lost sales systems and its impact on service measures," International Journal of Production Research, Taylor & Francis Journals, vol. 55(16), pages 4680-4694, August.
    19. Morris A. Cohen & Paul R. Kleindorfer & Hau L. Lee, 1988. "Service Constrained (s, S) Inventory Systems with Priority Demand Classes and Lost Sales," Management Science, INFORMS, vol. 34(4), pages 482-499, April.
    20. Bijvank, Marco & Vis, Iris F.A., 2012. "Lost-sales inventory systems with a service level criterion," European Journal of Operational Research, Elsevier, vol. 220(3), pages 610-618.
    21. E A Silver & H Naseraldin & D P Bischak, 2009. "Determining the reorder point and order-up-to-level in a periodic review system so as to achieve a desired fill rate and a desired average time between replenishments," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 60(9), pages 1244-1253, September.
    22. Stephen M. Disney & Borja Ponte & Xun Wang, 2021. "Exploring the nonlinear dynamics of the lost-sales order-up-to policy," International Journal of Production Research, Taylor & Francis Journals, vol. 59(19), pages 5809-5830, October.
    23. Tijms, H. C. & Groenevelt, H., 1984. "Simple approximations for the reorder point in periodic and continuous review (s, S) inventory systems with service level constraints," European Journal of Operational Research, Elsevier, vol. 17(2), pages 175-190, August.
    24. Baganha, Manuel P. & Pyke, David F. & Ferrer, Geraldo, 1996. "The undershoot of the reorder point: Tests of an approximation," International Journal of Production Economics, Elsevier, vol. 45(1-3), pages 311-320, August.
    25. Manuel P. Baganha & Geraldo Ferrer & David F. Pyke, 1999. "The residual life of the renewal process: A simple algorithm," Naval Research Logistics (NRL), John Wiley & Sons, vol. 46(4), pages 435-443, June.
    26. Anuraag Gutgutia & J. K. Jha, 2018. "A closed-form solution for the distribution free continuous review integrated inventory model," Operational Research, Springer, vol. 18(1), pages 159-186, April.
    27. David E. Platt & Lawrence W. Robinson & Robert B. Freund, 1997. "Tractable (Q, R) Heuristic Models for Constrained Service Levels," Management Science, INFORMS, vol. 43(7), pages 951-965, July.
    28. Larsen, C. & Thorstenson, A., 2014. "The order and volume fill rates in inventory control systems," International Journal of Production Economics, Elsevier, vol. 147(PA), pages 13-19.
    29. Andrew Caplin & John Leahy, 2010. "Economic Theory and the World of Practice: A Celebration of the ( S , s ) Model," Journal of Economic Perspectives, American Economic Association, vol. 24(1), pages 183-202, Winter.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Pavlos Delias & Fotis C. Kitsios, 2023. "Operational research and business intelligence as drivers for digital transformation," Operational Research, Springer, vol. 23(3), pages 1-8, September.

    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. Eugenia Babiloni & Ester Guijarro, 2020. "Fill rate: from its definition to its calculation for the continuous (s, Q) inventory system with discrete demands and lost sales," Central European Journal of Operations Research, Springer;Slovak Society for Operations Research;Hungarian Operational Research Society;Czech Society for Operations Research;Österr. Gesellschaft für Operations Research (ÖGOR);Slovenian Society Informatika - Section for Operational Research;Croatian Operational Research Society, vol. 28(1), pages 35-43, March.
    2. Manuel Cardós & Ester Guijarro & Eugenia Babiloni, 2017. "On the estimation of on-hand stocks for base-stock policies and lost sales systems and its impact on service measures," International Journal of Production Research, Taylor & Francis Journals, vol. 55(16), pages 4680-4694, August.
    3. Bijvank, Marco & Vis, Iris F.A., 2011. "Lost-sales inventory theory: A review," European Journal of Operational Research, Elsevier, vol. 215(1), pages 1-13, November.
    4. Bijvank, Marco & Bhulai, Sandjai & Tim Huh, Woonghee, 2015. "Parametric replenishment policies for inventory systems with lost sales and fixed order cost," European Journal of Operational Research, Elsevier, vol. 241(2), pages 381-390.
    5. Tamer Boyacı & Guillermo Gallego, 2002. "Managing waiting times of backordered demands in single‐stage (Q, r) inventory systems," Naval Research Logistics (NRL), John Wiley & Sons, vol. 49(6), pages 557-573, September.
    6. David A. Goldberg & Dmitriy A. Katz-Rogozhnikov & Yingdong Lu & Mayank Sharma & Mark S. Squillante, 2016. "Asymptotic Optimality of Constant-Order Policies for Lost Sales Inventory Models with Large Lead Times," Mathematics of Operations Research, INFORMS, vol. 41(3), pages 898-913, August.
    7. Hill, Roger M. & Johansen, Soren Glud, 2006. "Optimal and near-optimal policies for lost sales inventory models with at most one replenishment order outstanding," European Journal of Operational Research, Elsevier, vol. 169(1), pages 111-132, February.
    8. Erkip, Nesim Kohen, 2023. "Can accessing much data reshape the theory? Inventory theory under the challenge of data-driven systems," European Journal of Operational Research, Elsevier, vol. 308(3), pages 949-959.
    9. Bijvank, Marco & Vis, Iris F.A., 2012. "Lost-sales inventory systems with a service level criterion," European Journal of Operational Research, Elsevier, vol. 220(3), pages 610-618.
    10. Noordhoek, Marije & Dullaert, Wout & Lai, David S.W. & de Leeuw, Sander, 2018. "A simulation–optimization approach for a service-constrained multi-echelon distribution network," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 114(C), pages 292-311.
    11. Strijbosch, L.W.G. & Moors, J.J.A., 1999. "Simple Expressions for Safety Factors in Inventory Control," Discussion Paper 1999-112, Tilburg University, Center for Economic Research.
    12. Bendre, Abhijit Bhagwan & Nielsen, Lars Relund, 2013. "Inventory control in a lost-sales setting with information about supply lead times," International Journal of Production Economics, Elsevier, vol. 142(2), pages 324-331.
    13. Ye, Yuan & Lu, Yonggang & Robinson, Powell & Narayanan, Arunachalam, 2022. "An empirical Bayes approach to incorporating demand intermittency and irregularity into inventory control," European Journal of Operational Research, Elsevier, vol. 303(1), pages 255-272.
    14. Syntetos, A.A. & Teunter, R.H., 2014. "On the calculation of safety stocks," Research Report 14003-OPERA, University of Groningen, Research Institute SOM (Systems, Organisations and Management).
    15. Mor Armony & Erica Plambeck & Sridhar Seshadri, 2009. "Sensitivity of Optimal Capacity to Customer Impatience in an Unobservable M/M/S Queue (Why You Shouldn't Shout at the DMV)," Manufacturing & Service Operations Management, INFORMS, vol. 11(1), pages 19-32, June.
    16. Boylan, J.E. & Syntetos, A.A., 2007. "The accuracy of a Modified Croston procedure," International Journal of Production Economics, Elsevier, vol. 107(2), pages 511-517, June.
    17. Kouki, Chaaben & Babai, M. Zied & Jemai, Zied & Minner, Stefan, 2019. "Solution procedures for lost sales base-stock inventory systems with compound Poisson demand," International Journal of Production Economics, Elsevier, vol. 209(C), pages 172-182.
    18. Sofia Estelles-Miguel & Manuel Cardos & Jose Miguel Albarracin Guillem & Marta Palmer Gato, 2014. "Calculation of the Approaches to Cycle Service Level in Continuous Review Policy: A Tool for Corporate Entrepreneur," Business and Management Research, Business and Management Research, Sciedu Press, vol. 3(1), pages 54-60, March.
    19. Cardós, Manuel & Babiloni, Eugenia, 2011. "Exact and approximate calculation of the cycle service level in periodic review inventory policies," International Journal of Production Economics, Elsevier, vol. 131(1), pages 63-68, May.
    20. Prak, Dennis & Rogetzer, Patricia, 2022. "Timing intermittent demand with time-varying order-up-to levels," European Journal of Operational Research, Elsevier, vol. 303(3), pages 1126-1136.

    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:spr:operea:v:23:y:2023:i:1:d:10.1007_s12351-023-00748-y. 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: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

    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.