Method for managing a workflow process that assists users in procurement, sourcing, and decision-support for strategic sourcing

• US 7,870,012 B2
• Filed: 05/15/2001
• Issued: 01/11/2011
• Est. Priority Date: 05/15/2001
• Status: Active Grant

• Current Assignee: Agile Software Corporation (Oracle Corporation)
• Original Assignee: Agile Software Corporation (Oracle Corporation)
• Inventors: Rudin, Kenneth M., Kanthanathan, Manoranjan, Labrou, Yannis, Katz, Steven Bruce
• Primary Examiner(s): Boswell; Beth V
• Assistant Examiner(s): CHONG CRUZ, NADJA N
• Application Number:
  US09/858,122
• Publication Number:
  US 20020174000A1
• Time in Patent Office: 3,528 Days
• Field of Search: 705 7- 8, 705/10, 705/26, 705/28, 705/35, 705/400
• US Class Current: 705/7.26
• CPC Class Codes: G06Q 10/06316 Sequencing of tasks or work
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A method for assisting a user with procurement decisions, sourcing decisions and strategic sourcing decisions in an enterprise is disclosed. The method implements a plurality of software modules in a logical workflow process based on the results of integrating and analyzing data. The workflow process provides a plurality of steps for discovering data, analyzing data, alerting the user about the data, recommending actions to the user based on the data, and executing those actions. The workflow process is based on a Value Chain Intelligence (VCI) system, which integrates and analyzes internal data from enterprises and external data from suppliers, catalogs, and marketplaces in real time for their impact on supply chains processes. Components for such a system may consist of internal data collection components, external data collection components, data integration components, and data application components. Various methods for searching, extracting, transforming, integrating, analyzing, and representing data internal to an enterprise and data external to an enterprise are also disclosed.

Claims

1. A method comprising:

discovering, by a computer system, internal and external data related to a plurality of components to be procured by an enterprise, wherein the internal data originates from one or more data sources internal to the enterprise, and wherein the external data originates from one or more data sources external to the enterprise;

storing, by the computer system, the discovered internal and external data in a data mart;

analyzing, by the computer system, the internal and external data using a first analysis module to determine criticality ratings for the plurality of components, wherein the criticality rating for a component indicates the strategic importance of the component to operations of the enterprise, and wherein the analyzing performed using the first analysis module is based on a first set of user-defined parameters that qualify the internal or external data;

analyzing, by the computer system, the internal and external data using a second analysis module to forecast prices for the plurality of components set by suppliers external to the enterprise, wherein the analyzing performed using the second analysis module is based on a second set of user-defined parameters that qualify the internal or external data;

analyzing, by the computer system, the internal and external data using a third analysis module to determine optimal inventory levels for the plurality of components, wherein the analyzing performed using the third analysis module is based on a third set of user-defined parameters that qualify the internal or external data;

analyzing, by the computer system, the internal and external data using a fourth analysis module to identify components in the plurality of components that are shortage risks, wherein the analyzing performed using the fourth analysis module is based on a fourth set of user-defined parameters that qualify the internal or external data;

collecting and integrating the analyzed data from the first, second, third and fourth analysis modules through a plurality of algorithms that optimize the analyzed data based on the first, second, third and fourth set of user-defined parameters;

recommending by the computer system, one or more proposed actions to take with respect to procurement of the plurality of components based on the collecting and integrating performed; and

providing, by the computer system, one or more computer-initiated options for fully or partially executing an action in the one or more proposed actions.

2. The method of claim 1, wherein the discovered internal and external data stored in the data mart is organized for querying and report generation, and represented to the user in a plurality of formats.

3. The method of claim 1, further comprising producing, by the computer system, one or more reports based on the analyzing performed using the first, second, third, and fourth analysis modules, wherein the one or more reports provide the user with information regarding an impact or potential impact of the discovered internal and external data on procurement decisions, sourcing decisions and strategic sourcing decisions in the enterprise with respect to the plurality of components, and wherein the one or more reports include information displayed in one or more graphical formats.

4. The method of claim 3, wherein the one or more graphical formats include a table, chart, graph, or map.

5. The method of claim 1, further comprising producing, by the computer system, one or more reports based on the analyzing performed using the first, second, third, and fourth analysis modules, wherein the one or more reports provide the user with information regarding an impact or potential impact of the discovered internal and external data on procurement decisions, sourcing decisions and strategic sourcing decisions in the enterprise with respect to the plurality of components, and wherein the one or more reports include information represented in one or more non-graphical formats.

6. The method of claim 5, wherein the one or more non-graphical formats include a news bulletin, an alert box, or an audio message.

7. The method of claim 1, wherein the step of discovering internal and external data assists the user in identifying parameters for criteria relevant to procurement decisions, sourcing decisions and strategic sourcing in the enterprise regarding the plurality of components.

8. The method of claim 7, wherein the parameters are user-defined.

9. The method of claim 1, wherein the steps of analyzing the discovered internal and external data using the first, second, third, and fourth analysis modules uses data from the step of discovering the internal and external data to produce one or more reports intended to assist the user in procurement decisions, sourcing decisions, or strategic sourcing decisions.

10. The method of claim 1, wherein the step of recommending one or more proposed actions uses data from the steps of analyzing the discovered internal and external data using the first, second, third, and fourth analysis modules to make recommendations for possible actions based on the discovered internal and external data.

11. The method of claim 1, wherein the steps of analyzing the discovered internal and external data using the first, second, third, and fourth analysis modules collects data from the step of discovering the internal and external data and additional data from user input to make recommendations in real time.

12. The method of claim 1, wherein the step of executing one or more actions uses data from the steps of analyzing the discovered internal and external data using the first, second, third, and fourth analysis modules as input for the user to decide which recommendations to execute and when to execute them.

13. The method of claim 1, wherein the step of discovering internal and external data collects, integrates and displays graphical and non-graphical data.

14. The method of claim 1, wherein the step of discovering internal and external data includes extraction, transformation and loading of data, scanning of data that has been aggregated across a single business unit or across multiple business units of the enterprise, conducting of real-time searching, and customizing of real-time alerts and news feeds.

15. The method of claim 1, wherein the step of executing one or more actions enables the user to set automation levels at either a first level, which provides a greater range of permitted automated actions, or at a second level, which provides a more restricted range of permitted automated actions.

16. The method of claim 15, wherein additional automation levels are selectable by the user, providing a plurality of customized ranges of permitted automated actions.

17. The method of claim 1, wherein the step of executing one or more actions provides agents that follow user-defined rules to enable hands-free handling of user-defined exceptions and processes.

18. The method of claim 1, wherein the step of executing one or more actions initiates a transaction via another application, carries out one or a plurality of transactions, and changes information in the another application.

19. The method of claim 1, wherein the step of executing one or more actions includes providing agents that follow user-defined rules to enable hands-free handling of user-defined exceptions and processes, initiating a transaction via another application, and carrying out certain transactions, wherein the certain transactions include generating and sending out a RFQ and changing discovered internal and external data in an internal application.

20. The method of claim 1, wherein the internal and external data are reintegrated into the data mart after each step of the method is performed, and wherein the data is continuously incorporated into the data mart automatically or at predetermined or other intervals.

21. The method of claim 1, further comprising alerting the user of conditions that are relevant to the user'"'"'s tasks in procurement, sourcing, or strategic sourcing.

22. The method of claim 21, wherein the conditions include values, combinations of values, and conditions for the values and combinations of values.

23. The method of claim 1 further comprising:

analyzing, by the computer system, the internal and external data using a fifth analysis module to determine, for each component in the plurality of components, an allocation of a purchase quantity of the component across a set of suppliers, wherein the allocation is based on contractual obligations with the set of suppliers and performance ratings for the set of suppliers, and wherein the analyzing performed using the fifth analysis module is based on a fifth set of user-defined parameters that qualify the internal or external data.

24. The method of claim 1 further comprising:

receiving, by the computer system, a condition pertaining to the internal or external data; and

if the condition is satisfied, sending an alert to the user.

25. The method of claim 1 wherein the criticality rating for a component in the plurality of components is based on one or more variables including profit impact of the component, a number of products that would be affected by a shortage of the component, and a current inventory level of the component.

26. The method of claim 1 wherein the optimal inventory levels for the plurality of components are based on inventory holding costs, revenue impact of stocking out of the components, and warehouse constraints.

27. The method of claim 1 wherein the one or more data sources internal to the enterprise include:

a supplier database comprising information about suppliers of the plurality of components;

a contracts database comprising information about supplier contracts;

an internal parts database comprising information about products incorporating the plurality of components;

a supply chain data database comprising information about inventory levels for the plurality of components, warehouse locations, and production schedules; and

an enterprise resource planning (ERP) database comprising information about accounting ledgers and financial records related to the plurality of components.

28. The method of claim 27 wherein the one or more data sources external to the enterprise include:

electronic product databases comprising information about products sold by one or more external suppliers, the information including pricing, availability, and lead time; and

subscription sources comprising information about industry trends and market news.

29. A system comprising:

a storage device configured to store internal and external data related to a plurality of components to be procured by an enterprise, wherein the internal data originates from one or more data sources internal to the enterprise, and wherein the external data originates from one or more data sources external to the enterprise; and

a processing component communicatively coupled with the storage device, the processing component being configured to;

analyze the internal and external data using a first analysis module to determine criticality ratings for the plurality of components, wherein the criticality rating for a component indicates the strategic importance of the component to operations of the enterprise, and wherein the analyzing performed using the first analysis module is based on a first set of user-defined parameters that qualify the internal or external data;

analyze the internal and external data using a second analysis module to forecast prices for the plurality of components set by suppliers external to the enterprise, wherein the analyzing performed using the second analysis module is based on a second set of user-defined parameters that qualify the internal or external data;

analyze the internal and external data using a third analysis module to determine optimal inventory levels for the plurality of components, wherein the analyzing performed using the third analysis module is based on a third set of user-defined parameters that qualify the internal or external data;

analyze the internal and external data using a fourth analysis module to identify components in the plurality of components that are shortage risks, wherein the analyzing performed using the fourth analysis module is based on a fourth set of user-defined parameters that qualify the internal or external data;

collect and integrate the analyzed data from the first, second, third and fourth analysis modules through a plurality of algorithms that optimize the analyzed data based on the first, second, third and fourth set of user-defined parameters;

recommend one or more proposed actions to take with respect to procurement of the plurality of components based on the collecting and integrating performed; and

provide one or more computer-initiated options for fully or partially executing an action in the one or more proposed actions.

30. A non-transitory computer readable storage medium having stored thereon instructions executable by a computer system, the instructions comprising:

instructions that cause the computer system to discover internal and external data related to a plurality of components to be procured by an enterprise, wherein the internal data originates from one or more data sources internal to the enterprise, and wherein the external data originates from one or more data sources external to the enterprise;

instructions that cause the computer system to store the discovered internal and external data in a data mart;

instructions that cause the computer system to analyze the internal and external data using a first analysis module to determine criticality ratings for the plurality of components, wherein the criticality rating for a component indicates the strategic importance of the component to operations of the enterprise, and wherein the analyzing performed using the first analysis module is based on a first set of user-defined parameters that qualify the internal or external data;

instructions that cause the computer system to analyze the internal and external data using a second analysis module to forecast prices for the plurality of components set by suppliers external to the enterprise, wherein the analyzing performed using the second analysis module is based on a second set of user-defined parameters that qualify the internal or external data;

instructions that cause the computer system to analyze the internal and external data using a third analysis module to determine optimal inventory levels for the plurality of components, wherein the analyzing performed using the third analysis module is based on a third set of user-defined parameters that qualify the internal or external data;

instructions that cause the computer system to analyze the internal and external data using a fourth analysis module to identify components in the plurality of components that are shortage risks, wherein the analyzing performed using the fourth analysis module is based on a fourth set of user-defined parameters that qualify the internal or external data;

instructions that cause the computer system to collect and integrate the analyzed data from the first, second, third and fourth analysis modules through a plurality of algorithms that optimize the analyzed data based on the first, second, third and fourth set of user-defined parameters;

instructions that cause the computer system to recommend one or more proposed actions to take with respect to procurement of the plurality of components based on the collecting and integrating performed; and

instructions that cause the computer system to provide one or more computer-initiated options for fully or partially executing an action in the one or more proposed actions.