At least two goals of creating pricing models are to analyze price behavior and to apply that analysis to real time transactions in order to preserve what are increasingly becoming narrower profit margins in complex transactions. Systems like, for example, SAP™, attempt to manage and control business processes using objective data in order to gain enterprise efficiencies. By manipulating objective data, these systems offer consistent metrics upon which businesses may make informed decisions and policies regarding the viability and direction of their products and services. However, in many cases, the decisions and policies may be difficult to procure as a result of the volume and organization of relevant data and may be difficult to implement as both temporal restraints and approval processes may inhibit rapid deployment of valuable information.
For example, referring to
The wealth of information contained in the various databases (104-120) however, is not “readable” by executive management teams due in part to accessibility and in part to volume. That is, even though data in the various repositories may be related through a Relational Database Management System (RDMS), the task of gathering data from disparate sources can be complex or impossible depending on the organization and integration of legacy systems upon which these systems may be created. In one instance, all of the various sources may be linked to a Data Warehouse 132 by various connections 144. Typically, data from the various sources may be aggregated to reduce it to a manageable or human comprehensible size. Thus, price lists may contain average prices over some selected temporal interval. In this manner, data may be reduced. However, with data reduction, individual transactions may be lost. Thus, CRM 124 and ERP 128 connections to an aggregated data source may not be viable.
Analysts 136, on the other hand, may benefit from aggregated data from a data warehouse. Thus, an analyst 136 may compare average pricing across several regions within a desired temporal interval to develop, for example, future trends in pricing across many product lines. An analyst 136 may then generate a report for an executive committee 140 containing the findings. An executive committee 140 may then, in turn, develop policies that drive pricing guidance and product configuration suggestions based on the analysis returned from an analyst 136. Those policies may then be returned to CRM 124 and ERP 128 entities to guide pricing activities via some communication channel 152 as determined by a particular enterprise.
As can be appreciated, a number of complexities may adversely affect this type of management process. First, temporal setbacks exist at every step of the process. For example, a CRM 124 may make a sale. That sale may be entered into a sales database 120, and INV database 116, and an AR database 108. The entry of that data may be automatic where sales occur at a network computer terminal, or may be entered in a weekly batch process thus introducing a temporal setback. Another example of a temporal setback is time-lag introduced by batch processing data stored to a data warehouse resulting in weeks-old data that may not be timely for real-time decision support. Still other temporal setbacks may occur at any or all of the transactions illustrated in
As such, methods of displaying and using predictive structured data, integrating that data into coherent and relevant business policies such as pricing guidance and product configuration suggestions, and deploying those policies in a timely and efficient manner may be desirable to achieve price modeling efficiency and accuracy.
In view of the foregoing, Systems and Methods for Margin-Sensitive Price Adjustments in an Integrated Price Management System are disclosed.
The present invention presents systems and methods generating margin sensitive pricing quotation in an integrated price adjustment system including: a) selecting products in selected product sets; b) providing pricing data corresponding to the products in selected product sets; c) providing guidance elements for products in selected product sets wherein guidance elements are margin sensitive; d) calculating guidance prices for products based upon guidance elements; e) selecting one of either pricing data or guidance prices; and f) generating a quotation based upon selections made such that margin sensitive pricing adjustments are incorporated into quotations. In some example embodiments, the present invention further includes providing predetermined suggestions for modifying the quotation.
In other embodiments, a computer program product for use in conjunction with a computer system for generating margin sensitive pricing quotation in an integrated price adjustment system, the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program product including: a) instructions for selecting products in selected product sets; b) instructions for providing pricing data corresponding to the products in selected product sets; c) instructions for providing guidance elements for products in selected product sets wherein guidance elements are margin sensitive; d) instructions for calculating guidance prices for products based upon guidance elements; e) instructions for selecting one of either pricing data or guidance prices; and f) instructions for generating a quotation based upon selections made such that margin sensitive pricing adjustments are incorporated into quotations. In some example embodiments, the present invention further includes providing predetermined suggestions for modifying the quotation are presented.
Embodiments of the invention may best be understood by reference to the following description taken in conjunction with the accompanying drawings in which:
As pertains to the present invention,
An analysis of a historical data may then be used to generate a transaction and policy database 208. For example, analysis of a selected group of transactions residing in a historical database may generate a policy that requires or suggests a rebate for any sale in a given region. In this example, some kind of logical conclusion or best guess forecast may determine that a rebate in a given region tends to stimulate more and better sales. A generated policy may thus be guided by historical sales transactions over a desired metric—in this case, sales by region. A policy may then be used to generate logic that will then generate a transaction item.
In this manner, a price list of one or many items reflecting a calculated rebate may be automatically conformed to a given policy and stored for use by a sales force, for example. In this example, a rebate may be considered as providing guidance to a sales force. Other guidance factors may be implemented and will be discussed in further detail below for
In some embodiments, policies are derived strictly from historical data. In other embodiments, policies may be generated ad hoc in order to test effects on pricing based hypothetical scenarios. In still other examples, executive committee(s) 220, who implements policies, may manually enter any number of policies relevant to a going concern. For example, an executive committee(s) 220 may incorporate forecast data from external sources 224 or from historical data stored in a historical database in one embodiment. Forecast data may comprise, in some examples, forward looking price estimations for a product or product set, which may be stored in a transaction and policy database. Forecast data may be used to generate sales policies such as guidance and suggestion as noted above. Still further, forecast data may be utilized by management teams to analyze a given deal to determine whether a margin corresponding to a deal may be preserved over a given period of time. In this manner, an objective measure for deal approval may be implemented. Thus forecast data, in some examples, may be used either to generate sales policy, to guide deal analysis, or both. Thus, in this manner, policies may be both generated and incorporated into the system.
After transactions are generated based on policies, a transactional portion of the database may be used to generate sales quotes by a sales force 216 in SAP 212, for example. SAP 212 may then generate a sales invoice which may then, in turn, be used to further populate a historical database 204. In some embodiments, sales invoices may be constrained to sales quotes generated by a transaction and policy database. That is, as an example, a sales quote formulated by a sales force 216 may require one or several levels of approval based on variance (or some other criteria) from policies (e.g. guidance and suggestion) stored in a transaction and policy database 208. In other embodiments, sales invoices are not constrained to sales quotes generated by a transaction and policy database.
Client-Side Operations
If a vendor proposal is accepted at a step 306, the method evaluates whether approval is necessary at a step 310. That is, for at least some vendor proposals, an approval process may be necessary depending on the terms of a deal both at a product level and at a product set level for a given time period. If it is determined that approval is not necessary, then the method generates a quote at a step 326 based upon a vendor proposal accepted at a step 306 whereupon the method ends. If approval is determined to be necessary at a step 310, the method determines whether a vendor proposal is approved at a step 314. Approval may be made at any of a number of administrative levels depending on the organizational structure of the business. Approval will be discussed in further detail for
If a vendor proposal is approved, the method generates a quote at a step 326 based upon an approved vendor proposal generated at a step 306, whereupon the method ends. If a vendor proposal is not approved, an approved proposal may be generated at a step 318. As with a vendor proposal, an approved proposal may be accepted by a buyer at a step 322. If an approved proposal is accepted at a step 322, the method generates a quote at a step 326 based upon the approved proposal accepted at a step 322 whereupon the method ends. If an approved proposal is not accepted at a step 322, the method may continue to generate a vendor proposal at a step 302 whereupon the method continues until a quote is generated or negotiations are terminated.
Step 302—Generate Vendor Proposal
Turning to
A guidance price may then be calculated and displayed in section 512. In order to flexibly meet user needs, an actual selling price may be overridden as displayed in section 516. A user may have options of using the calculated guidance price 524; an override price 528; an override discount 532; or an override margin 540. An override selling price may be displayed when an override is selected. In this example, an override discount 532 has been selected and an override selling price has been calculated and displayed in accordance with that selection.
Each of the override fields (528-536) may also contain, for example, an approval field 540. An approval field indicates whether an override parameter may be flagged for approval (see Step 310,
As can be appreciated by one skilled in the art any number of configuration suggestions may be displayed in a resized window depending on user selections. In the described embodiment, an upsell suggestion is illustrated. In other examples, a bundled suggestion may be displayed. In bundled suggestions, additional products may be available as a part of a bundled product for a given configuration. In this manner, sales staff may be easily and efficiently informed with respect to various options offered by a retailer. Other types of configuration suggestions that may be utilized under the present invention may include without limitation downsell related suggestions, collateral or in kind related suggestions, client related suggestions, demographic related suggestions, or regional related suggestions.
Returning to
Step 318—Generate Approved Proposal
Thus, in a step 804, a flagged proposal may be received. All flagged parameters may then be inspected at a step 808. That is, an entire proposal history may be examined to determine the nature and type of proposal parameters have been entered. In inspecting flagged proposal items at a step 808, a user may compare and subsequently adjust pricing using guidance, suggestion, and forecasting at a step 812. Guidance and suggestion have been discussed at length above for
As can be appreciated, by displaying forecast data in graphic fashion, margins may be examined over longer periods of time. By examining forecast data in this manner, concessions in pricing may be made at the time of proposal generation that may not appear to preserve sales margins, but will, in fact, result in a quality deal over time. In the past, this kind of information was not readily available in a price adjustment system as noted above. Further, although the embodiment described displays forecast data only to supervisory staff, forecast data may be further displayed to general sales users under the present invention as contemplated.
Returning to
Back-Side Operations: Pricing Guidance and Configuration Suggestion
The utility of any pricing system is at least partially dependent on the rationale of the underlying logic. As can be appreciated, a logical schema must be flexibly implemented in order to achieve broad efficiencies. Pricing guidance and configuration suggestion examples for users has been described above. Underlying logic for pricing guidance and configuration suggestion is now described.
Richness guidance 1012 represents another top level guidance element. Richness guidance 1012 describes guidance impact to an account in terms of configuration richness. That is, a configuration that is rich generally may have more features or may feature more current technology. For example, a rich computer system may contain a current chip set along with extended memory, a large display, large disk capacity, and high video capability while a thin computer system may contain an older, more limited chip set, more limited memory, a small display, small disk capacity, and low video capability. In one embodiment, richness may be subdivided into rich 1014, mainstream 1016, and thin 1018. As noted above, an adjustment may be made for each of the relationships depending on business objectives of a company. Further, as noted above, adjustments may be made upward or downward without limitation depending on the business objectives.
Deal size guidance 1020 represents another example top level guidance element. Deal size guidance 1020 describes guidance impact to an account in terms of the size of a particular deal. Deal size may generally be related to a dollar value and may be adjusted by magnitude without limitation depending on a particular buyer. In one embodiment, deal size may be subdivided into small 1022, medium 1024, and large 1026. In one example each subdivision represents a range of values. In other examples each subdivision is marked by a threshold amount. As noted above, an adjustment may be made for each of the relationships depending on business objectives of a company. Further, as noted above, adjustments may be made upward or downward without limitation depending on the business objectives.
Guidance element weight 1028 specifies the relative importance of previously described elements RAD guidance 1002, richness guidance 1012, and deal size guidance 1020 when calculating an overall guidance pricing structure. In one embodiment, LOB RAD 1030 corresponds to RAD guidance 1002; richness 1032 corresponds to richness guidance 1012; and deal size 1034 corresponds to deal size guidance 1020. Other guidance elements and corresponding weighting elements are contemplated under the present invention. In one example, weighting is accomplished by entering a percentage of weight for each weight element. Thus, for example, LOB RAD 1030 may be weighted at 30%; richness 1032 at 45%; and deal size 1034 at 25%. In this example, richness will influence overall guidance with LOB RAD and deal size following. As noted above, an adjustment may be made for each of the relationships without limitation depending on business objectives of a company.
Product richness 1036 specifies price threshold above and below which a product should be considered ‘rich’ or ‘thin’ as discussed for richness guidance element 1012. In one embodiment a thin threshold value comprises a threshold value below which a product may be considered thin. Typically, the value is a dollar amount corresponding to a product or product set. In like manner, in another example, a rich threshold value comprises a threshold value above which a product may be considered rich. Typically, the value is a dollar amount corresponding to a product or product set. Where the ranges corresponding to a thin threshold value and a rich threshold value are non-overlapping, the difference between values comprises a range of values corresponding to a mainstream richness designation. Where the ranges corresponding to a thin threshold value and a rich threshold value overlap, an error message may be generated. In this manner product richness may be quantified.
In the embodiment illustrated in
An upsell SKU 1110 is a selected product SKU associated with a driver SKU 1106. An upsell SKU 1110 may be selected from a lookup table corresponding to associated driver SKUs. In this manner configuration compatibility may be assured since only a list of available and compatible products may be available. As with a driver SKU 1106, an upsell SKU 1110 has a corresponding description 1112. A description 1112 describes, in plain language for example, a product, product set, product group or service corresponding to a selected upsell SKU. In some embodiments a suggested discount 1113 may be entered. A discount for a given upsell product or service may help to further promote selected products or services. A date range represented by start and end dates 1114 may be selected in order to confine a configured suggestion to a desired time frame. Further, a suggestion may be configured to be forced or optional via a force selection box 1116. In an example of a forced suggestion, the effect to a user would be that replacing a driver product with an upsell product would be automatically displayed; however, a user selection would not be mandatory. When force selection box 1116 is not selected, suggestions may not be displayed. Results from suggestion configurations input may then be displayed graphically in section 1118. Any number of configurations may be viewed and sorted in accordance with user preferences.
In the embodiment illustrated in
A bundled SKU 1210 is a selected product SKU associated with a driver SKU 1206. A bundled SKU 1210 may be selected from a lookup table corresponding to associated driver SKUs. In this manner configuration compatibility may be assured since only a list of available and compatible products may be available. As with a driver SKU 1206, a bundled SKU 1210 has a corresponding description 1212. A description 1212 describes, in plain language for example, a product, product set, product group or service corresponding to a selected bundled SKU. In some embodiments a suggested discount 1213 may be entered. A discount for a given bundled product or service may help to further promote selected products or services. A date range represented by start and end dates 1214 may be selected in order to confine a configured suggestion to a desired time frame. Further a suggestion may be configured to be forced or optional via a force selection box 1216. In an example of a forced suggestion, the effect to a user would be that selling a driver product with a bundled product would be automatically displayed; however, a user selection would not be mandatory. When force selection box 1216 is not selected, suggestions may not be displayed. A message box 1218 may be further configured to display a message when a bundled suggestion is presented. Results from suggestion configurations input may then be displayed graphically in section 1220. Any number of configurations may be viewed and sorted in accordance with user preferences.
As can be appreciated, the examples described herein detail guidance pricing, configuration suggestion, and forecasting in embodiments of the present invention. Other methods and uses that may be used in combination with guidance pricing, configuration suggestions, and forecasting are contemplated by the present invention.
While this invention has been described in terms of several preferred embodiments, there are alterations, permutations, modifications and various substitute equivalents, which fall within the scope of this invention. It should also be noted that there are many alternative ways of implementing the methods and systems of the present invention. It is therefore intended that the following appended claims be interpreted as including all such alterations, permutations, modifications, and various substitute equivalents as fall within the true spirit and scope of the present invention. In addition, the use of subtitles in this application is for clarity only and should not be construed as limiting in any way.
This application is a continuation-in-part of U.S. patent application Ser. No. 10/615,166 filed on Jul. 7, 2003 now abandoned by MARAIS, entitled “SYSTEMS AND METHODS FOR PRICING PRODUCTS,” which claims priority to provisional application Ser. No. 60/395,703 filed Jul. 12, 2002. The content of those applications are incorporated herein by reference. This application is related to U.S. patent application Ser. No. 10/121,803 filed on Apr. 12, 2002 by HUERTA et al., entitled “RULE-BASED SYSTEM FOR DETERMINING PRICE ADJUSTMENTS IN A PRODUCT CATALOG,” now U.S. Pat. 7,233,928 issued Jun. 19, 2007. The content of that application is incorporated herein by reference. This application is related to U.S. patent application Ser. No. 10/121,816 filed on Apr. 12, 2002 by RAGHUPATHY et al. entitled “SYSTEM AND METHOD FOR GROUPING PRODUCTS IN A CATALOG,”, now U.S. Pat. No. 7,308,421, issued Dec. 11, 2007. The content of that application is incorporated herein by reference.
Number | Name | Date | Kind |
---|---|---|---|
3806711 | Cousins, Jr. | Apr 1974 | A |
5053957 | Suzuki | Oct 1991 | A |
5224034 | Katz et al. | Jun 1993 | A |
5461708 | Kahn | Oct 1995 | A |
5497489 | Menne | Mar 1996 | A |
5537590 | Amado | Jul 1996 | A |
5590269 | Kruse et al. | Dec 1996 | A |
5670984 | Robertson et al. | Sep 1997 | A |
5689287 | Mackinlay et al. | Nov 1997 | A |
5710887 | Chelliah et al. | Jan 1998 | A |
5740448 | Gentry et al. | Apr 1998 | A |
5758327 | Gardner et al. | May 1998 | A |
5808894 | Wiens et al. | Sep 1998 | A |
5870717 | Wiecha | Feb 1999 | A |
5873069 | Reuhl et al. | Feb 1999 | A |
5878400 | Carter, III | Mar 1999 | A |
5946666 | Nevo et al. | Aug 1999 | A |
6009407 | Garg | Dec 1999 | A |
6075530 | Lucas et al. | Jun 2000 | A |
6078901 | Ching | Jun 2000 | A |
6151031 | Atkins et al. | Nov 2000 | A |
6211880 | Impink, Jr. | Apr 2001 | B1 |
6320586 | Plattner et al. | Nov 2001 | B1 |
6434533 | Fitzgerald | Aug 2002 | B1 |
6553350 | Carter | Apr 2003 | B2 |
6665577 | Onyshkevych | Dec 2003 | B2 |
6678695 | Bonneau et al. | Jan 2004 | B1 |
6785664 | Jameson | Aug 2004 | B2 |
6801201 | Escher | Oct 2004 | B2 |
6812926 | Rugge | Nov 2004 | B1 |
6851604 | Girotto et al. | Feb 2005 | B2 |
6856967 | Woolston et al. | Feb 2005 | B1 |
6907403 | Klein et al. | Jun 2005 | B1 |
6988076 | Ouimet | Jan 2006 | B2 |
7015912 | Marais | Mar 2006 | B2 |
7046248 | Perttunen | May 2006 | B1 |
7076463 | Boies et al. | Jul 2006 | B1 |
7080026 | Singh et al. | Jul 2006 | B2 |
7092929 | Dvorak et al. | Aug 2006 | B1 |
7133848 | Phillips et al. | Nov 2006 | B2 |
7149716 | Gatto | Dec 2006 | B2 |
7155510 | Kaplan | Dec 2006 | B1 |
7218325 | Buck | May 2007 | B1 |
7233928 | Huerta et al. | Jun 2007 | B2 |
7254584 | Addison, Jr. | Aug 2007 | B1 |
7308421 | Raghupathy et al. | Dec 2007 | B2 |
7315835 | Takayasu et al. | Jan 2008 | B1 |
7343355 | Ivanov et al. | Mar 2008 | B2 |
20010003814 | Hirayama et al. | Jun 2001 | A1 |
20020007323 | Tamatsu | Jan 2002 | A1 |
20020032610 | Gold et al. | Mar 2002 | A1 |
20020042782 | Albazz et al. | Apr 2002 | A1 |
20020052817 | Dines et al. | May 2002 | A1 |
20020059058 | Doolin et al. | May 2002 | A1 |
20020059229 | Natsumeda et al. | May 2002 | A1 |
20020072993 | Sandus et al. | Jun 2002 | A1 |
20020099596 | Geraghty | Jul 2002 | A1 |
20020107819 | Ouimet | Aug 2002 | A1 |
20020116348 | Phillips et al. | Aug 2002 | A1 |
20020128953 | Quallen et al. | Sep 2002 | A1 |
20020152133 | King et al. | Oct 2002 | A1 |
20020152150 | Cooper et al. | Oct 2002 | A1 |
20020156695 | Edwards | Oct 2002 | A1 |
20020165726 | Grundfest | Nov 2002 | A1 |
20020165760 | Delurgio et al. | Nov 2002 | A1 |
20020178077 | Katz et al. | Nov 2002 | A1 |
20020188576 | Peterson et al. | Dec 2002 | A1 |
20020194051 | Hall et al. | Dec 2002 | A1 |
20030028451 | Ananian | Feb 2003 | A1 |
20030033240 | Balson et al. | Feb 2003 | A1 |
20030095256 | Cargill et al. | May 2003 | A1 |
20030110066 | Walser et al. | Jun 2003 | A1 |
20030115129 | Feaver et al. | Jun 2003 | A1 |
20030126053 | Boswell et al. | Jul 2003 | A1 |
20030130883 | Schroeder et al. | Jul 2003 | A1 |
20030167209 | Hsieh | Sep 2003 | A1 |
20030191723 | Foretich et al. | Oct 2003 | A1 |
20030195810 | Raghupathy et al. | Oct 2003 | A1 |
20030200185 | Huerta et al. | Oct 2003 | A1 |
20030225593 | Ternóey et al. | Dec 2003 | A1 |
20030229552 | Lebaric et al. | Dec 2003 | A1 |
20040024715 | Ouimet | Feb 2004 | A1 |
20040049470 | Ouimet | Mar 2004 | A1 |
20040078288 | Forbis et al. | Apr 2004 | A1 |
20040117376 | Lavin et al. | Jun 2004 | A1 |
20040128225 | Thompson et al. | Jul 2004 | A1 |
20040133526 | Shmueli et al. | Jul 2004 | A1 |
20040193442 | Kimata et al. | Sep 2004 | A1 |
20040267674 | Feng et al. | Dec 2004 | A1 |
20040267676 | Feng et al. | Dec 2004 | A1 |
20050004819 | Etzioni et al. | Jan 2005 | A1 |
20050096963 | Myr et al. | May 2005 | A1 |
20050197857 | Avery | Sep 2005 | A1 |
20050197971 | Kettner et al. | Sep 2005 | A1 |
20050256778 | Boyd et al. | Nov 2005 | A1 |
20050267831 | Esary et al. | Dec 2005 | A1 |
20050278227 | Esary et al. | Dec 2005 | A1 |
20060004861 | Albanese et al. | Jan 2006 | A1 |
20060031179 | Lehrman | Feb 2006 | A1 |
20060069585 | Springfield et al. | Mar 2006 | A1 |
20060241923 | Xu et al. | Oct 2006 | A1 |
Number | Date | Country |
---|---|---|
WO 9960486 | Nov 1999 | WO |
WO 0029995 | May 2000 | WO |
WO 2005119500 | Dec 2005 | WO |
Number | Date | Country | |
---|---|---|---|
20060031178 A1 | Feb 2006 | US |
Number | Date | Country | |
---|---|---|---|
60395703 | Jul 2002 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 10615166 | Jul 2003 | US |
Child | 10914715 | US |