Inventory Auditing and Replenishment Using Point-of-Sales Data

41 Pages Posted: 28 Oct 2014 Last revised: 23 Sep 2018

Date Written: September 14, 2018

Abstract

Events such as spoilage, expiration, damage due to employee and/or customer handling, employee theft, and customer shoplifting reduce inventories in retail stores without these reductions being reflected in inventory records. As a result, inventory records often include phantom inventories (i.e., units of goods present in inventory records that are not actually available for sale). These phantom inventories cause replenishment delays and stockouts, which ultimately hurt service levels. The optimal auditing and replenishment policy in the presence of phantom inventories is complex. We analyze the structure of the problem using tools from discrete mathematics and dynamic programming to derive a polynomial algorithm for computing the optimal policy in our setting. Moreover, we propose a simple auditing and replenishment policy based on a threshold on the estimated fraction of demand to be met on a given day conditional on the POS data up to that day, a statistic that we refer to as the daily expected service level. We compare that policy with the optimal policy in our setting, which we compute algorithmically, and show it performs comparably in most cases. Our simple policy is easy to compute and interpret, and thus offers an attractive solution for inventory managers facing the challenge of phantom inventories.

Keywords: shelf availability, inventory-record inaccuracy, POMDP, optimal replenishment, retail analytics

JEL Classification: C11, D81

Suggested Citation

Bassamboo, Achal and Moreno, Antonio and Stamatopoulos, Ioannis, Inventory Auditing and Replenishment Using Point-of-Sales Data (September 14, 2018). Available at SSRN: https://ssrn.com/abstract=2515147 or http://dx.doi.org/10.2139/ssrn.2515147

Achal Bassamboo

Northwestern University - Department of Managerial Economics and Decision Sciences (MEDS) ( email )

2001 Sheridan Road
Evanston, IL 60208
United States

Antonio Moreno

Harvard University - Technology & Operations Management Unit ( email )

Boston, MA 02163
United States

HOME PAGE: http://www.hbs.edu/faculty/Pages/profile.aspx?facId=1029325

Ioannis Stamatopoulos (Contact Author)

University of Texas at Austin - McCombs School of Business ( email )

2110 Speedway B6000
Austin, TX 78705
United States

Register to save articles to
your library

Register

Paper statistics

Downloads
376
rank
72,882
Abstract Views
2,761
PlumX