Detection of phantom inventories at retail stores using a Bayesian approach

Thesis: S.M. in Engineering and Management, Massachusetts Institute of Technology, System Design and Management Program, 2019

Bibliographic Details
Main Author: Tripathy, Sonali.
Other Authors: Chris Caplice.
Format: Thesis
Language:eng
Published: Massachusetts Institute of Technology 2019
Subjects:
Online Access:https://hdl.handle.net/1721.1/122257
_version_ 1826194671773155328
author Tripathy, Sonali.
author2 Chris Caplice.
author_facet Chris Caplice.
Tripathy, Sonali.
author_sort Tripathy, Sonali.
collection MIT
description Thesis: S.M. in Engineering and Management, Massachusetts Institute of Technology, System Design and Management Program, 2019
first_indexed 2024-09-23T10:00:13Z
format Thesis
id mit-1721.1/122257
institution Massachusetts Institute of Technology
language eng
last_indexed 2024-09-23T10:00:13Z
publishDate 2019
publisher Massachusetts Institute of Technology
record_format dspace
spelling mit-1721.1/1222572019-11-22T03:34:11Z Detection of phantom inventories at retail stores using a Bayesian approach Tripathy, Sonali. Chris Caplice. Massachusetts Institute of Technology. Engineering and Management Program. System Design and Management Program. Massachusetts Institute of Technology. Engineering and Management Program System Design and Management Program Engineering and Management Program. System Design and Management Program. Thesis: S.M. in Engineering and Management, Massachusetts Institute of Technology, System Design and Management Program, 2019 Cataloged from PDF version of thesis. Includes bibliographical references (page 35). Phantom inventories result from mismatch in the inventory that is actually available at a store on the shelf and the existing inventory as per the data record at any retail store. Inventory on hand (IOH) record for each SKU(stock keeping unit) at any store is summation of on-shelf and back room inventory. Mismatch in this data impacts the product availability at a store and in turn results in lost opportunities of revenues for the store and the CPG (consumer product goods) manufacturer. A phantom inventory remains unnoticed unless an intervention such as regular shelf re-stocking, physical audit or consumer inquiry occurs at the store. However, even these interventions may not coincide with actual shelf stock out event and hence, the phantom inventory would continue to exist. This report proposes a Bayesian approach based on consecutive zero sales in the POS (point of sales system) while inventory IOH remains positive through the observation time. The daily demand is designed using a negative binomial distribution, which is used further to determine the posterior probability of phantom inventories given a specific set of consecutive days without sales of a SKU at a store. The prevalence of phantom inventories is then calculated using all the number of consecutive days without sales for each SKU store combination and is compared to a Gumbel distribution. This approach has been applied on one data set including POS and IOH data provided by a CPG manufacturer, where the prevalence was found to be 11.63%. by Sonali Tripathy. S.M. in Engineering and Management S.M.inEngineeringandManagement Massachusetts Institute of Technology, System Design and Management Program 2019-09-17T19:51:01Z 2019-09-17T19:51:01Z 2019 2019 Thesis https://hdl.handle.net/1721.1/122257 1119555264 eng MIT theses are protected by copyright. They may be viewed, downloaded, or printed from this source but further reproduction or distribution in any format is prohibited without written permission. http://dspace.mit.edu/handle/1721.1/7582 35 pages application/pdf Massachusetts Institute of Technology
spellingShingle Engineering and Management Program.
System Design and Management Program.
Tripathy, Sonali.
Detection of phantom inventories at retail stores using a Bayesian approach
title Detection of phantom inventories at retail stores using a Bayesian approach
title_full Detection of phantom inventories at retail stores using a Bayesian approach
title_fullStr Detection of phantom inventories at retail stores using a Bayesian approach
title_full_unstemmed Detection of phantom inventories at retail stores using a Bayesian approach
title_short Detection of phantom inventories at retail stores using a Bayesian approach
title_sort detection of phantom inventories at retail stores using a bayesian approach
topic Engineering and Management Program.
System Design and Management Program.
url https://hdl.handle.net/1721.1/122257
work_keys_str_mv AT tripathysonali detectionofphantominventoriesatretailstoresusingabayesianapproach