Sales transaction analysis tool and associated method of use

• US 20080255973A1
• Filed: 04/10/2007
• Published: 10/16/2008
• Est. Priority Date: 04/10/2007
• Status: Abandoned Application

• Current Assignee: Celanese International Corporation (Celanese Corporation)
• Original Assignee: Celanese International Corporation (Celanese Corporation)
• Inventors: El Wade, Robert, Cisneros Garcia, Victor, Herzog, Bernhard Matthias, Zumsteg, Anne Christine
• Application Number:
  US11/784,785
• Publication Number:
  US 20080255973A1
• Time in Patent Office: Days
• US Class Current: 705/35
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

A computer implemented sales transaction tool and associated method of use is disclosed. This includes at least one processor configured to receive sales transaction information and programmed to provide the following functionality: a series of control functions that can be selectively activated by input to the processor for creating at least one subset of the sales transaction information, a plurality of graphical representations that are generated based on the selected subset of sales transaction information, and displaying at least one graphical representation of the plurality of graphical representations on an electronic display associated with the processor. Graphical representations of sales transaction information may include a slope and scatter diagram of sales transaction information, a waterfall chart, waterfall transactional analysis, a time series chart, a price sensor, a margin sensor, a break-even analysis graph and a bubble chart. There are graphical representations to evaluate opportunity of moving low margin products to average margins of comparable products and determining value for products having a single customer.

Claims

35. A sales transaction tool comprising:

at least one processor configured for receiving sales transaction information, said processor being programmed to provide the following functionality;

a series of control functions that can be selectively activated by user input to the at least one processor for creating at least one subset of the sales transaction information, wherein the series of control functions includes at least one of a product-type control, a time period-type control, a predetermined grouping of customers, and a predetermined market;

a plurality of graphical representations that are generated based on the selected subset of sales transaction information, wherein the plurality of graphical representations includes at least one or more of a graphical representation of gross sales price information minus predetermined cost elements versus quantity, a slope and scatter diagram of sales transaction information, a price and margin solver, a time series chart, a price sensor, a margin sensor and a break-even analysis graph, waterfall analysis of sales transaction information, a low volume analysis tool for estimating opportunity of moving low margin products to average margins of comparable products, a single customer analysis tool for determining value with a single customer, and a transactional waterfall bubble chart, wherein the processor includes at least one electronic display for displaying at least one of said graphical representations.

1. A sales transaction tool comprising:

at least one processor configured to receive sales transaction information, said processor being programmed to provide the following functionality;

a series of control functions that can be selectively activated by user input to the at least one processor for creating at least one subset of the sales transaction information;

a plurality of graphical representations that are generated based on the selected subset of sales transaction information; and

said processor having at least one electrically connected electronic display for displaying at least one of said graphical representations.

2. The sales transaction tool according to claim 1, wherein the series of control functions includes at least one regional-type control.

3. The sales transaction tool according to claim 2, wherein the at least one regional-type control is selected from the group consisting of at least one predetermined sales organization, at least one predetermined geographic region, at least one predetermined country where products are shipped, or at least one sales representative.

4. The sales transaction tool according to claim 1, wherein the series of control functions includes at least one product-type control.

5. The sales transaction tool according to claim 4, wherein the at least one product-type control is selected from the group consisting of predetermined product information, a subgrouping of a predetermined product, a component for a predetermined product component, a different version of a predetermined product, a different category of a predetermined product, or a predetermined material handling group for a predetermined product.

6. The sales transaction tool according to claim 1, wherein the series of control functions includes at least one time period-type control.

7. The sales transaction tool according to claim 6, wherein the at least one time period-type control is selected from the group consisting of a predetermined quarter, a predetermined month or a predetermined year.

8. The sales transaction tool according to claim 1, wherein the series of control functions includes at least one predetermined grouping of customers.

9. The sales transaction tool according to claim 1, wherein the series of control functions includes at least one of a predetermined market and a predetermined submarket.

10. The sales transaction tool according to claim 1, wherein the series of control functions includes at least one predetermined affiliated party.

11. The sales transaction tool according to claim 1, wherein the plurality of graphical representations includes at least one graphical representation of gross sales price information minus predetermined cost elements versus quantity.

12. The sales transaction tool according to claim 11, wherein the cost elements can selectively exclude predetermined cost elements selected from the group including at least one of raw materials, fixed costs and energy costs.

13. The sales transaction tool according to claim 11, wherein the at least one graphical representation of gross sales price information minus predetermined cost elements versus quantity is graphically presented with fishtail analysis.

14. The sales transaction tool according to claim 11, wherein the at least one a graphical representation of gross sales price information minus predetermined cost elements versus cumulative quantity can be compared against another graphical representation of gross sales price information minus predetermined cost elements versus quantity.

15. The sales transaction tool according to claim 1, wherein the plurality of graphical representations includes at least one slope and scatter diagram of sales transaction information selected from the group consisting of a target price, an invoice gross, a first imputed discount, a sales order price, a top quartile price, a second imputed discount, a small quantity upcharge, discounts printed on an invoice, invoice net, volume rebate, transactional corrections, allocated corrections, early payment discount(s), net price, variable cost of raw materials, packaging costs, last leg of freight charges, variable margin, net price, cash cost of accounts receivables, cash cost of inventory, internal shipment cost, cost to serve, commissions, duties, pocket margin, fixed costs, energy costs or profit margin versus quantity.

16. The sales transaction tool according to claim 15, wherein the slope and scatter diagram can be utilized to generate a waterfall chart.

17. The sales transaction tool according to claim 16, wherein the generated waterfall chart can be based on a predetermined customer'"'"'s data.

18. The sales transaction tool according to claim 16, wherein the generated waterfall chart diagram can be utilized to generate a series chart.

19. The sales transaction tool according to claim 15, wherein the slope and scatter diagram includes a logarithmic graph.

20. The sales transaction tool according to claim 1, further comprising a price and margin solver for estimating at least one of a price element, a margin element and a cost element.

21. The sales transaction tool according to claim 1, wherein the price and margin solver utilizes at least one of a target and a confidence level.

22. The sales transaction tool according to claim 1, wherein the plurality of graphical representations includes at least one of a time series chart, a price sensor, a margin sensor and a break-even analysis graph.

23. The sales transaction tool according to claim 22, wherein the price sensor includes a first portion that is a price decrease of a predetermined percentage or more and a second portion that is a price change of the predetermined percentage or less and a third portion that is a price increase of the predetermined percentage or more.

24. The sales transaction tool according to claim 22, wherein the margin sensor includes a first portion that is a margin decrease of a predetermined percentage or more and a second portion that is a margin change of the predetermined percentage or less and a third portion that is a margin increase of the predetermined percentage or more.

25. The sales transaction tool according to claim 22, wherein the time series chart includes a representation of price over time.

26. The sales transaction tool according to claim 22, wherein the break-even analysis graph evaluates volume change in relationship to price change.

27. The sales transaction tool according to claim 1, wherein the plurality of graphical representations includes at least one waterfall analysis of sales transaction information selected from the group consisting of a target price, an invoice gross, a first imputed discount, a sales order price, a top quartile price, a second imputed discount, a small quantity upcharge, discounts printed on an invoice, invoice net, volume rebate, transactional corrections, allocated corrections, early payment discount(s), net price, variable cost of raw materials, packaging cost, last leg of freight charges, variable margin, net price, cash cost of accounts receivables, cash cost of inventory, internal shipment cost, cost to serve, commissions, duties, pocket margin, fixed costs, energy costs or profit margin versus quantity.

28. The sales transaction tool according to claim 27, wherein the at least one waterfall analysis of sales transaction information generates at least one of a histogram and a time series chart.

29. The sales transaction tool according to claim 27, further comprising a filter that obtains a subgroup of the sales transaction information to generate at least one additional waterfall analysis.

30. The sales transaction tool according to claim 29, wherein the at least one additional waterfall analysis of the subgroup of sales transaction information generates at least one of a histogram and a series chart.

31. The sales transaction tool according to claim 1, further comprising a low volume analysis tool for estimating opportunity of moving low margin products to average margins of comparable products, which generates a graphical representation of sales and at least one of profit margin and pocket margin over predetermined time periods.

32. The sales transaction tool according to claim 1, further comprising a single customer analysis tool for determining value with a single customer, which generates a graphical representation of least one of profit margin and pocket margin and at least one of percentage of quantity and percentage of sales over predetermined percentages of customer dependence.

33. The sales transaction tool according to claim 32, wherein the graphical representation includes at least one of opportunity and risk.

34. The sales transaction tool according to claim 1, further comprising a transactional waterfall bubble chart that shows at least one of invoice gross, net price, target price, and top quartile price in relationship to at least one of a target price, an invoice gross, a first imputed discount, a second imputed discount, a small quantity upcharge, discounts printed on an invoice, volume rebate, transactional corrections, allocated corrections, early payment discount(s), variable cost of raw materials, packaging cost, last leg of freight charges, variable margin, cash cost of accounts receivables, cash cost of inventory, internal shipment cost, cost to serve, commissions, duties, pocket margin, fixed costs, energy costs and profit margin.

46. The method for processing and displaying selected sales transaction information according to claim 36, wherein the plurality of graphical representations includes at least one waterfall analysis of sales transaction information selected from the group consisting of a target price, an invoice gross, a first imputed discount, a sales order price, a top quartile price, a second imputed discount, a small quantity upcharge, discounts printed on an invoice, invoice net, volume rebate, transactional corrections, allocated corrections, early payment discount(s), net price, variable cost of raw materials, packaging cost, last leg of freight charges, variable margin, net price, cash cost of accounts receivables, cash cost of inventory, internal shipment costs, cost to serve, commissions, duties, pocket margin, fixed costs, energy costs or profit margin versus quantity.

47. The method for processing and displaying selected sales transaction information according to claim 36, further comprising estimating opportunity of moving low margin products to average margins of comparable products, which generates a graphical representation of sales and at least one of profit margin and pocket margin over predetermined time periods with a low volume analysis tool.

36. A method for processing and displaying selected sales transaction information comprising:

receiving sales transaction information with at least one processor;

selectively activating a series of control functions programmed into said at least one processor, by user input to the at least one processor, for creating at least one subset of the sales transaction information;

generating a plurality of graphical representations based on the selected subset of sales transaction information; and

displaying at least one of said graphical representations on at least one electronic display.

37. The method for processing and displaying selected sales transaction information according to claim 36 wherein the series of control functions includes:

at least one regional-type control selected from the group consisting of at least one predetermined sales organization, at least one predetermined geographic region, at least one predetermined country where products are shipped, or at least one sales representative;

at least one product-type control selected from the group consisting of predetermined product information, a subgrouping of a predetermined product, a component for a predetermined product component, a different version of a predetermined product, a different category of a predetermined product, or a predetermined material handling group for a predetermined product; and

at least one time period-type control selected from the group consisting of a predetermined quarter, a predetermined month or a predetermined year.

38. The method for processing and displaying selected sales transaction information according to claim 36, wherein the series of control functions includes at least one of predetermined grouping of customers, a predetermined market and a predetermined submarket.

39. The method for processing and displaying selected sales transaction information according to claim 36, wherein the plurality of graphical representations includes at least one a graphical representation of gross sales price information minus predetermined cost elements versus quantity.

40. The method for processing and displaying selected sales transaction information according to claim 36, wherein the at least one graphical representation of gross sales price information minus predetermined cost elements versus quantity is graphically presented with fishtail analysis.

41. The method for processing and displaying selected sales transaction information according to claim 36, wherein the plurality of graphical representations includes at least one of a slope and scatter diagram of sales transaction information selected from the group consisting of a target price, an invoice gross, a first imputed discount, a sales order price, a top quartile price, a second imputed discount, a small quantity upcharge, discounts printed on an invoice, invoice net, volume rebate, transactional corrections, allocated corrections, early payment discount(s), net price, variable cost of raw materials, packaging cost, last leg of freight charges, variable margin, net price, cash cost of accounts receivables, cash cost of inventory, internal shipment cost, cost to serve, commissions, duties, pocket margin, fixed costs, energy costs or profit margin versus quantity.

42. The method for processing and displaying selected sales transaction information according to claim 41, further comprising utilizing at least one of a waterfall chart, a series chart, and a logarithmic graph.

43. The method for processing and displaying selected sales transaction information according to claim 36, further comprising estimating at least one of a price element, a margin element and a cost element with a price and margin solver.

44. The method for processing and displaying selected sales transaction information according to claim 36, wherein the plurality of graphical representations includes at least one of a time series chart, a price sensor, a margin sensor and a break-even analysis graph.

45. The method for processing and displaying selected sales transaction information according to claim 44, wherein the price sensor includes a first portion that is a price decrease of a predetermined percentage or more and a second portion that is a price change of the predetermined percentage or less and a third portion that is a price increase of the predetermined percentage and the margin sensor includes a first portion that is a margin decrease of a predetermined percentage or more and a second portion that is a margin change of the predetermined percentage or less and a third portion that is a margin increase of the predetermined percentage.

46-1. The method for processing and displaying selected sales transaction information according to claim 35, further comprising determining value with a single customer, which generates a graphical representation of least one of profit margin and pocket margin and at least one of percentage of quantity and percentage of sales over predetermined percentages of customer dependence with a single customer analysis tool.

47-2. The method for processing and displaying selected sales transaction information according to claim 35, further comprising utilizing a transactional waterfall bubble chart that shows at least one of invoice gross, net price, target price, and top quartile price in relationship to at least one of a target price, an invoice gross, a first imputed discount, a second imputed discount, a small quantity upcharge, discounts printed on an invoice, volume rebate, transactional corrections, allocated corrections, early payment discount(s), variable cost of raw materials, packaging costs, last leg of freight charges, variable margin, cash cost of accounts receivables, cash cost of inventory, internal shipment costs, cost to serve, commissions, duties, pocket margin, fixed costs, energy costs and profit margin.

48. A method for processing and displaying selected sales transaction information comprising:

receiving sales transaction information with at least one processor;

selectively activating a series of control functions programmed into said at least one processor, by user input to the at least one processor, for creating at least one subset of the sales transaction information, wherein the series of control functions includes at least one of a product-type control, a time period-type control, a predetermined grouping of customers, and a predetermined market;

generating a plurality of graphical representations based on the selected subset of sales transaction information wherein the plurality of graphical representations includes graphical representation of at least one of gross sales price information minus predetermined cost elements versus quantity, a slope and scatter diagram of sales transaction information, a price and margin solver, a time series chart, a price sensor, a margin sensor and a break-even analysis graph, waterfall analysis of sales transaction information, a low volume analysis tool for estimating opportunity of moving low margin products to average margins of comparable products, a single customer analysis tool for determining value with a single customer, and a transactional waterfall bubble chart; and

displaying at least one of said graphical representations on at least one electronic display.