Perpetual Inventory Adjustment for Retail Nil Pick Accuracy
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Inaccurate perpetual inventory (PI) values in retail stores lead to inefficient operations, particularly when a 'nil pick' occurs, where an item is not found despite indicating availability, wasting system resources and causing inefficiencies.
Innovation Solution
A system that adjusts PI values after a nil pick, using an interface, database, and control circuit to block adjustments during audits or when backroom inventory contradicts the nil pick, and calculates adjustments based on item, sales, and supply chain information.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If PI values are used to track product availability, then inventory tracking is improved, but nil picks occur when items are not found despite indicating availability
Solution Approach 1:
The system implements feedback by monitoring nil pick events and using them to trigger PI value adjustments. When a nil pick occurs, the system receives feedback about the discrepancy between indicated availability and actual availability, then adjusts the PI value accordingly to prevent future nil picks for the same item
Solution Approach 2:
The system performs preliminary actions by adjusting PI values proactively after detecting nil pick patterns. Rather than waiting for multiple nil picks to accumulate, the system takes preliminary action to correct the PI value immediately upon detecting a nil pick event, preventing further resource wastage
2Measurement precision
If PI adjustments are made after every nil pick, then inventory accuracy is improved, but system resources are wasted on unnecessary adjustments during audits or when backroom inventory exists
Solution Approach 1:
The system checks for blocking conditions (audits, backroom inventory) before making PI adjustments. This preliminary check prevents unnecessary adjustments from being made when they would not improve accuracy, thereby conserving system resources
Solution Approach 2:
The system applies different rules for PI adjustments based on local conditions. When an audit is in progress or backroom inventory exists, the system locally modifies the adjustment behavior by blocking adjustments, whereas under normal conditions adjustments are made freely to maintain accuracy
3Measurement precision
If nil picks are investigated thoroughly, then PI value accuracy is improved, but store operations become less efficient due to additional resource allocation
Solution Approach 1:
The system performs self-service by automatically detecting nil picks, analyzing the cause, and adjusting PI values without requiring manual intervention from store employees. This automation maintains accuracy while preserving operational efficiency by eliminating the need for human investigation of each nil pick event
Data Source
AI summary
An electronic indication of a nil pick is received. Item information associated with the desired product, sales data concerning the desired product, supply chain information associated with the desired product, and a perpetual inventory (PI) value of the desired product are stored. An adjustment to the PI of the desired product is blocked when a predetermined event occurs at the retail store, or when information that contradicts the validity of the nil pick is received from the retail store. When the adjustment to the PI of the desired product is not blocked, an amount of the adjustment is determined based upon one or more of: the item information associated with the product, the sales data concerning the product, and the supply chain information associated with the desired product.