Dynamic Replenishment Parameter Tool for Retail Inventory

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current inventory replenishment methods in retail businesses rely on fixed threshold values, which are often unreliable and inaccurate, leading to inefficiencies in managing inventory levels and resulting in either excess stock or stockouts.

Innovation Solution

A replenishment parameter tool that generates dynamic order-point and order-up-to-level values using historical sales data and demand forecast data, even when forecast data is unavailable, to optimize inventory levels and reduce costs.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If fixed threshold values are used for inventory replenishment, then the replenishment process is simple to operate, but the accuracy of inventory level management deteriorates

Engineering Contradiction:
Improvereplenishment process simplicityVSAvoidinventory level accuracy
Core Design Contradiction:
Ease of operationVSMeasurement precision

Solution Approach 1:

The patent transforms static fixed threshold values into dynamic calculated values. The system automatically computes order-point and order-up-to-level values based on historical sales data and demand forecasts, allowing the thresholds to adapt to changing demand patterns while maintaining operational simplicity through automation.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The patent changes the parameters from fixed constants to variable values derived from data analysis. By using statistical methods to calculate replenishment parameters based on historical data and forecasts, the system achieves higher precision in inventory management while keeping the user interface simple.

Inventive Principle:
Principle #35Parameter changes

2Measurement precision

If demand forecast data is used to generate replenishment parameters, then the accuracy of inventory management improves, but the system complexity increases

Engineering Contradiction:
Improveinventory management accuracyVSAvoidsystem complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The system performs self-service by automatically generating replenishment parameters without requiring manual intervention. The computer application autonomously processes historical sales data, incorporates demand forecasts when available, and calculates optimal replenishment values, reducing the perceived complexity for users while maintaining high accuracy.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent introduces a computer application as an intermediary that handles the complex calculations and data processing. This intermediary layer manages the complexity internally while presenting a simple interface to users, bridging the gap between sophisticated analysis and ease of use.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Reliability

If dynamic replenishment parameters are calculated using historical sales data and demand forecasts, then the reliability of inventory levels improves, but the computational requirements and processing time increase

Engineering Contradiction:
Improveinventory level reliabilityVSAvoidparameter calculation time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system performs preliminary actions by pre-calculating and storing historical sales statistics and demand forecast data. When replenishment parameters are needed, the system quickly retrieves and combines pre-processed data rather than performing complex calculations from raw data, significantly reducing computation time while maintaining reliability.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent replaces manual or mechanical calculation methods with automated computer-based processing. The computer application efficiently handles data retrieval, statistical analysis, and parameter calculation, achieving high reliability results much faster than traditional methods would allow.

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

Data Source

PatentUS9990597B2System and method for forecast driven replenishment of merchandise
Publication Date: 2018.06.05 ORACLE INT CORP
  • US9990597B2 patent drawing
  • US9990597B2 patent drawing
  • US9990597B2 patent drawing

AI summary

Systems, methods, and other embodiments are disclosed that are configured to generate replenishment parameters for use by an external replenishment system. In one embodiment, sales statistics are generated for an item based at least in part on historical sales data for the item. A determination is made as to if demand forecast data is available for the item. If demand forecast data is not available, an order-point value for the item is generated based at least in part on the sales statistics. If demand forecast data is available, demand forecast statistics are generated and the order-point value is generated based at least in part on the sales statistics and the demand forecast statistics. An order-up-to-level is generated based at least in part on the order-point value.