Inventory Accuracy via Error Prediction and Threshold Adjustment

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Inaccurate perpetual inventory in retail environments leads to errors in tracking and forecasting, affecting product availability and profitability, as existing methods struggle to accurately reflect actual on-hand inventory levels due to factors like theft, expiration, and incorrect data entry.

Innovation Solution

A store management system that includes an inventory system, shipping system, and checkout system, coupled with databases and control circuits, continuously updates and adjusts on-hand inventory values by predicting and compensating for errors, using estimated adjustment values and on-hand variation thresholds to ensure accurate inventory levels.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If traditional inventory tracking methods are used, then the system maintains perpetual inventory records, but the accuracy of inventory information deteriorates due to errors from theft, expiration, and incorrect data entry

Engineering Contradiction:
Improveinventory accuracyVSAvoidperpetual inventory reliability
Core Design Contradiction:
Measurement precisionVSReliability

Solution Approach 1:

The system implements feedback loops where actual inventory counts are continuously compared with perpetual inventory records. Discrepancies trigger automatic investigations and corrections, creating a closed-loop system that continuously improves inventory accuracy. The feedback mechanism includes regular physical counts, cycle counting, and real-time monitoring of inventory transactions to identify and correct errors promptly.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The patent replaces manual mechanical inventory tracking methods with automated electronic systems. Barcode scanners, RFID tags, and integrated POS systems automatically capture inventory transactions, eliminating manual data entry errors. The system substitutes human-operated mechanical counting with automated sensing and data processing technologies that continuously update inventory records without human intervention.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Measurement precision

If frequent physical inventory counts are performed to improve accuracy, then inventory information becomes more reliable, but productivity and time efficiency deteriorate due to store operations disruption

Engineering Contradiction:
Improveinventory accuracyVSAvoidstore operational efficiency
Core Design Contradiction:
Measurement precisionVSProductivity

Solution Approach 1:

Instead of continuous full inventory counts, the system implements periodic cycle counting where a portion of inventory is counted at regular intervals. Different SKUs are assigned to different counting cycles, allowing continuous monitoring without complete store shutdowns. This periodic approach maintains accuracy while minimizing disruption to store operations and customer service.

Inventive Principle:
Principle #19Periodic action

Solution Approach 2:

The system performs preliminary inventory preparations before counting operations, such as organizing items by count sequence, preparing counting equipment in advance, and scheduling counts during low-traffic periods. This preliminary action reduces the time and disruption of actual counting operations, maintaining productivity while achieving accurate inventory measurements.

Inventive Principle:
Principle #10Preliminary action

3Reliability

If manual inventory adjustment methods are used, then the system can correct errors, but the complexity and time required for error correction increases

Engineering Contradiction:
Improveinventory reliabilityVSAvoiderror correction complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The system implements self-service error correction where the inventory management software automatically identifies discrepancies, analyzes potential causes, and suggests or applies corrections without manual intervention. The system self-diagnoses counting errors, transaction errors, and adjustment anomalies, then automatically reconciles inventory records with actual counts, reducing the complexity and time of error correction procedures.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent introduces an intermediary automated reconciliation system that acts as a mediator between physical inventory counts and perpetual records. This intermediary software layer automatically processes the reconciliation, identifies errors, and applies corrections, simplifying the complex task of error correction and reducing manual workload while maintaining high reliability.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS11093893B2Apparatus and method of maintaining accurate perpetual inventory information
Publication Date: 2021.08.17 WALMART APOLLO LLC
  • US11093893B2 patent drawing
  • US11093893B2 patent drawing
  • US11093893B2 patent drawing

AI summary

Methods and apparatuses are provided for use in managing product inventory, comprising: a control circuit; a memory storing instructions to cause the control circuit to perform: obtain a reference on-hand quantity value; determine an estimated on-hand adjustment value corresponding to a predicted error between the reference on-hand quantity value and a predicted actual on-hand value; receive a retail store supplied on-hand adjustment value; set an on-hand adjustment value to the retail store supplied on-hand adjustment value when the retail store supplied on-hand adjustment value is within an on-hand variation threshold; modify the estimated on-hand adjustment value as a function of a difference between the retail store supplied on-hand adjustment value and the estimated on-hand adjustment value when the retail store supplied on-hand adjustment value is not within the on-hand variation threshold, and set the on-hand adjustment value to the modified estimated on-hand adjustment value.