WO2004049125A2 - Configurable pricing optimization system - Google Patents

Configurable pricing optimization system Download PDF

Info

Publication number
WO2004049125A2
WO2004049125A2 PCT/US2003/037601 US0337601W WO2004049125A2 WO 2004049125 A2 WO2004049125 A2 WO 2004049125A2 US 0337601 W US0337601 W US 0337601W WO 2004049125 A2 WO2004049125 A2 WO 2004049125A2
Authority
WO
WIPO (PCT)
Prior art keywords
user
pricing
product
optimization
promotion
Prior art date
Application number
PCT/US2003/037601
Other languages
French (fr)
Other versions
WO2004049125A3 (en
Inventor
Mark Cooke
Original Assignee
Manugistics Atlanta, Inc.
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Manugistics Atlanta, Inc. filed Critical Manugistics Atlanta, Inc.
Priority to AU2003293018A priority Critical patent/AU2003293018A1/en
Publication of WO2004049125A2 publication Critical patent/WO2004049125A2/en
Publication of WO2004049125A3 publication Critical patent/WO2004049125A3/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions

Definitions

  • the present invention relates to a configurable price optimization application which allows users to define or add additional boundaries and constraints as needed to better meet business concerns and to improve the accuracy of the pricing optimizations calculations.
  • Businesses commonly use promotional schemes to improve sales volumes and profits. For instance, a business may adjust prices as needed to encourage sales of particular products. Likewise, businesses may specially present or advertise their products to increase consumer awareness and demand. To generate incremental revenue or expand market share, companies spend billions of dollars annually in promotional discounts, rebates, cash incentives, coupons, and subsidized financing. Because of the variety of promotions in play at any one time, the complexity of the market, and an inadequate understanding of customer response, few companies are able to accurately predict the overall effectiveness of their promotional spending.
  • the user making promotion decisions is faced with the challenge of how to best target promotional spending to achieve corporate goals at the lowest cost. To make this decision, the user needs to accurately forecast how a proposed promotion will affect revenues, profits, and sales volumes for each product. Likewise, the user needs to calculate how much each promotion will reduce on-hand inventory while minimizing cross-product and cross-segment dilution. The user further needs to predict how different market segments will react to different types of promotions. The user also needs to determine which combination of promotions will produce the highest return on expenditure while meeting sales, margin, and market share targets.
  • the present invention provides a promotion pricing system and a related model for producing a value evaluation and recommendation for promotion on a targeted product so as to analyze, evaluate, improve, and design promotions to meet a user's need.
  • the promotion pricing system generates promotion price evaluations and recommendations for each product promotion related to a target product of a user along with associated competing products from the user and competitors.
  • the user can be an individual, an organization, a corporation, an association or any entity providing, including activities related to making, selling, resale, offering for sale, distributing and other commercial conducts, products or service or both in the stream of commerce.
  • the promotion pricing system of the present invention is general enough to provide price evaluations and recommendations with varying degrees of available data. While the ideal client for the system would maintain data on lost customers, competitor prices, industry availability and the like, most clients will have data on only a subset of the potential drivers of market response. In this way, the system enables the user to obtain valuable insight from the evaluation of a promotion program even with a minimum amount of input data and then increasing that value through increased forecasting accuracy and accurate evaluation as new and/or existing data is integrated.
  • the promotion pricing system of the present invention enables the user to determine the impact of proposed promotions before committing to the promotion. Using historical data and statistically derived market response models, the promotion pricing system tests promotional scenarios and forecasts the results.
  • the promotion pricing system can simultaneously consider cannibalization effects of the promotion on other products or channels, allowing the user to maximize overall revenue growth.
  • the user may develop and target promotions for each product, customer segment, and distribution channel.
  • the promotion system further helps the user determine the best allocation of promotion and incentive dollars to meet your goals at the lowest possible expenditure. In this way, the promotion system and method of the present invention can produce substantial additional profit per year.
  • the promotion system of the present invention tracks its progress, generates performance alerts when user-defined parameters are exceeded, and quickly pinpoints problems. Meanwhile, results are fed back into the system to help fine-tune future campaigns.
  • the promotion system of the present invention allows a business to better understand customer price sensitivity and to acquire new customers at the least cost while retaining existing customers.
  • the system further helps manage product or service life cycles by suggesting promotions to encourage the sale of older inventory.
  • the promotion system further acts to minimize product cannibalization and to address sales shortfalls.
  • the promotion pricing system of the presenting invention is comprised of modularization of the necessary analytical steps along with specifications for these modules. These modules cooperate to implement statistical market response estimation that provides statistically stable, fact-based information on customer response to promotions.
  • the modules further allow data capture to leverage enterprise and supply chain data sources.
  • the modules include a product segmentation module, an incentive translation module, a customer segmentation module, a data aggregation module, a model selection module, a calibration module, an evaluation module, a constraints generation module, a cost structure module, an optimization module, a market channel performance module, and an alert module.
  • the system has a distributed architecture that is flexible, easy to configure, and easy to deploy and use over an internet/intranet.
  • a preferred embodiment of the promotion pricing system is constructed using modules coded in Java and distributed over the Internet to allow large-scale, controlled access to the promotion pricing system of the present invention.
  • the system may include a promotion pricing dashboard to enable proactive analysis of business performance and market dynamics.
  • the system may also include a strategy tester to help determine the most effective promotion schemes as well as a market response engine to maximize demand lift, revenue, and profits.
  • the present invention provides a configurable pricing system that allows users to define or modify data used to analyze, evaluate, improve, and design pricing changes according to the user's need.
  • a Graphical user interface or some other type of user interface allows the user to access and review various data to be used during pricing optimization. The user may then modify this data as needed to improve the pricing evaluation, such as defining sales or pricing trends, or relationships between the product of interest and other competing items.
  • the user interface may further display changes in pricing and the effects of the pricing changes, as caused by the user's changes.
  • the interface may also allow the user to modify the mathematical model to be used during price optimization, as well as define variables, constraints, and boundaries to be considered during the price optimization.
  • FIGS. 1A-C illustrate block diagrams of a promotion pricing system in accordance with embodiments of the present invention
  • FIGS. 2-13 represent steps in the operation of various components of the promotion pricing system of FIGS. 1A-1C;
  • FIG. 14 represents a user configurable pricing optimization system in accordance with embodiments of the present invention.
  • the present invention provides a promotion pricing system 100 for producing and evaluating promotion pricing strategies.
  • a user may employ the present invention to evaluate historical data to determine a more ideal promotional strategy to accomplish various business goals, such as increasing total sales volumes or increasing sales in certain desired market segments.
  • the promotion pricing system functions to either propose a promotional strategy or to evaluate the expected effect of a promotional policy provided by the user.
  • the promotion pricing system 100 works by defining the market by specifying the various products in the market, as well as the suppliers (i.e., sellers in the market) and demanders (i.e., consumers).
  • the promotion pricing system 100 looks to historical market data to create a market model which may be used to determine various information, such as profit or sales maximizing conditions.
  • the promotion pricing system 100 includes combinations of the following components: A product segmentation module (“PSM”) 200, an incentive translation module (“ITM”) 300, a customer segmentation module (“CUSM”) 400, a data aggregation module (“DAM”) 500, a model selection module (“MSM”) 600, a calibration module (“CM”) 700, an evaluation module (“EM”) 800, a constraints generation module (“CGM”) 900, a cost structure module (“COSM”) 1000, an optimization module (“OM”) 1100, a market channel performance module (“MCPM”) 1200, and an alert module (“AM”) 1300.
  • PSM product segmentation module
  • ITM incentive translation module
  • CUSM customer segmentation module
  • DAM data aggregation module
  • the components may operate concurrently on independent computers, while interacting and exchanging data using known communication and networking techniques.
  • the components 200-1300, as well as the general operation of the promotion pricing system 100, are now described in greater detail below. However, the general, overall operation of the promotion pricing system is first provided.
  • the promotion pricing system 100 receives various data inputs and processes these inputs to analyze promotion schemes.
  • the inputs received by various embodiments of the promotion pricing system 100 are product information, consumer account information, commercial channel information, purchase/sales order information, competitor and competitor product information, and promotion campaign information.
  • Product information is part of the base data required by the promotion pricing system 100.
  • the product information consists of basic product information on pricing, costs, inventory and product hierarchies.
  • account information provides account or customer profile information. This data is used to micro-segment the market and target different customer profiles with customized promotions.
  • Channel information encompasses data on both inbound Sales channels (via which customers purchase system 100s or services) and outbound Marketing channels (through which customers are presented with promotional campaigns).
  • the promotion pricing system 100 uses this information to incorporate sales channel-specific buying behavior, price elasticity, and costs. Information on outbound channels is used to model marketing channel-specific cost distinctions and response variations. Overall, product, account, and channel information form the base data for the promotion pricing system 100.
  • Sales order information answers the question “who bought what at what price when and how,” where the "who” identifies the customer segment or profile of the customer; the "what" the set of products or services on offer; the “price” the pricing information associated with the sale, including any promotion information if relevant, and the "when” the timing of the purchase; and the how the channel or medium used for the sales transaction.
  • both the user's own sales order and competitive sales order information are available for the promotion pricing system 100 to model competitive factors.
  • Competitive information forms another component driving the system 100's analysis of promotional schemes. This data identifying competitors helps to establish the competitive landscape.
  • raw sales order or market share data may be used to incorporate competitive information into the analysis. As laid out below, this information could manifest itself in either transaction or market share data.
  • Competitive sales order data consist of sales transaction data on competitive products. If unavailable to the user, the Sales Order data could potentially be obtained from various third-party sources depending on the user's industry. In the event that Competitive Sales Order data is unavailable, the promotion pricing system 100 can use market size and market share information to model competitive factors. However, this lack of information may curtail the effectiveness of the competitive model.
  • Promotion or campaign information forms the third important ingredient required by the promotion pricing system 100.
  • Promotion information describes in detail the nature of past or currently running campaigns and the incentives associated with each. This information includes a listing of prior promotions, the product segments and trading channels associated with the prior promotions, the nature of the promotions, the duration of the promotions, etc.
  • the promotion pricing system 100 analyzes a promotion scheme and produces several outputs, including promotion effectiveness and market response, price elasticity information, and cannibalization/dilution details. In determining price elasticity, the promotion pricing system 100 may generate both the user's elasticity and cross-elasticity of other products, sales channels or incentive types on market response. The resolution of the forecasts depends on the quantity and quality of sales order and competitive data available. If individual product forecasts cannot be reliably generated, elasticity at an aggregate level (or product segment group) is generated by the promotion pricing system 100.
  • the promotion pricing system 100 can compute expected lifts (i.e., sales increases) for a given promotion program in terms of quantity revenue, margin, or other industry-specific metrics. These estimates are generated at the level product, incentive type, sales channel, and marketing channel levels. The promotion pricing system 100 may then use cross-elasticity determinations to compute cannibalization or dilution effects on a given product or sales channel from competing or surrogate products and sales channels.
  • promotion system 100 Another functionality of the promotion system 100 is mark-down optimization.
  • a retailer may receive shipments of excess inventory to their stores. The retailer knows how much of this inventory is normally sold within a given period of time given historical information and general business knowledge. However, they do not know the optimal discount to set to achieve the objective of selling that inventory within the specified time period. In other words, the user does not want to overdiscount a product, promotion system 100 can solve this type of problem given certain inputs such as the target product, the total initial inventory for that product, and the amount of inventory that is to be sold for a given period. Promotion system 100 would then compute that discount which maximizes profit while clearing pre-identified excess inventory during the specified period.
  • the promotion system may also perform strategic objective analyses in assessing and achieving strategic corporate objectives.
  • a user generally does not know if 1) an objective is obtainable, and 2) how strategically she should approach achieving this objective using promotional incentives.
  • Promotion system 100 can solve this problem by identifying 1) if the revenue target is feasible, and 2) if the target is feasible, what promotional incentive level will maximize profitability given this constraint.
  • the PSM 200 defines the products in the market model created and analyzed by promotion pricing system 100. Specifically, the PSM 200 creates and organizes a list of related products. As generally illustrated in FIG. 2, the PSM 200 may employ a production segmentation method 210 for collecting, organizing and presenting the product data. The user may input this data (Step 220), or the PSM 200 may collect data from a list of products, step 230. For instance, the PSM 200 may download data from a database containing product catalog information or may employ known data collection and mining techniques such as automated XML data crawling applications. Alternatively, the PSM may use defining product characteristics to select appropriated competing products in view of a list of the user's products.
  • the PSM categorize products into product segments by similar behavior, attributes, or features, step 240.
  • the categorization of the products may be generally accomplished by organizing the product data into a relational database and then employing standard query language (SQL) to organize the product data according to desired characteristics.
  • SQL standard query language
  • the PSM 200 may determine promotion impacting factors including impacts across segments, step 250.
  • the PSM 200 may then list the user's own target products along with associated, competing products, step 260. In this way, the PSM 200 also defines the suppliers to the market model created and evaluated by the promotion pricing system 100.
  • the PSM 200 does not include competitors' products in the product segmentation. Instead, the PSM 200 only looks to the user's products. In this way, the collection and analysis of data are simplified at the cost of decreased accuracy.
  • the promotion pricing system 100 operates under the general assumption that transactions are independent events that differ only by promotional efforts. These assumptions become increasingly less likely with smaller sets of data and suppliers.
  • the CUSM 300 defines and categorizes the consumers of the products specified by the PSM 200 in the product segmentation method 210.
  • the user may manually provide data for the segmentation of the customers or, more typically, the CUSM 300 may automatically segment the customer according to various demographic or market information.
  • the CUSM 300 preferably automatically segments the customers using various characteristics. For instance, commercial consumers may be divided into categories of differing business sizes and revenue levels.
  • the CUSM 300 may operate using a customer segmentation method 310, as illustrated in FIG. 3. In the customer segmentation method 310, the CUSM 300 first collects a list of customers for the products defined by the PSM 200.
  • the CUSM 300 may either receive the customer list from an external source, step 320, or the CUSM 300 may automatically generate the customer list, step 330.
  • the CUSM 300 may analyze a record of past transactions involving the products designated by the PSM 200.
  • the CUSM 300 next reviews customer characteristics, step 340.
  • the analysis of the customers may be generally accomplished by organizing the customer data into a relational database and then employing SQL to organize the customer data according to desired characteristics, such as geographic location.
  • the CUSM 300 then divides the customers into different possible global customer segmentations, each with two or more segments, step 350. Using historical transaction data, the CUSM 300 may further determine cross impacts between customer segments, step 360.
  • the CUSM then keeps only the customer segmentations without cross-impact between different segments, step 370.
  • the CUSM 300 only looks to customer categories in which sales are independent events to avoid covariance terms in the mathematical evaluation of the market model created by the promotion pricing system 100. In other words, sales to one consumer segment of the market should not effect demand from other consumer segments.
  • the ITM 400 collects and organizes data related to various promotional techniques.
  • the ITM 400 may employ an incentive typing method 410, as illustrated in FIG. 4.
  • the ITM 400 collects incentive offers for promotion programs over certain time periods, step 420.
  • the ITM 400 specifies different incentive types associated with promotion programs for both the user's own target products and competitors products identified by the PSM 200.
  • the incentives may include rebates, discounts, low-rate financing, bundled goods, etc.
  • the user may provide the promotion data, or the ITM 400 may evaluate prior transactions to determine historically employed promotional techniques.
  • the ITM 400 then translates the incentive offers into consistent measurable drivers by incentive types, step 430.
  • the ITM 400 may mathematically transform the promotions to best fit market modeling needs.
  • the ITM 400 may further consider non-monetary promotions, step 440.
  • the ITM 400 may add to the list of incentives non- monetary incentives such as prominent display or advertisement of the products.
  • the non- monetary incentives identified in step 400 may typically be specified by the user, prespecified in the ITM 400, or may be dynamically determined from transaction data.
  • the DAM 500 evaluates historical transactions in view of the various defined products, customers, and promotional techniques. Specifically, the DAM 500 may employ the data aggregation technique 510 depicted in FIG. 5. In step 520, the DAM 500 may separate data by customer segments. The separation may be automated or specified by the user. The DAM 500 may then determine a time interval at which to aggregate transaction volume data, step 530, on the basis of the number of time periods needed to estimate parameters, the incentive offer and price variation cycle, and data collection frequency. The DAM 500 then aggregates volume data at selected time intervals for target products, step 540.
  • the DAM 500 aggregates competing product volume at the same time interval, and calculates corresponding market share under each segment, step 550.
  • the DAM 500 then computes average prices and incentive offers by each channel for each product over each time interval, step 560.
  • the DAM 500 uses statistical analyses techniques to determine patterns, such as seasonality, and other statistical factors, step 580.
  • the output of the DAM 500 is typically a relational database in which each historical transaction has been characterized by product segment, customer segment, and incentive type.
  • the MSM 600 then uses the aggregated data created by the DAM 500 to select an appropriate model for use in analyzing and accessing promotional efforts.
  • the MSM 600 generally employs a model selection process 610 depicted in FIGS. 6A-B.
  • the MSM 600 first lists the user's own target products and lists all associated products from the user's competitors, step 615.
  • the MSM 600 evaluates whether competitor information is available. If competitor information is not available, a simplistic statistical model is used to model the promotions with the penalty of lower accuracy, step 625. The simplistic model is described in greater detail below.
  • the promotion pricing system may initially use the simplistic statistical model and change to more precise promotion evaluation models as more data becomes available.
  • the MSM 600 decides whether a substantially complete set of product volume data is available over the time periods of interest. If a substantially complete set of product volume data is available over the time periods of interest, then the dependent variable during evaluation is sales volume, step 640, and the promotion pricing system 100 evaluates promotion efforts using a multiplicative model described in greater detail below, step 645.
  • the MSM 600 evaluates the product segments defined in the PSM 200, step 650. At decision 660, the MSM 600 determines whether there is apparent cross impact among these segments. Likewise, at decision 670, the MSM 600 determines whether any of the promotion programs substantially overlap over different time periods of interest. If there is an apparent cross impact among these segments or any of the promotion programs substantially overlap over different time periods of interest, then the dependent variable during evaluation is sales volume, step 640, and the MSM 600 selects the multiplicative model for use during the promotion pricing system's 100 evaluation of promotional efforts, step 645.
  • the MSM 600 uses market share as the dependent variable during evaluation, step 680.
  • the MSM decides whether there are too many products in each segment defined by the PSM 200, determination 690. Generally, the MSM 600 looks to see if the number of products in each segment exceeds a predetermined maximum. If there are too many products in each segment, the MSM 600 again selects the multiplicative model for use during the promotion pricing system's 100 evaluation of promotional efforts, step 645. If the MSM 600 determines that there are not too many products in each segment during determination 680, the MSM 600 selects an attraction model for use during the promotion pricing system's 100 evaluation of promotional efforts, step 695. The attraction model for evaluating promotions is described in greater detail below.
  • the subjective variable of attractiveness or utility does not really exist.
  • the user may use Market Share (actually the natural logarithm of market share) or sales volume to represent the attractiveness, or utility, of the product i, deal type j.
  • the CM 700 evaluates the above- described inputs and produces the outputs results using different models that guide the data analysis. For instance, the CM 700 may use either a multiplicative model that measures market share or sales volumes. Alternatively, the CM 700 may use an attraction model that measures market share. Specifically, the CM 700 determines the values for the dependent variables designated above in step 640 and 690. The CM 700 further integrates new transaction data to adjust values of the dependent variable. In turn, as described below, the EM 800 uses the values for the dependent variables to access various promotional planning schemes. The operation of the CM 700 varies according to the model selected by the CSM 600.
  • X ki the kth marketing instrument on product i and can be prices, incentive offers, or other factors;
  • P the parameter for effect k that are global over the set of considered products.
  • Equation 1A Equation IB.
  • Yi may be defined as the natural logarithm of the utility of product i as measured by either volume or market share, as represented in equation 1C:
  • the dependent variable in the multiplicative model is either sales volume or market share.
  • sales volume raises concerns of seasonality and trend factors in the transaction data, whereas market share tends to be more stable over different time periods. For instance, the sales volumes of many products are higher during the Christmas season regardless of promotion schemes.
  • the elasticity in the multiplicative model is equal to ⁇ and is constant over market share and driver levels. Accordingly, the multiplicative model is generally dependent on the user's sales volumes data but does not look to competitors' transaction data. Also, because it is easy to aggregate sales volume over multiple time periods, it is fairly simple to incorporate data from different time periods.
  • the attraction model uses only market share as a dependent variable and assumes constant total sales quantities. In this way, the attraction model incorporates data from competitors' transactions. Specifically, the attraction model uses the following equation to measure a product's utility and to quantify any change in the value or "utility" of product caused by a promotion.
  • X h the kth marketing instrument on product i
  • P k the parameter for effect k that are global over the set of considered products
  • fk a function, such as Id, depending on the driver.
  • the attraction model embodied in equation 2A does not take into account effects induced by any competitors, or any effect other than the ones generated by the product, the brand's product or exterior global parameters such as the trend. Also, the variables used can be either quantitative, such as price and age, or qualitative, such as trend or the belonging to a specific category.
  • si is the market share of product i
  • Ai is the utility (market share) of product i
  • n is the number of considered products in the segment
  • ⁇ Aj is the total utility (market share) of m product in the segment.
  • the promotion pricing system employs a differential-effect version of the attraction model.
  • the parameters of the attraction model are product-specific instead of being global. Therefore, equation 2 A becomes:
  • Equation 2B is thereby modified to product equation 2C: K m
  • Equation 2B may be rewritten as
  • J a set of promotion types
  • ⁇ i constant influence of vehicle i
  • ⁇ ij.k kth parameter of vehicle i, deal type j
  • the CM 700 uses a calibration method 710 as illustrated in FIG. 7.
  • the CM 700 first receives data from the modules 200-600 as well as historical transaction data, step 720.
  • the CM 700 next evaluates the data using one of the models for determining the utility of a product, step 730. Once all parameters have been obtained, the attractiveness of the target incentive could easily be calculated, and so can the market share, Sij, step 740
  • ⁇ A y for all pairs of i and j represents is the sum of utilities for the subsegment of the target vehicle.
  • the CM 700 may also determine period variables, step 750.
  • the period variables account for the fact that the sum of market shares in a subsegment, in a period of time, equals one.
  • the dependent variable in the regression is utility. Since this variable does not really exist, the Manufacturer may use Market Share to represent utility with certain adjustments.
  • the following equation shows the relationship between Utility and Market Share.
  • the CM 700 When using ln(MarketShare) to represent In (Utility), the CM 700 should not exclude In (f(month)) from the model. Thus, the period variable, some function of month, has been incorporated in the model.
  • the CM 700 may function as a modules promotion translator that translates the different promotions offered into the appropriate driver of a product, step 760.
  • the driver represents the actual impact of the promotion on customers' valuation of the product and competitive products. For instance, customers may be indifferent between discounted prices and reduced interest rate financing because either promotion may allow the customers to pay the same periodic and total payments. It should be appreciated that the term "incentive" may also be used to refer to an aggregate of separate offers. There are no functional requirements concerning the value of the drivers. However, there may be some requirements due to the mathematical process used within the various models. Evaluation Module 800
  • the EM 800 accesses the promotion scheme using the calibration results produced by the CM 700 in method 710. Specifically, the EM 100 uses the evaluation method 810, as depicted in FIG. 8. During evaluation, the EM 800 receives baseline information from the user, including sales volume information for the attraction model, information of the user's promotions, and competitors to the related products ups, assuming the same promotions existing offers across customer segments, step 820. If the market share is predicted by the multiplicative model, the share elasticity should be evaluated instead of volume in step 820. The user may also input values for predicting variables to get responses for an adjusted program, though incentive offers to one customer segment could be distinctive from the other, step 830. For the attraction model, the user may input the total baseline volume Vi for the product over interest over the defined customer segments, the baseline volumes for other choice sets can be derived by market shares and overall customer segment ratio as follows. For example,
  • V V, r * S [r * S kl + (l - r)* S i2 ]
  • Vj V, * V * S ⁇ + (1 - r > S J 2 / * S A + (1 - r> S t2 ] (9)
  • the EM 800 may also allow the user to specify or select business goals, such as profit maximizing or sales volume maximization, step 840. For instance, the user may wish to maximize sales and may accept losses on the sales to accomplish the increased sales volume or market share.
  • the EM 800 may access constraints created by the CGM 900 described below. In this way, the EM may determine which goal may be accomplished while adhering to the specified constraints.
  • perfo ⁇ ning profit maximization the EM 800 predicts the ability of the promotion scheme to change profits, step 845. The EM 800 looks to the sales price and the expected change in sales for a product. The EM 800 then uses these values to estimate expected revenues attributable to the promotion scheme.
  • the EM 800 may also receive an estimate of costs produced by the COSM 1000, as described below. The EM 800 may then find the expected profits attributed to the promotion scheme by subtracting estimated costs from the estimated revenues.
  • the EM 800 may also cooperate with other applications to increase the accuracy of the evaluation.
  • the EM 800 may cooperate with a known demand forecasting application, step 850, such as NetWORKS DemandTM produced by Manugistics, Inc. of Rockville, Maryland.
  • the demand forecaster acts as an early-warning system, predicting future customer demand, alerting of potential supply problems, and finding patterns undetected by traditional solutions. It enables a user to understand demand drivers, to more accurately predict future needs, and to unify disparate planning processes through its scalable and web-based multi-model architecture. In this way, the EM 800 may separate demand changes caused by market forces from sales changes resulting from a promotion.
  • the EM 800 may also integrate with known market management applications to control inventory supply levels in a market through promotions, step 860.
  • NetWORKS Market ManagerTM produced by Manugistics, Inc. of Rockville, Maryland provides a global view of all market activities that are happening for a product, location, or product family, simplifying the process of coordinating market activity information related to market promotions.
  • EM 800 predicts and evaluates the ability of suggested promotions to the to predict the availability of the suggested promotion to achieve goals desired by the market management application.
  • the EM 800 may integrate this data into the evaluation, step 870. Specially, the EM 800 may adjust the utility values produced using either the multiplicative method or the attraction method to reflect actual sales data related to a promotion. In this way, the EM 800 may also look to actual sales and adjust the prior predictions. Constraints Generation Module 900
  • the CGM 900 functions to accept, create or define various constraints on the variables used in the other components of the promotion pricing system 100.
  • the CGM 900 operates according to a constraints generation method 910 depicted in FIG. 9.
  • the CGM 900 first accepts user defined constraints, step 920.
  • the CGM 900 may generate constraints, step 930, based on inputs from the user or prespecified settings.
  • Possible constraints include directionality constraints to enforce the assumption that a promotion scheme should only positively affect product utility.
  • Another possible constraint is to assume equal cross impact, thereby assuming that increase in sales volumes of market share are equally taken from other competitors, thereby simplifying the promotion assessment calculations.
  • Another set of constraints relate to the incrementality, or the minimal intervals between usable values for the variables in the calibration and assessment. For instance, rounding the values for a variable may decrease accuracy but decreases the computational accuracy.
  • Application of constraints may restrict regular significance tests of estimated parameters, but the calibration process will provide adjusted R2 to evaluate model fitness.
  • the COSM 1000 functions to determine costs for the promotion schemes. As described in the cost organization method 1010 and illustrated in FIG. 10, the COSM 1000 first determines base product cost without the promotion scheme, step 1020. The COSM then determines indirect promotion costs caused by the promotion scheme, step 1030. In particular, the COSM 1000 looks to, for example, the increased costs per unit associated with increased sales volume or share from the promotion. The COSM 1000 next determines the direct costs for the promotional scheme, step 1040. For instance, the COSM 1000 may determine incentive costs, offer channel cost, customer segment cost, order channel cost, etc. The COSM 1000 then sums the indirect and direct promotion scheme costs to determine a total cost.
  • Optimization Module 1100 One common question facing businesses is which products should be targeted for promotional incentives (i.e., discounts) and at what level should these discounts be set? The OM 1100 can provide the answer to this question. Specifically, the OM 1100 will identify the optimal discount for each product (which generates the highest profitability) and rank products by profitability (given the recommended incentive).
  • the user can establish business constraints to better reflect the needs of their business. For example, in the set fixed incentive levels, the user can identify an incentive level that should apply for any selected products or segments (i.e., all menswear should be discounted at 15%). In equality constraints on incentive levels, the user can specify that the discount for dress slacks should always be equal to the discount for dress shoes. With Min / Max constraints on incentive levels, the user can set a maximum discount level (i.e., max discount of 50% assuring that the effective price of the product remains above that of lesser product lines), or minimum discount level (i.e., min discount level should remain above 6% to assure customer satisfaction and ease of communication).
  • a maximum discount level i.e., max discount of 50% assuring that the effective price of the product remains above that of lesser product lines
  • minimum discount level i.e., min discount level should remain above 6% to assure customer satisfaction and ease of communication.
  • Min / Max constraints on margin allows the user to ensure that the recommended discount level will not erode the objective per unit margins for a product (i.e., the margin for dress slacks must remain above 4%). Minimums can also be set (i.e., we must achieve at least a 10% margin on the sale of dress shirts). Similarly, set fixed margins allows a target margin to be established (i.e., all products within the casual wear product line must have a margin of 14%).
  • Max incentive budget at global level the user may specify a total "Incentive Budget” for a given time period (i.e., the total amount of cash back incentives should not exceed $800,000 for the next fiscal year, or the total dollar amount of cumulative discounts must not exceed $10,000).
  • Inventory constraint allows the user to specify an inventory amount to prevent product shortages resulting from a sale (i.e., for a summer promotion, users only have 20,000 t-shirts available, and therefore, should set the discount level to maximize profitability for this number of units).
  • users identify the number of units to be sold for a given period (i.e. in March, the user would like to sell 5,000 units of Dress Slacks).
  • the OM 1100 will identify the Promotional Incentives that maximize profitability given general user inputs. This is a highly intelligent feature that offers significant value in solving a variety of "real-world" business issues.
  • the optimization feature is related to the above-described strategic objective analysis feature, which evaluates several promotions to meet a target revenue.
  • an apparel retailer may desire to increase profitability.
  • the retailer offers a variety of product lines, of which Dress Slacks and Button-Down Shirts have recently encountered increased sales as a result of the popularity of designs.
  • Store Groups that the retailer can utilize to generate sales. In particular, Western Region stores currently have not been showing reasonable profitability. This retailer historically has offered flat discounts at the product level to generate sales.
  • Promotion system 100 can provide the answer to this question by identifying a group of products to consider for promotions and the promotional incentive type (i.e. discount).
  • the OM 1100 will:
  • the user can identify which products within the dress slacks and button down shirts should be targeted for promotions, what the promotional incentive should be for each (i.e., discount), and how this will affect the overall profitability of the Western Region store group.
  • the user can establish business constraints to better reflect the needs of their business.
  • the user may define the following business constraints. For instance, the user may set fixed incentive levels which can identify an incentive level that should apply for any selected products, store groups or sales channels (e.g. all menswear should be discounted at 15%).
  • the user may use equality constraints on incentive levels that can specify that the discount for dress slacks should be the same across all regions.
  • the Min/Max constraints on incentive levels can be set at a maximum discount level (e.g. max discount of 50%), or minimum discount level (e.g., min discount level should remain above 6% to assure customer satisfaction and ease of communication).
  • the Min/Max constraints on margin allows the user to assure that the recommended discount level will not erode the objective per unit margins for a product (e.g., the margin for Dress Slacks must remain above 4%).
  • Maximums can also be set (e.g. we can have at most a 10% margin on the sale of Dress Shirts).
  • the user may set fixed margins which allow a target margin to be established (e.g., all products within the casual wear product line must have a margin of 14%) by setting the Min/Max incentive budget at global level, the user may specify a total "Incentive Budget" for a given time period (e.g., the total amount of cash back incentives should not exceed $800,000 for the next fiscal year, or the total dollar amount of cumulative discounts must not exceed $10,000).
  • the inventory constraint allows the user to specify an inventory amount to prevent product shortages resulting from a sale (e.g., for summer promotion, only have 20,000 t-shirts available, and therefore, should set the discount level to maximize profitability for this number of units).
  • the demand target helps the user identify the number of units to be sold for a given period (e.g., in March, sell 5,000 units of Dress Slacks).
  • the OM 1100 allows the user to select the promotion that maximizes profit, subject to certain constraints. This is particularly useful if the market response model incorporates cannibalization or affinity relationships. As illustrated in Fig. 11, the OM 1100 employs an optimization method 1110.
  • the first step 1120 is to define an offer template. This generally consists of product/sales channel combinations, target customer segment, target incentive type and a time period. These may be defined according to previously defined methods, 210, 310, 410, and 510.
  • An offer is made to a list of choices, where a choice is a combination of customer segment, product, and channel. For each choice, there is an incentive type (e.g., cash back, discount), and an incentive level (e.g., $20 off, 5% off).
  • an incentive type e.g., cash back, discount
  • an incentive level e.g., $20 off, 5% off.
  • An offer template has the same form as an offer, with the following exception.
  • An offer has associated incentive levels (e.g., level of discount, APR). For example, printer at 20% off, computer at $100 off (assuming "printer” and "computer” are choices).
  • some of the incentive levels that take on real values may be set to be VARIABLE. So, for example, printer at VARIABLE % off, computer at $100 off might be part of an offer template.
  • Each offer template has instances associated with it. For example, printer at VARIABLE % off, computer at $100 off would have, as an instance, printer at 20% off, computer at $100 off.
  • the user specifies business rules/constraints.
  • Incentive constraints apply at the group level.
  • a group is a set of product / channel combinations that have been selected together by the user.
  • incentive constraints including:
  • the user can set the incentive level to be a certain fixed amount (e.g., 7%) for all choices in the group.
  • the user can specify that all the incentive levels within the group lie between specified min and max values.
  • the user may specify a min or a max or both.
  • Amount - Cost (Cost).
  • the user can specify that all margins within the group must be a certain amount (e.g., 8%).
  • the system may set equality constraints on incentive levels within the group.
  • Financial constraints (min / max incentive budget) apply at the global level. This constraint will apply only to those product/sales channel combinations that are a part of the promotion.
  • Incentive budget is the sum of cost of discount times volume across all product/channel combinations that are a part of the promotion.
  • volume constraints (min / max volume, inventory) apply at a product level. These constraints apply only to product / sales channel combinations that are a part of the promotion. For example, suppose the user has selected "Blue Shirts/San Francisco,” “Blue Shirts/San Jose” and “Blue Shirts/L.A.” to be in the promotion, where "Blue Shirts” is a product. Then the user could impose a volume constraint on the sales of Blue Shirts. This would be applied to the sum of volumes, Vol(Blue Shirts/San Francisco) + Vol(Blue Shirts/San Jose) + Vol(Blue Shirts/L.A.).
  • Optimization subject to inventory constraints is similar to unconstrained optimization but user could add constraints saying that demand generated should not exceed user-specified amounts (e.g., amount of inventory available). Alternatively, the user may optimize subject to business rules.
  • incentive groups the user can ensure that incentives are constant across a product category.
  • constraints the user can operate within a fixed marketing budget, and/or ensure that incentives do not vary too greatly from what is currently in place.
  • the OM 1100 determines the optimal offer. Specifically, the OM 1100 aims to solve (or approximately solve) the problem of considering all the offers that are instances of this offer template. The OM 1100 further considers the subset of these that satisfy the constraints. Each such offer will have an associated profit, and the OM 1100 finds the one that gives the largest profit and uses this as the optimal offer.
  • the OM 1100 generally produces exact values; for example, it may return that an optimal discount is 28.47% off. The user can always use the optimized program as a guide and round values. Optionally, the OM 1100 may restrict optimization to consider only rounded promotions. In the instant example, the OM 1100 may compare the profitability of a 28% discount with profits from 29% discounts.
  • the strategy testing method 1210 comprises the creation of an offer for the customer segment and products of interest, step 1220.
  • the next step 1230 is to try different direct channel and inventive offer combinations.
  • the MCPM 1200 then chooses the promotion offer that gives the best results, 1240.
  • the user's inputs into the MCPM 1200 includes target products; target customer segment; target incentive type, e.g., cash rebate; marketing communication budget; direct mail unit costs; direct telemarketing unit costs; etc.
  • target incentive type e.g., cash rebate
  • the promotion system 100 determines the number of consumers reached if certain direct channel is chosen as well as which direct marketing channel to choose in order to achieve high margin and what incentive offer gives higher margins.
  • the promotion system 100 further determines expected propensity of a promotion offer, expected number of sales of a promotion offer, expected incremental costs of a promotion offer, and expected incremental profits of a promotion offer.
  • a marketing manager has a given number of consumers to reach in the target segment, and is trying to create a direct campaign to promote certain products and achieve high margin at the same time.
  • the AM 1300 produces alerts bringing to the user's attention any unexpected data trend.
  • This feature refers to a list view of data behavior that violates some administrator defined business rules in terms of performance indicators.
  • the alert method 1310 is depicted in FIG. 13. Specifically, pre-defined logical expressions with threshold parameters need to be specified and updated by user step 1320.
  • Baseline value refers to the value against which actual current value is compared. It varies depending on the alert type and is defined during step 1320.
  • Various levels of alert severity may be defined in step 1320.
  • the severity relates the degree of deviation from a baseline value to an actual value.
  • the user needs to specify thresholds against which comparison is made, based on business domain knowledge and practice, and then input them into the appropriate data table. For instance, a severe alert for the actual vs. forecast could be generated if actual sales fall 2000 units or more short of forecast; similarly, a medium alert for the same type would be generated if actual sales fall 1000 to 2000 units short of forecast; and so on.
  • thresholds for a severe alert is 2000 or more, and between 1000 and 2000 for medium alerts.
  • the alert may further have a direction either below or above, which indicates if actual values are below or above baseline values.
  • the time period transaction data is aggregated to generate business metrics. It is also the time unit each forecast value is based upon. For actual vs. forecast alerts, it is time unit which forecast is made upon depending on the time unit for the calibration process.
  • the AM 1300 defines this time unit as the basic time unit. For other types of alert, it could be anything beyond the basic time unit, and it is highly desirable to have other time units. For instance, if the basic time unit is made at a weekly level, the time unit could be week, month, quarter, and year, etc. for alerts of current period vs. previous period.
  • the AM 1300 may employ dynamic on-line analytical processing capability to perform any one of the following actions several times over or in succession, in order to gain a better understanding of a business situation, step 1330:
  • Basic alert types include actual vs. forecast, current time period vs. previous period, same variation trend, and year over year comparison.
  • the actual vs. forecast alert is generated by comparison of actual values in the current time period to the forecast value.
  • the baseline value is forecast value for current time period. For instance, if the actual sales of button down shirt for last week were 1000 units less than the forecast, this type of alert would be stimulated.
  • An actual vs. forecast alert may be promotion focused, i.e., only promotion-associated sales can be involved in such an alert, because the forecast in current release is at promotion level.
  • a general forecast or planning enables a more general actual vs. forecast alert.
  • the current time period vs.
  • previous period alert is generated when actual values for the current time period are deviated from the previous time period at certain degree.
  • the baseline value may be the actual values for the previous time period. For instance, if the actual sales of button-down shirts for February were 1000 units less than those of January, such type of alert would be stimulated.
  • a variation trend may be generated when actual values in n consecutive time periods decrease or increase, showing a consistent trend in these time periods.
  • the baseline value could be a correlation coefficient for the time serial of actual values and time periods. For instance, if the monthly actual sales of button-down shirts from January to June of 2001 were 300, 280, 250, 240, 220, and 190, respectively, showing a declination trend, such type of alert would be stimulated because the correlation coefficient is more than 0.9.
  • a year-over-year alert may be generated when actual values for a time period deviate from the same time period in the previous year to a certain degree.
  • the baseline value refers to the value for the same time period in the last year. For instance, if December sales of button-down shirts in year 2000 were 3000 units less than those in year 1999, such type of alert would be stimulated.
  • the promotion system 100 is configured to operate over a distributed network such as the Internet.
  • the various modules of the promotion system 100 operate as JAVA or C applications that may be served or are executed at the server.
  • the user may be in communication with the system 100 via electronic networks such as the Internet, an intranet, an extranet, a Value Added Network ("VAN"), VPN and the like.
  • the Internet browser may be, for example, Netscape Navigator or Microsoft Internet Explorer.
  • FIG. 1C the promotion system 100 is connected to a market management application 40 and a demand forecaster 50. The interaction of the promotional pricing system 100 with these components is described above in the text accompanying FIG. 8.
  • the operation of the promotion system 100 and the use of drivers are now explained through the following example that describes the creation of a promotion pricing model for a manufacturer.
  • three types of incentives are offered by the Manufacturer for its truck - a cash rebate, low finance and a lease rate.
  • the truck finance and the truck lease drivers are the price paid by the customer per month, so by construction they will never be null. If the Manufacturer decides not to give any cash rebate for its Truck (no incentives for cash back), the driver price still won't be null for mathematical purposes because at some point in the process of calculating the utility of Truck, the log of the drivers will need to be calculated and, therefore, the drivers cannot be null.
  • the promotion system 100 operates to prevent null values for the drivers that may preclude or adversely impact the evaluation of the promotions.
  • Table 1 represents the different incentives that may be offered by the Manufacturer as well as the drivers affected by these incentives.
  • the promotion system 100 determines, for instance, that the product (or product segments) of interest is Truck (“T”) and the primary competitor product segment is an SUV (S). As suggested in the Table 1, the different promotions in this example are a cash discount (C), a finance discount (F) and a lease discount (L). Hypothetically, the customers for the product segments may be segmented into Upscale (U) and downscale (C) categories. The promotion system 100 may further define a trend or time period so as to compare offers across different times and thereby allow normalization for past promotions.
  • the incentive translator may further designate the independent variables representing the measure the consumers use to evaluate the competing products. For instance, the Manufacturer may use Attractiveness to measured utility in the product segment including the Truck and the SUV. As described above, the independent variable Attractiveness is a function of many factors, including:
  • preference variables are the constant component of the model, and the influence of the manufacturer's other products, cross-impact influences from competitive products, and trend factors impact the independent variable through their coefficients.
  • Other factors that may be considered in determining the Attractiveness of products are:
  • cross-impact influences such as cross channel, pull-forward factors
  • a choice is a combination of product i, incentive typej, and channel k.
  • a choice is what a customer can choose.
  • a choice context is the environment where customers are making decisions, or things customers cannot change.
  • a choice context is a combination of Market Group, Subsegment, Segmentation, Customer segment.
  • volumeT,C,Promo, Young VolumeA,B,Base, Young x XB ,Basc, r o m, g
  • Target choice Truck cash(T,C);
  • Baseline program Base
  • A can be any vehicle in the target subsegment
  • B can be any incentive type in the choice set
  • volumeA,B,Base, Young user's volume estimate of the baseline choice for the target customer segment
  • the sum of volumes for all choices in the promo program equals the sum of volumes for all choices in the baseline program, given the choice context. Another issue arises when user estimates VolumeA,B,Base Young. Practically, users may not have a good idea about this variable because this (VolumeA,B, Base, Young) may not be meaningful enough to them. To fix this, the promotion system 100 can use something more meaningful for the Baseline choice, and then the users will be asked to provide volume estimates for the Baseline choice, which now makes more sense to them. In the following example, the promotion system 100 asks users to estimate VolumeSedan,Base, Young,, instead of Volumesedan,Cash,Base, Young or Volumesedan,Fin,Base, Young.
  • volumeSedan,Base Young and STruck,Cash,Promo,Young are provided by user promotion system 100. Also,
  • the Promotion Pricing system 100 may calculate the conditional probabilities from the database, Prob(VolSedan,young
  • a choice is a combination of product i, incentive typej, channel k and represents what a customer can choose.
  • a choice context is the environment where customers are making decisions, or things customers cannot change.
  • a choice context may be a combination of Market Group, Subsegment, Segmentation, Customer segment.
  • users may associate different segmentations with different products.
  • the segmentation for Sedan is (Old, Young), and the segmentation for Truck is (Rich, Poor).
  • the Manufacturer has an incentive for (Sedan, Old), but there will be no incentive for (Sedan, Poor) because (Rich, Poor) is not how Sedan segmented its customers.
  • Sedarioid x so 0 0 0 B so Sedan ⁇ young 0 X s ⁇ 0 0 B SY
  • Xij the drivers, including its own driver and cross-impact drivers, for vehicle i, segment j;
  • Bij the parameters of the corresponding vehicle and segment are Xij , Bij matrices.
  • the promotion system 100 may calculate the cross-impact driver from Truck onto a customer segment J of Sedan.
  • Truck has 3 customer segments 1, 2, 3.
  • Each customer segment of Truck has its own cash incentive (CGAR), finance program incentive (FGAMP) and monthly lease payment (LMP). Call these CGAR(l), FGAMP(l), LMP(l), etc.
  • CGAR cash incentive
  • FGAMP finance program incentive
  • LMP monthly lease payment
  • weights being the conditional probabilities of the customer segments.
  • the promotion system 100 may assume that all other products will be associated with this segmentation as well. For example, there are still two products (Sedan, Truck), and the segmentation for Sedan is specified to be (Old, Young). The regression now looks like this:
  • equation 24 may be seen as :
  • X own drivers and cross-impact drivers.
  • Si the normalized market share of vehicle i
  • Equation 24 the sum of market shares of vehicles in the same subsegment With the multiplicative model, equation 24 is also written as:
  • constraints are the directions of Betas and other client-specific constraints.
  • the promotion system 100's goal is to get an idea of how many ⁇ parameters the calibration will need to determine.
  • the calibration process will need to solve the following equation for each customer segment and each subsegment of the products.
  • Y is the vector (n,l) of the utility of a product for a certain segment, channel, deal-type over the last n periods of time;
  • X is the matrix (n, m) of the drivers of a product for a certain segment, channel, deal-type over the last m periods of time;
  • B is the vector (m,l) of the ⁇ for a certain product, segment, channel and deal-type over the last m periods of time.
  • the promotion pricing system may estimate the variable m first, i.e., estimate for a product, deal-type, subsegment, customer segment, and channel, how many B needs to be calculated.
  • m first i.e., estimate for a product, deal-type, subsegment, customer segment, and channel.
  • the promotion system 100 may estimate each time the number of ⁇ , assuming global segmentation and no X-impact between trade-up/trade-down in different deal types or different channels, and no constraint across subsegments.
  • the number of ⁇ s equals the number of MarketGroups * the number of product Subsegments * the number of Customer Segments * [the number of Choices * (the number of Choices+2) + the number of Periods-1].
  • the number of Observations equals the number of MarketGroups * the number of product subsegments * the number of Customer segments * the number of Choices * the number of Periods. If there were no constraint, it has to meet the condition that the number of Observations is equal or greater than the number of ⁇ s to be able to estimate all ⁇ s. So,
  • the number of ⁇ 's equals the number of MarketGroups * the number of product Subsegments * the number Customer Segments * the number of Choices * (the number of Choices+2).
  • the number of Observations equals the number of MarketGroups * the number of product subsegments * the number of Customer segments * the number of Choices * the number of Periods. If there are no other constraints, the model still has to meet the condition that (X) the number of Observations is equal or greater than the number of ⁇ 's to be able to estimate all ⁇ s. Therefore, the number of Periods must be greater than the number of Choices +2.
  • the configurable pricing optimization system 1400 includes a price optimization application 1410 that operates by defining a optimization problem and producing an optimal pricing solution 1420 to the defined optimization problem.
  • the present application describes a value evaluation and recommendation for promotions on a targeted product so as to analyze, evaluate, improve, and design promotions to meet a user's need.
  • Other types of pricing optimization solution are also known. For instance, co-owned U.S. Application Nos. 09/517,983 and 09/517,983, the subject matter of which is hereby incorporated by reference, provide a pricing solution that addresses finding an target price for a particular item as needed to accomplish particular business goals (e.g., sales volume, profits, etc.).
  • Another pricing optimization application described in U.S. Application No. 09/859,674, the subject matter of which is also incorporated by reference, provides a dynamic pricing system that generates pricing recommendations for each product in each market by normalizing historic pricing and sales data, and then analyzing the historic data using parameters describing the user's business objectives to produce a pricing list to achieve these objectives.
  • These and other price optimization systems and methods generally entail the solution of an optimization problem given various constraints, boundaries, or the lack thereof.
  • the data used to define the optimization problem, including the various constraints and boundaries may be stored in a database 1430 associated with the price optimization application 1410.
  • the database 1430 may be a memory storage unit or other data structure physically represented in a known storage media such as electronic memory or semi-permanent magnetic or optical storage.
  • the configurable pricing optimization system 1400 includes a configuration application 1440 that enables users to define the optimization problems, such as defining various constraints and boundaries, as needed for the price optimization application 1410.
  • the configuration application 1440 may operate by directly editing the contents of database 1430 or by providing data directly to the price optimization application 1410, which then bypasses the stored data in the database 1430.
  • the configuration application 1440 may be implemented using multiple known methods.
  • the configuration application 1440 may be a text editor or other similar application that allows users to directly provide configuration data.
  • the configuration application 1440 may be some type of GUI (graphical user interface) program through a Visual Basic window or through another programming language such as JAVA or C+.
  • the configuration application 1440 may direct the user through a list of possible boundaries and constraints to be defined.
  • the configuration application 1440 may further show defaults values to the user.
  • a user may further use the configuration application 1440 to other direct the operation of the price optimization application 1410, as described in greater detail below.
  • the configuration application 1440 may be used to direct the mathematical model or to define various boundaries or constraints to be considered by the price optimization application 1410. It should be appreciated that various mathematical models may be used in the analysis of a price optimization, depending on the desired results and the needs of the used. The different models may be used depending on whether a pricing problem is unconstrained, bounded unconstrained, constrained, mixed- discrete non-linear, etc, and the various models used to address these optimization problems are described in greater detail below.
  • Equation 38 An unconstrained problem is mathematically depicted in Equation 38:
  • Equation 39 min f(x*, x 2 ,..., x n ), given lb; ⁇ X; ⁇ ub- (39)
  • the pricing optimization application 1410 seeks to find a solution to equation 40:
  • the Golden Section Search method operates such that given, at each stage, a bracketing triplet of points, the next point to be tried is represents a fraction 0.38197 into the larger of the two intervals (measuring from the central point of the triplet). If starting with a bracketing triplet whose segments are not in the golden ratios, the procedure of choosing successive points at the golden mean point of the larger segment will quickly converge you to the proper, self-replicating ratios. Because this method is linearly convergent, the golden section search guarantees that each new function evaluation will (after self-replicating ratios have been achieved) bracket the minimum to an interval just 0.61803 times the size of the preceding interval.
  • a golden section search is designed to handle, in effect, the worst possible case of function minimization, with the uncooperative minimum hunted down and cornered like a scared rabbit. But, if the function is nicely parabolic near to the minimum, then the parabola fitted through any three points ought to identify the minimum a single leap, or at least very near to the minimum. The procedure is technically called inverse parabolic interpolation. But, no minimization scheme that depend solely on the technique is likely to succeed in practice. In the Brent's Method, the exacting task is to invent a scheme that relies on a sure-but-slow technique, like golden section search, when the function is not cooperative, but that switches over to the parabolic interpolation when the function allows.
  • Step 2 Compute the search direction in the space of variables as follows in Equation 41:
  • Step 3 Find a new solution x (k+1) by line search along the direction s(x (k) ).
  • Step 4 Update A (k+1) by using some iterative methods such as Davidon-
  • DFP Fletcher-Powell
  • Step 5 Test the stopping criterion, if satisfying the criterion, then stop, otherwise, go back to Step 2.
  • the quasi-Newton method is very powerful if the first derivatives are available and their evaluation is not expensive.
  • Direction Set ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇ ⁇
  • Powell's Method starts at a point x in n-dimensional space, and proceed from there in some vector direction d n , then any function of n variables f(x) can be minimized along the direction d n by line search methods.
  • x o be the initial approximation to the minimum
  • u-, u 2 , , u n be the columns of the identity matrix.
  • Step 3 Replace u n by x n - x 0 .
  • Step 4 Compute B to minimize f(x n +Bu n ) and replace x 0 by x n +Bu n .
  • Step 1 If the stopping criterion satisfies, then stop the iteration; otherwise, go to Step 1. For a general nonlinear function, the iteration is repeated until some stopping criterion is satisfied.
  • the algorithm above is mainly for the unconstrained nonlinear problems without bounds for the variables.
  • an interval may be implemented for each line search.
  • the line search intervals may be computed to make sure that the new points always lie inside the bounds when the initial point lies inside the bounds.
  • Powell's method is then modified such that for each line search min B ⁇ f(x + Bu) ⁇ , the line search interval of B is (B-, B u ) which are defined as follows:
  • the Nelder-Mead's method is a simplex-based method constructing an evolving pattern of n + 1 points in R n that are viewed as the vertices of a simplex.
  • Nelder-Mead's method is based on the idea of creating a sequence of changing simplexes, but deliberately modified so that the simplex 'adapts itself to the local landscape'. This method is also called "Downhill Simplex
  • the Nelder-Mead method starts with n+1 points defining an initial simplex, then take a series of steps moving the point of the simplex where the function is largest through the opposite face of the simplex to a lower point. These steps are called reflections, and they are constructed to conserve the volume of the simplex. When it can do so, the method expands the simplex in one or another direction to take larger steps. When it reaches a relative floor, the method contracts itself in all directions, pulling itself in around its lowest point.
  • a current simplex is defined by its n+1 vertices, each a point in R n along with the corresponding values off. Iteration k begins by ordering and labeling the current set of vertices as x-, ... , x n+ ⁇ such that f(x ⁇ ) ⁇ f(x 2 ) ⁇ ... ⁇ f(x n+ ⁇ ).
  • reflection, expansion, contraction, and shrinkage each associated with a scalar parameter.
  • the coefficients of reflection, expansion, contraction, and shrinkage are denoted respectively by p, ⁇ , ⁇ , and ⁇ . These coefficients should satisfy p > 0, ⁇ > l, 0 ⁇ ⁇ ⁇ l and 0 ⁇ ⁇ ⁇ 1.
  • An iteration of Nelder-Mead's method generally includes:
  • Step 1 Order the n + 1 vertices to satisfy f(x ⁇ ) ⁇ f(x 2 ) ⁇ ... ⁇ f(x n + ⁇ ).
  • Evaluate f r f(x r ), and if f(x ⁇ f r ⁇ f n , accept the reflected point x r , replace x n+ ⁇ by x r , terminate the iteration and go to Step 1.
  • Step 3 If f r ⁇ f-, calculate the expansion point X s from Equation 42:
  • Step 4 If f r ⁇ f n , the method performs a contraction between x and the better of x n+1 and x r . If f n ⁇ f r ⁇ f n+ ⁇ (i.e., x r is strictly better than x n+ ⁇ ) perform an outside contraction using equation 43:
  • Step 1 Iff- ⁇ f n+ ⁇ (i.e., X n+ i is better than x r , perform an inside contraction by calculating
  • Step 5 N new vertices are formed from Equation 45
  • the vertices of the simplex at the next iteration consist of xi, v 2 , ... , v n+ -.
  • the algorithm above is mainly for the unconstrained nonlinear problems without bounds for the variables.
  • the initial vertices are chosen inside the bounds, then the centroid of the vertices is inside the bounds.
  • a new point inside the bounds may always obtained for reflection, expansion and contraction.
  • the SQP methods also known as sequential, or recursive, quadratic programming methods, employ Newton's method or Quasi-Newton 's method to directly solve for conditions for the original pricing problem.
  • the accompanying subproblem turns out to be the minimization of a quadratic approximation of the Lagrangian function optimized over a linear approximation to the constraints.
  • this type of process is also known as a projected Lagrangian, or the Lagrange Newton, approach.
  • Step 1 Give an initial point x 0 .
  • Set i 0.
  • Step 2 Find h ⁇ at x Congress a quasi-Newton direction of descent at x, by solving. If none exists, then stop the algorithm and x, is the solution to the original problem.
  • Step 3 A Line Search is performed such that i such that (i) X f l-ocji ! , (ii) f°
  • Equation 45 the following system represented by Equation 45 is solved by the pricing optimization application 1410, and then the line-search procedure determines the step-length along this direction.
  • H represents the Hessian of the Lagrangian at x rope either given explicitly or approximated by finite differences or variable metric techniques.
  • the SQP method is a very useful class of algorithms for the solution of constrained optimization problems. This class of methods is superlinearly convergent. Numerical experiments have showed this class of methods often dramatically outperforms algorithms of other classes.
  • SA simulated annealing
  • the algorithm accepts not only the movements improving the objective function, but also the movements corresponding to a deterioration in the objective function value with a finite probability. These movements allow the algorithm to move away from local optima and find a global optimum.
  • nonlinear mixed-discrete optimization problems are more complicated than the problems with only continuous variables. It is very hard to use traditional optimization algorithms to solve the nonlinear mixed-discrete optimization problems.
  • a SA algorithm can deal with a variety of nonlinear optimization problems while it can deal with mixed-discrete problems more efficiently and more robustly.
  • a SA algorithm maintains the speed and reliability of gradient descent algorithms while at the same time avoiding being trapped at a local optimum.
  • a SA algorithm is much easier to be implemented and more effective than other optimization algorithms for nonlinear mixed-discrete optimization problems.
  • a SA algorithm approaches the global optimization problems similarly to using a bouncing ball that can bounce over mountains from valley to valley. It begins at a high "temperature” which enables the ball to make very high bounces, which enables it to bounce over any mountain to access any valley, given enough bounces. As the temperature declines the ball cannot bounce so high, and it can also settle to bounce trapped in relatively small ranges of valleys.
  • a generating distribution generates possible valleys or states to be explored.
  • An acceptance distribution is also defined, which depends on the difference between the function value of the present generated valley to be explored and the last saved lowest valley. The acceptance distribution decides probabilistically whether to stay in a new lower valley or to bounce out of it. All the generating and acceptance distributions depend on the temperature.
  • a SA algorithm is an optimization technique based on the behavior of condensed matter at low temperature.
  • the procedure employs methods that originated from statistical mechanics to find global minima of systems with very large degree of freedom.
  • a simulated annealing algorithm presents an optimization approach which has some important properties making it attractive.
  • the SA algorithm can be employed to solve a wide range of problems. It can process cost functions possessing quite arbitrary degrees of nonlinearities, discontinuities, and stochasticity and quite arbitrary boundary conditions and constraints imposed on these objective functions. It also can deal with chaotic and noisy data. This kind of algorithm is quite versatile since it does not rely on any restrictive properties of the model.
  • the SA algorithm can also be implemented quite easily with the degree of coding quite minimal relative to other nonlinear optimization algorithms, because this kind of algorithm does not require directional analyses involving function derivatives.
  • the SA algorithm can also be tuned for use in more than one problem.
  • a given optimization algorithm can be tuned to enhance its performance and since it takes time and effort to become familiar with a given code, the ability to tune a given algorithm for use in more than one problem should be considered an important feature of an algorithm.
  • the SA algorithm may further provide high quality solutions to many problems and does not depend on initial solutions. It statistically guarantees finding an optimal solution, and its main advantage over other local search methods are its flexibility and its ability to approach global optimality. Overall, the SA algorithm is a robust and generic technique.
  • the procedure of the SA algorithm is composes of four basic parts: Initialization, Melting Process, Annealing Process and Reannealing.
  • Initialization is to set the parameters and assign some values to the variables. Melting process is to find an initial temperature which should be large enough to explore all feasible solutions. Also, a starting solution is selected during the melting process. Annealing process is to generate a number of random moves, decrement the temperature and finally to find a solution as the optimal solution of the problem.
  • Reannealing process is to increase the annealing temperature and restart annealing process if the temperature is very low and the stopping criterion is not satisfied.
  • This algorithm has the following four computing steps:
  • Step 1 Initialization. This step is to initialize the values of some variables, input the important constants and compute several parameters.
  • Step 2 Melting Process. This step is to find an initial temperature T° and a starting point x°. Finding an appropriate initial temperature is very important. A too large initial temperature may significantly increase computational time while a too small initial temperature may miss a possible global optimal solution. In addition, as discussed before, an appropriate initial temperature is dependent of each individual problem. Hence, a good melting process which can find an appropriate initial temperature is vital for the robustness of a algorithm.
  • Step 3 Annealing Process. This step is to find a solution until the stopping criterion is satisfied. For each temperature, generate a number of random moves.
  • the step length of variables is adjusted. Repeat this process until the stopping criterion is satisfied or the temperature is very low. If the stopping criterion is satisfied, then the best solution is considered as the optimal solution. Otherwise, go to next step.
  • Step 4 Reannealing Process. This step is to increase the annealing temperature and return to Step 3. If the temperature is very low and the stopping criterion is not satisfied, the annealing temperature is increased and the current solution is considered as an initial solution. Then, return to Step 3 and reannealing until find a better solution. Then, the best solution is considered as the optimal solution.
  • the former approach can be used.
  • the routine can simply be programmed to reject any proposed changes which result in constraint violation, so that a search of feasible space only is executed.
  • this approach cannot be followed: (l)if there are any equality constraints defined on the system, or (2) if the feasible space defined by the constraints is (suspected to be) disjoint, so that it is not possible to move between all feasible solutions without passing through infeasible space.
  • the latter approach should be used.
  • the problem should be transformed into an unconstrained one by constructing an augmented objective function incorporating any violated constraints as penalty functions.
  • a two-phase approach may be employed to improve the penalty approach.
  • the original optimization problem is checked for feasibility, and if so, a feasible point is found.
  • the feasible point may be used as the initial point.
  • a very large constant may be chosen as the penalty constant in the new objective function.
  • f p2 (x) f(x) + ⁇ (C J * p J (x)) (49) where the definition of p,(x) is same as above and C, is enough large penalty constants. By introducing the penalty function as described above, all moves should be kept from moving out of the feasible region. Thus, it can be seen that various different models may be used to address the various pricing optimization problems, depending on the user's needs.
  • the configuration application 1440 allows the user to specify the model and to provide various input to direct the operation of the these models.
  • the configuration application 1440 may further be used by users to define the optimization conditions. Examples of this use are numerous, but examples may include the definition of a minimum inventory, thus constraining various optimization calculating (i.e., the pricing optimization application cannot propose a profit maximizing price that depletes inventory stocks).
  • the configuration application 1440 allows the user to define market conditions. For instance, the user may define cyclical sales cycles or needs that the pricing optimization application would not readily discover through the analysis of past sales.
  • the configuration application 1440 may be used to define the relationship of different items, such that changes in the pricing of one item may effect sales of the second item. Overall, the configuration application 1440 allows users to easily define market characteristics. If the user does not define these conditions, the pricing optimization application 1410 may produce faulty results or may optimize using techniques to solve unbounded/unconstrained pricing problem
  • the configuration application 1440 may compare and display the price optimization results 1420 with and without the user's inputs.
  • the user may compare the results and use the results to determine the accuracy/desirability of the changes supplied to the configuration application 1440.
  • the user may similarly compare the computing resources required to solve an optimization application with and without the user defined conditions.

Abstract

The present invention provides a configurable pricing system (100) that allows users to define or modify data used to analyze, evaluate (800), improve, and design pricing changes according to the user's need. A Graphical user interface or some other type of user interface allows the user to access (220) and review various data to be used during pricing optimization (1100). The user may then modify this data as needed to improve the pricing evaluation (800), such as defining sales or pricing trends, or relationships between the product of interest and other competing items. The user interface may further display changes in pricing and the effects of the pricing changes, as caused by the user's changes. The interface may also allow the user to modify the mathematical model to be used during price optimization (1100), as well as define variables, constraints (900), and boundaries to be considered during the price optimization (1100).

Description

CONFIGURABLE PRICING OPTIMIZATION SYSTEM
RELATED APPLICATIONS
This application claims priority to U.S. Provisional Application No. 60/428,912 filed November 26, 2002, the disclosure of which is hereby incorporated by reference in its entirety. This application is also a continuation-in-part application of pending U.S. Patent Application No. 09/987,706 filed on November 15, 2001 (claiming priority to U.S. Provisional Application No. 60/249,057 filed November 15, 2000), the disclosure of which is hereby also incorporated by reference in its entirety.
Field of the Invention
The present invention relates to a configurable price optimization application which allows users to define or add additional boundaries and constraints as needed to better meet business concerns and to improve the accuracy of the pricing optimizations calculations.
Background of the Invention
Businesses commonly use promotional schemes to improve sales volumes and profits. For instance, a business may adjust prices as needed to encourage sales of particular products. Likewise, businesses may specially present or advertise their products to increase consumer awareness and demand. To generate incremental revenue or expand market share, companies spend billions of dollars annually in promotional discounts, rebates, cash incentives, coupons, and subsidized financing. Because of the variety of promotions in play at any one time, the complexity of the market, and an inadequate understanding of customer response, few companies are able to accurately predict the overall effectiveness of their promotional spending.
The user making promotion decisions is faced with the challenge of how to best target promotional spending to achieve corporate goals at the lowest cost. To make this decision, the user needs to accurately forecast how a proposed promotion will affect revenues, profits, and sales volumes for each product. Likewise, the user needs to calculate how much each promotion will reduce on-hand inventory while minimizing cross-product and cross-segment dilution. The user further needs to predict how different market segments will react to different types of promotions. The user also needs to determine which combination of promotions will produce the highest return on expenditure while meeting sales, margin, and market share targets.
Therefore, there exists a further need for a system or method to accurately forecast the impact of promotions and to automate these tasks. It is a further goal of the present invention to provide a system and method to automatically determine the best allocation of promotional expenditure.
There further exists a need for a pricing optimization application that allows user to manually define constraints or to add additional constraints, as needed to further goal of the present invention as needed to better meet business concerns and to improve the accuracy of the pricing optimizations calculations.
Summary of the Present Invention
In response to these and other needs, the present invention provides a promotion pricing system and a related model for producing a value evaluation and recommendation for promotion on a targeted product so as to analyze, evaluate, improve, and design promotions to meet a user's need. The promotion pricing system generates promotion price evaluations and recommendations for each product promotion related to a target product of a user along with associated competing products from the user and competitors. The user can be an individual, an organization, a corporation, an association or any entity providing, including activities related to making, selling, resale, offering for sale, distributing and other commercial conducts, products or service or both in the stream of commerce.
The promotion pricing system of the present invention is general enough to provide price evaluations and recommendations with varying degrees of available data. While the ideal client for the system would maintain data on lost customers, competitor prices, industry availability and the like, most clients will have data on only a subset of the potential drivers of market response. In this way, the system enables the user to obtain valuable insight from the evaluation of a promotion program even with a minimum amount of input data and then increasing that value through increased forecasting accuracy and accurate evaluation as new and/or existing data is integrated. The promotion pricing system of the present invention enables the user to determine the impact of proposed promotions before committing to the promotion. Using historical data and statistically derived market response models, the promotion pricing system tests promotional scenarios and forecasts the results. The user can then determine how much each proposed promotion will affect revenues, profits, and sales volumes; how much each promotion will reduce on-hand inventory, how different customer segments will respond to different promotions, and which combination of promotions will generate the highest return on your promotional expenditures. In one embodiment, the promotion pricing system can simultaneously consider cannibalization effects of the promotion on other products or channels, allowing the user to maximize overall revenue growth.
With the promotion system of the present invention, the user may develop and target promotions for each product, customer segment, and distribution channel. The promotion system further helps the user determine the best allocation of promotion and incentive dollars to meet your goals at the lowest possible expenditure. In this way, the promotion system and method of the present invention can produce substantial additional profit per year.
Also, once the promotional campaign is under way, the promotion system of the present invention tracks its progress, generates performance alerts when user-defined parameters are exceeded, and quickly pinpoints problems. Meanwhile, results are fed back into the system to help fine-tune future campaigns.
Overall, the promotion system of the present invention allows a business to better understand customer price sensitivity and to acquire new customers at the least cost while retaining existing customers. The system further helps manage product or service life cycles by suggesting promotions to encourage the sale of older inventory. The promotion system further acts to minimize product cannibalization and to address sales shortfalls.
In the preferred embodiment, the promotion pricing system of the presenting invention is comprised of modularization of the necessary analytical steps along with specifications for these modules. These modules cooperate to implement statistical market response estimation that provides statistically stable, fact-based information on customer response to promotions. The modules further allow data capture to leverage enterprise and supply chain data sources. The modules include a product segmentation module, an incentive translation module, a customer segmentation module, a data aggregation module, a model selection module, a calibration module, an evaluation module, a constraints generation module, a cost structure module, an optimization module, a market channel performance module, and an alert module.
In another embodiment, the system has a distributed architecture that is flexible, easy to configure, and easy to deploy and use over an internet/intranet. Specifically, a preferred embodiment of the promotion pricing system is constructed using modules coded in Java and distributed over the Internet to allow large-scale, controlled access to the promotion pricing system of the present invention.
In another embodiment, the system may include a promotion pricing dashboard to enable proactive analysis of business performance and market dynamics. The system may also include a strategy tester to help determine the most effective promotion schemes as well as a market response engine to maximize demand lift, revenue, and profits.
In another embodiment, the present invention provides a configurable pricing system that allows users to define or modify data used to analyze, evaluate, improve, and design pricing changes according to the user's need. A Graphical user interface or some other type of user interface allows the user to access and review various data to be used during pricing optimization. The user may then modify this data as needed to improve the pricing evaluation, such as defining sales or pricing trends, or relationships between the product of interest and other competing items. The user interface may further display changes in pricing and the effects of the pricing changes, as caused by the user's changes. The interface may also allow the user to modify the mathematical model to be used during price optimization, as well as define variables, constraints, and boundaries to be considered during the price optimization.
Brief Description of the Drawings
A more complete understanding of the present invention and advantages thereof may be acquired by referring to the following description taken in conjunction with the accompanying drawings, in which like reference numbers indicate like features, and wherein: FIGS. 1A-C illustrate block diagrams of a promotion pricing system in accordance with embodiments of the present invention;
FIGS. 2-13 represent steps in the operation of various components of the promotion pricing system of FIGS. 1A-1C; and
FIG. 14 represents a user configurable pricing optimization system in accordance with embodiments of the present invention.
Detailed Description of the Preferred Embodiment As generally illustrated in FIG. 1A, the present invention provides a promotion pricing system 100 for producing and evaluating promotion pricing strategies. In particular, a user may employ the present invention to evaluate historical data to determine a more ideal promotional strategy to accomplish various business goals, such as increasing total sales volumes or increasing sales in certain desired market segments. The promotion pricing system functions to either propose a promotional strategy or to evaluate the expected effect of a promotional policy provided by the user. The promotion pricing system 100 works by defining the market by specifying the various products in the market, as well as the suppliers (i.e., sellers in the market) and demanders (i.e., consumers). The promotion pricing system 100 then looks to historical market data to create a market model which may be used to determine various information, such as profit or sales maximizing conditions.
In various implementations of the preferred embodiment, the promotion pricing system 100 includes combinations of the following components: A product segmentation module ("PSM") 200, an incentive translation module ("ITM") 300, a customer segmentation module ("CUSM") 400, a data aggregation module ("DAM") 500, a model selection module ("MSM") 600, a calibration module ("CM") 700, an evaluation module ("EM") 800, a constraints generation module ("CGM") 900, a cost structure module ("COSM") 1000, an optimization module ("OM") 1100, a market channel performance module ("MCPM") 1200, and an alert module ("AM") 1300. Each of these components 200-1300 may generally function as software applications that coexist on a single computer. Alternatively, the components may operate concurrently on independent computers, while interacting and exchanging data using known communication and networking techniques. The components 200-1300, as well as the general operation of the promotion pricing system 100, are now described in greater detail below. However, the general, overall operation of the promotion pricing system is first provided.
Data Inputs and Outputs
As illustrated in FIG. 1A, The promotion pricing system 100 receives various data inputs and processes these inputs to analyze promotion schemes. Among the inputs received by various embodiments of the promotion pricing system 100 are product information, consumer account information, commercial channel information, purchase/sales order information, competitor and competitor product information, and promotion campaign information.
Product information is part of the base data required by the promotion pricing system 100. The product information consists of basic product information on pricing, costs, inventory and product hierarchies. Likewise, account information provides account or customer profile information. This data is used to micro-segment the market and target different customer profiles with customized promotions. Channel information encompasses data on both inbound Sales channels (via which customers purchase system 100s or services) and outbound Marketing channels (through which customers are presented with promotional campaigns). The promotion pricing system 100 uses this information to incorporate sales channel-specific buying behavior, price elasticity, and costs. Information on outbound channels is used to model marketing channel-specific cost distinctions and response variations. Overall, product, account, and channel information form the base data for the promotion pricing system 100.
Purchase, or sales order, data drives the analysis of the promotion pricing system. Sales order information answers the question "who bought what at what price when and how," where the "who" identifies the customer segment or profile of the customer; the "what" the set of products or services on offer; the "price" the pricing information associated with the sale, including any promotion information if relevant, and the "when" the timing of the purchase; and the how the channel or medium used for the sales transaction. Ideally, both the user's own sales order and competitive sales order information are available for the promotion pricing system 100 to model competitive factors. However, alternatives exist, as described below. Competitive information forms another component driving the system 100's analysis of promotional schemes. This data identifying competitors helps to establish the competitive landscape. In addition to this base competitive data, raw sales order or market share data may be used to incorporate competitive information into the analysis. As laid out below, this information could manifest itself in either transaction or market share data. Competitive sales order data consist of sales transaction data on competitive products. If unavailable to the user, the Sales Order data could potentially be obtained from various third-party sources depending on the user's industry. In the event that Competitive Sales Order data is unavailable, the promotion pricing system 100 can use market size and market share information to model competitive factors. However, this lack of information may curtail the effectiveness of the competitive model.
Promotion or campaign information forms the third important ingredient required by the promotion pricing system 100. Promotion information describes in detail the nature of past or currently running campaigns and the incentives associated with each. This information includes a listing of prior promotions, the product segments and trading channels associated with the prior promotions, the nature of the promotions, the duration of the promotions, etc.
Using the above-described inputs, the promotion pricing system 100 analyzes a promotion scheme and produces several outputs, including promotion effectiveness and market response, price elasticity information, and cannibalization/dilution details. In determining price elasticity, the promotion pricing system 100 may generate both the user's elasticity and cross-elasticity of other products, sales channels or incentive types on market response. The resolution of the forecasts depends on the quantity and quality of sales order and competitive data available. If individual product forecasts cannot be reliably generated, elasticity at an aggregate level (or product segment group) is generated by the promotion pricing system 100.
Using this price elasticity information and baseline volume estimates taken as input from either the user or third-party systems, the promotion pricing system 100 can compute expected lifts (i.e., sales increases) for a given promotion program in terms of quantity revenue, margin, or other industry-specific metrics. These estimates are generated at the level product, incentive type, sales channel, and marketing channel levels. The promotion pricing system 100 may then use cross-elasticity determinations to compute cannibalization or dilution effects on a given product or sales channel from competing or surrogate products and sales channels.
Another functionality of the promotion system 100 is mark-down optimization. A retailer may receive shipments of excess inventory to their stores. The retailer knows how much of this inventory is normally sold within a given period of time given historical information and general business knowledge. However, they do not know the optimal discount to set to achieve the objective of selling that inventory within the specified time period. In other words, the user does not want to overdiscount a product, promotion system 100 can solve this type of problem given certain inputs such as the target product, the total initial inventory for that product, and the amount of inventory that is to be sold for a given period. Promotion system 100 would then compute that discount which maximizes profit while clearing pre-identified excess inventory during the specified period.
The promotion system may also perform strategic objective analyses in assessing and achieving strategic corporate objectives. A user generally does not know if 1) an objective is obtainable, and 2) how strategically she should approach achieving this objective using promotional incentives. Promotion system 100 can solve this problem by identifying 1) if the revenue target is feasible, and 2) if the target is feasible, what promotional incentive level will maximize profitability given this constraint.
Product Segmentation 200
The PSM 200 defines the products in the market model created and analyzed by promotion pricing system 100. Specifically, the PSM 200 creates and organizes a list of related products. As generally illustrated in FIG. 2, the PSM 200 may employ a production segmentation method 210 for collecting, organizing and presenting the product data. The user may input this data (Step 220), or the PSM 200 may collect data from a list of products, step 230. For instance, the PSM 200 may download data from a database containing product catalog information or may employ known data collection and mining techniques such as automated XML data crawling applications. Alternatively, the PSM may use defining product characteristics to select appropriated competing products in view of a list of the user's products. After acquiring the data, the PSM categorize products into product segments by similar behavior, attributes, or features, step 240. The categorization of the products may be generally accomplished by organizing the product data into a relational database and then employing standard query language (SQL) to organize the product data according to desired characteristics. In organizing the product data, the PSM 200 may determine promotion impacting factors including impacts across segments, step 250. The PSM 200 may then list the user's own target products along with associated, competing products, step 260. In this way, the PSM 200 also defines the suppliers to the market model created and evaluated by the promotion pricing system 100.
In another embodiment, the PSM 200 does not include competitors' products in the product segmentation. Instead, the PSM 200 only looks to the user's products. In this way, the collection and analysis of data are simplified at the cost of decreased accuracy. Particularly, the promotion pricing system 100 operates under the general assumption that transactions are independent events that differ only by promotional efforts. These assumptions become increasingly less likely with smaller sets of data and suppliers.
Customer Segmentation Module 300
The CUSM 300 defines and categorizes the consumers of the products specified by the PSM 200 in the product segmentation method 210. The user may manually provide data for the segmentation of the customers or, more typically, the CUSM 300 may automatically segment the customer according to various demographic or market information. The CUSM 300 preferably automatically segments the customers using various characteristics. For instance, commercial consumers may be divided into categories of differing business sizes and revenue levels. The CUSM 300 may operate using a customer segmentation method 310, as illustrated in FIG. 3. In the customer segmentation method 310, the CUSM 300 first collects a list of customers for the products defined by the PSM 200. As with the PSM 200, the CUSM 300 may either receive the customer list from an external source, step 320, or the CUSM 300 may automatically generate the customer list, step 330. For instance, the CUSM 300 may analyze a record of past transactions involving the products designated by the PSM 200. The CUSM 300 next reviews customer characteristics, step 340. The analysis of the customers may be generally accomplished by organizing the customer data into a relational database and then employing SQL to organize the customer data according to desired characteristics, such as geographic location. The CUSM 300 then divides the customers into different possible global customer segmentations, each with two or more segments, step 350. Using historical transaction data, the CUSM 300 may further determine cross impacts between customer segments, step 360. The CUSM then keeps only the customer segmentations without cross-impact between different segments, step 370. The CUSM 300 only looks to customer categories in which sales are independent events to avoid covariance terms in the mathematical evaluation of the market model created by the promotion pricing system 100. In other words, sales to one consumer segment of the market should not effect demand from other consumer segments.
Incentive Typing Module 400
The ITM 400 collects and organizes data related to various promotional techniques. The ITM 400 may employ an incentive typing method 410, as illustrated in FIG. 4. In the incentive typing method 410, the ITM 400 collects incentive offers for promotion programs over certain time periods, step 420. The ITM 400 specifies different incentive types associated with promotion programs for both the user's own target products and competitors products identified by the PSM 200. For instance, the incentives may include rebates, discounts, low-rate financing, bundled goods, etc.
During step 420, the user may provide the promotion data, or the ITM 400 may evaluate prior transactions to determine historically employed promotional techniques. The ITM 400 then translates the incentive offers into consistent measurable drivers by incentive types, step 430. In step 430, the ITM 400 may mathematically transform the promotions to best fit market modeling needs.
In another embodiment, the ITM 400 may further consider non-monetary promotions, step 440. For instance, the ITM 400 may add to the list of incentives non- monetary incentives such as prominent display or advertisement of the products. The non- monetary incentives identified in step 400 may typically be specified by the user, prespecified in the ITM 400, or may be dynamically determined from transaction data.
Data Aggregation Module 500
After the PSM 200, CUSM 300, and ITM 400 define the market to be modeled, the DAM 500 evaluates historical transactions in view of the various defined products, customers, and promotional techniques. Specifically, the DAM 500 may employ the data aggregation technique 510 depicted in FIG. 5. In step 520, the DAM 500 may separate data by customer segments. The separation may be automated or specified by the user. The DAM 500 may then determine a time interval at which to aggregate transaction volume data, step 530, on the basis of the number of time periods needed to estimate parameters, the incentive offer and price variation cycle, and data collection frequency. The DAM 500 then aggregates volume data at selected time intervals for target products, step 540. If the products are clearly segmented, the DAM 500 aggregates competing product volume at the same time interval, and calculates corresponding market share under each segment, step 550. The DAM 500 then computes average prices and incentive offers by each channel for each product over each time interval, step 560. The DAM 500 then uses statistical analyses techniques to determine patterns, such as seasonality, and other statistical factors, step 580. The output of the DAM 500 is typically a relational database in which each historical transaction has been characterized by product segment, customer segment, and incentive type.
Model Selection Module 600
The MSM 600 then uses the aggregated data created by the DAM 500 to select an appropriate model for use in analyzing and accessing promotional efforts. The MSM 600 generally employs a model selection process 610 depicted in FIGS. 6A-B. In the model selection process 610, the MSM 600 first lists the user's own target products and lists all associated products from the user's competitors, step 615. At determination 620, the MSM 600 evaluates whether competitor information is available. If competitor information is not available, a simplistic statistical model is used to model the promotions with the penalty of lower accuracy, step 625. The simplistic model is described in greater detail below. Furthermore, the promotion pricing system may initially use the simplistic statistical model and change to more precise promotion evaluation models as more data becomes available.
If competitor information is available, then at determination 630, the MSM 600 decides whether a substantially complete set of product volume data is available over the time periods of interest. If a substantially complete set of product volume data is available over the time periods of interest, then the dependent variable during evaluation is sales volume, step 640, and the promotion pricing system 100 evaluates promotion efforts using a multiplicative model described in greater detail below, step 645.
If only samples of the user's and competitors' products volume data over time are available for the time period of interest, the MSM 600 evaluates the product segments defined in the PSM 200, step 650. At decision 660, the MSM 600 determines whether there is apparent cross impact among these segments. Likewise, at decision 670, the MSM 600 determines whether any of the promotion programs substantially overlap over different time periods of interest. If there is an apparent cross impact among these segments or any of the promotion programs substantially overlap over different time periods of interest, then the dependent variable during evaluation is sales volume, step 640, and the MSM 600 selects the multiplicative model for use during the promotion pricing system's 100 evaluation of promotional efforts, step 645. If there is neither an apparent cross impact among these segments nor substantial overlaps in promotions over different time periods of interest, then the MSM 600 uses market share as the dependent variable during evaluation, step 680. The MSM then decides whether there are too many products in each segment defined by the PSM 200, determination 690. Generally, the MSM 600 looks to see if the number of products in each segment exceeds a predetermined maximum. If there are too many products in each segment, the MSM 600 again selects the multiplicative model for use during the promotion pricing system's 100 evaluation of promotional efforts, step 645. If the MSM 600 determines that there are not too many products in each segment during determination 680, the MSM 600 selects an attraction model for use during the promotion pricing system's 100 evaluation of promotional efforts, step 695. The attraction model for evaluating promotions is described in greater detail below.
Calibration Module 700
In evaluating a promotion, the subjective variable of attractiveness or utility does not really exist. To calibrate the model, the user may use Market Share (actually the natural logarithm of market share) or sales volume to represent the attractiveness, or utility, of the product i, deal type j. In particular, the CM 700 evaluates the above- described inputs and produces the outputs results using different models that guide the data analysis. For instance, the CM 700 may use either a multiplicative model that measures market share or sales volumes. Alternatively, the CM 700 may use an attraction model that measures market share. Specifically, the CM 700 determines the values for the dependent variables designated above in step 640 and 690. The CM 700 further integrates new transaction data to adjust values of the dependent variable. In turn, as described below, the EM 800 uses the values for the dependent variables to access various promotional planning schemes. The operation of the CM 700 varies according to the model selected by the CSM 600.
Multiplicative Model
The multiplicative model assumes constant elasticity over market share and driver level and is defined by the following equation la:
Figure imgf000015_0001
Y where ' = the utility of product i as measured by either volume and market share;
a> = the marketing effectiveness of the brand of product i; ε> - the noise;
K = the total number of effects considered;
X ki = the kth marketing instrument on product i and can be prices, incentive offers, or other factors; and
P = the parameter for effect k that are global over the set of considered products.
If Yi is in sales volume, the calibration could be done for target products only. By taking the natural logarithm of both sides, Equation 1A may be rewritten as Equation IB.
In (Y i ) = a i +
Figure imgf000016_0001
Alternatively, Yi may be defined as the natural logarithm of the utility of product i as measured by either volume or market share, as represented in equation 1C:
Figure imgf000016_0002
As can be seen from equations 1A-1C, the dependent variable in the multiplicative model is either sales volume or market share. The use of sales volume as the dependent variable raises concerns of seasonality and trend factors in the transaction data, whereas market share tends to be more stable over different time periods. For instance, the sales volumes of many products are higher during the Christmas season regardless of promotion schemes. Furthermore, the elasticity in the multiplicative model is equal to β and is constant over market share and driver levels. Accordingly, the multiplicative model is generally dependent on the user's sales volumes data but does not look to competitors' transaction data. Also, because it is easy to aggregate sales volume over multiple time periods, it is fairly simple to incorporate data from different time periods.
Attraction Model
In comparison with the multiplicative model, the attraction model uses only market share as a dependent variable and assumes constant total sales quantities. In this way, the attraction model incorporates data from competitors' transactions. Specifically, the attraction model uses the following equation to measure a product's utility and to quantify any change in the value or "utility" of product caused by a promotion.
A = exp(α, + ε, ) l fk (Xh ) A
<t=ι (2A)
where ' = the utility of product i in market share; a< = the marketing effectiveness of the brand of product i; ε' = the statistical noise;
K = the total number of effects considered;
X h = the kth marketing instrument on product i; Pk = the parameter for effect k that are global over the set of considered products; and
fk = a function, such as Id, depending on the driver.
The attraction model embodied in equation 2A does not take into account effects induced by any competitors, or any effect other than the ones generated by the product, the brand's product or exterior global parameters such as the trend. Also, the variables used can be either quantitative, such as price and age, or qualitative, such as trend or the belonging to a specific category.
Once the utility of a product (i.e., product i) is known, the market share of this ith product among the specific market segment is calculated using equation 3:
Figure imgf000018_0001
where
si is the market share of product i;
Ai is the utility (market share) of product i;
m is the number of considered products in the segment; and
Σ Aj is the total utility (market share) of m product in the segment.
Alternatively, the promotion pricing system employs a differential-effect version of the attraction model. In differential-effect version of the attraction model, the parameters of the attraction model are product-specific instead of being global. Therefore, equation 2 A becomes:
Figure imgf000018_0002
where notations remain the same.
Even greater accuracy in the attraction model may be achieved by the promotion pricing system by adding new influences to the model to reflect a more realistic market. Particularly, the influences of the competitor's product can be added to the calculation of the utility of a product. This modification addresses the possibility of cross-impacts caused by similar competitive products that can influence the attraction of the product being considered. Equation 2B is thereby modified to product equation 2C: K m
At =^att)Ylllfk(Xb) A
*-*-. =ι (2C).
The calculation of the market share remains the same, as described above.
In application, a user may use transformations to simplify equations 2A-2C. For instance, logarithmic transformations may be used to make the estimation of the parameters a linear process. In this way, Equation 2B may be rewritten as
Figure imgf000019_0001
where: I = set of products
J = a set of promotion types
C = set of products/deal types that have asymmetric cross impacts on the target vehicle
Aij -= attraction of the product i, deal type j
αi = constant influence of vehicle i
rj = constant influence of deal type j
xi j,k = kth driver vehicle i, deal type j
βij.k = kth parameter of vehicle i, deal type j
K = total number of drivers
As can be seen from above equations 2A-2D, the elasticity in the attraction model varies by market share and driver levels. It should be appreciated that these models may be modified and/or combined as needed by the user. Likewise, other models may be incorporated within the operation of the promotion pricing system of the present invention. These and other similar modifications to the present invention are anticipated within the present application and considered within the scope of the present invention.
The CM 700 uses a calibration method 710 as illustrated in FIG. 7. The CM 700 first receives data from the modules 200-600 as well as historical transaction data, step 720. The CM 700 next evaluates the data using one of the models for determining the utility of a product, step 730. Once all parameters have been obtained, the attractiveness of the target incentive could easily be calculated, and so can the market share, Sij, step 740
Figure imgf000020_0001
where ΣAy for all pairs of i and j represents is the sum of utilities for the subsegment of the target vehicle.
The CM 700 may also determine period variables, step 750. The period variables account for the fact that the sum of market shares in a subsegment, in a period of time, equals one. Theoretically, the dependent variable in the regression is utility. Since this variable does not really exist, the Manufacturer may use Market Share to represent utility with certain adjustments. The following equation shows the relationship between Utility and Market Share.
MarketShare, =
^T Utility j J (5A)
where*'' e (1, J)is the subsegment to which vehicle i belongs. The ΣUtilityj does not depend on i, but only depends on time/month. This means that ΣUtilityj will be the same no matter which of two products are used, assuming two products are in the same subsegment. However, the ΣUtilityj does when with different periods of time. The CM 700 may rewrite the above equation: , , Utility!
MarketShare, =
/{month) (53)
t/tz'b'ty, = MarketShare, χ /{month) r^p
Then,
In Utility, = lnMarketSharet + ln/(month) ,-,-r- -
When using ln(MarketShare) to represent In (Utility), the CM 700 should not exclude In (f(month)) from the model. Thus, the period variable, some function of month, has been incorporated in the model.
The CM 700 operates using several assumptions to improve accuracy as well as decrease required processing time. For instance, the CM 700 assumes that there is no cross impact between customer segments. Please note, however, that there may be cross- impact among product segments, e.g., a promotion of computers may indirectly promote the related peripherals. Furthermore, with the multiplicative model, the value for share or volume elasticity is assumed to be equal to a corresponding βki, as defined below. Likewise, for the attraction model, the market size for each product segment is fixed at a specific time period, and all market segments should be included or ΣSi = 1.
The CM 700 may function as a modules promotion translator that translates the different promotions offered into the appropriate driver of a product, step 760. The driver represents the actual impact of the promotion on customers' valuation of the product and competitive products. For instance, customers may be indifferent between discounted prices and reduced interest rate financing because either promotion may allow the customers to pay the same periodic and total payments. It should be appreciated that the term "incentive" may also be used to refer to an aggregate of separate offers. There are no functional requirements concerning the value of the drivers. However, there may be some requirements due to the mathematical process used within the various models. Evaluation Module 800
The EM 800 accesses the promotion scheme using the calibration results produced by the CM 700 in method 710. Specifically, the EM 100 uses the evaluation method 810, as depicted in FIG. 8. During evaluation, the EM 800 receives baseline information from the user, including sales volume information for the attraction model, information of the user's promotions, and competitors to the related products ups, assuming the same promotions existing offers across customer segments, step 820. If the market share is predicted by the multiplicative model, the share elasticity should be evaluated instead of volume in step 820. The user may also input values for predicting variables to get responses for an adjusted program, though incentive offers to one customer segment could be distinctive from the other, step 830. For the attraction model, the user may input the total baseline volume Vi for the product over interest over the defined customer segments, the baseline volumes for other choice sets can be derived by market shares and overall customer segment ratio as follows. For example,
= V V, = r * S [r * Skl + (l - r)* Si2]
VJX = VΛ * SjJS = Vt * r * S /[r * Sa + (l - r)* S,2]
(8)
Vj = V, * V * Sβ + (1 - r> S J2 / * SA + (1 - r> St2] (9)
The adjusted program volume will then be
Val
Figure imgf000022_0001
* Sll + (l - r)* S,2 ] (10)
In one embodiment, the EM 800 may also allow the user to specify or select business goals, such as profit maximizing or sales volume maximization, step 840. For instance, the user may wish to maximize sales and may accept losses on the sales to accomplish the increased sales volume or market share. When evaluating the promotion in view of the business goals specified in step 840, the EM 800 may access constraints created by the CGM 900 described below. In this way, the EM may determine which goal may be accomplished while adhering to the specified constraints. When perfoπning profit maximization, the EM 800 predicts the ability of the promotion scheme to change profits, step 845. The EM 800 looks to the sales price and the expected change in sales for a product. The EM 800 then uses these values to estimate expected revenues attributable to the promotion scheme. Where the EM 800 cannot measure costs, it proposes a revenue maximizing promotion scheme. The EM 800 may also receive an estimate of costs produced by the COSM 1000, as described below. The EM 800 may then find the expected profits attributed to the promotion scheme by subtracting estimated costs from the estimated revenues.
In other embodiments, the EM 800 may also cooperate with other applications to increase the accuracy of the evaluation. For instance, the EM 800 may cooperate with a known demand forecasting application, step 850, such as NetWORKS Demand™ produced by Manugistics, Inc. of Rockville, Maryland. The demand forecaster acts as an early-warning system, predicting future customer demand, alerting of potential supply problems, and finding patterns undetected by traditional solutions. It enables a user to understand demand drivers, to more accurately predict future needs, and to unify disparate planning processes through its scalable and web-based multi-model architecture. In this way, the EM 800 may separate demand changes caused by market forces from sales changes resulting from a promotion.
The EM 800 may also integrate with known market management applications to control inventory supply levels in a market through promotions, step 860. For instance, NetWORKS Market Manager™ produced by Manugistics, Inc. of Rockville, Maryland provides a global view of all market activities that are happening for a product, location, or product family, simplifying the process of coordinating market activity information related to market promotions. In operation, EM 800 predicts and evaluates the ability of suggested promotions to the to predict the availability of the suggested promotion to achieve goals desired by the market management application.
As additional transaction data becomes available, the EM 800 may integrate this data into the evaluation, step 870. Specially, the EM 800 may adjust the utility values produced using either the multiplicative method or the attraction method to reflect actual sales data related to a promotion. In this way, the EM 800 may also look to actual sales and adjust the prior predictions. Constraints Generation Module 900
The CGM 900 functions to accept, create or define various constraints on the variables used in the other components of the promotion pricing system 100. The CGM 900 operates according to a constraints generation method 910 depicted in FIG. 9. The CGM 900 first accepts user defined constraints, step 920. Alternatively, the CGM 900 may generate constraints, step 930, based on inputs from the user or prespecified settings. Possible constraints include directionality constraints to enforce the assumption that a promotion scheme should only positively affect product utility. Another possible constraint is to assume equal cross impact, thereby assuming that increase in sales volumes of market share are equally taken from other competitors, thereby simplifying the promotion assessment calculations. Another set of constraints relate to the incrementality, or the minimal intervals between usable values for the variables in the calibration and assessment. For instance, rounding the values for a variable may decrease accuracy but decreases the computational accuracy. Application of constraints may restrict regular significance tests of estimated parameters, but the calibration process will provide adjusted R2 to evaluate model fitness.
COSM 1000
The COSM 1000 functions to determine costs for the promotion schemes. As described in the cost organization method 1010 and illustrated in FIG. 10, the COSM 1000 first determines base product cost without the promotion scheme, step 1020. The COSM then determines indirect promotion costs caused by the promotion scheme, step 1030. In particular, the COSM 1000 looks to, for example, the increased costs per unit associated with increased sales volume or share from the promotion. The COSM 1000 next determines the direct costs for the promotional scheme, step 1040. For instance, the COSM 1000 may determine incentive costs, offer channel cost, customer segment cost, order channel cost, etc. The COSM 1000 then sums the indirect and direct promotion scheme costs to determine a total cost.
Optimization Module 1100 One common question facing businesses is which products should be targeted for promotional incentives (i.e., discounts) and at what level should these discounts be set? The OM 1100 can provide the answer to this question. Specifically, the OM 1100 will identify the optimal discount for each product (which generates the highest profitability) and rank products by profitability (given the recommended incentive).
To guide the operation of the OM 1100, the user can establish business constraints to better reflect the needs of their business. For example, in the set fixed incentive levels, the user can identify an incentive level that should apply for any selected products or segments (i.e., all menswear should be discounted at 15%). In equality constraints on incentive levels, the user can specify that the discount for dress slacks should always be equal to the discount for dress shoes. With Min / Max constraints on incentive levels, the user can set a maximum discount level (i.e., max discount of 50% assuring that the effective price of the product remains above that of lesser product lines), or minimum discount level (i.e., min discount level should remain above 6% to assure customer satisfaction and ease of communication). Min / Max constraints on margin allows the user to ensure that the recommended discount level will not erode the objective per unit margins for a product (i.e., the margin for dress slacks must remain above 4%). Minimums can also be set (i.e., we must achieve at least a 10% margin on the sale of dress shirts). Similarly, set fixed margins allows a target margin to be established (i.e., all products within the casual wear product line must have a margin of 14%). With Min /
Max incentive budget at global level, the user may specify a total "Incentive Budget" for a given time period (i.e., the total amount of cash back incentives should not exceed $800,000 for the next fiscal year, or the total dollar amount of cumulative discounts must not exceed $10,000). Inventory constraint allows the user to specify an inventory amount to prevent product shortages resulting from a sale (i.e., for a summer promotion, users only have 20,000 t-shirts available, and therefore, should set the discount level to maximize profitability for this number of units). Likewise, through a demand target, users identify the number of units to be sold for a given period (i.e. in March, the user would like to sell 5,000 units of Dress Slacks).
The OM 1100 will identify the Promotional Incentives that maximize profitability given general user inputs. This is a highly intelligent feature that offers significant value in solving a variety of "real-world" business issues. The optimization feature is related to the above-described strategic objective analysis feature, which evaluates several promotions to meet a target revenue. As an example, an apparel retailer may desire to increase profitability. The retailer offers a variety of product lines, of which Dress Slacks and Button-Down Shirts have recently encountered increased sales as a result of the popularity of designs. Additionally, there are a variety of Store Groups that the retailer can utilize to generate sales. In particular, Western Region stores currently have not been showing reasonable profitability. This retailer historically has offered flat discounts at the product level to generate sales. The issue is the selection of which products should be targeted for promotional incentives (i.e., discounts) and at what level should these discounts be set? Promotion system 100 can provide the answer to this question by identifying a group of products to consider for promotions and the promotional incentive type (i.e. discount). Thus, the OM 1100 will:
(1) Identify the optimal discount for each product / store group / sales channel combination (which generates the highest profitability); and
(2) Rank product / store group / sales channel combinations by profitability
(given the recommended incentive).
By employing the OM 1100, the user can identify which products within the dress slacks and button down shirts should be targeted for promotions, what the promotional incentive should be for each (i.e., discount), and how this will affect the overall profitability of the Western Region store group.
Additionally, the user can establish business constraints to better reflect the needs of their business. For example, the user may define the following business constraints. For instance, the user may set fixed incentive levels which can identify an incentive level that should apply for any selected products, store groups or sales channels (e.g. all menswear should be discounted at 15%). For Example, the user may use equality constraints on incentive levels that can specify that the discount for dress slacks should be the same across all regions.
The Min/Max constraints on incentive levels can be set at a maximum discount level (e.g. max discount of 50%), or minimum discount level (e.g., min discount level should remain above 6% to assure customer satisfaction and ease of communication). The Min/Max constraints on margin allows the user to assure that the recommended discount level will not erode the objective per unit margins for a product (e.g., the margin for Dress Slacks must remain above 4%).
Maximums can also be set (e.g. we can have at most a 10% margin on the sale of Dress Shirts). The user may set fixed margins which allow a target margin to be established (e.g., all products within the casual wear product line must have a margin of 14%) by setting the Min/Max incentive budget at global level, the user may specify a total "Incentive Budget" for a given time period (e.g., the total amount of cash back incentives should not exceed $800,000 for the next fiscal year, or the total dollar amount of cumulative discounts must not exceed $10,000). The inventory constraint allows the user to specify an inventory amount to prevent product shortages resulting from a sale (e.g., for summer promotion, only have 20,000 t-shirts available, and therefore, should set the discount level to maximize profitability for this number of units). And, the demand target helps the user identify the number of units to be sold for a given period (e.g., in March, sell 5,000 units of Dress Slacks).
The OM 1100 allows the user to select the promotion that maximizes profit, subject to certain constraints. This is particularly useful if the market response model incorporates cannibalization or affinity relationships. As illustrated in Fig. 11, the OM 1100 employs an optimization method 1110. The first step 1120 is to define an offer template. This generally consists of product/sales channel combinations, target customer segment, target incentive type and a time period. These may be defined according to previously defined methods, 210, 310, 410, and 510. An offer is made to a list of choices, where a choice is a combination of customer segment, product, and channel. For each choice, there is an incentive type (e.g., cash back, discount), and an incentive level (e.g., $20 off, 5% off). An offer template has the same form as an offer, with the following exception. An offer has associated incentive levels (e.g., level of discount, APR). For example, printer at 20% off, computer at $100 off (assuming "printer" and "computer" are choices). In an offer template, some of the incentive levels that take on real values may be set to be VARIABLE. So, for example, printer at VARIABLE % off, computer at $100 off might be part of an offer template. Each offer template has instances associated with it. For example, printer at VARIABLE % off, computer at $100 off would have, as an instance, printer at 20% off, computer at $100 off. In step 1130, the user specifies business rules/constraints. There are generally three types of constraints: incentive constraints (which apply at the group level), financial constraints (which apply at the global level), and volume constraints (which apply at the product level). Incentive constraints apply at the group level. A group is a set of product / channel combinations that have been selected together by the user. For a group, there are several allowable types of incentive constraints, including:
(a) Set fixed incentive levels. The user can set the incentive level to be a certain fixed amount (e.g., 7%) for all choices in the group.
(b) Equality constraints on incentive levels. The user can specify that all the incentive levels must be the same for all choices within the group. If this is not the case, then the incentive levels can vary independently.
(c) Min / Max constraints on incentive levels. The user can specify that all the incentive levels within the group lie between specified min and max values. The user may specify a min or a max or both.
(d) Set fixed margins. Margin for a choice is defined as (List Price - Discount
Amount - Cost) / (Cost). The user can specify that all margins within the group must be a certain amount (e.g., 8%).
(e) Min / Max constraints on margin. The user can specify that all the margins within the group lie between specified min and max values. The user may specify a min or a max or both.
By default, the system may set equality constraints on incentive levels within the group. Financial constraints (min / max incentive budget) apply at the global level. This constraint will apply only to those product/sales channel combinations that are a part of the promotion. Incentive budget is the sum of cost of discount times volume across all product/channel combinations that are a part of the promotion.
In contrast, volume constraints (min / max volume, inventory) apply at a product level. These constraints apply only to product / sales channel combinations that are a part of the promotion. For example, suppose the user has selected "Blue Shirts/San Francisco," "Blue Shirts/San Jose" and "Blue Shirts/L.A." to be in the promotion, where "Blue Shirts" is a product. Then the user could impose a volume constraint on the sales of Blue Shirts. This would be applied to the sum of volumes, Vol(Blue Shirts/San Francisco) + Vol(Blue Shirts/San Jose) + Vol(Blue Shirts/L.A.).
The system will check that min <= max when constraints are entered, but generally will not use any intelligence to determine if there is a feasible solution. Constraints on margin will be translated by the promotional pricing system 100 into constraints on incentive level. Constraints on volume and incentive budget will generally only be available in absolute (i.e., not incremental) terms. The system will also generate constraints for each choice. These are dependent on the incentive type. For example, a discount expressed as % off would have 0 <-= Discount <= 100.
Optimization subject to inventory constraints is similar to unconstrained optimization but user could add constraints saying that demand generated should not exceed user-specified amounts (e.g., amount of inventory available). Alternatively, the user may optimize subject to business rules. Using incentive groups, the user can ensure that incentives are constant across a product category. Using constraints, the user can operate within a fixed marketing budget, and/or ensure that incentives do not vary too greatly from what is currently in place.
In step 1140, the OM 1100 determines the optimal offer. Specifically, the OM 1100 aims to solve (or approximately solve) the problem of considering all the offers that are instances of this offer template. The OM 1100 further considers the subset of these that satisfy the constraints. Each such offer will have an associated profit, and the OM 1100 finds the one that gives the largest profit and uses this as the optimal offer.
The OM 1100 generally produces exact values; for example, it may return that an optimal discount is 28.47% off. The user can always use the optimized program as a guide and round values. Optionally, the OM 1100 may restrict optimization to consider only rounded promotions. In the instant example, the OM 1100 may compare the profitability of a 28% discount with profits from 29% discounts.
Marketing Channel Performance Module 1200 Another embodiment of the promotion system 100 includes the MCPM 1200 to maximize market investment return. As illustrated in Fig. 12, the strategy testing method 1210 comprises the creation of an offer for the customer segment and products of interest, step 1220. The next step 1230 is to try different direct channel and inventive offer combinations. The MCPM 1200 then chooses the promotion offer that gives the best results, 1240.
The user's inputs into the MCPM 1200 includes target products; target customer segment; target incentive type, e.g., cash rebate; marketing communication budget; direct mail unit costs; direct telemarketing unit costs; etc.
The promotion system 100 then determines the number of consumers reached if certain direct channel is chosen as well as which direct marketing channel to choose in order to achieve high margin and what incentive offer gives higher margins. The promotion system 100 further determines expected propensity of a promotion offer, expected number of sales of a promotion offer, expected incremental costs of a promotion offer, and expected incremental profits of a promotion offer.
Overall, a marketing manager has a given number of consumers to reach in the target segment, and is trying to create a direct campaign to promote certain products and achieve high margin at the same time.
Alert Module 1300
The AM 1300 produces alerts bringing to the user's attention any unexpected data trend. This feature refers to a list view of data behavior that violates some administrator defined business rules in terms of performance indicators. The alert method 1310 is depicted in FIG. 13. Specifically, pre-defined logical expressions with threshold parameters need to be specified and updated by user step 1320. Baseline value refers to the value against which actual current value is compared. It varies depending on the alert type and is defined during step 1320.
Various levels of alert severity may be defined in step 1320. The severity relates the degree of deviation from a baseline value to an actual value. The user needs to specify thresholds against which comparison is made, based on business domain knowledge and practice, and then input them into the appropriate data table. For instance, a severe alert for the actual vs. forecast could be generated if actual sales fall 2000 units or more short of forecast; similarly, a medium alert for the same type would be generated if actual sales fall 1000 to 2000 units short of forecast; and so on. In this example, thresholds for a severe alert is 2000 or more, and between 1000 and 2000 for medium alerts. The alert may further have a direction either below or above, which indicates if actual values are below or above baseline values.
The time period transaction data is aggregated to generate business metrics. It is also the time unit each forecast value is based upon. For actual vs. forecast alerts, it is time unit which forecast is made upon depending on the time unit for the calibration process. The AM 1300 defines this time unit as the basic time unit. For other types of alert, it could be anything beyond the basic time unit, and it is highly desirable to have other time units. For instance, if the basic time unit is made at a weekly level, the time unit could be week, month, quarter, and year, etc. for alerts of current period vs. previous period.
The AM 1300 may employ dynamic on-line analytical processing capability to perform any one of the following actions several times over or in succession, in order to gain a better understanding of a business situation, step 1330:
(1) Comparison of two elements within a Dimension against a single metric or a set of metrics. E.g., compare Product A's performance vs. Product B's performance.
(2) Slice and dice a report across predefined Dimension (min-ship)
(3) Pivot Dimensions
(4) Include metrics from the set of predefined metrics
(5) Drill up or drill down on Dimension hierarchies
(6) Define new metrics and draw these into the analysis
Basic alert types include actual vs. forecast, current time period vs. previous period, same variation trend, and year over year comparison. The actual vs. forecast alert is generated by comparison of actual values in the current time period to the forecast value. The baseline value is forecast value for current time period. For instance, if the actual sales of button down shirt for last week were 1000 units less than the forecast, this type of alert would be stimulated. An actual vs. forecast alert may be promotion focused, i.e., only promotion-associated sales can be involved in such an alert, because the forecast in current release is at promotion level. Alternatively, a general forecast or planning enables a more general actual vs. forecast alert. The current time period vs. previous period alert is generated when actual values for the current time period are deviated from the previous time period at certain degree. The baseline value may be the actual values for the previous time period. For instance, if the actual sales of button-down shirts for February were 1000 units less than those of January, such type of alert would be stimulated.
A variation trend may be generated when actual values in n consecutive time periods decrease or increase, showing a consistent trend in these time periods. In this case, the baseline value could be a correlation coefficient for the time serial of actual values and time periods. For instance, if the monthly actual sales of button-down shirts from January to June of 2001 were 300, 280, 250, 240, 220, and 190, respectively, showing a declination trend, such type of alert would be stimulated because the correlation coefficient is more than 0.9.
Similarly, a year-over-year alert may be generated when actual values for a time period deviate from the same time period in the previous year to a certain degree. The baseline value refers to the value for the same time period in the last year. For instance, if December sales of button-down shirts in year 2000 were 3000 units less than those in year 1999, such type of alert would be stimulated.
In one embodiment depicted in FIG. IB, the promotion system 100 is configured to operate over a distributed network such as the Internet. Specifically, the various modules of the promotion system 100 operate as JAVA or C applications that may be served or are executed at the server. In particular, the user may be in communication with the system 100 via electronic networks such as the Internet, an intranet, an extranet, a Value Added Network ("VAN"), VPN and the like. The Internet browser may be, for example, Netscape Navigator or Microsoft Internet Explorer. Those skilled in the art will recognize that this invention may be physically implemented in a number of ways. In another embodiment illustrated in FIG. 1C, the promotion system 100 is connected to a market management application 40 and a demand forecaster 50. The interaction of the promotional pricing system 100 with these components is described above in the text accompanying FIG. 8.
Promotional Pricing Example
The operation of the promotion system 100 and the use of drivers are now explained through the following example that describes the creation of a promotion pricing model for a manufacturer. In the following example, it is supposed that three types of incentives are offered by the Manufacturer for its truck - a cash rebate, low finance and a lease rate. Logically, the truck finance and the truck lease drivers are the price paid by the customer per month, so by construction they will never be null. If the Manufacturer decides not to give any cash rebate for its Truck (no incentives for cash back), the driver price still won't be null for mathematical purposes because at some point in the process of calculating the utility of Truck, the log of the drivers will need to be calculated and, therefore, the drivers cannot be null. The promotion system 100 operates to prevent null values for the drivers that may preclude or adversely impact the evaluation of the promotions. The following Table 1 represents the different incentives that may be offered by the Manufacturer as well as the drivers affected by these incentives.
Table 1
Figure imgf000033_0001
The promotion system 100 determines, for instance, that the product (or product segments) of interest is Truck ("T") and the primary competitor product segment is an SUV (S). As suggested in the Table 1, the different promotions in this example are a cash discount (C), a finance discount (F) and a lease discount (L). Hypothetically, the customers for the product segments may be segmented into Upscale (U) and downscale (C) categories. The promotion system 100 may further define a trend or time period so as to compare offers across different times and thereby allow normalization for past promotions.
The incentive translator may further designate the independent variables representing the measure the consumers use to evaluate the competing products. For instance, the Manufacturer may use Attractiveness to measured utility in the product segment including the Truck and the SUV. As described above, the independent variable Attractiveness is a function of many factors, including:
(1) preference variables, namely the product and promotion type;
(2) the manufacturer's own influence as measured by the driver of the target incentive (producti * deal typej)
(3) cross-impact influences, including cross-product and cross-deal factors; and
(4) month trends,
where preference variables are the constant component of the model, and the influence of the manufacturer's other products, cross-impact influences from competitive products, and trend factors impact the independent variable through their coefficients. Other factors that may be considered in determining the Attractiveness of products are:
(5) preference variables in the channel
(6) the manufacturer's own influence in the channel
(7) cross-impact influences such as cross channel, pull-forward factors
(8) seasonality trends
(9) a competitive factor
Thus, the example has defined products, channels, incentives, customer segments, and many other variables. Two concepts are now introduced: choice and choice situation. A choice is a combination of product i, incentive typej, and channel k. A choice is what a customer can choose. A choice context is the environment where customers are making decisions, or things customers cannot change. A choice context is a combination of Market Group, Subsegment, Segmentation, Customer segment. Here is a more detailed example of the above method, dropping the Adjustment factor for now to simplify the problem: c ur,C,Pr onto, Young
VolumeT,C,Promo, Young = VolumeA,B,Base, Young x XB,Basc,rom,g
where Target choice: Truck cash(T,C);
Target Program: Promo;
Target Customer Segment: Young;
Baseline program: Base;
Baseline Choice: (Vehicle A, Incentive B);
A: can be any vehicle in the target subsegment;
B: can be any incentive type in the choice set;
VolumeA,B,Base, Young: user's volume estimate of the baseline choice for the target customer segment;
ST,C,Promo,Youngt: the forecast market share of the target choice for the target customer segment; and
SA,B,Base,Young: the forecast market share of the baseline choice for the target customer segment;
This equation 11 implies the following relation:
τr J °lUmeT,C,?τomo.. Joung VθlUmβA B B γ _,
Volume = — = — = > Volume promo ^T,C,?ι onto, Young " A,B,Base,Young Base
(12). The sum of volumes for all choices in the promo program equals the sum of volumes for all choices in the baseline program, given the choice context. Another issue arises when user estimates VolumeA,B,Base Young. Practically, users may not have a good idea about this variable because this (VolumeA,B, Base, Young) may not be meaningful enough to them. To fix this, the promotion system 100 can use something more meaningful for the Baseline choice, and then the users will be asked to provide volume estimates for the Baseline choice, which now makes more sense to them. In the following example, the promotion system 100 asks users to estimate VolumeSedan,Base, Young,, instead of Volumesedan,Cash,Base, Young or Volumesedan,Fin,Base, Young.
Assuming the following conditions:
There are only two deal types available: (Finance, Cash); Sedan is also a vehicle in the subsegment; Target customer segment: Young; Target choice: (Truck, Cash) or (T, C); and Baseline Choice: (Sedan)
then, VolumeTruck,Cash,Promo,Young can be obtained from the following equation:
VolumeT, C, Promo, Young = VolumeSedan, Base, Young x — ' 'Prom°' °mg (13)
'-' Sedan, Base, Young
where VolumeSedan,Base Young and STruck,Cash,Promo,Young are provided by user promotion system 100. Also,
Ssedan,Base Young = Ssedan,Cash,Base, Young + Ssedan,Fin,Base, Young, (14)
which are still provided by the promotion pricing system, as described above. c T,C, Promo, Young
VolumeSedan Base Young x s Sab,e.C"sn<Base.γ°""g + sabi ,Fm,Bas , oung
" °l Sedan,Cash,Base,Young "' * ^ Sedcm,Fm,Base,Young
° Sedan,Cash,Baie,Young ' Sedan,Fm,Base,Young ^ jC" romO YθUn_ϊ ∑ Vol + SSedanfias Base Yomg + ∑ Vol + S Sedan, Fin, Base, Young Base
^ Sedan,Cash, Base, Young Sedan, Fin, Base, Young v CT ~J p Qt iO YoUtlff
Figure imgf000037_0001
ST,C,Promo, Young
VolumeT,C,Base, Young (15)
If providing VolumeSedan,Base, Young is still difficult to users, users can estimate
VolumeSedan,Base. The Promotion Pricing system 100 may calculate the conditional probabilities from the database, Prob(VolSedan,young | VolSedan,old+young), and then compute VolumeSedan,Base, Young.
VolumeSedan,Base, Young = VolumeSedan,Base x
Pr ob(VolSedan,young | VolSedan,Young+01d) (16).
The example has discussed products, channels, incentives, customer segments, and many other variables. Two concepts new are now introduced in the example: choice and choice situation. A choice is a combination of product i, incentive typej, channel k and represents what a customer can choose. Similarly, a choice context is the environment where customers are making decisions, or things customers cannot change. In this example, a choice context may be a combination of Market Group, Subsegment, Segmentation, Customer segment.
In this example, users may associate different segmentations with different products. Let's assume that there are two products (Sedan, Truck). The segmentation for Sedan is (Old, Young), and the segmentation for Truck is (Rich, Poor). In this example, the Manufacturer has an incentive for (Sedan, Old), but there will be no incentive for (Sedan, Poor) because (Rich, Poor) is not how Sedan segmented its customers. Sedarioid xso 0 0 0 Bso Sedan young 0 X 0 0 BSY
Truck rich 0 0 Xm 0 BTR
Truck poor 0 0 0 XTP BTP
(17A)
or
Y = X B (17B)
where
Y: In(market share of vehicle i and segment j); and
Xij: the drivers, including its own driver and cross-impact drivers, for vehicle i, segment j;
Bij: the parameters of the corresponding vehicle and segment are Xij , Bij matrices; and
Superscript: S = Sedan, T = Truck; O = Old, Y = Young, R = Rich, P = Poor.
Accordingly,
xso = [x. so X r:SO so LSY X. so
Λτo TY
Figure imgf000038_0001
ySY _ \γSY VSY γSY V Y Λ - Ji-so A Λm r/J
BSY βSY
YPso PSY P βTSOY P βTSYΪ J'
Figure imgf000038_0002
BTR TR βTR βTR]
{PSR SP PTR PTP J'
Figure imgf000039_0001
Since the segmentation associated with Sedan is not (Rich, Poor), the incentive driver for (Sedan, Rich), or (Sedan, Poor) will need to be deduced using conditional probabilities.
To calculating the cross-impact drivers under segmentation, the promotion system 100 may calculate the cross-impact driver from Truck onto a customer segment J of Sedan. Suppose Truck has 3 customer segments 1, 2, 3. Each customer segment of Truck has its own cash incentive (CGAR), finance program incentive (FGAMP) and monthly lease payment (LMP). Call these CGAR(l), FGAMP(l), LMP(l), etc. The cross-impact drivers onto Sedan are then:
CGAR = P(1 I J)*CGAR(1) + P(2 | J)*CGAR(2) + P(3 | J)*CGAR(3) (18)
FGAMP = P(l | J)*FGAMP(1) + P(2 | J)*FGAMP(2) +
P(3 I J)*FGAMP(3) (19)
LMP = P(1 I J)*LMP(1) + P(2 I J)*LMP(2) + P(3 | J)*LMP(3) (20),
thereby using the weighted averages of the drivers, with the weights being the conditional probabilities of the customer segments.
Similar formulas apply for different numbers of customer segments, i.e., if the customer segments of the impacting vehicle are in a set CS, then
CGAR = <<= P(i I J) * CGAR(i) (21), FGAMP =<ecs p(i I J) * FGAMP(ι) (22), and
LMP ='«cs P(i I J) * LMP(i) (23).
Alternatively, once a segmentation has been specified for a product, the promotion system 100 may assume that all other products will be associated with this segmentation as well. For example, there are still two products (Sedan, Truck), and the segmentation for Sedan is specified to be (Old, Young). The regression now looks like this:
Sedarioid
Figure imgf000040_0001
TruckM
Truck young
Figure imgf000040_0002
By imposing the segmentation assumption, the number of calibration models becomes manageable. This gives the promotion pricing system 100 the capability to compute parameters for all possible segmentations in advance. With the attraction model, equation 24 may be seen as :
Y=X *β (25), where Y = Utility, and
X = own drivers and cross-impact drivers.
Also,
S.
Si = i (26)
Where, Si = the normalized market share of vehicle i, and
∑s,
J = the sum of market shares of vehicles in the same subsegment With the multiplicative model, equation 24 is also written as:
Y=X *β (25)
For instance, if the products in the multiplicative model Truck(T) and SUV(S) and the promotion types are Cash(C) and Finance(F), then
TC ~ aτc X PTC Λ- TC X PTF -A- TF "■" PAC-X- AC X
Figure imgf000041_0001
(27)
TF γ
>2τF — (*TF P >T'. F Λ TF + β. TF TC X. TC X AC-X- AC xβ A. F (28)
QAC - Ac + PAC X- AC + PAF %AF + PTC %TC + PTF % (29)
QAF - aAF + PAF X AF + PAC % Αc + PTC -^TC + PTF -^TF ΠQ)
where the constraints are the directions of Betas and other client-specific constraints.
Suppose in a homogenous market, two products (L=l,2) are competing with each other in 12 (T=12) month periods, both products have two incentive offers (K=l,2). So there are K*L pairs (l=l/k=l, l=l/k=2, l=2/k=l, l=2 k=2) of unique product offers (1=1,2,3,4) for each period. The following equations describe different approaches to estimate promotion responses. With the multiplicative model,
S, = exp(αl) * πxΛ * β 7=1 j (31)
Ln(S i, t) = a + Σ π β- Ln(χj.0
J"' J-1 y (32)
where the number of parameters estimated (columns in X matrix) is I*(l+I) = 20, the number of observations (rows) equals PT = 48, the elasticity is esi = βij. In contrast, with the attraction model,
Ai = exp(α/) * jX ,* e
(33);
Figure imgf000042_0001
where the number of parameter estimated (columns in X matrix) equals I*(l+I)+T, or 32; the number of observations (rows) is I*T, which is 48 in this example; and elasticity is found by esi = βij (1-si).
In both models, the dummy variable Du = 1 if u = t and Du = 0 if u ≠ t
If the algorithm does not allow estimating without intercept term,
4 a, = ∑ ajdj, where dj = 1 if j = i and dj = 0 if j ≠ i , Constraints can then be:
7=1
Gey > 0 if i =j
αy < 0 if i in (1,2) and j in (3,4) or vice versa, so that
α*2 = α3
α2ι = 3
α13 = α2
Figure imgf000042_0002
The promotion system 100's goal is to get an idea of how many β parameters the calibration will need to determine. The calibration process will need to solve the following equation for each customer segment and each subsegment of the products.
L prodl,channeH,deal-typel 0 prodl,channell,deal type* 0 0 prod 1, channel l,deal-tyρ el prc>da,channelc,deal typed 0 0 pro dn, channelc, deal-typed 0 Y prodn-channelc-deal-- typed
(36)
where
Y is the vector (n,l) of the utility of a product for a certain segment, channel, deal-type over the last n periods of time;
X is the matrix (n, m) of the drivers of a product for a certain segment, channel, deal-type over the last m periods of time; and
B is the vector (m,l) of the β for a certain product, segment, channel and deal-type over the last m periods of time.
In this example, the promotion pricing system may estimate the variable m first, i.e., estimate for a product, deal-type, subsegment, customer segment, and channel, how many B needs to be calculated. The following table fixes the value of each constant:
Table 2
Parameter Number
Product N
Deal type Δ
Segment Σ
Subsegment S
Channels c
X-product K
Period P
By listing the drivers used to calculate the attraction of a certain product, deal-type, segment and channel, the promotion system 100 may estimate each time the number of β, assuming global segmentation and no X-impact between trade-up/trade-down in different deal types or different channels, and no constraint across subsegments.
Table 3
Figure imgf000044_0001
Thus, for every product, deal-type, segment and channel, the total number of βs to be estimated by the calibration will then be:
Total number of βs = σS * [NδC * (δCK + δC + 2) + P - 1].
Example, with the model set up in Table 4,
Table 4
Parameter Number
Product 20
Deal type 3
Segment 4
Subsegment 2
Channels 3
X-products 3
Periods 24
Then, the total number of β = 4*2* [20*3*3* (3*3*3 + 3*3+2) + 24 - 1] = 54,904
In the attraction model, the number of βs equals the number of MarketGroups * the number of product Subsegments * the number of Customer Segments * [the number of Choices * (the number of Choices+2) + the number of Periods-1]. Likewise, the number of Observations equals the number of MarketGroups * the number of product subsegments * the number of Customer segments * the number of Choices * the number of Periods. If there were no constraint, it has to meet the condition that the number of Observations is equal or greater than the number of βs to be able to estimate all βs. So,
the number of Periods > the number of Choices + 3 +
^(the number of Choices -1) (37) In the multiplicative model, the number of β's equals the number of MarketGroups * the number of product Subsegments * the number Customer Segments * the number of Choices * (the number of Choices+2). As before, the number of Observations equals the number of MarketGroups * the number of product subsegments * the number of Customer segments * the number of Choices * the number of Periods. If there are no other constraints, the model still has to meet the condition that (X) the number of Observations is equal or greater than the number of β's to be able to estimate all βs. Therefore, the number of Periods must be greater than the number of Choices +2.
User Configuration of Pricing Optimization
Turning now to FIG. 14, another embodiment of the present invention provides a configurable pricing optimization system 1400. The configurable pricing optimization system 1400 includes a price optimization application 1410 that operates by defining a optimization problem and producing an optimal pricing solution 1420 to the defined optimization problem. As described above, the present application describes a value evaluation and recommendation for promotions on a targeted product so as to analyze, evaluate, improve, and design promotions to meet a user's need. Other types of pricing optimization solution are also known. For instance, co-owned U.S. Application Nos. 09/517,983 and 09/517,983, the subject matter of which is hereby incorporated by reference, provide a pricing solution that addresses finding an target price for a particular item as needed to accomplish particular business goals (e.g., sales volume, profits, etc.). Another pricing optimization application described in U.S. Application No. 09/859,674, the subject matter of which is also incorporated by reference, provides a dynamic pricing system that generates pricing recommendations for each product in each market by normalizing historic pricing and sales data, and then analyzing the historic data using parameters describing the user's business objectives to produce a pricing list to achieve these objectives. These and other price optimization systems and methods generally entail the solution of an optimization problem given various constraints, boundaries, or the lack thereof. The data used to define the optimization problem, including the various constraints and boundaries may be stored in a database 1430 associated with the price optimization application 1410. The database 1430 may be a memory storage unit or other data structure physically represented in a known storage media such as electronic memory or semi-permanent magnetic or optical storage. Continuing with FIG. 14, the configurable pricing optimization system 1400 includes a configuration application 1440 that enables users to define the optimization problems, such as defining various constraints and boundaries, as needed for the price optimization application 1410. The configuration application 1440 may operate by directly editing the contents of database 1430 or by providing data directly to the price optimization application 1410, which then bypasses the stored data in the database 1430.
It should be appreciated that the configuration application 1440 may be implemented using multiple known methods. For instance, the configuration application 1440 may be a text editor or other similar application that allows users to directly provide configuration data. Alternatively, the configuration application 1440 may be some type of GUI (graphical user interface) program through a Visual Basic window or through another programming language such as JAVA or C+. The configuration application 1440 may direct the user through a list of possible boundaries and constraints to be defined. The configuration application 1440 may further show defaults values to the user. A user may further use the configuration application 1440 to other direct the operation of the price optimization application 1410, as described in greater detail below.
In one embodiment, the configuration application 1440 may be used to direct the mathematical model or to define various boundaries or constraints to be considered by the price optimization application 1410. It should be appreciated that various mathematical models may be used in the analysis of a price optimization, depending on the desired results and the needs of the used. The different models may be used depending on whether a pricing problem is unconstrained, bounded unconstrained, constrained, mixed- discrete non-linear, etc, and the various models used to address these optimization problems are described in greater detail below.
An unconstrained problem is mathematically depicted in Equation 38:
min f(x*, x2,..., xn) (38) where Xj (i = 1, 2, • • • , n) are variables and f is a nonlinear objective function. Similarly, a Bounded Unconstrained Problem is mathematically described in Equation 39: min f(x-, x2, ..., xn), given lb; < X; < ub- (39)
where xi (i = 1, 2, • ■ • , n) are variables, lb; and ub; are the lower bounds and upper bound, respectively, and f is a nonlinear objective function. In a constrained problem, the pricing optimization application 1410 seeks to find a solution to equation 40:
min f(x), given s.t. gj (x) = 0,j = l, 2,..., k hj(x) ≤ 0, j = k + l, k + 2,...,m lbi ≤ Xi ≤ ubj, i = l, 2,..., n (40) where x = [xi, x2,..., xn]τ is a vector of all variables x- which are continuous, lb; and ub; are the lower and upper bounds of the variable x;, respectively, and the objective function f(x) is constrained by functions gj(x) and hj(x). In the same way, a mixed-discrete nonlinear optimization problem may minimize or maximize an arbitrary objective function with mix-discrete variables subject to nonlinear equality and inequality constraints using equation 40, but where x = [xi, x2,..., xn]τ is a vector of all variables x- which may be continuous, integer, boolean or discrete.
Various algorithms may be employed for one-variable optimization problems, the most elementary type of optimization problem. There are a number of different approaches to one-variable optimization problems, and the approaches could be classified as derivatives-based approaches and non-derivatives-based approaches. For instance, Golden Section Search method and Brent's method may be used for one-variable optimization problems.
The Golden Section Search method operates such that given, at each stage, a bracketing triplet of points, the next point to be tried is represents a fraction 0.38197 into the larger of the two intervals (measuring from the central point of the triplet). If starting with a bracketing triplet whose segments are not in the golden ratios, the procedure of choosing successive points at the golden mean point of the larger segment will quickly converge you to the proper, self-replicating ratios. Because this method is linearly convergent, the golden section search guarantees that each new function evaluation will (after self-replicating ratios have been achieved) bracket the minimum to an interval just 0.61803 times the size of the preceding interval.
A golden section search is designed to handle, in effect, the worst possible case of function minimization, with the uncooperative minimum hunted down and cornered like a scared rabbit. But, if the function is nicely parabolic near to the minimum, then the parabola fitted through any three points ought to identify the minimum a single leap, or at least very near to the minimum. The procedure is technically called inverse parabolic interpolation. But, no minimization scheme that depend solely on the technique is likely to succeed in practice. In the Brent's Method, the exacting task is to invent a scheme that relies on a sure-but-slow technique, like golden section search, when the function is not cooperative, but that switches over to the parabolic interpolation when the function allows.
Several algorithms are also known for Unconstrained Problems. Some methods employ gradient information, while Quasi-Newton Methods requires only first derivatives. The computing steps of Quasi-Newton method for multiple variables are as follows:
Step 1 : Choose an initial point x^, select a symmetric positive-definite matrix A(0) (i.e., unit matrix I) and set k = 0.
Step 2: Compute the search direction in the space of variables as follows in Equation 41:
s(x(k)) = -A(k) V(x(k)) (41)
Step 3: Find a new solution x(k+1) by line search along the direction s(x(k)).
Step 4: Update A(k+1) by using some iterative methods such as Davidon-
Fletcher-Powell (DFP) method.
Step 5: Test the stopping criterion, if satisfying the criterion, then stop, otherwise, go back to Step 2. The quasi-Newton method is very powerful if the first derivatives are available and their evaluation is not expensive.
When the objective function is smooth, unconstrained optimization problems can be solved by using gradient-based methods such as Newton methods, quasi-Newton methods, the steepest descent method (Cauchy's method) and conjugate gradient methods. However, the gradient-based methods are inappropriate for objective functions where calculation of functions is very expensive or time-consuming; exact first partial derivatives of functions can not be calculated; or numerical approximation of the gradient of functions is impractically expensive or slow.
In many pricing optimization models, the objective functions are obtained by regression, and the functions are not known until the regression. Hence, each value of functions is obtained by calling a parser of expression of functions which is a time- consuming process. Obviously, the exact first partial derivatives of functions are not known, either. To be approximate the gradient of functions, the parser has to be called multiple times to get multiple function values. This is impractically expensive, and to optimize a function with the properties listed above, the best choice is a direct search method. This kind of methods has the important properties of using only function values and not using an approximate gradient.
Direct search methods can be classified as three sub-categories: Direction Set
Method (i.e., Powell's Method) Simplex-Based Method (i.e., Nelder-Mead's Method) and Pattern Search Method (i.e., Hooke-Jeeves' Method).
Powell's Method starts at a point x in n-dimensional space, and proceed from there in some vector direction dn, then any function of n variables f(x) can be minimized along the direction dn by line search methods. Let xo be the initial approximation to the minimum, and let u-, u2, , un be the columns of the identity matrix. The iterating steps are as follows:
Step 1 : For i = 1, ... , n, compute B- to minimize f(xn + B-u-), and define
Figure imgf000050_0001
• Step 2: For i = 1, ... , n - 1, replace ui by U u. Step 3 : Replace un by xn - x0.
Step 4 Compute B to minimize f(xn+Bun) and replace x0 by xn+Bun.
If the stopping criterion satisfies, then stop the iteration; otherwise, go to Step 1. For a general nonlinear function, the iteration is repeated until some stopping criterion is satisfied.
The algorithm above is mainly for the unconstrained nonlinear problems without bounds for the variables. To solve bounded problems, an interval may be implemented for each line search. The line search intervals may be computed to make sure that the new points always lie inside the bounds when the initial point lies inside the bounds. Powell's method is then modified such that for each line search minB{f(x + Bu)}, the line search interval of B is (B-, Bu) which are defined as follows:
Bi = max{(lb! - x,)/^ for u, > 0.0,
(ub! - x,)/^ for u, < 0.0, and
-1.0e + 12 for u, = 0.0}.
Bu = min{(ub! - x,)/^ for u, > 0.0,
Figure imgf000051_0001
1.0e + 12 for u, = 0.0}.
Since x is between the lower bound lb and the upper bound ub, then for any B between Bi and Bu, x + Bu is between lb and ub.
Continuing with the direct search methods, the Nelder-Mead's method is a simplex-based method constructing an evolving pattern of n + 1 points in Rn that are viewed as the vertices of a simplex. Nelder-Mead's method is based on the idea of creating a sequence of changing simplexes, but deliberately modified so that the simplex 'adapts itself to the local landscape'. This method is also called "Downhill Simplex
Method". The Nelder-Mead method starts with n+1 points defining an initial simplex, then take a series of steps moving the point of the simplex where the function is largest through the opposite face of the simplex to a lower point. These steps are called reflections, and they are constructed to conserve the volume of the simplex. When it can do so, the method expands the simplex in one or another direction to take larger steps. When it reaches a relative floor, the method contracts itself in all directions, pulling itself in around its lowest point.
At each iteration of Nelder-Mead's method, a current simplex is defined by its n+1 vertices, each a point in Rn along with the corresponding values off. Iteration k begins by ordering and labeling the current set of vertices as x-, ... , xn+ι such that f(xι) < f(x2) < ... < f(xn+ι). There are four possible operations: reflection, expansion, contraction, and shrinkage, each associated with a scalar parameter. The coefficients of reflection, expansion, contraction, and shrinkage are denoted respectively by p, χ, γ, and σ. These coefficients should satisfy p > 0, χ > l, 0 < γ < l and 0 < σ < 1.
A generic iteration of Nelder-Mead's method has two possible outcomes:
A single new vertex - the accepted point - which replaces xn+ι (the worst point) in the set of vertices for the next iteration; and
if a shrink is performed, a set of n new points that, together with x-, form the simplex at the next iteration.
An iteration of Nelder-Mead's method generally includes:
Step 1 : Order the n + 1 vertices to satisfy f(xι) < f(x2) < ... < f(xn+ι).
Step 2: Compute the reflection point xr from xr = x + p(x - xn+ι), where x is the centroid of the n best vertices except xn+1; i.e., x = ∑(x-/n). Evaluate fr = f(xr), and if f(x < fr < fn, accept the reflected point xr, replace xn+ι by xr, terminate the iteration and go to Step 1.
Step 3: If fr < f-, calculate the expansion point Xs from Equation 42:
χe = + χ(χ- - ). (42) and evaluate fe = f(xe)- If fe f, accept xe, replace xn+ι by xe, terminate the iteration. Otherwise, the method accepts xr, replaces xn+ι by xr, terminates the iteration,and returns to step 1.
Step 4: If fr < fn, the method performs a contraction between x and the better of xn+1 and xr. If fn < fr < fn+ι (i.e., xr is strictly better than xn+ι) perform an outside contraction using equation 43:
Xc = x + γ(Xr - x)- (43)
and evaluate fc = f(xc). If fc ≤ fr, accept Xc, replace xn+ι by xc, terminate the iteration and go to Step 1. Otherwise, go to Step 5 described below. Iff- < fn+ι (i.e., Xn+i is better than xr, perform an inside contraction by calculating
x'c = x - γ(x - xn+ι), (44)
and evaluate f cc = f(x'c). If f c < fn+i- accept x'c, replace xn+ι by x'c, terminate the iteration and go to Step 1 or Step 5.
Step 5: N new vertices are formed from Equation 45
v; = Xi + σ(xi - xl), i = 2, ... , n + 1, (45)
and evaluate fat these points. The vertices of the simplex at the next iteration consist of xi, v2, ... , vn+-.
The algorithm above is mainly for the unconstrained nonlinear problems without bounds for the variables. The initial vertices are chosen inside the bounds, then the centroid of the vertices is inside the bounds. By known computation, a new point inside the bounds may always obtained for reflection, expansion and contraction. Also, the new vertices after performing a shrink step lie inside the bounds since all the previous vertices Xj (i = 1, 2, ... , n + 1) lie inside the bounds.
Other price optimization applications 1410 may similarly use a SQP Method for
Constrained Problems. The SQP methods, also known as sequential, or recursive, quadratic programming methods, employ Newton's method or Quasi-Newton 's method to directly solve for conditions for the original pricing problem. As a result, the accompanying subproblem turns out to be the minimization of a quadratic approximation of the Lagrangian function optimized over a linear approximation to the constraints. Hence, this type of process is also known as a projected Lagrangian, or the Lagrange Newton, approach.
The general iteration of SQP method can be described as follows:
Step 1 : Give an initial point x0. Set i = 0.
Step 2: Find h^ at x„ a quasi-Newton direction of descent at x, by solving. If none exists, then stop the algorithm and x, is the solution to the original problem.
Step 3: A Line Search is performed such that i such that (i) Xfl-ocji!, (ii) f°
(x- -α.h.) < f°(χ.).
Step 4: Set Xj+1 = x, + afa, i = i + 1, go to Step 2.
At each iteration, the following system represented by Equation 45 is solved by the pricing optimization application 1410, and then the line-search procedure determines the step-length along this direction.
min {Vf0(x1)T h + hTHh/2} s.t. f (Xl) + Vf(Xl)T h < 0, j = 1, 2, ... , m (46) where H represents the Hessian of the Lagrangian at x„ either given explicitly or approximated by finite differences or variable metric techniques.
The SQP method is a very useful class of algorithms for the solution of constrained optimization problems. This class of methods is superlinearly convergent. Numerical experiments have showed this class of methods often dramatically outperforms algorithms of other classes.
An algorithm based on simulated annealing which is called simulated annealing (SA) algorithm can also be classified as a random search approach, but this kind of algorithm can avoid getting trapped in a local optimum. The algorithm accepts not only the movements improving the objective function, but also the movements corresponding to a deterioration in the objective function value with a finite probability. These movements allow the algorithm to move away from local optima and find a global optimum. In addition, nonlinear mixed-discrete optimization problems are more complicated than the problems with only continuous variables. It is very hard to use traditional optimization algorithms to solve the nonlinear mixed-discrete optimization problems. However, a SA algorithm can deal with a variety of nonlinear optimization problems while it can deal with mixed-discrete problems more efficiently and more robustly. In fact, an important characteristic of a SA algorithm is that it does not require specialist knowledge about how to solve a particular problem. This makes the algorithm generic in the sense that it can be used in a variety of optimization problems without the need to change the basic structure of the computation. A SA algorithm maintains the speed and reliability of gradient descent algorithms while at the same time avoiding being trapped at a local optimum. In particular, a SA algorithm is much easier to be implemented and more effective than other optimization algorithms for nonlinear mixed-discrete optimization problems.
A SA algorithm approaches the global optimization problems similarly to using a bouncing ball that can bounce over mountains from valley to valley. It begins at a high "temperature" which enables the ball to make very high bounces, which enables it to bounce over any mountain to access any valley, given enough bounces. As the temperature declines the ball cannot bounce so high, and it can also settle to bounce trapped in relatively small ranges of valleys. A generating distribution generates possible valleys or states to be explored. An acceptance distribution is also defined, which depends on the difference between the function value of the present generated valley to be explored and the last saved lowest valley. The acceptance distribution decides probabilistically whether to stay in a new lower valley or to bounce out of it. All the generating and acceptance distributions depend on the temperature.
A SA algorithm is an optimization technique based on the behavior of condensed matter at low temperature. The procedure employs methods that originated from statistical mechanics to find global minima of systems with very large degree of freedom. A simulated annealing algorithm presents an optimization approach which has some important properties making it attractive. The SA algorithm can be employed to solve a wide range of problems. It can process cost functions possessing quite arbitrary degrees of nonlinearities, discontinuities, and stochasticity and quite arbitrary boundary conditions and constraints imposed on these objective functions. It also can deal with chaotic and noisy data. This kind of algorithm is quite versatile since it does not rely on any restrictive properties of the model. The SA algorithm can also be implemented quite easily with the degree of coding quite minimal relative to other nonlinear optimization algorithms, because this kind of algorithm does not require directional analyses involving function derivatives. The SA algorithm can also be tuned for use in more than one problem. For any reasonably difficult nonlinear or stochastic system, a given optimization algorithm can be tuned to enhance its performance and since it takes time and effort to become familiar with a given code, the ability to tune a given algorithm for use in more than one problem should be considered an important feature of an algorithm. The SA algorithm may further provide high quality solutions to many problems and does not depend on initial solutions. It statistically guarantees finding an optimal solution, and its main advantage over other local search methods are its flexibility and its ability to approach global optimality. Overall, the SA algorithm is a robust and generic technique.
While a SA algorithm has some important strengths mentioned above, it also has the following weaknesses:
It can be quite time-consuming to find an optimal solution, especially when using the "standard" Boltzmann technique. There is a clear tradeoff between the quality of the solutions and the time required to compute them;
It can be difficult to fine tune to specific problems, relative to some other fitting techniques. Since a SA algorithm is a metaheuristic, a lot of choices are required to turn it into an actual algorithm. The tailoring work required to account for different classes of constraints and to fine-tune the parameters of the algorithm can be rather delicate; and
It can lose the ergodic property or its strengths such as that it can not statistically guarantee finding an optimal solution by misuse, e.g., by transforming a SA algorithm into a method of "simulated quenching" (SQ). The procedure of the SA algorithm is composes of four basic parts: Initialization, Melting Process, Annealing Process and Reannealing. Initialization is to set the parameters and assign some values to the variables. Melting process is to find an initial temperature which should be large enough to explore all feasible solutions. Also, a starting solution is selected during the melting process. Annealing process is to generate a number of random moves, decrement the temperature and finally to find a solution as the optimal solution of the problem. Reannealing process is to increase the annealing temperature and restart annealing process if the temperature is very low and the stopping criterion is not satisfied.
This algorithm has the following four computing steps:
Step 1: Initialization. This step is to initialize the values of some variables, input the important constants and compute several parameters.
Step 2: Melting Process. This step is to find an initial temperature T° and a starting point x°. Finding an appropriate initial temperature is very important. A too large initial temperature may significantly increase computational time while a too small initial temperature may miss a possible global optimal solution. In addition, as discussed before, an appropriate initial temperature is dependent of each individual problem. Hence, a good melting process which can find an appropriate initial temperature is vital for the robustness of a algorithm.
Step 3: Annealing Process. This step is to find a solution until the stopping criterion is satisfied. For each temperature, generate a number of random moves.
Based on a random probability, some moves are accepted and some others are rejected. According to the ratio of the accepted moves to the total moves, the step length of variables is adjusted. Repeat this process until the stopping criterion is satisfied or the temperature is very low. If the stopping criterion is satisfied, then the best solution is considered as the optimal solution. Otherwise, go to next step.
Step 4: Reannealing Process. This step is to increase the annealing temperature and return to Step 3. If the temperature is very low and the stopping criterion is not satisfied, the annealing temperature is increased and the current solution is considered as an initial solution. Then, return to Step 3 and reannealing until find a better solution. Then, the best solution is considered as the optimal solution.
This application now addresses the solution of constrained functions when the optimization methods for unconstrained problems are used to solve the constrained problems. For unconstrained problems, only the objective function is evaluated for each solution.
Most practical optimization problems are constrained problems. Some approach needs to be given to the handling of constraints when using the unconstrained optimization algorithms for the constrained problems. To deal with the constraints, there are two approaches which can be used. One solution restricts the solution space to solutions which conform to the constraints, and the other allows solutions which violate the constraints and find an optimal solution to satisfy the constraints by using a suitably defined penalty function. In the former method, the solution is then checked against the constraints. If the constraints are satisfied, the solution is usable, otherwise, the solution is discarded and a new solution is generated and checked.
Therefore, some of the solutions generated are unusable and thus a portion of the computational time is not productive. In the latter approach, all neighborhood solutions are usable. The acceptance of a solution depends on the magnitude of the objective function value. The solutions which violate the constraints are expected to be rejected by its penalized objective function value. The larger the violation of the constraints in a solution, the higher is the probability of the solution being rejected. This penalty function approach is likely to lead to simpler neighborhood moves and a smoother topology. However, caution must be excised in selection of the penalty function. A poorly defined penalty function leads to a worse final solution or even makes the algorithms not converge.
Experience and some computational experiments are needed to find an appropriate penalty function for a specific problem.
In many cases, the former approach can be used. The routine can simply be programmed to reject any proposed changes which result in constraint violation, so that a search of feasible space only is executed. However, there are two important circumstances in which this approach cannot be followed: (l)if there are any equality constraints defined on the system, or (2) if the feasible space defined by the constraints is (suspected to be) disjoint, so that it is not possible to move between all feasible solutions without passing through infeasible space.
In either case above, the latter approach should be used. The problem should be transformed into an unconstrained one by constructing an augmented objective function incorporating any violated constraints as penalty functions. To overcome the disadvantage of the penalty approach, a two-phase approach may be employed to improve the penalty approach. In Phase 1, the original optimization problem is checked for feasibility, and if so, a feasible point is found. In Phase 2, the feasible point may be used as the initial point. Also, a very large constant may be chosen as the penalty constant in the new objective function.
The objective function is used for Phase 1 problem is represented by equation 47:
fpι(x) = ΣPj(x)(3) (47) where pj(x) quantifies the magnitudes of any constraint violations and pj(x) is as follows in equation 48:
Pj(x) = max(0, g,2(x)), j = 1, 2, ... , k; and
Pj(x) = (max(0, hj(x)))2, j = k + 1, k + 2, ... , m (48).
If the value of the objective function fpι(x) attains zero at an x , then the solution x is a feasible point for the original optimization problem. The algorithm continues to Phase 2 to find the optimal solution. If the final value of fl{x) is great than zero, then the original problem is infeasible.
The objective function in Phase 2 is provided in equation 49:
fp2(x) = f(x) + Σ(CJ * pJ(x)) (49) where the definition of p,(x) is same as above and C, is enough large penalty constants. By introducing the penalty function as described above, all moves should be kept from moving out of the feasible region. Thus, it can be seen that various different models may be used to address the various pricing optimization problems, depending on the user's needs. The configuration application 1440 allows the user to specify the model and to provide various input to direct the operation of the these models.
The configuration application 1440 may further be used by users to define the optimization conditions. Examples of this use are numerous, but examples may include the definition of a minimum inventory, thus constraining various optimization calculating (i.e., the pricing optimization application cannot propose a profit maximizing price that depletes inventory stocks). In a similar fashion, the configuration application 1440 allows the user to define market conditions. For instance, the user may define cyclical sales cycles or needs that the pricing optimization application would not readily discover through the analysis of past sales. In another application, the configuration application 1440 may be used to define the relationship of different items, such that changes in the pricing of one item may effect sales of the second item. Overall, the configuration application 1440 allows users to easily define market characteristics. If the user does not define these conditions, the pricing optimization application 1410 may produce faulty results or may optimize using techniques to solve unbounded/unconstrained pricing problem
In another embodiment, the configuration application 1440 may compare and display the price optimization results 1420 with and without the user's inputs. In this, the user may compare the results and use the results to determine the accuracy/desirability of the changes supplied to the configuration application 1440. The user may similarly compare the computing resources required to solve an optimization application with and without the user defined conditions.
Conclusion
The foregoing description of the preferred embodiments of the invention has been presented for the purposes of illustration and description. It is not intended to be exhaustive or to limit the invention to the precise form disclosed. Many modifications and variations are possible in light of the above teaching. For instance, the method of the present invention may be modified as needed to incorporate new communication networks and protocols as they are developed. It is intended that the scope of the invention be limited not by this detailed description, but rather by the claims appended hereto. The above specification, examples and data provide a complete description of the manufacture and use of the composition of the invention. Since many embodiments of the invention can be made without departing from the spirit and scope of the invention, the invention resides in the claims hereinafter appended.

Claims

What is claimed:
1. A configurable pricing optimization system comprising:
a price optimization application, tangibly embodying a program of instructions executable by a machine to receive stored data and to use this stored data to suggest an optimal pricing level according to business goal;
a configuration application, tangibly embodying a program of instructions executable by a machine to allow a user to modify the stored data, whereby the modification of the stored data modifies the suggested optimal pricing level.
2. The configurable pricing optimization system of claim 1, whereby the configuration application allows the user to define boundaries or constraints for a mathematical model used by the price optimization application.
3. The configurable pricing optimization system of claim 1 , whereby the configuration application allows the user to define market conditions to be considered by the price optimization application.
4. The configurable pricing optimization system of claim 3, whereby the configuration application allows the user to define the relationship between two products, whereby the relationship is used by the price optimization application to determine changes in sales of a first product caused by changes in a price for a second product.
5. The configurable pricing optimization system of claim 1, whereby the price optimization application performs method steps of creating a model of a market for the product, collecting historical transaction data related to the product in the market, and analyzing the historical data and the model to determine sales volume changes from changes in the price of the product, and whereby the configuration application allows the user to define the market model.
6. The configurable pricing optimization system of claim 1, whereby the configuration application visually displays possible values for a data variable to be modified.
7. The configurable pricing optimization system of claim 1, whereby the configuration application visually displays changes in the suggested optimal pricing level.
8. A configurable pricing optimization system comprising:
a price optimization means for receiving stored data and for using this stored data to suggest an optimal pricing level;
a configuration means for allowing a user to modify the stored data, whereby the modification of the stored data modifies the suggested optimal pricing level.
9. The configurable pricing optimization system of claim 8, whereby the configuration means allows the user to define boundaries or constraints for a mathematical model used by the price optimization means.
10. The configurable pricing optimization system of claim 8, whereby the configuration means allows the user to define market conditions to be considered by the price optimization means.
11. The configurable pricing optimization system of claim 10, whereby the configuration means allows the user to define the relationship between two products, whereby the relationship is used by the price optimization means to determine changes in sales of a first product caused by changes in a price for a second product.
12. The configurable pricing optimization system of claim 8, whereby the price optimization means performs method steps of creating a model of a market for the product, collecting historical transaction data related to the product in the market, and analyzing the historical data and the model to determine sales volume changes from changes in the price of the product, and whereby the configuration means allows the user to define the market model.
13. The configurable pricing optimization system of claim 8, whereby the configuration means visually displays possible values for a data variable to be modified.
14. The configurable pricing optimization system of claim 8, whereby the configuration means visually displays changes in the suggested optimal pricing level.
PCT/US2003/037601 2002-11-26 2003-11-26 Configurable pricing optimization system WO2004049125A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2003293018A AU2003293018A1 (en) 2002-11-26 2003-11-26 Configurable pricing optimization system

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US42891202P 2002-11-26 2002-11-26
US60/428,912 2002-11-26

Publications (2)

Publication Number Publication Date
WO2004049125A2 true WO2004049125A2 (en) 2004-06-10
WO2004049125A3 WO2004049125A3 (en) 2004-08-05

Family

ID=32393484

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2003/037601 WO2004049125A2 (en) 2002-11-26 2003-11-26 Configurable pricing optimization system

Country Status (2)

Country Link
AU (1) AU2003293018A1 (en)
WO (1) WO2004049125A2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10783287B2 (en) 2017-06-14 2020-09-22 International Business Machines Corporation Employing natural language processing to facilitate geospatial analysis

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5752238A (en) * 1994-11-03 1998-05-12 Intel Corporation Consumer-driven electronic information pricing mechanism
US5873069A (en) * 1995-10-13 1999-02-16 American Tv & Appliance Of Madison, Inc. System and method for automatic updating and display of retail prices
US5878400A (en) * 1996-06-17 1999-03-02 Trilogy Development Group, Inc. Method and apparatus for pricing products in multi-level product and organizational groups
US5970470A (en) * 1997-07-08 1999-10-19 Walker Asset Management Limited Partnership System and method for establishing and managing subscription purchase agreements including commitments to purchase goods over time at agreed upon prices
US6044357A (en) * 1998-05-05 2000-03-28 International Business Machines Corporation Modeling a multifunctional firm operating in a competitive market with multiple brands
US6061691A (en) * 1998-08-31 2000-05-09 Maxagrid International, Inc. Method and system for inventory management
US6085164A (en) * 1993-09-15 2000-07-04 Sabre Inc. Apparatus and method of allocating flight inventory resources based on the current market value
US6094641A (en) * 1997-05-21 2000-07-25 Khimetrics, Inc. Method for incorporating psychological effects into demand models
US6223163B1 (en) * 1997-03-21 2001-04-24 Walker Digital, Llc Method and apparatus for controlling offers that are provided at a point-of-sale terminal

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6085164A (en) * 1993-09-15 2000-07-04 Sabre Inc. Apparatus and method of allocating flight inventory resources based on the current market value
US5752238A (en) * 1994-11-03 1998-05-12 Intel Corporation Consumer-driven electronic information pricing mechanism
US5873069A (en) * 1995-10-13 1999-02-16 American Tv & Appliance Of Madison, Inc. System and method for automatic updating and display of retail prices
US5878400A (en) * 1996-06-17 1999-03-02 Trilogy Development Group, Inc. Method and apparatus for pricing products in multi-level product and organizational groups
US6223163B1 (en) * 1997-03-21 2001-04-24 Walker Digital, Llc Method and apparatus for controlling offers that are provided at a point-of-sale terminal
US6094641A (en) * 1997-05-21 2000-07-25 Khimetrics, Inc. Method for incorporating psychological effects into demand models
US5970470A (en) * 1997-07-08 1999-10-19 Walker Asset Management Limited Partnership System and method for establishing and managing subscription purchase agreements including commitments to purchase goods over time at agreed upon prices
US6044357A (en) * 1998-05-05 2000-03-28 International Business Machines Corporation Modeling a multifunctional firm operating in a competitive market with multiple brands
US6061691A (en) * 1998-08-31 2000-05-09 Maxagrid International, Inc. Method and system for inventory management

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
FRIEDMAN D.D.: 'Price theory: an intermediate text', 1990, SOUTH-WESTERN PUBLISHING CO. pages 1 - 592, XP002978374 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10783287B2 (en) 2017-06-14 2020-09-22 International Business Machines Corporation Employing natural language processing to facilitate geospatial analysis
US10824777B2 (en) 2017-06-14 2020-11-03 International Business Machines Corporation Employing natural language processing to facilitate geospatial analysis

Also Published As

Publication number Publication date
AU2003293018A1 (en) 2004-06-18
AU2003293018A8 (en) 2004-06-18
WO2004049125A3 (en) 2004-08-05

Similar Documents

Publication Publication Date Title
US7287000B2 (en) Configurable pricing optimization system
US7072848B2 (en) Promotion pricing system and method
JP5662446B2 (en) A learning system for using competitive evaluation models for real-time advertising bidding
US9773250B2 (en) Product role analysis
Schmittlein et al. Customer base analysis: An industrial purchase process application
Chan et al. A dynamic decision support system to predict the value of customer for new product development
US8010404B1 (en) Systems and methods for price and promotion response analysis
US20210334844A1 (en) Method and system for generation of at least one output analytic for a promotion
US7403904B2 (en) System and method for sequential decision making for customer relationship management
US7016936B2 (en) Real time electronic service interaction management system and method
US8639558B2 (en) Providing markdown item pricing and promotion calendar
US8082175B2 (en) System and method for optimization of a promotion plan
US20030149603A1 (en) System and method for operating a non-linear model with missing data for use in electronic commerce
US20030140023A1 (en) System and method for pre-processing input data to a non-linear model for use in electronic commerce
Matsuoka A framework for variance analysis of customer equity based on a Markov chain model
US20210312488A1 (en) Price-Demand Elasticity as Feature in Machine Learning Model for Demand Forecasting
US20230419184A1 (en) Causal Inference Machine Learning with Statistical Background Subtraction
US8805715B1 (en) Method for improving the performance of messages including internet splash pages
Kopalle Modeling retail phenomena
JP2004054439A (en) Method, device and program for supporting formulation of marketing strategy based on analysis of customer behavior
Banerjee Optimal retail pricing model under multi-period consumer purchase planning horizon
US20070043606A1 (en) Identifying and validating survey objectives
WO2004049125A2 (en) Configurable pricing optimization system
Sridhar et al. Customer profitability analysis and customer lifetime value
Moldenhauer et al. Basket analysis in practice: mathematical models and applications in offline retail

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): BW GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase in:

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP