A Demand Estimation Algorithm for Inventory Management Systems Using Censored Data (2024)

Authors

  • A. NiksereshtComputer Science and Engineering Department, Shiraz University, Shiraz, Iran
  • K. ZiaratiComputer Science and Engineering Department, Shiraz University, Shiraz, Iran

Volume: 7 | Issue: 6 | Pages: 2215-2221 | December 2017 | https://doi.org/10.48084/etasr.1517

Corresponding author: A. Nikseresht

Abstract

During the selling time horizon of a product category, a number of products may become unavailable sooner than others and the customers may substitute their desired product with another or leave the system without purchase. So, the recorded sales do not show the actual demand of each product. In this paper, a nonparametric algorithm to estimate true demand using censored data is proposed. A customer choice model is employed to model the demand and then a nonlinear least square method is used to estimate the demand model parameters without assuming any distribution on customer’s arrival. A simple heuristic approach is applied to make the objective function convex, making the algorithm perform much faster and guaranteeing the convergence. Simulated dataset of different sizes are used to evaluate the proposed method. The results show a 23% improvement in root mean square error between estimated and simulated true demand, in contrast to alternate methods usually used in practice.

Keywords:

demand, estimation, inventory, revenue, management, control, unconstraining, uncensoring

Downloads

Download data is not yet available.

References

N. Agrawal, S. A. Smith, “Estimating negative binomial demand for retail inventory management with unobservable lost sales”, Naval Research Logistics, Vol. 43, No. 6, pp. 839–861, 1996 DOI: https://doi.org/10.1002/(SICI)1520-6750(199609)43:6<839::AID-NAV4>3.0.CO;2-5

C. Eltze, S. Goergens, M. Loury, “Grocery store operations: Which improvements matter most?”, Akzente, Vol. 1, No. 1, pp. 74–81, 2013

C. Stefanescu,“Multivariate Demand: Modeling and Estimation from Censored Sales”, Available at: http://ssrn.com/abstract=1334353, 2009 DOI: https://doi.org/10.2139/ssrn.1334353

B. Tan, S. Karabati, “Retail inventory management with stock-out based dynamic demand substitution”, International Journal of Production Economics, Vol. 145, No. 1, pp. 78–87, 2013 DOI: https://doi.org/10.1016/j.ijpe.2012.10.002

J. Aastrup, H. Kotzab, “Analyzing out-of-stock in independent grocery stores: an empirical study”, International Journal of Retail & Distribution Management, Vol. 37, No. 9, pp. 765–789, 2009 DOI: https://doi.org/10.1108/09590550910975817

G. Xin, P. R. Messinger, J. Li, “Influence of soldout products on consumer choice”, Journal of Retailing, Vol. 85, No. 3, pp. 274–287, 2009 DOI: https://doi.org/10.1016/j.jretai.2009.05.009

S. Karmarkar, D. Goutam, B. Tathagata, “Revenue impacts of demand unconstraining and accounting for dependency”, Journal of Revenue and Pricing Management, Vol. 10, No. 4, pp. 367–381, 2011 DOI: https://doi.org/10.1057/rpm.2009.54

R. R. Wickham, Evaluation of forecasting techniques for short-term demand of air transportation, MSc Thesis, Massachusetts Institute Technology, 1995

K. T. Talluri, G. J. van Ryzin, I. Z. Karaesmen, G. J. Vulcano, “Revenue management: Models and methods”, 2008 Winter Simulation Conference, pp. 145–156, 2008 DOI: https://doi.org/10.1109/WSC.2008.4736064

L. R. Weatherford, “A review of optimization modeling assumptions in revenue management situations”, AGIFORS Reservations and Yield Management Study Group, 1997

W. L. Cooper, T. Homem-de-Mello, A. J. Kleywegt, “Models of the Spiral-Down Effect in Revenue Management”, Operations Research, Vol. 54, No. 5, pp. 968–987, 2006 DOI: https://doi.org/10.1287/opre.1060.0304

R. Saleh, “Estimating lost demand with imperfect availability indicators”, AGIFORS Reservations and Yield Management Study Group, 1997

R. J. A. Little, D. B. Rubin, Statistical Analysis with Missing Data, John Wiley & Sons, 2002 DOI: https://doi.org/10.1002/9781119013563

A. Nikseresht, K. Ziarati, “Review on the Newest Revenue Management Demand Forecasting Methods”, International Conference on Management, Economics and Industrial Engineering, Vol. 1, No. 1, 2015

P. Guo, B. Xiao, J. Li, “Unconstraining methods in revenue management systems: Research overview and prospects”, Advances in Operations Research, Vol. 2012, Article ID 270910, 2012 DOI: https://doi.org/10.1155/2012/270910

A. Nikseresht, K. Ziarati, “Estimating True Demand in Airline’s Revenue Management Systems using Observed Sales”, International Journal of Advanced Computer Science and Applications, Vol. 8, No. 7, pp. 361-369, 2017 DOI: https://doi.org/10.14569/IJACSA.2017.080748

K. T. Talluri, G. J. Van Ryzin, The Theory and Practice of Revenue Management, Springer Science & Business Media, 2005 DOI: https://doi.org/10.1007/b139000

A. Haensel, G. Koole, “Estimating unconstrained demand rate functions using customer choice sets”, Journal of Revenue and Pricing Management, Vol. 10, No. 5, pp. 438–454, 2011 DOI: https://doi.org/10.1057/rpm.2010.1

A. Haensel, G. Koole, J. Erdman, “Estimating unconstrained customer choice set demand: A case study on airline reservation data”, Journal of Choice Modelling, Vol. 4, No. 3, pp. 75–87, 2011 DOI: https://doi.org/10.1016/S1755-5345(13)70043-5

G. Vulcano, G. van Ryzin, R. Ratliff, “Estimating Primary Demand for Substitutable Products from Sales Transaction Data”, Operations Research, Vol. 60, No. 2, pp. 313–334, 2012 DOI: https://doi.org/10.1287/opre.1110.1012

C. C. Queenan, M. Ferguson, J. Higbie, R. Kapoor, “A Comparison of Unconstraining Methods to Improve Revenue Management Systems”, Production and Operations Management, Vol. 16, No. 404, pp. 729–746, 2007 DOI: https://doi.org/10.1111/j.1937-5956.2007.tb00292.x

V. F. Farias, S. Jagabathula, D. Shah, “A Nonparametric Approach to Modeling Choice with Limited Data”, Management Science, Vol. 59, No. 2, pp. 305-322, 2009 DOI: https://doi.org/10.1287/mnsc.1120.1610

A. G. Kok, M. L. Fisher, “Demand Estimation and Assortment Optimization Under Substitution: Methodology and Application”, Operations Research, Vol. 55, No. 6, pp. 1001–1021, 2007 DOI: https://doi.org/10.1287/opre.1070.0409

A. Hubner, H. Kuhn, S. Kuhn, “An efficient algorithm for capacitated assortment planning with stochastic demand and substitution”, European Journal of Operational Research, Vol. 250, No. 2, pp. 505–520, 2016 DOI: https://doi.org/10.1016/j.ejor.2015.11.007

A. Jain, N. Rudi, T. Wang, “Demand Estimation and Ordering Under Censoring: Stock-Out Timing Is (Almost) All You Need,” Operations Research, Vol. 63, No. 1, pp. 134–150, 2015 DOI: https://doi.org/10.1287/opre.2014.1326

L. G. Cooper, M. Nakanishi, Market-Share Analysis: Evaluating Competitive Marketing Effectiveness, Kluwer Academic Publishers, 1988 DOI: https://doi.org/10.1007/978-94-009-2681-3

S.-E. Andersson, “Passenger choice analysis for seat capacity control: A pilot project in Scandinavian Airlines”, International Transactions in Operational Research, Vol. 5, No. 6, pp. 471–486, 1998 DOI: https://doi.org/10.1111/j.1475-3995.1998.tb00130.x

S. Ja, S. Rao, B. V. Chandler, “Passenger recapture estimation in airline RM”, AGIFORS 41st Annual Symposium, 2001

T. S. Gruca, D. Sudharshan, “Equilibrium Characteristics of Multinomial Logit Market Share Models”, Journal of Marketing Research, Vol. 28, No. 4, pp. 480–482, 1991 DOI: https://doi.org/10.1177/002224379102800410

R. H. Zeni, Improved Forecast Accuracy in Airline Revenue Management by Unconstraining Demand Estimates from Censored Data, Universal-Publishers, 2001

Tarek Abdallah, G. Vulcano, “Demand Estimation under the Multinomial Logit Model from Sales Transaction”, working paper, Available at: https://www.researchgate.net/profile/Gustavo_Vulcano, 2016

A Demand Estimation Algorithm for Inventory Management Systems Using Censored Data (2024)

FAQs

What are the algorithms for inventory management? ›

First in, first out (FIFO) and Last in, First Out (LIFO) are the two most common inventory tracking algorithms (LIFO). FIFO tracks inventory that is received and sold in chronological order, whereas LIFO tracks inventory that is received and sold in reverse chronological order.

What is the difference between demand forecasting and demand estimation? ›

The answer is that estimation attempts to quantify the links between the level of demand and the variables which determine it. Forecasting, on the other hand, attempts to predict the overall level of future demand rather than looking at specific linkages.

What is demand estimation? ›

Demand estimation is the process of forecasting, with varying levels of confidence and accuracy, the sources, amounts, and timing of production demand by consumers. It involves analyzing past data and trends to predict demand as well as gathering forecasts from customers to inform the model as well.

What are the 4 types of inventory management system? ›

The four types of inventory management are just-in-time management (JIT), materials requirement planning (MRP), economic order quantity (EOQ) , and days sales of inventory (DSI).

What are the 4 main steps in inventory management? ›

To manage your inventory effectively, you can follow a 4 step process:
  • Assess what you have now.
  • Review what you had.
  • Analyse sales.
  • Identify items to repurchase or retire.
Jan 18, 2024

What are the methods of demand estimation forecasting? ›

The five most popular demand forecasting methods are: trend projection, market research, sales force composite, Delphi method, and the econometric method.

What are the types of demand forecasting and estimation? ›

In quantitative forecasting, past data is analysed using statistical techniques to find trends that may be utilised to estimate future demand. Qualitative forecasting uses expert judgement and individual perspectives to project future demand.

What is the role of demand estimation and demand forecasting? ›

Demand estimation helps you be prepared with the products when the customers want them. It helps forecast demand for a particular product and be prepared with your marketing activities to attract customers. Being sold out for days and weeks when your products demand is high kills your business the most.

Why do we need to estimate demand? ›

Demand forecasting allows businesses to optimize inventory by predicting future sales. By analyzing historical sales data, demand managers can make informed business decisions about everything from inventory planning and warehousing needs to running flash sales and meeting customer expectations.

What is demand estimation by regression analysis? ›

One of the methods you can use for demand forecasting is regression analysis, which is a statistical technique that explores the relationship between a dependent variable (such as demand) and one or more independent variables (such as price, season, or promotion).

What are the 3 most important inventory control techniques? ›

Four popular inventory control methods include ABC analysis; Last In, First Out (LIFO) and First In, First Out (FIFO); batch tracking; and safety stock.

What are the three most common inventory control models? ›

Three of the most popular inventory control models are Economic Order Quantity (EOQ), Inventory Production Quantity, and ABC Analysis. Each inventory model has a different approach to help you know how much inventory you should have in stock.

What are the three most commonly used methods of inventory management? ›

The three most popular inventory management techniques are the push technique, the pull technique, and the just-in-time technique. These strategies offer businesses different pathways to meeting customer demand.

What are the three systems used in inventory control? ›

Inventory control systems are crucial for businesses that deal with managing and storing products or materials. There are three primary types of inventory control systems: periodic, perpetual, and just-in-time (JIT). Periodic inventory control is a system where stock levels are manually checked periodically.

Top Articles
Latest Posts
Article information

Author: Carmelo Roob

Last Updated:

Views: 6084

Rating: 4.4 / 5 (45 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Carmelo Roob

Birthday: 1995-01-09

Address: Apt. 915 481 Sipes Cliff, New Gonzalobury, CO 80176

Phone: +6773780339780

Job: Sales Executive

Hobby: Gaming, Jogging, Rugby, Video gaming, Handball, Ice skating, Web surfing

Introduction: My name is Carmelo Roob, I am a modern, handsome, delightful, comfortable, attractive, vast, good person who loves writing and wants to share my knowledge and understanding with you.