Demand Model Forecasting with Confidence Intervals for Commerce Control

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Economic modeling in retail environments faces challenges in accurately predicting demand and confidence intervals, especially when historical data is limited or noisy, leading to unreliable forecasts due to statistical uncertainty and the failure to account for future changes in key retail factors like price and promotional activities.

Innovation Solution

A method and system that transform transactional data into forecasts and confidence intervals by estimating model parameters using a demand model, generating predictions for goods based on proposed prices or promotions, and determining confidence intervals to control commerce system operations, incorporating both parameter and statistical uncertainties.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If statistical models are used to generate demand forecasts, then predictions can be made for future demand, but the forecasts have inherent statistical uncertainty and inaccuracy

Engineering Contradiction:
Improveforecast reliabilityVSAvoiddemand prediction precision
Core Design Contradiction:
ReliabilityVSMeasurement precision

Solution Approach 1:

The system implements feedback by continuously monitoring actual sales data and comparing it to forecasted demand, then using this information to refine and update model parameters. This closed-loop approach allows the model to learn from past predictions and improve future forecast accuracy, directly addressing the reliability-precision contradiction by making the system adaptive rather than static.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The system dynamically adjusts model parameters based on changing market conditions, seasonal patterns, and historical performance. By allowing parameters to change over time rather than remaining fixed, the model can adapt to new data patterns and maintain both reliability and precision even as market conditions evolve.

Inventive Principle:
Principle #35Parameter changes

2Productivity

If simple empirical measures of forecast error are used, then confidence intervals can be generated quickly, but the estimates are inaccurate because they do not account for future changes in retail factors

Engineering Contradiction:
Improveforecast generation speedVSAvoidconfidence interval accuracy
Core Design Contradiction:
ProductivityVSMeasurement precision

Solution Approach 1:

The system performs preliminary actions by pre-calculating and storing historical forecast errors organized by different retail scenarios (price changes, promotional activities, seasonal periods). When generating new forecasts, the system can quickly retrieve and apply relevant historical error patterns rather than calculating everything from scratch, thus maintaining both speed and accuracy.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system introduces an intermediary layer that acts as a bridge between simple empirical measures and complex predictive models. This intermediary uses machine learning algorithms to learn patterns from historical data and generate adjusted confidence intervals that account for future retail factors, thereby improving accuracy without sacrificing the computational efficiency of empirical methods.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Adaptability or versatility

If linear interpolation is used to estimate confidence intervals for unknown price points, then forecasts can be made for new pricing scenarios, but the estimates are notoriously inaccurate

Engineering Contradiction:
Improveforecast applicability to new scenariosVSAvoidconfidence interval accuracy
Core Design Contradiction:
Adaptability or versatilityVSMeasurement precision

Solution Approach 1:

The system replaces the mechanical linear interpolation method with a data-driven machine learning approach. Instead of assuming a straight-line relationship between known price points, the system uses historical sales data and demand models to learn the actual nonlinear relationship between price and demand, providing much more accurate confidence interval estimates for new pricing scenarios while maintaining adaptability.

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

4Measurement precision

If demand models account for multiple retail factors like price and promotions, then forecast accuracy improves, but model complexity increases

Engineering Contradiction:
Improvedemand forecast accuracyVSAvoidmodel complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The system segments the complex demand model into modular components, each handling a specific retail factor (price elasticity, promotional lift, seasonal effects). This modular architecture allows the system to incorporate multiple factors improving accuracy while keeping each component manageable and interpretable, reducing overall model complexity through structured decomposition.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS8117061B2System and method of using demand model to generate forecast and confidence interval for control of commerce system
Publication Date: 2012.02.14 SAP SE
  • US8117061B2 patent drawing
  • US8117061B2 patent drawing
  • US8117061B2 patent drawing

AI summary

A method for transforming transactional data into a forecast and confidence interval for controlling a commerce system involves moving goods between members of a commerce system, and recording transaction data related to movement of goods between the members of the commerce system. The transaction data includes price, product, time, and promotion. The model parameters are estimated based on the transactional data using a demand model to generate a forecast of demand for the goods based on a proposed price or promotion. A confidence interval of the certainty associated with the forecast of demand for the goods is determined based on the proposed price or promotion. The forecast of demand for the goods and confidence interval is provided to the commerce system to control the movement of goods based on the forecast of demand for the goods and confidence interval. The forecast and confidence interval can be graphically displayed.