Detection of phantom inventories at retail stores using a Bayesian approach

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%.

Name thesis:degree_name

Master

Department dc:contributor.department

Massachusetts Institute of Technology. Engineering and Management Program

Grantor dc:publisher

Massachusetts Institute of Technology

Year dc:date.issued

2019

Author dc:creator

• Tripathy, Sonali.

Advisor dc:contributor.advisor

• Chris Caplice.

• Engineering and Management Program.
• System Design and Management Program.

Statement dc:rights

• 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.

Licence dc:rights.uri

• http://dspace.mit.edu/handle/1721.1/7582

Language dc:language.iso

eng

Handle dc:identifier.uri

https://hdl.handle.net/1721.1/122257

OAI identifier oai:identifier

oai:dspace.mit.edu:1721.1/122257