Title:

Kind
Code:

A1

Abstract:

The present invention provides systems and related methods for forming a market response model (“MRM”) for modeling the probability of winning a price quote to a prospect or customer. Such a MRM may thereafter be used to estimate the probability of winning a bid to sell a product or service to a particular customer at a particular price against specific competition. In preferred embodiments, the process of developing a particular MRM for use in optimizing a bid entails the steps of acquiring historical data; creating an analysis data set from the historical data; exploring the data sets and identifying segments; defining an MRM structure using the segments; and validating the MRM. Embodiments of the present invention provide systems and related methods for forming a MRM for modeling the probability of winning a price quote to a prospect or customer. Such systems and methods may be used to estimate the probability of selling a product or service to a particular customer at a particular price against specific competition.

Inventors:

Haas, Stephen M. (US)

Isaaks, Edward (Redwood City, CA, US)

Boyd, Dean (Cottage Grove, OR, US)

Mcshane-vaughn, Mary (Fayetteville, GA, US)

Phillips, Robert (Palo Alto, CA, US)

Michael Jr., Eldredge J. (Menlo Park, CA, US)

Kadner, Debra (US)

Denizeri, Yosun (San Francisco, CA, US)

Guardino, Thomas E. (Eugene, OR, US)

Isaaks, Edward (Redwood City, CA, US)

Boyd, Dean (Cottage Grove, OR, US)

Mcshane-vaughn, Mary (Fayetteville, GA, US)

Phillips, Robert (Palo Alto, CA, US)

Michael Jr., Eldredge J. (Menlo Park, CA, US)

Kadner, Debra (US)

Denizeri, Yosun (San Francisco, CA, US)

Guardino, Thomas E. (Eugene, OR, US)

Application Number:

10/356717

Publication Date:

11/27/2003

Filing Date:

02/03/2003

Export Citation:

Assignee:

Manugistics Atlanta, Inc. (Rockville, MD)

Primary Class:

Other Classes:

705/7.36

International Classes:

View Patent Images:

Related US Applications:

Primary Examiner:

MANSFIELD, THOMAS L

Attorney, Agent or Firm:

Sheridan Ross PC (Denver, CO, US)

Claims:

1. A method for statistically modeling a market, the method comprising the steps of: acquiring historical data related to said market; creating an analysis data set from said historical data; segmenting said analysis data set, said segmenting identifying predictable segments of the market; and defining a market response model using said segmented analysis data set, wherein said market response model provides a probability of winning a bid at a particular price and wherein a non-linear regression is used to define said market response model according to a binomial logistic.

2. The method of claim 1 further comprising the step of validating the defined market response model.

3. The method of claim 1 further comprising the step of using the market response model to determine an optimal price for a bid.

4. The method of claim 1 wherein said non-linear regression uses at least one price-related predictor and non-price predictors.

5. The method of claim 1 wherein said market data comprises historic data representative of marketplace conditions.

6. The method of claim 5 wherein said historical data includes data on a competitor.

7. The method of claim 1 wherein said creating of said analysis data set from said historical data includes data comprises one of deleting outlier records, estimating missing data, or defining new combination variables.

8. The method of claim 5 wherein the historical data is a set of quote records selected from a group consisting of: account characteristics; quote characteristics; prior price offered; competitors; competitor offered prices; and prior quote winner.

9. The method of claim 1 wherein said the step of creating an analysis data set further comprises applying business logic and experience to examine the market data.

10. The method of claim 1 wherein said creating of said analysis data set from said historical data includes data comprises applying business logic and experience to examine the market data and create variable aggregations, transformation, and summary statistics.

11. The method pf claim 1, wherein the step of segmenting said analysis data set further comprises employing statistical clustering and categorization techniques.

12. The method of claim 13 wherein the step of segmenting said analysis data set further comprises using classification and regression trees (CART).

13. The method of claim 13 wherein the step of segmenting said analysis data set further comprises using Chi-squared automatic integration detector (CHAID).

14. The method of claim 1, wherein the step of segmenting said analysis data set further comprises specifying and using strategic and institutional constraints on cross-section price differentials.

15. The method of claim 1, wherein said non-linear regression employs a binomial logistic to define estimated win probability according to the definition:

16. A modeling and optimization system for determining the probability of winning a prospective bid to perform services or sell products, the system comprising a response modeling module adapted to allow a user to: receive input of historical data related to a relevant market; manipulate said historical data to create an analysis data set from said historical data; segment said analysis data set so as to identify predictable segments of the market; and define a market response model using said segmented analysis data set, wherein said response modeling module calculates a model for estimating a probability of winning a bid at a particular price and wherein a non-linear regression is used to define said market response model according to a binomial logistic.

17. The system of claim 16, wherein said response modeling module is further adapted to allow the user to validate the defined market response model according to business rules.

18. The system of claim 16, wherein said response modeling module allows the user to create said analysis data set from said historical data by one of deleting outlier records, estimating missing data, creating variable aggregations, creating variable transformations, or creating variable summary statistics.

19. The system of claim 16, wherein said response modeling module allows the user to segmenting said analysis data set by employing statistical clustering and categorization techniques selected from the group consisting of cluster analyses, classification and regression trees (CART), and Chi-squared automatic integration detector (CHAID).

20. The system of claim 16, wherein said non-linear regression employs a binomial logistic to define estimated win probability according to the definition:

Description:

[0001] This application claims the benefit of priority from U.S. Provisional Patent Applications Serial No. 60/352,878, filed Feb. 1, 2002, and Serial No. 60/358,732, filed Feb. 25, 2002, the disclosures of which are hereby incorporated by reference in their entirety.

[0002] The present invention relates to the creation of models for use in predicting the expected profitability of contract offers, bids, quotes, and sales pricing. More particularly, the present invention relates to systems and related methods for preparing models that take market and competitor historical data as inputs in predicting market response to custom price offers.

[0003] A bid is a contract proposal to a current or potential account customer for delivery of products (or services) over a specified time period at a specified price. Bids contain at least one, and may contain more than one, product or service order. For example, a bid can contain the following information: bid number, account, the description, the status, the account executive, notable dates, and one or more product orders.

[0004] In certain industries, companies bid on work to be performed on behalf of other customer companies or entities, such work typically being either the production of a product or the provision of a service on a regular basis. Such companies often competitively bid against one another for a contract, and, in making a bid for a contract or to provide a certain set of products or services, the goal is to make an optimal bid where the company balances the likelihood of winning the contract at the bid price with the profit that will be obtained if the contract is won at that bid price. In this manner, a “target price” is arrived at for a given contract.

[0005] In order to make a satisfactory bid to obtain a contract or other agreement for the provision of a product or service, a company must evaluate the aspects for the specific bid parameters that, if properly reflected in the bid price, enable the company to properly balance the likelihood of winning the bid with the profit achieved if the bid is won (otherwise known as “expected profit”). Traditionally, bid pricing has been assisted by computer systems that estimate the cost of serving individual customers, taking into account the special factors affecting the bid price. These typical cost of service-based bidding systems often compute a price floor or minimum bid for a prospective contract or agreement based on the cost of delivering the products or services while the actual calculation of profit for the contract is subjectively later added on by the company. Consequently, while the traditional cost of service-based bidding systems can provide guidance on the minimum bid, they provide no guidance for the optimal way to balance the likelihood of winning the bid with the profit achieved if the bid is won. This guidance can only be provided if a target price is established that balances the likelihood of winning the bid with the profit achieved if the bid is won by maximizing the expected profit that is achieved by the target price.

[0006] Traditional cost of service-based bidding systems have a number of drawbacks as they typically lack the ability to factor the market response of customers and competitors into pricing decisions. This is mainly due to the fact that such pricing tools and system are cost-focused even though clients may increasingly demand products and services that are tailored to their specific needs. The traditional cost of service-based bidding systems also lack the ability to track and analyze post-bid information, such as interim bid wins and bid losses, the profitability of won bids, and otherwise capture useful data which can be analyzed for the generation of future bids.

[0007] Thus, there remains a need in the art for a method of establishing market response models useful when carrying out optimization analyses for target and bid pricing where such models take market and competitor response characteristics into account. There is a further need in the art for bid pricing method that takes market and competitor response characteristics into account via a market response model when generating bids for portfolios of products and services to be provided or performed over extended contract periods.

[0008] In light of the deficiencies described above and other deficiencies present in the art, it is an object of the present invention to provide modeling and optimization systems and related methods that enable companies to provide rapid custom quotes for each customer, deal, and/or account.

[0009] Further, it is an object of the present invention to provide modeling and optimization systems and related methods that tailor quotes to each specific competitive situation by taking into account expected market responses to pricing and bid changes.

[0010] Similarly, it is an object of the present invention to provide modeling and optimization systems and related methods that are able to accurately predict win probability and profit outcome from historical sales, bid, and/or fulfillment data.

[0011] Additionally, it is an object of the present invention to provide modeling and optimization systems and related methods that balance the likelihood of winning the business against contribution to margin to help manage the complexity of bid pricing.

[0012] Finally, it is an object of the present invention to provide modeling and optimization systems and related methods that can be fine-tuned on an ongoing basis as market response to recent developments in the relevant marketplace.

[0013] To achieve these and other objects, the present invention provides a market response model (“MRM”) determined from historical marketplace data, where the MRM may be used to predict how a given segment of a market will respond to pricing fluctuations. Such an MRM may then be used as an input to the optimization of any prospective quote or contract bid where the optimization determines the optimal “target” price that maximizes the expected profitability from offering the quote (i.e., the target price is the price that optimally balances the probability of winning the quote with the profit achieved if it is won as opposed to the price with the highest “estimated win probability,” which would mean driving the price down to the point where winning would be unprofitable).

[0014] Price quotation optimization solutions according to the present invention, preferably embodied by electronic computational systems and related methods, employ MRMs to help gauge a customer's willingness to pay a quoted price for a particular product or service bid. The MRMs are established from market segmentation and statistical regression analyses of historical bid and marketplace data. This data is acquired and segmented along various relevant market dimensions, including customer type, size, product category, current supplier, region, and other statistically significant dimensions. Using this segmentation, the market response to a custom quote, reflected by the probability of winning a bid, can be forecasted for any new bid. In this manner, a company is able to decide how to price any custom offer to any potential customer against any competition.

[0015] According to preferred embodiments of the present invention, the modeling and optimization systems and related methods implement a process for developing a particular MRM generally by acquiring historical data, creating an analysis data set from the historical data, exploring the data sets and identifying segments therein; defining an MRM structure using the segments; and validating the MRM for use in optimizing future bids. This MRM can thereafter be employed to predict how customers will respond to a custom price offer, and therefore be used as an input in selecting optimum bidding strategies.

[0016] The probabilistic results of a MRM are produced using a statistical analysis of historical data. The historical data often comes from multiple sources, and should be representative of current marketplace conditions and should include data from a mix of products and competitors. Ideally, the historical data should include a complete set of quote records (wins, losses, and partial wins) including the following information: account characteristics; quote characteristics; prior price offered; competitors; competitor offered prices; and prior quote winner.

[0017] The historical data is converted into one or more analysis data sets by applying business logic and experience to the data. This may include estimating missing (but necessary) data, deleting known outlier records in the historical data, and creating variable aggregations, transformations and summary statistics with the goal of providing the necessary information to produce an accurate MRM from the historical data set.

[0018] In segmenting the market, statistical clustering and categorization techniques are employed to determine stable and predictable market segments within the analysis data sets. If there are strategic or institutional constraints on cross-segment price differentials, these constraints can be specified and utilized for market segmentation as well, and separate MRMs can be established for each segment.

[0019] In preferred embodiments of the invention, statistical classification algorithms and analyses, such as cluster analyses, classification and regression trees (“CART”) and chi-square automatic integration detector (“CHAID”), are used to identify segments within historical data and enable stable and predictable demand patterns to be extracted from voluminous sales data in an effective manner.

[0020] Analytic regression techniques are thereafter employed to estimate the likely response to any new bid by any current or potential customer. Based on such predicted customer responses to changes in price, the system and related methods of the present invention determine optimal prices for any particular sale or bid.

[0021] In one preferred embodiment, the present invention employs a binomial logistic to determine an estimated probability of winning a bid or auction according to various predictors. Predictors can be market segmentation criteria, bid drivers, or a product of several of these. For every predictor specified by the user, the associated coefficient values that define the market response curve are estimated using data analysis and regression and stored. These coefficients are used in combination with account and bid characteristics to calculate win probabilities.

[0022] Pricing optimization systems employing MRM methods according to the present invention track customer responses to price changes or bids as they are made to continuously update the current model.

[0023] In the above manner, MRMs performs three main functions: updating the coefficients for market response predictors on the basis of historical data (which can be accepted, rejected, or altered by the user); for a particular bid, evaluating the price-independent predictors to generate a market response curve that depends only on price; and for a particular bid and offered price, calculating the estimated probability of winning (“the market response”).

[0024] In embodiments of the invention, the modeling and optimization systems can include tools that enable the win probability, or estimated probability of winning a bid at a given price, to be represented by a MRM module as a market response curve. The market response curve, which can also be called a win probability curve, is a continuous function that relates win probabilities to net prices while holding all other variables constant.

[0025] Additional features and advantages of the invention are set forth in the description that follows, and in part are apparent from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention are realized and attained by the structure and steps particularly pointed out in the written description and claims hereof as well as the appended drawings.

[0026] It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory and are intended to provide further explanation of the invention as claimed.

[0027] The accompanying drawings, which are included to provide further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention. In the drawings with like reference numbers representing corresponding parts throughout:

[0028]

[0029]

[0030]

[0031]

[0032]

[0033]

[0034]

[0035]

[0036] Reference is now made in detail to the preferred embodiment of the present invention, examples of which are illustrated in the accompanying drawings.

[0037] The present invention provides a system, method, and software for forming a market response model (MRM) for modeling the probability of winning a price quote to a prospect or customer. In other words, a MRM may be used to estimate the probability of selling a product or service to a particular customer at a particular price against specific competition. The present invention further relates to a modeling and optimization system for performing these steps. In one embodiment, the system may include tools, templates, guidelines, and software for performing each step. Implementations of the system may include various communication and reporting mechanisms to interact with users, other systems, and data storage devices.

[0038] Preferred embodiments of the present invention include modeling and optimization systems which contain a response modeling module that is adapted to perform operations for calculating a target bid price to optimize revenues. The response modeling module provides tools and associated used interfaces to facilitate the generation of a MRM from the examination of historical bid information records, where the MRM may thereafter be utilized to calculate bid win probabilities as a function of price-related variables.

[0039] A given MRM produced by the response modeling module according preferred embodiments of the present invention define the response of the market to changes in price-related and non-price predictors or variables such that the modeling and optimization system can thereafter calculate the optimum target price for making a bid which will both be profitable to the company making the bid, and which will take into account the likely bids of other competing bidders to maximize the chance of bid success. Predictors are measurements or indicator variables used to estimate (or “predict”) the win probability for a bid. Predictors can be, for example, market segmentation criteria, bid variables, or a product of several of these. The response modeling module is adapted to build an MRM by fitting associated coefficients with identified predictors so as to define one or more win probability curves. The win probability curve, also called a market response curve, is a function of these predictors (each predictor measuring key attributes of the accounts of the bids) and their coefficients (which measure the relative weights of the predictors in estimating win probabilities). Each predictor's coefficient is calculated using suitable logistic regression routines on historical bid data. For every predictor identified by the response modeling module or specified by the user as being relevant to market response, the coefficient values that define the market response curve are estimated by the response modeling module and stored. These coefficients are used in combination with account and bid characteristics to calculate win probabilities.

[0040] In certain embodiments of the invention, the response modeling module may include routines for displaying a market response curve for each segment. The market response curve is defined by a functional form and coefficients and embodies price sensitivity (elasticity) and brand preference. Overall, a MRM provides considerable advantages in determining target pricing to achieve various business goals such as profit or sales maximization.

[0041]

[0042] As depicted in

[0043] As described above, the probabilistic results of a MRM are produced using a statistical analysis of historical data. In acquiring the historical data at step

[0044] After the acquiring of a complete historical data set, this data set is converted into one or more analysis data sets at step

[0045] After analysis data set is ready, the MRM process

[0046] A MRM typically segments the historical data in to various categories or buckets for analysis including, but not limited to, account tenure/relationship, Industry segment, Customer size, Region, Quote Type, Quote Size; and Competitor identity. The response modeling module may then use various relationships from these segments when predicting the probability of winning a price quote to a prospect or customer.

[0047] In preferred embodiments of the invention, statistical classification algorithms and analyses, such as cluster analyses, classification and regression trees (“CART”) and chi-square automatic integration detector (“CHAID”), are used to identify segments within historical data and enable stable and predictable demand patterns to be extracted from voluminous sales data in an effective manner. The classic CART algorithm was popularized by Breiman, Friedman, Olshen, and Stone in the early 1980s, and CART is a known algorithm that builds classification and regression trees for predicting continuous dependent variables (regression) and categorical predictor variables (classification). In one embodiment, the MRM module may incorporate commercially available data analysis software such as “CART” produced by Salford Systems of San Diego to assist in automating segmentation operations.

[0048] Taking into account the customer segmenting, analytic regression techniques are thereafter employed at step

[0049] In one preferred embodiment, the present invention employs a binomial logistic to determine an estimated probability of winning a bid or auction according to various predictors. For every predictor specified by the user, the associated coefficient values of the binomial that define the market response curve are estimated using data analysis and regression and stored. These coefficients can then be used in combination with account and bid characteristics to calculate win probabilities. In this preferred embodiment, the MRM module may estimate the probability of winning a bid or auction (Est_Win_Prob), as contained in Equation 1 below.

[0050] Where, in Equation 1 above:

[0051] I_{i }

[0052] I_{i}

[0053] I_{i}

[0054] Price represents price-related predictor variables(s) such as absolute price, discount, ratio of absolute price to business as usual price or competitor price, etc.;

[0055] Other_{j }

[0056] f_{1}_{2}_{3}_{4 }

[0057] β_{0}_{i}_{0}_{i}_{j,0 }_{j,i }

[0058] The β_{0 }_{i }_{0 }_{i }_{j,0 }_{j,i }

[0059] In defining a MRM structure, various statistical metrics may be employed to identify a correct model for the MRM. For instance, a significance of fit test can be used to measure whether at least one of the model coefficients is likely different from 0. Similarly, the AKAIKE information criterion could provide a numerical comparison between two market response models. The WALD test could be used to add or reject individual predictor variables to or from the MRM or the likelihood ratio test.

[0060] In the regressions performed at step

[0061] The response modeling module uses the MRM defined at step

[0062] Once an MRM is established using appropriate regression techniques, the MRM is validated. Validating the MRM is generally an iterative procedure (as reflected by the dashed flow arrows in

[0063] Once an MRM has been found to be acceptable, the MRM module can output representations of the regression, including graphical representation such as a histogram of the ratio of target price to historical price. In this manner, the success in optimizing revenue in the contracts and transactions represented in the historical data can be analyzed.

[0064] Statistical metrics may likewise be used to assess the accuracy of a MRM during validation step

[0065] Various business metrics may also be employed to assess the applicability of the MRM to current conditions. For example, a sensitivity check examines whether poor price sensitivities are due to unusually large intercepts in the MRM. Other business metrics include comparing any unconstrained target price historical and list prices for reasonableness, comparing any discounts at unconstrained target prices to the discount at historical prices for reasonableness, comparing predicted profit at target prices to the profit at historical prices for reasonableness, and comparing the proportion of bids won at target prices to the proportion won at historical prices.

[0066] In one embodiment, the some of the historical data may be summarized in the form of price curves to indicate of the predictability of price response, and of how challenging it will be to develop the MRM. In another embodiment, the results of an MRM are communicated to a user through one or more standard graphs such as price recommendation histograms that form snapshots of the price changes that result overall or by segment from the MRM.

[0067] As described above, a MRM and the results predicted therefrom are validated. For example, this validation may be communicated to users in the form of “Report Cards” containing a qualitative summary of data, model, or pricing results. Project teams, whereby each team can set its own grading curve, may establish the Report Card scores. Also, other process outputs may be directly inputted and displayed on report cards.

[0068] The operation of a response modeling module according to one preferred embodiment of the invention will now be described by an example of the creation of an MRM using a hypothetical historical data set. This example spans

[0069] In applying segments to the analysis data set, the MRM module may employ any known and classification algorithm that can be automated readily, including CART and CHAID and preferably CART. As shown in

[0070] As shown in

[0071] Once the segmentation algorithm has been employed to produce segments, the price sensitivity in each segment can be explored to perform a manual check on the segmenting. In embodiments in the invention, this can be performed by producing various graphs of the data falling within each segment, including average graphs of fulfillment rate versus price for each pricing segment.

[0072] As will be readily appreciated by one of ordinary skill in the art, the historical data set does not demonstrate all of the particular variables that a business person would like to see. For example, the data set does not currently show the profit which was achieved in each entry. Generally, profit can be calculated as the difference between price and cost times the actual volumes sold. According to embodiments of the present invention, new “dependent” variables can be defined and created at any time, such as during the creation of the analysis data set or after the segmentation of data, to help in exploring pricing segments. As shown in

[0073] One of the advantages of using a CART algorithm to segment the quote data is that the task of variable selection becomes simplified. First, the CART algorithm provides a rank order list of the importance of the variables. Understandably, this list is useful in determining which variables will be relevant for logistic regression in the MRM. Second, the tree generated by the CART algorithm often exhausts the explanatory powers of the predictor variables utilized to build the tree. Thus, predictor variables used to build the CART tree generally do not need to be regressed in a subsequent logistic equation to produce a MRM.

[0074] With respect to the logistic equation, it should be obvious that one will ordinarily want to include price as a predictor variable as this is typically the main variable which is most often varied when making bids or listing products for sale. Additionally, from the example of

[0075] Although the present invention is preferably implemented in an electronic environment and may involve operations performed by software, this is not a limitation of the present invention as those of ordinary skill in the art can appreciate that the present invention can be implemented in hardware or in various combinations of hardware and software, without departing from the scope of the invention. Modifications and substitutions by those of ordinary skill in the art are considered to be within the scope of the present invention, which is not to be limited except by the claims that follow.

[0076] The foregoing description of the preferred embodiments of the present 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. It will be apparent to those of ordinary skill in the art that various modifications and variations can be made to the disclosed embodiments and concepts of the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention covers the modifications and variations of this invention provided that they come within the scope of any claims and their equivalents.