Markdown Schedule Optimization for Physical Retail Stores

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing systems for optimizing inventory item markdown schedules in physical retail stores are inefficient due to differences in operating behavior and data availability compared to online channels, leading to inaccurate modeling of price sensitivity and demand, which results in suboptimal clearance programs that do not account for unique store conditions and data sparsity.

Innovation Solution

A system that builds and applies models to forecast price sensitivity for inventory items at physical stores, using statistical techniques suitable for low data volumes, data cleansing, and historical clearance data to adjust forecasted sensitivity, generating optimal markdown schedules that consider store-specific factors and constraints.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Extent of automation

If standard online clearance modeling techniques are applied to physical stores, then the clearance process can be automated, but the price sensitivity modeling becomes inaccurate due to differences in operating behavior and data availability

Engineering Contradiction:
Improveclearance process automationVSAvoidprice sensitivity modeling accuracy
Core Design Contradiction:
Extent of automationVSMeasurement precision

Solution Approach 1:

The patent applies local quality by creating store-specific price sensitivity models that account for unique physical store characteristics, operating behaviors, and data availability patterns. Each store receives customized modeling parameters rather than a uniform online-clearance approach, thereby maintaining automation while improving accuracy for each local context.

Inventive Principle:
Principle #3Local quality

Solution Approach 2:

The patent changes the modeling parameters to reflect physical store realities, including adjusted data weighting schemes, modified price elasticity calculations, and customized clearance trajectory parameters that differ from online channel assumptions. This allows automated processing while adapting to physical store-specific conditions.

Inventive Principle:
Principle #35Parameter changes

2Measurement precision

If complex modeling techniques are used to account for physical store differences, then price sensitivity accuracy improves, but the system complexity increases

Engineering Contradiction:
Improveprice sensitivity modeling accuracyVSAvoidmodeling system complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The patent performs preliminary actions by pre-processing and cleansing physical store data before modeling, establishing standardized data formats and quality thresholds in advance. This preparation work reduces the complexity of subsequent modeling operations while maintaining high accuracy requirements.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent introduces intermediary data processing layers including data cleansing modules, normalization routines, and validation protocols that bridge raw physical store data and the pricing models. These intermediaries simplify the overall system architecture by handling complexity in discrete, manageable stages rather than requiring a monolithic complex model.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Measurement precision

If historical clearance data is extensively used to adjust forecasted price sensitivity, then demand prediction accuracy improves, but the time required for data processing increases

Engineering Contradiction:
Improvedemand prediction accuracyVSAvoiddata processing time
Core Design Contradiction:
Measurement precisionVSLoss of time

Solution Approach 1:

The patent extracts only the most relevant historical clearance data features needed for adjusting price sensitivity forecasts, rather than processing entire historical datasets. By selecting and extracting only critical parameters (such as price elasticity coefficients, clearance velocity metrics, and category-specific patterns), the system achieves high prediction accuracy while minimizing data processing time.

Inventive Principle:
Principle #2Taking out (Extraction)

Solution Approach 2:

The patent applies partial action by using a curated subset of historical data that provides sufficient accuracy for price sensitivity adjustment without requiring complete historical analysis. This selective approach processes only the essential portion of historical information needed for effective clearance optimization, balancing accuracy with efficiency.

Inventive Principle:
Principle #16Partial or excessive action

Data Source

PatentUS11631102B2Optimization of markdown schedules for clearance items at physical retail stores
Publication Date: 2023.04.18 TARGET BRANDS INC
  • US11631102B2 patent drawing
  • US11631102B2 patent drawing
  • US11631102B2 patent drawing

AI summary

Methods and systems are described for optimizing markdown schedules for clearance items at physical retail stores. For example, price sensitivity of a current inventory item at a physical retail store may be modeled using techniques that account for differences in operating behavior and data availability at physical stores versus online channels for selling items. When the current item is placed on clearance at the physical retail store, a request for a markdown schedule, including goals for the clearance, may be received. The forecasted price sensitivity of the current item may be adjusted based on actual price sensitivity of one or more past clearance items (e.g., based on actual clearance sales data) determined to match the current item. An optimal markdown schedule for the item may then be determined based, at least in part, on the adjusted price sensitivity of the item and clearance goals.