Computer-implemented systems and methods for reducing cost flow models

• US 7,813,948 B2
• Filed: 08/25/2006
• Issued: 10/12/2010
• Est. Priority Date: 08/25/2006
• Status: Active Grant

• Current Assignee: SAS Institute Incorporated
• Original Assignee: SAS Institute Incorporated
• Inventors: Ratzloff, John Phillip
• Primary Examiner(s): Jeanty; Romain
• Application Number:
  US11/510,527
• Publication Number:
  US 20080065435A1
• Time in Patent Office: 1,509 Days
• Field of Search: 705/7, 707/600, 707/607
• US Class Current: 705/7.22
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: G06Q 10/06312 Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
• CPC Class Codes: G06Q 10/06375 Prediction of business process outcome or impact based on a proposed change

Abstract

Computer-implemented methods and systems for use in analyzing costs associated with cost flow models having components of relationships and entities. Reduction criteria is received for use in reducing number of components that are in a first cost flow model. The reduction criteria is used to generate a reduced cost flow model. The reduced cost flow model has less components than the number of components that are in the received first cost flow model.

Claims

1. A computer-implemented method for analyzing costs associated with cost flow models having components of relationships and entities, the method comprising:

receiving, using one or more computer processors, data associated with a first cost flow model that identifies the costs associated with relationships among the entities, including resources, activities, and cost objects, wherein the first cost flow model is a multi-dimensional directed graph for depicting how money flows in an enterprise, wherein nodes of the graph represent accounts associated with the resources, activities, or cost objects, wherein an account exists at the intersection of a plurality of dimension members within a multi-dimensional database (MDDB) having dimensions, each dimension containing one or more dimension members, and wherein an edge of the multi-dimensional directed graph is associated with a percentage defining how much money flows from a source account to a destination account;

receiving reduction criteria, and using the reduction criteria to reduce the number of components in the first cost flow model;

using the reduction criteria to generate a reduced cost flow model, wherein the reduced cost flow model has fewer components than the number of components that are in the received first cost flow model, and wherein the reduced cost flow model is used to analyze costs associated with the entities in the reduced cost flow model; and

processing and storing the reduced cost flow model, wherein computation processing and storage requirements associated with processing and storing the reduced cost flow model is less than computation processing and storage requirements associated with processing and storing the first cost flow model, wherein the storing of the reduced cost flow model includes storing the reduced cost flow model in a relational database management system (RDBMS) or an Online Analytical Processing (OLAP) database, and wherein each cost flow path in the reduced cost flow model is stored in a data record row in a table in the RDBMS or the OLAP database.

2. The method of claim 1, wherein the first and reduced cost flow models are activity-based costing flow graphs.

3. The method of claim 1, wherein the first cost flow model depicts how money flows in the enterprise, starting from the resources to the activities, and finally, to the cost objects.

4. The method of claim 1, wherein the resources represent accounts in a general ledger, and wherein the cost objects represent products or services provided by the enterprise.

5. The method of claim 4, wherein a cost object account exists at an intersection of a product or service dimension and a customer dimension.

6. The method of claim 5, wherein the first cost flow model is a multi-dimensional directed graph that includes over 100,000 accounts and over 1,000,000 edges, and wherein the reduced cost flow model is a multi-dimensional directed graph that contains less than 100,000 accounts and less than 1,000,000 edges.

7. The method of claim 1, wherein the reduced cost flow model includes a first account and a second account, and wherein the reduced cost flow model is used to analyze how much money the first account contributed to the second account.

8. The method of claim 1, wherein the cost flows in the first cost flow model are preserved in the reduced cost flow model.

9. The method of claim 8, wherein preserving the cost flows for the entities in the reduced cost flow model indicates that the starting cost of the reduced cost flow model is the same cost as the end cost for the reduced cost flow model, and wherein preserving the cost flows for the entities in the reduced cost flow model indicates that when removing or merging accounts, the cost for the reduced cost flow model does not change.

10. The method of claim 1, wherein the reduction criteria includes criteria related to which of the entities to remove from the first cost flow model when generating the reduced cost flow model.

11. The method of claim 1, wherein the reduction criteria includes criteria related to which of the entities from the first cost flow model to merge when generating the reduced cost flow model.

12. The method of claim 1, wherein at least two of the entities comprise accounts associated with service departments.

13. The method of claim 12, wherein at least one of the service departments comprises a human resources department, an information technology department, a maintenance department, or an administrative department.

14. The method of claim 1, wherein the reduced cost flow model is used to determine allocation of costs for the entities in the reduced cost flow model, thereby allowing a user to establish a cost associated with operating each of the entities in the reduced cost flow model.

15. The method of claim 14, wherein the allocation of costs comprises at least one of budgeting, allocating expenses, allocating revenues, allocating profits, assigning capital, and combinations thereof.

16. The method of claim 1, wherein the entities comprise cost pools.

17. The method of claim 16, wherein the cost pools include at least one of the group consisting of organizational cost pools, activity-based cost pools, or process-based cost pools, other logical groupings of money, and combinations thereof.

18. The method of claim 1, wherein the reducing the number of components that are in the first cost flow model includes reducing the number of entities that are in the first cost flow model.

19. The method of claim 1, wherein the reducing the number of components that are in the first cost flow model includes reducing the number of entities and relationships that are in the first cost flow model.

20. The method of claim 1, wherein the reducing the number of components that are in the first cost flow model includes reducing the number of relationships that are in the first cost flow model.

21. The method of claim 1, wherein reducing the first cost flow model to generate the reduced cost flow model results in each cost flow path of the reduced cost flow model having one or no nodes per stage, and wherein the table contains one column for each stage.

22. Computer software stored on one or more computer readable mediums, the computer software comprising program code, when executed by a computer for carrying out a method for analyzing costs associated with cost flow models having components of relationships and entities, the method comprising:

receiving, using one or more computer processors, data associated with a first cost flow model that identifies the costs associated with relationships among the entities, including resources, activities, and cost objects, wherein the first cost flow model is a multi-dimensional directed graph for depicting how money flows in an enterprise, wherein nodes of the graph represent accounts associated with the resources, activities, or cost objects, wherein an account exists at the intersection of a plurality of dimension members within a multi-dimensional database (MDDB) having dimensions, each dimension containing one or more dimension members, and wherein an edge of the multi-dimensional directed graph is associated with a percentage defining how much money flows from a source account to a destination account;

receiving reduction criteria, and using the reduction criteria to reduce the number of components in the first cost flow model;

using the reduction criteria to generate a reduced cost flow model, wherein the reduced cost flow model has fewer components than the number of components that are in the received first cost flow model, and wherein the reduced cost flow model is used to analyze costs associated with the entities in the reduced cost flow model; and

processing and storing the reduced cost flow model, wherein computation processing and storage requirements associated with processing and storing the reduced cost flow model is less than computation processing and storage requirements associated with processing and storing the first cost flow model, wherein the storing of the reduced cost flow model includes storing the reduced cost flow model in a relational database management system (RDBMS) or an Online Analytical Processing (OLAP) database, and wherein each cost flow path in the reduced cost flow model is stored in a data record row in a table in the RDBMS or the OLAP database.

23. A system for analyzing costs associated with cost flow models having components of relationships and entities, comprising:

one or more processors;

a computer-readable storage medium containing software instructions executable on the one or more processors to cause the one or more processors to perform operations including;

receiving data associated with a first cost flow model that identifies the costs associated with relationships among the entities, including resources, activities, and cost objects, wherein the first cost flow model is a multi-dimensional directed graph for depicting how money flows in an enterprise, wherein nodes of the graph represent accounts associated with the resources, activities, or cost objects, wherein an account exists at the intersection of a plurality of dimension members within a multi-dimensional database (MDDB) having dimensions, each dimension containing one or more dimension members, and wherein an edge of the multi-dimensional directed graph is associated with a percentage defining how much money flows from a source account to a destination account;

receiving reduction criteria, and using the reduction criteria to reduce the number of components in the first cost flow model;

using the reduction criteria to generate a reduced cost flow model, wherein the reduced cost flow model has fewer components than the number of components that are in the received first cost flow model, and wherein the reduced cost flow model is used to analyze costs associated with the entities in the reduced cost flow model; and

processing and storing the reduced cost flow model, wherein computation processing and storage requirements associated with processing and storing the reduced cost flow model is less than computation processing and storage requirements associated with processing and storing the first cost flow model, wherein the storing of the reduced cost flow model includes storing the reduced cost flow model in a relational database management system (RDBMS) or an Online Analytical Processing (OLAP) database, and wherein each cost flow path in the reduced cost flow model is stored in a data record row in a table in the RDBMS or the OLAP database.

24. A computer-readable storage medium encoded with instructions that when executed, cause a computer to perform a method for analyzing costs associated with cost flow models having components of relationships and entities, the method comprising:

receiving data associated with a first cost flow model that identifies the costs associated with relationships among the entities, including resources, activities, and cost objects, wherein the first cost flow model is a multi-dimensional directed graph for depicting how money flows in an enterprise, wherein nodes of the graph represent accounts associated with the resources, activities, or cost objects, wherein an account exists at the intersection of a plurality of dimension members within a multi-dimensional database (MDDB) having dimensions, each dimension containing one or more dimension members, and wherein an edge of the multi-dimensional directed graph is associated with a percentage defining how much money flows from a source account to a destination account;

receiving reduction criteria, and using the reduction criteria to reduce the number of components in the first cost flow model;

using the reduction criteria to generate a reduced cost flow model, wherein the reduced cost flow model has fewer components than the number of components that are in the received first cost flow model, and wherein the reduced cost flow model is used to analyze costs associated with the entities in the reduced cost flow model; and

processing and storing the reduced cost flow model, wherein computation processing and storage requirements associated with processing and storing the reduced cost flow model is less than computation processing and storage requirements associated with processing and storing the first cost flow model, wherein the storing of the reduced cost flow model includes storing the reduced cost flow model in a relational database management system (RDBMS) or an Online Analytical Processing (OLAP) database, and wherein each cost flow path in the reduced cost flow model is stored in a data record row in a table in the RDBMS or the OLAP database.